Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<40585F8E.91B3C9B7_at_remove_spam.peasland.com>...
> > to round it off, we cant change the value in v$parameter right?
> >
> > for this to happen, we have to put it in initsid.ora
>
> Some parameters can be changed "on the fly". You'll have to look in
> V$PARAMETER, specifically the ISSYS_MODIFIABLE column. This will let you
> know if you can use the ALTER SYSTEM command to modify it "on the fly".
> If not, then your only recourse is to modify your INIT.ORA file, then
> you will have to bounce the database.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
thanks for the info
Received on Wed Mar 17 2004 - 23:07:41 CST
