Query to find SELECT statements during a time period
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Query to find SELECT statements during a time period

  1. #1
    Join Date
    Jan 2003
    Posts
    21

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    A user call is a Parse, an Execute, or a Fetch.

    http://storacle.princeton.edu:9001/o...atisti.htm#414
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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
  •  



Click Here to Expand Forum to Full Width