RE: application deadlock ORA-00060

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 12 Apr 2008 21:43:30 -0700 (PDT)
Message-ID: <731427.85798.qm@web80608.mail.mud.yahoo.com>

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" <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.
>
> Regards,
> Brandon

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 12 2008 - 23:43:30 CDT