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