OraFAQ Forum: Client Tools » Tool for tracking SQLs in Oracle 11g

Home » SQL & PL/SQL » Client Tools » Tool for tracking SQLs in Oracle 11g (Oracle 11g,Windows 2008)

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

Tool for tracking SQLs in Oracle 11g [message #636954]

Wed, 06 May 2015 06:47

shyamu
Messages: 30
Registered: September 2011
Location: HYD

Member

Hi,

Do we have any tool track what are sql statements are executed in my database.

I was looking something related to SQLPROFILER in SQL SERVER 2008.

Kindly advise me on this.

Thanks
Shyam.

Report message to a moderator

Re: Tool for tracking SQLs in Oracle 11g [message #636955 is a reply to message #636954]

Wed, 06 May 2015 06:52

BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal

Senior Member

ALTER SYSTEM SET SQL_TRACE=TRUE;

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: Tool for tracking SQLs in Oracle 11g [message #636969 is a reply to message #636954]

Wed, 06 May 2015 13:33

John Watson
Messages: 8499
Registered: January 2010
Location: Global Village

Senior Member

alternatively, AUDIT ALL STATEMENTS;

Report message to a moderator

Previous Topic:	Create new database in SQL Plus or PowerShell
Next Topic:	Language Support in Toad

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 26 15:54:29 CST 2021