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

Home -> Community -> Usenet -> c.d.o.server -> Total Parses

Total Parses

From: murthy <muthy69_at_yahoo.com>
Date: 25 Jun 2002 04:37:16 -0700
Message-ID: <300217f3.0206250337.885275a@posting.google.com>


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

Original text of this message

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