Re: Huge "shmmax" & tiny "shared_memory_size"

srivenu wrote:

> shmsys:shminfo_shmmax=4294967295
> This specifies the size of the maximum shared memory segment that you
> can have.
> Its o.k. even if your current instance size is way smaller than this.
> If later you want to increase the size of your instance, you can do so
> without needing to reboot the system.
> What kind of shared memory errors are you getting ?
> Your shared_memory_size is not 9000000, Your shared pool size is 9MB
> and i think it is very small.
> regards
> Srivenu

And if you don't follow Oracle's documented recommendations for shared memory and semaphore parameters you will likely become quite friendly with ORA-03113.

Daniel Morgan Received on Wed Jan 08 2003 - 10:55:19 CST