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.
1. Nologging seemed to be generating MORE redo than normal delete. !!?
2. 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 [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).