Home » RDBMS Server » Server Administration » Old sql problem
Old sql problem [message #299058] Fri, 08 February 2008 13:56 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
I have a problem:
i wanna trace a dml that few months ago hang the system.
i have a trc and alert.log and i have the trans_id and the pid but i want to know if exist a way to find the sql and user that excecuted.

Does anybody have an idea howto find it?
or howto trace that sql?
thank you in advance

Report message to a moderator

Re: Old sql problem [message #299105 is a reply to message #299058] Sat, 09 February 2008 07:59 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Oracle Version: ?

>or howto trace that sql?
Enable sql tracing through SQL_TRACE =TRUE at system level
and check udump folder for generated trace file and using tkprof utility convert .trc to readable text file.

http://www.oracle-base.com/articles/10g/SQLTrace10046TrcsessAndTkprof10g.php

[Updated on: Sat, 09 February 2008 07:59]

Report message to a moderator

Previous Topic: rollback and tablespace space usage
Next Topic: Urgent: Removing tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 05:54:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.