RE: Looking for all events

From: McGlaughlin,Stewart <mcglaughlin_at_attws.com>
Date: Tue, 9 May 2000 15:28:52 -0400
Message-Id: <10492.105297@fatcity.com>

Gautam,

The following query should give you what you're looking for:

select NAME,

         VALUE,
         ISDEFAULT,
         ISSES_MODIFIABLE,
         ISMODIFIED
from     sys.v_$parameter

order by NAME;

Is Default - Whether the parameter value is the default. FALSE indicates the value has
been altered in the init.ora. Session Modifiable - TRUE=the parameter can be changed
with ALTER SESSION / FALSE=the parameter cannot be changed with ALTER SESSION System Modifiable - IMMEDIATE=the parameter can be changed with ALTER SYSTEM /
DEFERRED=the parameter cannot be changed until the next session / FALSE=the parameter cannot be changed with ALTER SYSTEM

Is Modified - 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. HTH

---

Stewart McGlaughlin
Oracle DBA
On-site at AT&T Wireless Services
Oracle Links @ http://www.pobox.com/~dba/oracle stewartm_at_iname.com

> >
> > Where can I find all the events that I can set in the init ora or
> through
> > alter system command. I have done RTFM but couldn't find it also went
> > through technet and metalink no luck there too. Hoping someone has some
> > pointers to this info.
> >
> >
> > Thx
> > Gautam Reddy
> >
> >
> --
> Author:
> INET: sheisey_at_att.net
>
> 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 Tue May 09 2000 - 14:28:52 CDT