Re: Weird messages in the alert.log file

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Wed, 25 Jun 2008 09:34:12 +0800
Message-ID: <804dabb00806241834m5cf45fe3nad0104a931c40f78@mail.gmail.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 24 2008 - 20:34:12 CDT