Database Administration (MOSC)

MOSC Banner

When will space in undo tablespace be released ?

edited Jan 13, 2010 1:30AM in Database Administration (MOSC) 5 commentsAnswered
Recenlty, our system reports error about snapshot too old during peak hours.  I found a standard Oracle Report will use up 130 M on undo tablespace.   That oracle report usually complete in 1 minute.  

Is it the 130 M space will be released after 1 minute or have to wait for 8 hours ( rentention period parameter) ?

If 50 reports submitted, 6G will be consumed.   I wonder if adding space is the only solution to it.   

Regards,

Christine

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center