Re: 9i SAVEPOINT question

If Space issues are your concern then you can use the resumable space management feature available with oracle9i instead of savepoints. It is generally not a good idea to commit frequently and also doing loads in batches causes other headaches like program restartability.You can use the resumable space management feature without any issues except if your code has queries or operations against remote objects. To utilize this feature the user needs the "resumable" system privilege. With this privilege available, prior to starting the process, you can set this for the session:

• Set up timeout for 20 hours! SQL> alter session enable resumable timeout 72000 name 'Project_name';

You can setup an "after suspend" trigger which can send you a page or an email notification in the event of space issues.

Hope this helps!

http://www.dbaxchange.com
(One stop site for practical solutions to oracle issues, oracle findings, Book recommendations, International job search site recommendations and much more....) Received on Thu Nov 24 2005 - 11:09:28 CST