Home » RDBMS Server » Server Administration » Reg. session in trace file
Reg. session in trace file [message #133032] Wed, 17 August 2005 07:13 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi all,
How can i know which session has generated the following message in the trace file.I am using oracle 9.2.
The msg from oracle server trace file is as below:-
-----------------------------
*** 2005-08-17 17:35:34.000
*** SESSION ID:(15.35) 2005-08-17 17:35:34.000
-----------------------------
There is a session_id in this trace file, how can i interpret it to know which user's session it is.

Thanks
Dinesh

Report message to a moderator

Re: Reg. session in trace file [message #133063 is a reply to message #133032] Wed, 17 August 2005 09:07 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Got it
serial no and sid# from v$session.

Thanks

dinesh

Report message to a moderator

Previous Topic: Creation date of table
Next Topic: ORA-00942: table or view does not exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 10:38:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.