resizing of shared_pool and shared_pool_reserved

Hi,

i've had a problem with backing up a physical standby (10.2.0.3 on AIX using ASM). i get ORA-4031 ("ASM EXTENT POINTER ARRAY") while running the backup and the instance crashes. the instance is configured to use automatic memory management. there's a similar bug 4237613 which has been fixed in 10.2.0.2 but applying the patch didn't solve the problem.
i nailed down the problem to a too small reserved shared pool. shared_pool_reserved_size is derived (default 5%) from shared_pool_size, the latter is dynamically managed by AMM. would the reserved shared pool be resized if the shared pool is grown/shrinked by AMM to keep it at 5%? the second question: if i set shared_pool_reserved_size to a value, will it become static? the documentation isn't very clear about the first question and i'm not sure about the second one.

regards,
-ap Received on Mon Feb 05 2007 - 13:21:07 CST