Re: sql_trace parameter

oops, replied to the wrong post previously.

Lisa,,

You deleted the trace file while the session was still open.

Oracle will not recreate it. You can truncate the file, but do not delete it.

Jared

On Mon, 8 Jan 2001, Lisa Yates wrote:

>
> Hi gurus....
>
> I've got a problem with my sql_trace parameter. I am unable to set it to
> TRUE now, however, I was able to earlier today. Here's the scenerio:
>
> 1) alter session set timed_statistics = true
>
> 2) alter session set sql_trace = true
>
> 3) run script I want analyzed
>
> 4) alter session set sql_trace = false
>
> 5) use another terminal and run tkprof on trace output
>
> 6) alter session set sql_trace = true
>
> 7) run another script I want analyzed
>
> 8) alter session set sql_trace = false
>
> 9) use another terminal and run tkprof on trace output
>
> 10) delete *.trc file
>
> 11) alter session set sql_trace = true
>
> 12) run another script I want analyzed
>
> 13) alter session set sql_trace = false
>
> 14) use another terminal and discover my trace output is not there
>
> 15) exit from sql session
>
> 16) login to sql again
>
> 17) look at v$parameter for sql_trace...it says is_sesmodifiable = false
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> 18) bounce the db
>
> 19) login to sql again
>
> 20) sql_trace is still not session modifiable (or system for that matter!)
>
> How can I make it modifiable again and what did I do to make it
> unmodifiable? TIA.
>
> Lisa
>
>
> ********************************************
> * Lisa Yates cosnit_at_creighton.edu *
> * Creighton University *
> * Omaha, Nebraska *
> * (402) 280-2419 fax: (402) 280-2573 *
> * Define the Universe, give 2 examples. *
> ********************************************
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lisa Yates
> INET: cosnit_at_creighton.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) Received on Tue Jan 09 2001 - 11:04:24 CST