Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Total Parses
How do i find the Total Parses in the system ?
I had given these 2 queries
1)select name,value from v$sysstat where name like '%parse count%';
NAME VALUE -------------------------------- ----------- parse count (total) 94850 parse count (hard) 11857
2) select namespace,gets,gethits,pins,reloads from v$librarycache
where namespace like '%SQL%';
SQL>
NAMESPACE GETS GETHITS ---------------- ------- -------- SQL AREA 91008 83262
Aren't GETS in V$LIBRARYCACHE supposed to show the total number of
parse calls ?
This is what steve adams says in ixora web site.
http://www.ixora.com.au/q+a/library.htm#end
Why is there a difference in the parse count(total) in first query and
the gets in the second query?
Thanks in advance
Received on Tue Jun 25 2002 - 06:37:16 CDT