-
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
-
Hi,
Statpack generates reports only for the statements which crosses Threshold
J Gangadhar
-
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)
--- 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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|