Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> suggestions for perfect client trace are welcome
hello group,
I want to automatically collect only the original sql-statements,
which were sent from all clients (oci)
to 10gR2 database, includig binds and time information
My problem is that I cannot avoid the implicit
sql-statements.
Example:
client sends:
execute immediate procedure xxx;
results in tracefile:
-trace info1...
...execute immediate procedure xxx;
-trace info1...
-trace info2...
..insert into ...
-trace info2...
-trace info3...
..delete from ...
-trace info2..
-trace info4...
..select from ...
-trace info4..
How can I avoid trace info 2-4?
And, if there is no way for avoiding,
how can I filter the tracefile for only
receiving
-trace info1...
...execute immediate procedure xxx;
-trace info1...
Thanks a lot for suggestions Received on Sun Feb 26 2006 - 01:55:09 CST