Click here to Login !
White Papers
UNIX
Database Details
License Information
INIT.ORA Parameters
Database File Information
Tablespace Information
Tablespace Usage Report
Table Fragmentation
Invalid Objects
SQL With Most Disk Reads
Buffer Hit Ratio
Library Cache Hit Ratio
Data Dictionary Hit Ratio
Library Cache Hit Ratio
select
sum(PINS),
sum(PINHITS),
round((sum(PINHITS) / sum(PINS)) * 100,3)
sum(RELOADS),
round((sum(PINS) / (sum(PINS) + sum(RELOADS))) * 100,3)
from
sys.v_$librarycache;
F.A.Q.
|
Terms & Conditions
|
Contact Us
©2005 Dibon
. All rights reserved.
