Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how to trace/log a specific session id ??

how to trace/log a specific session id ??

From: jim allison <jallison01_at_yahoo.com>
Date: Tue, 18 Jul 2000 09:16:46 -0700 (PDT)
Message-Id: <10562.112285@fatcity.com>


Hi friends,

I´m sure this is piece of cake for many of you, but I really need some help.

I´m in need of tracing (or logging) all SQL commands executed on a specific session id. This session is NOT a sql plus procedure, it is opened by another client/server application. I have no control over it BEFORE it starts, and I´ll only find out its session id after it is already running.

I´d like to see all SQLs being executed ... no need for the actual results of them ...

Any tips ??

Thanks for helping,

Jim  



Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere! http://mail.yahoo.com/ Received on Tue Jul 18 2000 - 11:16:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US