Hi all, Thanks for all your reply.. I got the solution.


Thanks,
Saroja.



"Holley Craig W. "
<oracledba-ezmlmshield-x66796271.[Email address protected]
11/02/2006 03:36 PM

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

Subject
RE: ORA-02095: specified initialization parameter cannot be modif ied






Nope. Can't be set in session, requires a reboot param change.

-----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

**************************************************************************************
The information contained in this email is privileged and confidential
information intended only for the use of the individual or entity named as
recipient. If the reader is not the intended recipient, please be
notified that any dissemination, distribution, or copy of this
communication is strictly prohibited. If you have received this
communication in error, please do not disclose this communication to any
other person. Please notify us immediately by telephone and return the
original to us at the address indicated above. 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


ForwardSourceID:NT000047AE

Oracle LazyDBA home page