OraFAQ Forum: Server Administration » import performance disable

Home » RDBMS Server » Server Administration » import performance disable_logging parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import performance disable_logging parameter [message #56301]

Tue, 18 March 2003 03:40

Walter
Messages: 15
Registered: September 1999

Junior Member

I have heard i can use the _disable_logging = TRUE if i want increase the performance.
Anyone can explain me exactly what database do if the logging operation is disable ?

Report message to a moderator

Re: import performance disable_logging parameter [message #56304 is a reply to message #56301]

Tue, 18 March 2003 05:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

DO NOT DO THAT.
it is true that, if set the performance will be better,
becuase NO REDO RECORDS are generated.
On the other hand, RECOVERY  is not possible even in case of instance crash ( which will be taken care ofautomatically).
say your database goes down abnormally,
then you cannot recover~!!!

Report message to a moderator

Previous Topic:	ORA-01110: data file 149: '//index.dbf'
Next Topic:	Oracle installation problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:25:33 CDT 2024