OraFAQ Forum: Server Administration » delete statement is hanging when undo reaches 12G space

Home » RDBMS Server » Server Administration » delete statement is hanging when undo reaches 12G space (oracle 10.2.0.2 solaris 10)

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

delete statement is hanging when undo reaches 12G space [message #325629]

Fri, 06 June 2008 19:27

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

Report message to a moderator

Re: delete statement is hanging when undo reaches 12G space [message #325630 is a reply to message #325629]

Fri, 06 June 2008 19:31

BlackSwan
Messages: 26766
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