dbTalk Databases Forums  

suggestions for perfect client trace are welcome

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss suggestions for perfect client trace are welcome in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ralf Moosandl
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.