Hi david,

Thanks for your reply. when i tried this statement mentioning
scope=spfile, i get this error.

ORA-32001: write to SPFILE requested but no SPFILE specified at startup

Thanks,
Saroja



"David Chiu " <oracledba-ezmlmshield-x10413030.[Email address protected]
11/02/2006 02:55 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: ORA-02095: specified initialization parameter cannot be modified







This parameter is not a dynamic parameter,
So you must bounce the instance for it to take effect.

As sys:
alter system set parallel_automatic_tuning = FALSE scope=spfile;
Create pfile from spfile;

Then bounce the instance

------------------------------------------------------------------------
----
David Chiu

-----Original Message-----
From: sarojadevi
[mailto:oracledba-ezmlmshield-x35336577.[Email address protected]
Sent: Thursday, November 02, 2006 9:45 AM
To: LazyDBA Discussion
Subject: ORA-02095: specified initialization parameter cannot be
modified

Hi gurus,

when i try to alter this parameter parallel_automatic_tuning = FALSE i
end up with this error. Is there any other way to change this parameter
without shutting down the db. Please help...

It's very urgent!!!

ORA-02095: specified initialization parameter cannot be modified

Thanks,
Saroja.
=====-----=====-----=====
Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


ForwardSourceID:NT0000FB76

Oracle LazyDBA home page