Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Should I be concerned about shared_pool_size=0

582751Jan 6 2010 — edited Jan 7 2010
Hi there,
Totally Oracle noob here, be gentle :)
I have an issue I'm trying to debug on Oracle 10G Express (mentioned in another thread on this forum) and after a bit of googling I ended up issuing:

SQL> show parameter shared
which told me:

NAME TYPE VALUE
------------------------------------ ----------- -------
hi_shared_memory_address integer 0
max_shared_servers integer
shared_memory_address integer 0
shared_pool_reserved_size big integer 9227468
shared_pool_size big integer 0
shared_server_sessions integer
shared_servers integer 4

Is there anything there that should cause concern. The reason I ask is that the problems I'm having may be related to memory - and shared_pool_size=0 seems like a bit of a red flag y'know.

So, simple question, is there anything here to be concerned about?

thanks
Jamie
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2010
Added on Jan 6 2010
11 comments
3,813 views