Re: 10g alter system set pga_aggre etc
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Sep 2008 23:24:16 +0800
Changes by ASMM (or AMM in 11g -- not sure about the behaviour in
11g) are not logged in the alert.log. However, the spfile does get
updated at shutdown (Thus, if __db_cache_size and
__shared_pool_size got dynamically changed 20 times, there are no
entries in the alert.log but the last set of values are wriitten into
the spfile at shutdown (the other 19 changes don't appear anywhere
except in v$SGA_RESIZE_OPS).
At 12:34 AM Friday, Michael McMullen wrote:
Are the alter system commands that show up in the alert log only as
a result of a human issuing them? Ie if oracle changes anything with
automatic memory management it wouldn't show up in the alert log as
an alter system command. Just want to make sure.
Thanks
Hemant K Chitale
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
