Home » RDBMS Server » Performance Tuning » Cannot find TraceFile for SESSION (Oracle Database 11g Release 11.1.0.7.0 - 64bit Production Windows)
Cannot find TraceFile for SESSION [message #562825] Mon, 06 August 2012 03:17
Andrey_R
Messages: 321
Registered: January 2012
Location: Israel
Senior Member

Hi All,

I'm trying to understand why I cannot find a tracefile for my session.

what I did is:

SQL> alter session set max_dump_file_size = unlimited timed_statistics = true session_cached_cursors
 = 1500 tracefile_identifier = 'ARP_20120806_1' events = '10053 trace name context forever, level 1'
;

Session altered.

Elapsed: 00:00:00.00
SQL> set termout off
SQL> set serveroutput on
SQL> set timing on
SQL>
SQL> select count(*) from dba_objects;

  COUNT(*)
----------
    135930

1 row selected.

Elapsed: 00:00:00.37
SQL> alter session set session_cached_cursors = 0;

Session altered.

Elapsed: 00:00:00.00
SQL> alter session set events = '10053 trace name context off';

Session altered.

Elapsed: 00:00:00.00
SQL>
SQL>
SQL> set termout on
SQL>
SQL> SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Default Trace File';

VALUE
----------------------------------------------------------------------------------------------------
--------------------------------------------------
Z:\oracle\........\some_db_ora_1820_ARP_20120806_1.trc

1 row selected.

Elapsed: 00:00:00.04
SQL>


in the path Z:\oracle\........\some_db_ora_1820_ARP_20120806_1.trc (changed for security reasons)
I cannot find a tracefile, and I don't understand why....

Anyone knows what am I missing here?
Thanks in advance.

Regards,
Andrey

[Updated on: Mon, 06 August 2012 03:18]

Report message to a moderator

Previous Topic: Performance difference of same query in 2 database
Next Topic: Increased LOGFILE did not increase performance
Goto Forum:
  


Current Time: Fri Jul 10 15:11:19 CDT 2020