how to put sid in alter syntax at oracle RAC db
592815Oct 17 2009 — edited Oct 17 2009Hi Experts,
I have 4 nodes RAC database. I want to modify system parameter as
ALTER SYSTEM RESET timed_statistics SCOPE=SPFILE SID=‘*’;
INST_ID INSTANCE_NAME
---------- ----------------
3 sale3
2 sale2
1 sale1
4 sale4
if I want to change parameter at one node. how do I put sid in alter command as
ALTER SYSTEM RESET timed_statistics SCOPE=SPFILE SID=‘sale1’;
Thanks
Jim