Just moments ago I ran the query below & got 40 rows returned. I'm at a loss to explain how an SQL statement can have ZERO parse_calls and ZERO executions while recording actual work against the DB
select FIRST_LOAD_TIME, DISK_READS , BUFFER_GETS , ROWS_PROCESSED, sql_text from v$sql where executions = 0 and parse_calls = 0 and disk_reads > 0 and buffer_gets > 0 / If anyone can explain why it is reasonable to get rows returned, I'd certainly appreciate an explanation and clarification. FWIW - V7.3.4.5 on Solaris 2.6 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
