1、查看硬解析与总解析比
SQL> select (select value from v$sysstat where name ='parse count (hard)')/(select value from v$sysstat where name ='parse count (total)') from dual;
SQL> select (select value from v$sysstat where name ='parse count (hard)')/(select value from v$sysstat where name ='parse count (total)') from dual;