DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Measuring SQL Execution Time

  1. 12-05-2003, 08:23 AM #1
    cormacb
    cormacb is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 12-05-2003, 11:41 AM #2
    ganga
    ganga is offline Member
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182
    Hi,

    Statpack generates reports only for the statements which crosses Threshold
    J Gangadhar
    Reply With Quote Reply With Quote
  3. 12-06-2003, 04:00 PM #3
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    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---
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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