Should I be concerned about shared_pool_size=0
582751Jan 6 2010 — edited Jan 7 2010Hi 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