v$sql ?

From: <Charlie_Mengler_at_HomeDepot.com>
Date: Fri, 21 Mar 2003 09:09:15 -0800
Message-Id: <24738.322717@fatcity.com>

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 Received on Fri Mar 21 2003 - 11:09:15 CST