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

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: 10694
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.
Previous Topic: about java.exe error
Next Topic: Oracle 7.3.4 and https-connections
Goto Forum:
  


Current Time: Fri Nov 26 22:46:07 CST 2021