September 2010
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
27282930  

OCP 10g(1z0-042) daily 10 practices-2

1.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
A – Each segment contains one or more extents
B – Mutiple tablespaces can share single datafile
C – A data block is a smallest unit of I/O for data files.
D – it is possible to have tablespaces of different blocks size in a database
E – Each data block in the database always corresponds to one OS block.
(Answer:A,C,D)

  Continue reading OCP 10g(1z0-042) daily 10 practices-2

OCP 10g(1z0-042) daily 10 practices-1

1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)

A – The database files are synchronized.
B – Uncommitted changes are no rolled back.
C – The database is closed,but the instance is still started.
D – Database buffers and redo buffers are not written to the disk.
E – The data base undergose automatic media recovery during the next startup.

  Continue reading OCP 10g(1z0-042) daily 10 practices-1

Site of Books

I found this web site scribd  by accident.There are lots of books on this site.Here’s another similar site slideshare. Have fun!

How to drop and recreate oracle undo tablespace and its datafile

if you get ORA-00600 or the following error message on your Oracle standby database:

Fri Mar 09 10:57:49 2007
Errors in file c:\oracle\admin92\crm\bdump\crmsb_mrp0_524.trc:
ORA-00600: internal error code, arguments: [3020], [356515961], [1], [4606], [2], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 85, block# 121)
ORA-10564: tablespace UNDOTBS2
ORA-01110: data file 85: ‘K:\ORADATA\CRM\UNDOTBS02_1.DBF’
ORA-10560: block type ‘KTU SMU HEADER BLOCK’

Or your undo tablespace has grown to unmanageable size (~ 35 Gbytes), you may want to recreate unto tablespace. Here is how:
Continue reading How to drop and recreate oracle undo tablespace and its datafile

彼岸-2008年5月12 14时28分

–摘录满文军为悼念在汶川地震中殉难的同胞新歌歌词

–祝愿在汶川大地震中遇难的同胞们能够到达彼岸

很少有人真的了解
思念是片海
很少有人能够到达彼岸
很多人都治好伤口
重新扬起帆
航离这片无边际的蓝
我比别人都要了解
夜有多灿烂
音乐和回忆来抵抗孤单
想着你甜甜的睡去
美梦多浪漫
推开窗天快要亮起来

轻轻的告诉她
我还在等待

昨天的漂流瓶
载着爱回来

轻轻的吹过来
我为爱等待

你留下的誓言
带着爱回来

Page 11 of 1612345678910111213141516