Re: 10g alter system set pga_aggre etc
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.
Hemant K ChitaleReceived on Fri Sep 26 2008 - 10:24:16 CDT