Questions on Shared_Pool and DB Buffer
Hi all,
I have two questions regarding Shared pool and DB Buffer.
1. Our Shared Pool Size is around 550MB, sometimes, in OEM performance monitor, I see that free Shared Pool goes below than 10M. I want to know how does Oracle manage in such scenarios.
Do we need to manually Flush it out?
2. How to check how much free database buffer cache is left? Is there any table, which can show free current DB buffer?
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart