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-----
From: Terrian, Tom [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 11:07 PM
To: Multiple recipients of list ORACLE-L
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-----
From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Number of SQL stmts.I think it also counts the recursive SQL statements issued-----Original Message-----
From: Terrian, Tom [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 9:08 PM
To: Multiple recipients of list ORACLE-L
Subject: Number of SQL stmts.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
