Hi!!
how to calculate the utilization of the SGA, like utilization of "Data buffer cache", "Redo Log Buffer", "Library cache" and "Data dict. cache"??
help me...thanks
Printable View
Hi!!
how to calculate the utilization of the SGA, like utilization of "Data buffer cache", "Redo Log Buffer", "Library cache" and "Data dict. cache"??
help me...thanks
You could use some tools like dbtools for SGA utilization. You can download a evaluation at:
http://www.softtreetech.com/
thank you, ggnanaraj...
But, I need the script or formula to calculate the utilization(ex. from the V$ tables)??
Do you have other idea about it??
thanks...
v$sgastat