Hi There
i am working on oracle 9i (9.2.0.8) on Aix, I am getting following out put from v$librarycahe.
SQL> select namespace,gethitratio from v$librarycache;

NAMESPACE GETHITRATIO
--------------- -----------
SQL AREA .964931564
TABLE/PROCEDURE .978323687
BODY .947667078
TRIGGER .998990466
INDEX .83909404
CLUSTER .991260015
OBJECT 1
PIPE 1
JAVA SOURCE 1
JAVA RESOURCE 1
JAVA DATA .673913043

11 rows selected.
so can any one let me how can i require desier
gethitratio.

Thanks in Advance
Regards
Mohsin...