Home » RDBMS Server » Server Administration » Snapshot Error on oracle 9i Auto Undo Management
Snapshot Error on oracle 9i Auto Undo Management [message #60434] Sun, 08 February 2004 04:00 Go to next message
Vinny75
Messages: 44
Registered: October 2003
Member
hello,

I am currently running a huge delete job on a sandbox environment that has Oracle 9.0.2 DB. Traditionally I would have set transaction to use a very large rollback segment and run this process. Now in sandbox I have Oracle 9i and set auto undo management letting oracle handle the rollback segments.

I am encountering snapshot too old error in this scenario after nearly about 3 hours of running. how do we handle this in 9i? I even increased undo threshhold to 1 hour from 15 mins and all it did was delay this snapshot error occurance. Tablespace has enough room to expand and therefore  not an issue. Please help.

V

Report message to a moderator

Re: Snapshot Error on oracle 9i Auto Undo Management [message #60509 is a reply to message #60434] Wed, 11 February 2004 09:29 Go to previous messageGo to next message
ilver
Messages: 50
Registered: January 2004
Member
Hi S...,
Have you checked the alert.log for entry(ies) related to this snapshot to old ?
As of Oracle 9i some information on this s-t-o events should be written to the alert.log
/ilver

Report message to a moderator

Re: Snapshot Error on oracle 9i Auto Undo Management [message #60836 is a reply to message #60434] Tue, 09 March 2004 10:15 Go to previous message
Robin dojng
Messages: 1
Registered: March 2004
Junior Member
this happens when some one login and did some DML, like insert, update or delete, but not commit and keep the connection to database in other words, the session is still open. so you need to kill these sessions or let user to get out. I am sure you will be ok.

Report message to a moderator

Previous Topic: processing of a DELETE or INSERT command
Next Topic: Estimate the UNIFORM SIZE tips (Locally Managed Tablespace - Oracle 8i).
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 07 22:56:01 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.