How to know how much BUFFER CACHE is used at a point in time.
Is there any script..?
I think that the system view x$bh can be used for that.
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio
It is X$BH.STATE.
But V$BH.STATUS is more readable.
Thanks and Regards,