Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> v$sql ?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US