Home » RDBMS Server » Security » how to trace sql statement
how to trace sql statement [message #144938] Sat, 29 October 2005 04:05 Go to next message
c_gajen
Messages: 8
Registered: September 2005
Location: Nagpur
Junior Member
hello,
i am using 9i on windows
can i trace sql statement of particular user(only scott)
when scott login.
using tkprof
or other utility.

thanks
gajen

Report message to a moderator

Re: how to trace sql statement [message #144939 is a reply to message #144938] Sat, 29 October 2005 04:25 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look here for what Thiru says.
http://www.orafaq.com/node/14
and followup with documentation.
First you must enable tracing.

Report message to a moderator

Previous Topic: about java.exe error
Next Topic: Oracle 7.3.4 and https-connections
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 19:14:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.