Databases Reference
In-Depth Information
The output will be as follows:
We are interested in the SQL AREA values, the first in the response, which indicates a
GETHITRATIO of 26 percent (poor value) for our example. For an OLTP database, we probably
want a value of .99999, while in a data warehouse environment a value above .9 is good.
To investigate parse data in a session, use the following statement:
SELECT S.NAME, V.VALUE FROM V$STATNAME S, V$MYSTAT V
WHERE S.STATISTIC# = V.STATISTIC# AND S.NAME LIKE 'parse%';
The output will be as follows:
