Home » RDBMS Server » Server Utilities » SQL Trace Utility
SQL Trace Utility [message #72190] Wed, 09 April 2003 06:37 Go to next message
Elavarasan
Messages: 7
Registered: January 2002
Junior Member
Hi,

Is there any SQLTrace utility available for Oracle, as it is in SQL Server?

Since we are taking over a new application, such a tool will be a great help in knowing the SQLs accessing the Oracle DB.

Need your help.

Rgds
Elavarasan.

Report message to a moderator

Re: SQL Trace Utility [message #72207 is a reply to message #72190] Sat, 12 April 2003 04:33 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
Please click on the link below for Oracle on-line documentation on the subject:

Report message to a moderator

Re: SQL Trace Utility [message #72214 is a reply to message #72190] Mon, 14 April 2003 21:52 Go to previous message
Elavarasan
Messages: 7
Registered: January 2002
Junior Member
Hi, thanx for your update. But my requirement was bit different. As you know, there is a seperate tool called SQLTrace in SQL Server. On starting the tool, it will capture all the SQL statements hitting the particular database. This will be very much useful when you are new to a application and want to know all the tables accessed by it.

I hope, SQLTRACE & TKPROF are serving a bit different of the above. Can you correct me on this...

Report message to a moderator

Previous Topic: Loading Binary using SQL *Loader
Next Topic: Changing characterset during import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 20:18:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.