Measuring SQL Execution Time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Measuring SQL Execution Time

  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Question Measuring SQL Execution Time

    Hi,

    I'm currently investigating some performance bottlenecks in my
    development system. I'm running tests for intervals of 10 minutes,
    20 minutes and 30 minutes. What is the best way to find out the amount of time that the DB instance has spent executing SQL statements during this test interval. ( I've generated Statspack reports but I'm unsure if the reports include execution time for all SQL statements or just the statements exceeding certain thresholds )

    Thanks,

    Cormac

  2. #2
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182
    Hi,

    Statpack generates reports only for the statements which crosses Threshold
    J Gangadhar

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    An excellent time to start strategize your statspack and taking snapshots on those specified intervals. Start sprinkling your database with that magic dust of taking snapshots on regular basis.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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