RE: NOLOGGING FEATURE

From: Greg Solomon <greg.solomon_at_betfair.com>
Date: Mon, 25 Jun 2001 02:29:17 -0700
Message-ID: <F001.00335F74.20010625020600@fatcity.com>

Hi Raj

RTFM is a relational trace file management system. Originally released as an add-on with 8.0.0.6, I think it now comes standard with 9i.

Cheers
Greg

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

Sent: Monday, 25 June 2001 09:52
To: Greg Solomon

Greg

I'm curious.. Whats RTFM is??

Raj

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

Sent: 22 June 2001 17:04
To: LazyDBA.com Discussion

Hi Regis

Delete nologging sounds like a cool feature. I assume that nologging would tell Oracle not to bother keeping an old image of the deleted row in the rollback buffer, because I promise not to do a rollback.

I RTFMed but couldn't find it. Did a few quick trials in sqlplus, 816 on Red Hat Linux. Results are below. I have two questions.

Nologging seemed to be generating MORE redo than normal delete. !!?
Was able to roll back after a delete nologging. !!?

Am I being stupid or something ?

Oops, that's three questions.

Cheers
Greg

SQL> delete greg where b=2;
2 rows deleted.

Execution Plan

0 DELETE STATEMENT Optimizer=CHOOSE 1 0 DELETE OF 'GREG'
2 1 TABLE ACCESS (FULL) OF 'GREG' Statistics

          0  recursive calls
          6  db block gets
          1  consistent gets
          0  physical reads
        544  redo size
        646  bytes sent via SQL*Net to client
        548  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
          2  rows processed

SQL> rollback;
Rollback complete.

SQL> delete greg nologging where b=2;
2 rows deleted.

Execution Plan

0 DELETE STATEMENT Optimizer=CHOOSE 1 0 DELETE OF 'GREG'
2 1 TABLE ACCESS (FULL) OF 'GREG' Statistics

          0  recursive calls
          8  db block gets
          1  consistent gets
          0  physical reads
        692  redo size
        646  bytes sent via SQL*Net to client
        558  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
          2  rows processed

SQL> rollback;

SQL> select * from greg;

A B
---------- ----------

         1          2
         1          2

Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these
terms:http://www.lazydba.com/legal.html

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Solomon
  INET: greg.solomon_at_betfair.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: 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 Mon Jun 25 2001 - 04:29:17 CDT