Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> suggestions for perfect client trace are welcome

suggestions for perfect client trace are welcome

From: Ralf Moosandl <ralf.moosandl_at_t-online.de>
Date: Sun, 26 Feb 2006 08:55:09 +0100
Message-ID: <dtrmrh$iuc$00$1@news.t-online.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US