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

Oracle LazyDBA home page