Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UNDO tablespace reaching maximum size - WHO is using it?

401820Sep 20 2007 — edited Sep 20 2007

My UNDO tablespace has been pretty static for a while but this morning it was at 93% and within 20 minutes I saw it at 98%. I added a datafile to buy some time, but is there any way I can identify specific sessions which may be filling it rapidly ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2007

Added on Sep 20 2007

#general-database-discussions

11 comments

1,257 views