Friday, August 15, 2008

The ultimate Oracle performance tuning parameter.

#I found this one the other day. Useful to speed up imports, but make sure you have a good backup or an updated CV before you use it.

_disable_logging = true

#data is still written to the log buffer, but is not written to the redo logs.
#if the instance dies, (crash or shutdown abort) there's no data in the online redo logs to do instance recovery.
#DO NOT USE THIS UNLESS YOU UNDERSTAND THE IMPACT !!!