Tom,
How do you plan to use this ratio?
Jared
"Terrian, Tom" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/20/2002 10:37 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Number of SQL stmts.
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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
