12.2.0.1 : Query to check performance

Hi ,

I would like to check  database health  in order to decide whether to diagnose its performance.

The objective is to periodically pass a query on a database and the result of this query lets you know if the performance of this database is worth diagnosed.

For example : CACHE HIT RATIO

SELECT

    round(

        (1 - (phy.value / (cur.value + con.value) ) ) * 100,

        2

    ) "Cache Hit Ratio"

FROM

    v$sysstat cur,

    v$sysstat con,

    v$sysstat phy

WHERE

        cur.name = 'db block gets'

    AND

        con.name = 'consistent gets'

    AND

        phy.name = 'physical reads';

Best regards.

GD