Home » RDBMS Server » Server Administration » delete statement is hanging when undo reaches 12G space (oracle 10.2.0.2 solaris 10)
delete statement is hanging when undo reaches 12G space [message #325629] Fri, 06 June 2008 19:27 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Experts,

i am running one package which contain set of delete statements.
when i initiates the package it is running and it was hanging
when undo is reaches 12G. from there it is not continuing further.
even i have space in undo tablespace.
how do i trace this problem. can any one provide some hits on this.

Regards,
kumar

Re: delete statement is hanging when undo reaches 12G space [message #325630 is a reply to message #325629] Fri, 06 June 2008 19:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>when undo is reaches 12G. from there it is not continuing further.
Please post proof that the above statement is valid & correct.

Are there any clues in alert_SID.log file?

[Updated on: Fri, 06 June 2008 19:53] by Moderator

Report message to a moderator

Re: delete statement is hanging when undo reaches 12G space [message #325643 is a reply to message #325629] Sat, 07 June 2008 00:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who here knows what you do inside the package?

Regards
Michel
Re: delete statement is hanging when undo reaches 12G space [message #325659 is a reply to message #325629] Sat, 07 June 2008 05:25 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
check your alert log.
Beware of checkpoint not complete message in the alert log file.
This might slow down the system tremendously.
Previous Topic: How to obtain DDL for REDO & UNDO?
Next Topic: PGA content
Goto Forum:
  


Current Time: Sat Dec 10 07:17:44 CST 2016

Total time taken to generate the page: 0.05811 seconds