Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> SQL+ AUTOTRACE OUTPUT
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: Sofiane-Ennaifar_at_cartes-bancaires.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 Wed Apr 04 2001 - 05:05:17 CDT