Tracing Oracle Internal Calls - Trace Sqlplus
相当于TOAD的sqlmonitor功能
[oracle10@zhangqiaoc ~]$ ps -ef|grep sqlplus
oracle10 460 412 0 13:35 pts/1 00:00:00 sqlplus
oracle10 841 368 0 13:50 pts/2 00:00:00 grep sqlplus
[oracle10@zhangqiaoc ~]$ gdb -p 460
(gdb) set height 0
(gdb) b kpursetstmttext
Breakpoint 1 at 0xd7debe
(gdb) while (1<2)
>x /s *(unsigned int *)($ebp+12)
>c
>end
0xb7f29000: ""
--[SQLPLUS]------------------------------------------------------
SQL> DECLARE
2 lvc_sql VARCHAR2(1000);
3 BEGIN
4 FOR i IN 1..100 LOOP
5 lvc_sql := 'INSERT INTO test VALUES('||i||')';
6 EXECUTE IMMEDIATE lvc_sql;
7 END LOOP;
8 END;
9 /
PL/SQL procedure successfully completed.
-----------------------------------------------------------------
[Switching to Thread 16384 (LWP 913)]
Breakpoint 1, 0x00ee1ebe in kpursetstmttext ()
from /oracle10/product/10.2/lib/libclntsh.so.10.1
0x80e21f8: "DECLARE\n lvc_sql VARCHAR2(1000);\nBEGIN\n FOR i IN 1..100 LOOP\n lvc_sql := 'INSERT INTO test VALUES('||i||')';\n EXECUTE IMMEDIATE lvc_sql;\n END LOOP;\nEND;"
只测试了SQLPLUS，如果是OCI等连接，可以gdb进去后info func得到方法列表，然后找出可能的FUNC测试下，可能是OCIStmtPrepare
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8242091/viewspace-676975/ ，如需转载，请注明出处，否则将追究法律责任。
