Query to find SELECT statements during a time period
I am trying to find out the no. of select statements executed b/w a time period e.g. b/w 8:00 AM to 8:00 PM.
we have already used the following statement
select * from v$sysstat where statistic# in (4, 5, 6)
but i m not sure what exactly statistic # 6 i.e. user calls means.
Any help is highly appreciated.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
As per Oracle document:
Number of user calls such as login, parse, fetch, or execute.
When determining activity, the ratio of user calls to RPI calls, give you an indication of how much internal work gets generated as a result of the type of requests the user is sending to Oracle.
I dont think anywhere you can find calls between the given period. The only way is to audit the database.
Click Here to Expand Forum to Full Width