AW: sql_trace parameter

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Tue, 9 Jan 2001 12:50:43 +0100
Message-Id: <10736.126100@fatcity.com>

Allessandro and Lisa,

a few month ago there was a discussion about setting "user_dump_dest" = from
session. The result was that it depends on Oracle Version and OS if = this
parameter can is modifiable by session. Here are the results:

NT 4.0	7.3.4		FALSE
		8.0.4		FALSE
		8.0.5		FALSE
		8.1.5		FALSE
		8.1.6		FALSE

WIN2000	8.1.6		IMMEDIATE

LINUX		8.1.5		IMMEDIATE

SOLARIS	8.0.6		IMMEDIATE
		8.1.6		IMMEDIATE

AIX		8.1.5		IMMEDIATE
		8.1.6.2	IMMEDIATE

I think setting SQL_TRACE is also OS dependend.

Regards

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: alessandro_at_applysolutions.com.br
[mailto:alessandro_at_applysolutions.com.br] Gesendet: 08. January 2001 22:13
An: Multiple recipients of list ORACLE-L Betreff: Re: sql_trace parameter

Lisa,
the false is incorrect, you can modify it on the=20 session level.=20
maybe this is a bug
Alessandro Guimaraes

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author:=20
  INET: alessandro_at_applysolutions.com.br

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). Received on Tue Jan 09 2001 - 05:50:43 CST