Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Initialization parameter transactions_per_rollback_segment, can you set this?

Re: Initialization parameter transactions_per_rollback_segment, can you set this?

From: BobMetelsky <bobmetelsky_at_comcast.net>
Date: Tue, 16 Aug 2005 13:57:25 -0400
Message-ID: <43022905.7040905@comcast.net>


Use UNDO segments rather than rollbacks
http://www.oracle.com/technology/oramag/oracle/05-jul/o45tuning.html

and/or
Dig on Steve Adams site for a script called commit.every() http://www.ixora.com.au/

This is a nice procedure which you wrap outside of your code and it commits every n seconds, works fantastic.

eg

begin

commit.every()

your code here

end;

bob

"Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies."

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 16 2005 - 13:05:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US