OraFAQ Forum: Backup & Recovery » backup and recovery

Home » RDBMS Server » Backup & Recovery » backup and recovery (oracle10g ,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

backup and recovery [message #471787]

Tue, 17 August 2010 05:52

zodiacsom
Messages: 37
Registered: December 2009
Location: pune

Member

Hi all,
top five wait event
data block wait
segment header wait

are most common for our database .
for second i add datafile to undo tablespace , but how can i drop the first undo datafile .
and what should i do to remove data block wait event

Report message to a moderator

Re: backup and recovery [message #471796 is a reply to message #471787]

Tue, 17 August 2010 06:19

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Hi - may I suggest that you post the statspack or AWR report to which you are referring? Without knowing the actual wait events, and related information in the reports, there is nothing one can do. And I do not think that "data block wait" or "segment header wait" are real event names.

Report message to a moderator

Re: backup and recovery [message #471827 is a reply to message #471796]

Tue, 17 August 2010 09:38

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://otn.oracle.com/pls/db102/drilldown?remark=quick_search&word=data+block+wait&tab_id=
http://www.oracle.com/pls/db102/search?remark=quick_search&word=segment+header+wait&tab_id=&format=ranked

Regards
Michel

Report message to a moderator

Previous Topic:	Facing Deadlock error while restore using TSPITR
Next Topic:	Old archive logs after open resetlogs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:59:15 CDT 2024