Listing parameters changed at the session level

From: Weaver, Walt <wweaver_at_rightnow.com>
Date: Thu, 05 Jul 2001 14:34:47 -0700
Message-ID: <F001.00342338.20010705142703@fatcity.com>

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). Received on Thu Jul 05 2001 - 16:34:47 CDT