RE: Number of SQL stmts.

There are Recursive Calls, User Calls and Execute Count. There is no definite relationship between them.  

I dont think the ratio u r trying to find is possible. and even if there is a way to fin the ratio, I don't think that will be useful to you.  

Naveen

-----Original Message-----

Sent: Tuesday, August 20, 2002 11:07 PM
To: Multiple recipients of list ORACLE-L

Thanks Naveen. That makes sense. My dilemma is that I am trying to get a ratio between the number of waits in v$system_event and the number of sql statements issued. So, does anyone know if the TOTAL_WAITS field in the V$SYSTEM_EVENT table includes wait generated by recursive SQL statements? If it doesn't, does anyone know how to get the total number of SQL statements (non-recursive) issued against a database?  

Thanks,
Tom

-----Original Message-----

Sent: Tuesday, August 20, 2002 1:05 PM
To: Multiple recipients of list ORACLE-L

I think it also counts the recursive SQL statements issued

-----Original Message-----

Sent: Tuesday, August 20, 2002 9:08 PM
To: Multiple recipients of list ORACLE-L

All,  

I am trying to determine the number of sql statements issued against my databases. Does anyone know if the "execution count" in v$sysstat is the number of sql statements issued against the database? I know that this is a cumulative number from when the database was last bounce, but it still seems very high. Does this really show me the number of statements issued since the last bounce?  

Thanks,
Tom

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).