Query to find SELECT statements during a time period

[krana]

Hi Friends,

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.

Best Regards,

Kashif

[SANJAY_G]

A user call is a Parse, an Execute, or a Fetch.

http://storacle.princeton.edu:9001/o...atisti.htm#414

[agasimani]

As per Oracle document:

user calls
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.