RE: application deadlock ORA-00060
Date: Sat, 12 Apr 2008 21:43:30 -0700 (PDT)
It's captured either when the query is hard parsed or if the last capture was _cursor_bind_capture_interval seconds ago (default 900).
> Subject: RE: application deadlock ORA-00060
> Date: Fri, 11 Apr 2008 09:04:52 -0700
> From: "Allen, Brandon" <Brandon.Allen_at_OneNeck.com>
> In 10g+, bind variables are also occasionally captured in
> v$sql_bind_capture, and dba_hist_sql_bind (but keep in mind a
> Diagnostics Pack is required for accessing all dba_hist views). I'm not
> sure exactly how Oracle decides when to capture the bind variables in
> these views, maybe only when the query is hard parsed.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Received on Sat Apr 12 2008 - 23:43:30 CDT