Re: ** trace file

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: "ajoshi977@xxxxxxxxx" <ajoshi977@xxxxxxxxx>
  • Date: Mon, 20 Apr 2009 13:04:40 -0600

Just use tracefile_identifier. Each part will get a new suffix. Works like a charm. Just have max_trace_file_size big enough for any single piece. If the limit is reached once the trace remains off even of you switch to a new file. That latter property may depend on the ps platform. 


Sent from my iPod

On Apr 20, 2009, at 12:16 PM, A Joshi <ajoshi977@xxxxxxxxx> wrote:


Tim,
I know the trace file name. I want to have a different name. For example I have a long procedure running for hours. I do a 
oradebug setospid 400
oradebug unlimit
oradebug event 10046 trace name context forever , level 12
then after 5minutes :
oradebug event 10046 trace name context off
to get the trace file. This makes the file quite bulky. Then I do some changes like create index, analyze etc and after sometime I do this trace again and so on. I want to do the second part to separate file.
I might need to do this couple of time and cannot have a 1GB trace file.
I also cannot remove the file or empty the trace file. Because after that nothing goes into the file. Thanks 

--- On Sun, 4/19/09, Tim Gorman <tim@xxxxxxxxx> wrote:
From: Tim Gorman <tim@xxxxxxxxx>
Subject: Re: ** trace file
To: ajoshi977@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Date: Sunday, April 19, 2009, 1:37 PM
If you're going to use ORADEBUG, then how about taking another approach and simply obtaining the regular trace file name using ORADEBUG TRACEFILE_NAME instead? 

Hope this helps!
Tim Gorman
consultant - Evergreen Database Technologies, Inc.
P.O. Box 630791, Highlands Ranch CO  80163-0791
website   = http://www.EvDBT.com/
email     = Tim@xxxxxxxxx
mobile    = +1-303-885-4526
fax       = +1-303-484-3608
Yahoo IM  = tim_evdbt


A Joshi wrote:


Hi,
Is there a way to give a specific name to a trace file. Thanks for help. tracefile_identifier can be used as below : 
alter session set tracefile_identifier='XY'
However, this does not seem to work for

oradebug setospid 400
oradebug unlimit
oradebug event 10046 trace name context forever , level 12
This is needed since same process could be running long and a new trace file is needed and old one needs to be deleted. I tried enabling trace for some time and then doing : 

oradebug event 10046 trace name context off
then enabling it again : this seems to add to the trace file but not much luck with getting the info using tkprof. Can someone help. Thanks.
I tried emptying trace file by moving another file to it and then doing vi and deleting contents. However, after that it does not write to the file. Thanks

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2009