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??
05-01-2006, 01:16 AM
use v$sqlarea and v$db_object_cache view, check for columns (sql_text,executions,loads)