Hi Walt -
Kinda getting into this myself recently. I found a reference to an
undocumented dbms package on Metalink today called: dbms_system.read_ev
I'm playing around with their test scripts to see what I can do with this
in conjunction with v$session and tracing and auditing. Check out notes
1020308.6 and 28446.1
Hope this helps.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Weaver,
Walt" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<wweaver@righ cc:
tnow.com> Subject: Listing parameters changed at
the session level
Sent by:
root@fatcity.
com
07/05/2001
05:27 PM
Please
respond to
ORACLE-L
Okay, I've consulted all of the Oracle posters I have pinned to the wall
here -- my TUSC posters, the Computer Associates poster -- and I've now
gotten desperate enough that I'm starting to dig into the Oracle
documentation on Technet.
But, I figured I'd post to the list and risk getting a few RTFM replies...
Specifically, I'm trying to figure out how to list all of the database
parameters that have been changed at the session level while I'm logged in
as that session.
Even more specifically, we're playing around with some stuff here, changing
CURSOR_SHARING to FORCE at the session level, and would like to ensure that
it really is set.
Maybe I'm having a brain fart here...
Thanks,
--Walt Weaver
Bozeman, Montana, USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
