Re: Weird messages in the alert.log file

From: Peter Teoh <>
Date: Wed, 25 Jun 2008 09:34:12 +0800
Message-ID: <>

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     0
SQL> 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

Original text of this message