Wednesday, October 21, 2009

Trace Session in Oracle.

There are many way to trace session in oracle, 'trcsess' is the one way to do that.

trcsess [output=] [session=] [clientid=] [service=] [action=] [module=]

output= output destination default being standard output.
session= session to be traced.
Session id is a combination of session Index & session serial number e.g. 8.13.
clientid= clientid to be traced.
service= service to be traced.
action= action to be traced.
module= module to be traced.
Space separated list of trace files with wild card '*' supported

*** Example ***
trcsess output=/tmp/trace.log session=983.29799


-- TaTsHuYa --

No comments: