RE: application deadlock ORA-00060

From: Yong Huang <>
Date: Sat, 12 Apr 2008 21:43:30 -0700 (PDT)
Message-ID: <>

It's captured either when the query is hard parsed or if the last capture was _cursor_bind_capture_interval seconds ago (default 900).

Yong Huang

> Subject: RE: application deadlock ORA-00060
> Date: Fri, 11 Apr 2008 09:04:52 -0700
> From: "Allen, Brandon" <>
> 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.
> Regards,
> Brandon

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Received on Sat Apr 12 2008 - 23:43:30 CDT

Original text of this message