-
Query Needed
How To Find The Following Data In Oracle Through Sql
1.transactions
2.usercalls
3.parse Cpu Time
4.recursive Cpu Time
5.other Cpu Time
6.count Of Execute
7.wait Time
8.memory Sort
9.response Time Per Transaction
10.responce Time Per Execute
11.active Session
12.commit Count
13.rollback Count
14.suspended Session
15.logons Per Transaction
16.session Mait Lock Count
17.consistent Change Ratio
18.user Rollback Ratio
-
Oracle tools AWR or TKPROF would give value to most of the fields that you've mentioned. If through sql, there are lots of dictionary views, go through the oracle docs.
Thanks
gtcol
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
|