| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: No logging question
In that case, you are pretty much SOL, sorry. nologging option of tables
only applies to direct path operations:
create as select
direct path Sql*Loader
insert /*+ APPEND */
Other than that, all other DML will get logged in the redo log, and as several have pointed out, using the _disable_logging parameter is highly risky, and it is a catch-all situation.
HTH. Regards:
Ferenc Mantfeld
-----Original Message-----
From: GL2Z/ INF DBA BENLATRECHE [SMTP:kbenlatreche_at_avl.sonatrach.dz] Sent: Tuesday, January 07, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: No logging question
As I understand, this hidden parameter is for the whole database. In my case It's just for a few tables (I don't care about recovery of these tables).
Thank you !
Best Regards
Kamel Benlatreche
-----Message d'origine-----
De : mantfield [mailto:mantfield_at_connexus.net.au]
Envoye : lundi 6 janvier 2003 19:19
A : Multiple recipients of list ORACLE-L
Objet : RE: No logging question
Welcome to the dark side, heh heh heh !
There is a hidden parameter that will achieve this . it is _disable_logging. Be warned though, if you set it to true, you have lost your ability to recover, and the only way you will recover is with full cold backup and would lose all subsequent work (not generally popular with the users), so the whole point of running in ARCHIVELOG mode becomes moot.
I have used this while still at Siebel, when doing very large installs or upgrades of large databases in a tight time-window, and the customers refused to move the redo logs over to solid state storage, I got about a 40% - 100% performance improvment, especially if the clients were conned into placing the redo logs onto RAID-5 storage (bad for serial write-intensive operations).
Nevertheless, if you have a specific need to disable all redo generation for a specific time, this is the way to do it. BTW, it does not work on Orale for Windows.
You have been warned, don't go trying this in production first thing, it could cost you your job or more.
Regards :
Ferenc Mantfeld
-----Original Message-----
From: GL2Z/ INF DBA BENLATRECHE [SMTP:kbenlatreche_at_avl.sonatrach.dz] Sent: Monday, January 06, 2003 8:34 PM To: Multiple recipients of list ORACLE-L Subject: No logging question
Hi All,
I want to avoid generation of archivelogs against all the DML applied to some tables.
Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GL2Z/ INF DBA BENLATRECHE
INET: kbenlatreche_at_avl.sonatrach.dz
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: mantfield
INET: mantfield_at_connexus.net.au
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: mantfield
INET: mantfield_at_connexus.net.au
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 07 2003 - 04:38:37 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |