Re: Listing parameters changed at the session level

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Thu, 05 Jul 2001 16:21:43 -0700
Message-ID: <F001.003424CE.20010705161105@fatcity.com>

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 
<ORACLE-L_at_fatcity.com>  
                    <wweaver_at_righ        cc:                                           
                       
                    tnow.com>            Subject:     Listing parameters changed at 
the session level         
                    Sent by:                                                           
                       
                    root_at_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: wweaver_at_rightnow.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).

--

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

Author:
INET: DBarbour_at_austin.isd.tenet.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