AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
SERVICE_MODULE easy tm parse time elapsed 0
SERVICE_MODULE easy tm execute count 0
SERVICE_MODULE easy tm sql execute elapsed time 0
SERVICE_MODULE easy tm opened cursors cumulative 0
SERVICE_MODULE easy tm session logical reads 0
SERVICE_MODULE easy tm physical reads 0
SERVICE_MODULE easy tm physical writes 0
SERVICE_MODULE easy tm redo size 0
SERVICE_MODULE easy tm user commits 0
SERVICE_MODULE easy tm workarea executions - optimal 0
SERVICE_MODULE easy tm workarea executions - onepass 0
AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
SERVICE_MODULE easy tm workarea executions - multipas 0
s
SERVICE_MODULE easy tm session cursor cache hits 0
SERVICE_MODULE easy tm user rollbacks 0
SERVICE_MODULE easy tm db block changes 0
SERVICE_MODULE easy tm gc cr blocks received 0
SERVICE_MODULE easy tm gc cr block receive time 0
SERVICE_MODULE easy tm gc current blocks received 0
SERVICE_MODULE easy tm gc current block receive time 0
SERVICE_MODULE easy tm cluster wait time 0
AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
SERVICE_MODULE easy tm concurrency wait time 0
SERVICE_MODULE easy tm application wait time 0
SERVICE_MODULE easy tm user I/O wait time 0
已选择54行。
视图：v$client_stats
SQL> l
1* select client_identifier,stat_name,value from v$client_stats
SQL> /
CLIENT_IDE STAT_NAME VALUE
---------- ------------------------------ ----------
es user calls 28
es DB time 45170
es DB CPU 20997
es parse count (total) 15
es parse time elapsed 13894
es execute count 14
es sql execute elapsed time 8309
es opened cursors cumulative 19
es session logical reads 35
es physical reads 0
es physical writes 0
CLIENT_IDE STAT_NAME VALUE
---------- ------------------------------ ----------
es redo size 1976
es user commits 0
es workarea executions - optimal 0
es workarea executions - onepass 0
es workarea executions - multipas 0
s
es session cursor cache hits 6
es user rollbacks 0
es db block changes 12
es gc cr blocks received 0
CLIENT_IDE STAT_NAME VALUE
---------- ------------------------------ ----------
es gc cr block receive time 0
es gc current blocks received 0
es gc current block receive time 0
es cluster wait time 0
es concurrency wait time 0
es application wait time 0
es user I/O wait time 0
已选择27行。
注意：在service级别的统计信息总是开启的，例如
SQL> l
1* select aggregation_type from dba_enabled_aggregations
SQL> /
AGGREGATION_TYPE
---------------------
CLIENT_ID
SERVICE_MODULE
SERVICE_MODULE_ACTION
SQL> select * from v$service_stats;
SERVICE_NAME_HASH SERVICE_NA STAT_ID STAT_NAME VALUE
----------------- ---------- ---------- ------------------------------ ----------
3427