Monitoring full table scans in DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Monitoring full table scans in DB

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    Monitoring full table scans in DB

    Hello -

    Apart from OEM tool, can someone tell me how else can I monitor long running transactions and full table-scans in an oracle database? Any scripts?

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    select sw.sid,s.serial#,sa.sql_text,sw.event,s.schemaname "oracle user",s.osuser "os user",s.machine from v$session_Wait
    sw,v$sqlarea sa,v$session s where s.status='ACTIVE' and sw.event like '%db file sca%' and s.sql_hash_value=sa.hash_value
    and s.sid = sw.sid;

    This will give complete SQL and the SESSION doing full table scan

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    Thank you!

    Thank you very much! Any other suggestions welcome!

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