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

Thread: Query Needed

Hybrid View

  1. #1
    Join Date
    Mar 2008
    Posts
    8

    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

  2. #2
    Join Date
    Oct 2006
    Posts
    175
    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
  •  


Click Here to Expand Forum to Full Width