-
Query to find SELECT statements during a time period
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.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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.
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|