Automatic shared memory management with no lower bound set for the shared pool size. Check v$sgastat for actual values. Hope you weren't after a ratio;-) On 6/8/09, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx> wrote: > Hello all, > Oracle 10gR2 on HPUX. Thought I would do a little tuning. My shared > pool shows a size of 0. Why? > > ciao, > Brian > > > > > This email message may contain legally privileged and/or confidential > information. If you are not the intended recipient(s), or the employee or > agent responsible for the delivery of this message to the intended > recipient(s), you are hereby notified that any disclosure, copying, > distribution, or use of this email message is prohibited. If you have > received this message in error, please notify the sender immediately by > e-mail and delete this email message from your computer. Thank you. -- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l