suggestions for perfect client trace are welcome -
02-26-2006
, 01:55 AM
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 |