Home » SQL & PL/SQL » Client Tools » Tool for tracking SQLs in Oracle 11g (Oracle 11g,Windows 2008)
Tool for tracking SQLs in Oracle 11g [message #636954] Wed, 06 May 2015 06:47 Go to next message
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.
Re: Tool for tracking SQLs in Oracle 11g [message #636955 is a reply to message #636954] Wed, 06 May 2015 06:52 Go to previous messageGo to next message
BlackSwan
Messages: 25795
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/
Re: Tool for tracking SQLs in Oracle 11g [message #636969 is a reply to message #636954] Wed, 06 May 2015 13:33 Go to previous message
John Watson
Messages: 7216
Registered: January 2010
Location: Global Village
Senior Member
alternatively, AUDIT ALL STATEMENTS;
Previous Topic: Create new database in SQL Plus or PowerShell
Next Topic: Language Support in Toad
Goto Forum:
  


Current Time: Thu Jan 18 17:04:17 CST 2018

Total time taken to generate the page: 0.02304 seconds