| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Alter different session
I was interested in this as well and all I could find was the followng Metalink Note which refers to setting tracing on not altering a different session. It also refers to a package DBMS_SUPPORT which seems to fit the same purpose but appears relatively short-lived as it dissapeared in 8.1.6 onwards. I assume the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION is seen as the prefferred option and there is no need for another package to do the same thing.
Just as a matter of interest what is your actual requirement for this as I cannot think of a reason at the moment
John
Note from Metalink - refers to setting trace on only. As recently as 5/18/2000 in doc id: NOTE:77343.1 the recommendation for setting level 4 trace for a specific session is to use DBMS_SYSTEM.SET_EV. See section 6.4 Level 4 Trace (Method 2).
As this is an important method to set the trace level, what method is recommended as a substitute if the SET_EV is no longer viable, considering I perform this via cron when needed until I can bounce the system to set it in init:
spool /tmp/settrace4.sql;
select 'EXEC DBMS_SYSTEM.SET_EV('||SID||','||SERIAL#||',10046,4,'''')'
from v$session;
select 'EXIT;' from dual;
spool off;
-----Original Message-----
From: Libal, Ivo [mailto:ivo.libal_at_knapp-systems.com]
Sent: 30 October 2001 08:45
To: Multiple recipients of list ORACLE-L
Subject: Alter different session
Hello
Is it possible to alter different session or can I change parameters only of
my own session (using 'alter session ...')
What priviledges do I need to do it? Is there a procedure to do it? (like
dbms_system.set_ev for events)
Kind regards
Ivo Libal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Libal, Ivo
INET: ivo.libal_at_knapp-systems.com
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).
 |
 |