RE: How much time can save using _disable

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 7 Oct 2005 10:24:52 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2705219237@AABO-EXCHANGE02.bos.il.pqe>

It's really impossible to predict.

It depends on the design of your application, and whether logging is a significant portion of your response time. Since you emphasize this is for testing only, I assume you're aware of the severe implications to your database in the event of a crash....

For anyone else reading this: Never, ever, ever set this parameter. ;-)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco
Sent: Friday, October 07, 2005 9:46 AM
To: oracle-l_at_freelists.org
Subject: How much time can save using _disable_logging on 10g

Hi,
To speed process on my personal computer, ONLY FOR MY TESTING DATABASE, I want to use _disable_logging parameter. How much can I expect to save in time using it.

Thank you in advance.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 07 2005 - 09:28:52 CDT

RE: How much time can save using _disable_logging on 10g