How to Trace bind variable values

原创 Linux操作系统作者：tolywang 时间：2005-02-19 00:00:00 0 删除编辑

http://www.ixora.com.au/q+a/0104/13105933.htm

Tracing bind variable values

The ORA-07445 error should have generated a trace file in the user_dump_dest directory, max_dump_file_size permitting. Towards the end of the file you should find a cursor dump including the bind variable values. Failing that you can explicitly request a processstate dump on future 7445 errors with

    event = "7445 trace name processstate level 2"

in the init.ora file, or with

    alter system set events '7445 trace name processstate level 2';

In general its also possible to use event 10046 at level 4 to trace bind variable values, but setting that globally would just fill up your udump directory.

Is there any workaround to get the value of bind variable when some error occurs as I'm using cursor_sharing = FORCE in Oracle 8.1.6.3 and getting some problem (ORA-7445) while inserting a record into one of the table and it's not possible for me to get the value as it's a world wide used application and the oracle generated trace file give the bind variable not the value. Basically I have to reproduce the same scenario that's why I need the value of bind variable.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84292/，如需转载，请注明出处，否则将追究法律责任。