Sunday, July 8, 2012

Changing SPFILE parameters in Oracle RAC Cluster





For Cluster wide Changes


ALTER SYSTEM SET OPEN_CURSORS=1500 sid='*' SCOPE=MEMORY;

to change parameters for One Instance

ALTER SYSTEM RESET OPEN_CURSORS SCOPE=SPFILE sid='prod1';


ALTER SYSTEM RESET OPEN_CURSORS SCOPE=SPFILE sid='*';

No comments:

Post a Comment