RE: Number of SQL stmts.

From: Terrian, Tom <tterrian_at_daas.dla.mil>
Date: Tue, 20 Aug 2002 09:37:28 -0800
Message-ID: <F001.004BA1B5.20020820093728@fatcity.com>

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: Terrian, Tom
  INET: tterrian_at_daas.dla.mil

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). Received on Tue Aug 20 2002 - 12:37:28 CDT