Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> some sql_trace related issue on 7.3.4

some sql_trace related issue on 7.3.4

From: <larry_xu_at_attglobal.net>
Date: Tue, 26 Oct 1999 01:15:19 -0400
Message-ID: <38153d18_3@news1.prserv.net>


Server 7.3.4.0.0. Client SQLPlus (NT) 3.3.4.0.0.

I have done "ALTER SESSION SET SQL_TRACE=TRUE;' many times to produce trace file for
tkprof.

In the middle of day, for whatever reason. after issue this statement,  a trace file with 0 byte was created in 'user_dump_dest' directory.  background info: this problem was happened shortly  after a 35MB trc file was written and truncated to 'user_dump_dest' without reach to the max_dump_file_size 102400 * 512 = 51MB )

Anybody encountered such a case while using sql_trace ? could it be possible that run out of disk/directory quota ?
Thanks in advance for any hint.

BTW, I also notice that by querying v$parameter NAME TYPE VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ DESCRIPTION
---------- --------- ---------- --------- -----

even after 'alter session set sql_trace=true'. Why?

In my opinion, it should read like:

VALUE                    : TRUE
ISDEFAULT             : FALSE

ISSES_MODIFIABLE: TRUE
ISSYS_MODIFIABLE: TRUE
ISMODIFIED             : MODIFIED
ISADJUSTED            : FALSE





Received on Tue Oct 26 1999 - 00:15:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US