-
Using only statistics available within the database, this calculation gives the best approximation of response time, in seconds, per transaction during a sample period. This is useful in further diagnosing performance issues by drilling down into individual components like Waits, CPU etc.
ResponseTime = (deltaTotalWait + deltaCpuTime) / deltaCommits + deltaRollbacks)
where:
deltaTotalWait: difference of \'sum of time waited for all wait events in v$system_event\' between sample end and start
deltaCpuTime: difference of \'select value from v$sysstat where name=\'CPU used by this session\'\' between sample end and start
deltaCommits: difference of \'select value from v$sysstat where name=\'user commits\'\' between sample end and start
deltaRollbacks: difference of \'select value from v$sysstat where name=\'user rollbacks\'\' between sample end and start
[Edited by uday on 04-03-2001 at 02:37 PM]
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
|