Sys@Lin11g> alter system reset pga_aggregate_target;
System altered.
Sys@Lin11g> alter system reset sga_target;
System altered.
…no scope=spfile sid=’*’ is needed. This resets the parameter in spfile only, the values in memory persist.
Monday, June 23, 2008
oracle automatic memory management
Note that after resetting various parameters I played with I realized that finally Oracle has implemented the human-friendly way for resetting parameters in SPFILE:
Subscribe to:
Post Comments (Atom)
1 comment:
Please do more articles like this in the future. Very informational and knowledgeable. I will expect more from you in the future. For now i will just bookmark your page and surely I'm gonna come back later to read more. Thank you to the writer!
www.imarksweb.org
Post a Comment