RE: application deadlock ORA-00060
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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).
Yong Huang
> Subject: RE: application deadlock ORA-00060
> Date: Fri, 11 Apr 2008 09:04:52 -0700
> From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
