Home » RDBMS Server » Backup & Recovery » backup and recovery (oracle10g ,)
backup and recovery [message #471787] Tue, 17 August 2010 05:52 Go to next message
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
Re: backup and recovery [message #471796 is a reply to message #471787] Tue, 17 August 2010 06:19 Go to previous messageGo to next message
John Watson
Messages: 4081
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.
Re: backup and recovery [message #471827 is a reply to message #471796] Tue, 17 August 2010 09:38 Go to previous message
Michel Cadot
Messages: 57603
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
Previous Topic: Facing Deadlock error while restore using TSPITR
Next Topic: Old archive logs after open resetlogs
Goto Forum:
  


Current Time: Thu Apr 17 00:26:15 CDT 2014

Total time taken to generate the page: 0.10560 seconds