Hello,
I have a table with 39 rows (3 blocks of 4Ko).
When I delete 4 rows from this table, the output of the SQL+ AUTOTRACE
is the following :
Statistics
----------------------------------------------------------
8 recursive calls
7 db block gets
8 consistent gets
0 physical reads
1067 redo size
40 bytes sent via SQL*Net to client
98 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
4 rows processed
I am enable to find an explanation of the following value :
db block gets 7 (table is composed of 3 blocks)
consistent gets 8 (table is composed of 3 blocks)
recursive calls 8 ???
Any one could give me a possible explanation ? (exact definition of 'db
block get' & 'consistent get')
When I delete all the table data, the SQL+ AUTOTRACE is the following :
Statistics
---------------------------------------------------------
0 recursive calls
39 db block gets
37 consistent gets
0 physical reads
7507 redo size
40 bytes sent via SQL*Net to client
73 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
35 rows processed
NB : the table is not indexed
Thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
