Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Listing parameters changed at the session level
Walt,
How about select * from v$parameter where ismodified ='MODIFIED';
Extract of doco is below (817 reference manual on v$parameter)
ISMODIFIED
VARCHAR2(10)
Indicates how the parameter was modified. If an ALTER SESSION was
performed, the value will be MODIFIED. If an ALTER SYSTEM (which will cause
all the currently logged in sessions' values to be modified) was performed
the value will be SYS_MODIFIED
Regards,
Bruce Reardon
-----Original Message-----
Sent: Friday, 6 July 2001 8:27
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 18:31:02 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |