Unanswered: 10g shared_pool_size must be 62198988, I need it to be 4M!
We have a sever with over 60 9i standby databases on, all with a shared_pool_size = 4M so the server runs under the 4gig of ram it has.
They run in standby mode and apply the redo logs perfectly with that amount of memory which is all they need to do, Obviously the memory would be changed if the standby database was activated.
I am in the process of upgrading databases to 10g but I cannot start the database in standby mode with less than 62M, I just get an error stating the shared_pool_size must be at least 62198988. I am going to need another 4 gig of ram to be able to do that!! Does anyone know if there is a way around this so I can continue to run the databases in 10g with 4M shared_pool_size?
There are 10 types of people in the world, those that know Binary and those that don't.