Re: Weird messages in the alert.log file
Date: Wed, 25 Jun 2008 09:34:12 +0800
Got a new break today.
Just checking the memory:
SQL> show parameter shared
hi_shared_memory_address integer 0 max_shared_servers integer shared_memory_address integer 0 shared_pool_reserved_size big integer 3M shared_pool_size big integer 60M shared_server_sessions integer shared_servers integer 0SQL> I realized that I had set the shared_pool_size to that number because earlier it had complained (while trying to install the smallest database I can experiment on):
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
So I promptly just set it exactly that values - thinking it must be some 600M number.
Ok...borderline values for shared_pool_size does turned up a lot of interesting issues.Received on Tue Jun 24 2008 - 20:34:12 CDT