Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "_disable_logging" parameter
On 16 Jan 98 19:51:24 +0100, "Lothar Armbruester" <lothar.armbruester_at_rheingau.netsurf.de> wrote:
>On 15-Jan-98 02:38:10 Connor McDonald wrote:
>>On our (overloaded, underconfigured) development server I have been
>>toying with the idea of enabling the "_disable_logging" parameter to
>>lessen the load on the machine.
>
>I would like to know, if this parameter is documented somewhere.
all parameters starting with _ are undocumented. so no, it is not.
>Are there any other parameters of this quality?
yes, there are many other _ parameters.
>I'm interested in a way to put the database in a kind of single user mode
>e.g. disable the generation of rollback data, the locking of rows etc.
cannot be done. rollback is generated even for a database that has disabled logging (you can still rollback work in those databases).
>
>The idea is the following:
>
>We have a database the is handling dialog processing at daytime and batch
>processing at nighttime. To speed up the batch, one could do a cold backup
>after dialog ends then put the database into the most speedy mode, do the
>batch and in the morning put the database in the nomal secure mode.
>
>Is that possible?
>
>CU,
>Lothar
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Jan 17 1998 - 00:00:00 CST