OraFAQ Forum: Performance Tuning » nothing in trace-file

Home » RDBMS Server » Performance Tuning » nothing in trace-file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

nothing in trace-file [message #208073]

Fri, 08 December 2006 01:12

AndreyPozhidaev
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
begin
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 ?

Report message to a moderator

Re: nothing in trace-file [message #208121 is a reply to message #208073]

Fri, 08 December 2006 04:52

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: nothing in trace-file [message #208267 is a reply to message #208073]

Fri, 08 December 2006 23:27

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

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

eg:

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

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

TKPROF: Release 10.1.0.2.0 - 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

C:\>

regards
Taj

Report message to a moderator

Previous Topic:	query tunning
Next Topic:	Timed out trying to start process J002 massage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:11:52 CST 2024