ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to Trace bind variable values

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13378482