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

Home -> Community -> Usenet -> c.d.o.server -> trace sql without session_id and serial#

trace sql without session_id and serial#

From: Steve Robin <ocmaman_at_gmail.com>
Date: Thu, 26 Jul 2007 00:14:15 -0700
Message-ID: <1185434055.426728.194320@d55g2000hsg.googlegroups.com>


My current database so many users are connected. SQL trace is off. I need to trace a developer session. I just have osname and username. Session is not connected right now. As soon as he connects some sql fired from that session. I know how trace it after he connects I can see session info from v$session but without knowing session id and serial#, how can I trace with osuser and username only.

I cann't restart database, because so many people are working on it.

Oracle Database : 9.2.0.8
OS : Windows 2000 Received on Thu Jul 26 2007 - 02:14:15 CDT

Original text of this message

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