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

Thread: hard parse SQL

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360

    hard parse SQL

    Anyone have any thoughts on the best way to capture what SQL is being hard parsed in the database? i've identified a library latching problem via statspack, the next step is to find the SQL and where its coming from. I dont think parse call section of statspack doesnt just give hard parses (is that true?). I'm thinking that I need to delve into v$sql_area to get whatI want. Any suggestions??
    TIA

  2. #2
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    use v$sqlarea and v$db_object_cache view, check for columns (sql_text,executions,loads)
    ~KD.DBA~

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