OraFAQ Forum: Server Administration » I am looking for script or utility to retrieve all statements from trace file

Home » RDBMS Server » Server Administration » I am looking for script or utility to retrieve all statements from trace file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I am looking for script or utility to retrieve all statements from trace file [message #54230]

Wed, 06 November 2002 03:14

Marian
Messages: 3
Registered: September 1999

Junior Member

Hello,

In our production DB we have a support account and
I require audit all issued statements in detail (including where clauses, bind variables etc.)
In my opinion the only way how to do it is event 10046, level 4.

But then tkprof don't report bind variables
therefore I am looking for script or utility to retrieve all issued statements from trace file including bind variables (it would by best without statistic data).

Can anybody help me?

Thank you.

Marian

Report message to a moderator

Re: I am looking for script or utility to retrieve all statements from trace file [message #54243 is a reply to message #54230]

Wed, 06 November 2002 11:01

andrew again
Messages: 2577
Registered: March 2000

Senior Member

See metalink note 39817.1 and www.hotsos.com

Report message to a moderator

Re: I am looking for script or utility to retrieve all statements from trace file [message #54250 is a reply to message #54230]

Wed, 06 November 2002 23:09

Marian
Messages: 3
Registered: September 1999

Junior Member

Thanks for reply, but I don't need to tune sql statements. I want only to audit all issued statements including bind variables.
e.g.
---------
sql statement #1
binds #1
---------
sql statement #2
binds #2
---------
sql statement #3
binds #3
---------
and so on ...

Marian

Report message to a moderator

Previous Topic:	clear TEMP Tablesapce
Next Topic:	oracle service not starting pentium 4 windows 2k

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:41:58 CDT 2024