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).