shared pool usage
I know I can run select * from x$ksmlru where ksmlrsiz >0;
But I am not comfortable to run this on a production machine. I want to know how much our memory is at and decide whether to increase or not. Version 10.2.0.3. on solaris 10.