Home » RDBMS Server » Backup & Recovery » backup and recovery (oracle10g ,)
backup and recovery [message #471787] Tue, 17 August 2010 05:52 Go to next message
Messages: 37
Registered: December 2009
Location: pune
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: 7002
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: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Current Time: Thu Jul 20 13:53:40 CDT 2017

Total time taken to generate the page: 0.05384 seconds