Home » RDBMS Server » Performance Tuning » nothing in trace-file
icon5.gif  nothing in trace-file [message #208073] Fri, 08 December 2006 01:12 Go to next message
Messages: 9
Registered: December 2005
Location: St. Petersburg
Junior Member

DB version 10.2.
Trigger on logon for tracing:

create trigger TRG_LOGON after logon on database
if (user='SUB') then
execute immediate 'alter session set tracefile_identifier = TEST_TEST';
EXECUTE IMMEDIATE 'alter session set MAX_DUMP_FILE_SIZE = unlimited';
execute immediate 'alter session set TIMED_STATISTICS = TRUE';
execute immediate 'alter session set events ''10046 trace name context forever, level 8''';
end if;
end ;

Session works correctly.
SQL-trace file created, but contains only one row like

: Dump file .../u01/home/oracle/admin/db/udump/x_ora_9999_qwerty.trc

and nothing else.

Why ?
Re: nothing in trace-file [message #208121 is a reply to message #208073] Fri, 08 December 2006 04:52 Go to previous messageGo to next message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh well, this is probably a complete nonsense, but - could you go to this directory and run TKPROF against 'x_ora_9999_qwerty.trc' file? After it is completed, read a human readable file (instead of a .trc file).
Re: nothing in trace-file [message #208267 is a reply to message #208073] Fri, 08 December 2006 23:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


as littlefoot mention ur "readable file"
then you can generate .txt file through tkprof utility for .trc files.


start >>>>> run >>>> cmd

C:\>tkprof D:\oracle\product\10.1.0\admin\orcl\bdump\orcl_ora_656.trc c:\tracef

TKPROF: Release - Production on Sat Dec 9 09:25:08 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

C:\>dir tracefile.txt
Volume in drive C has no label.
Volume Serial Number is CC55-E5A1

Directory of C:\

09-12-2006 09:25 AM 1,221 tracefile.txt
1 File(s) 1,221 bytes
0 Dir(s) 8,544,964,608 bytes free


Previous Topic: query tunning
Next Topic: Cost is high
Goto Forum:

Current Time: Sun Aug 20 03:09:48 CDT 2017

Total time taken to generate the page: 0.06655 seconds