dba_enabled_aggregations(二)
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
AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
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
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
已选择27行。
SQL> l
1* select aggregation_type,service_name,module,action,stat_name,value from v$serv_mod_act_stats
SQL> /
AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
SERVICE_MODULE_ACTION easy tm ta user calls 0
SERVICE_MODULE_ACTION easy tm ta DB time 0
SERVICE_MODULE_ACTION easy tm ta DB CPU 0
SERVICE_MODULE_ACTION easy tm ta parse count (total) 0
SERVICE_MODULE_ACTION easy tm ta parse time elapsed 0
SERVICE_MODULE_ACTION easy tm ta execute count 0
SERVICE_MODULE_ACTION easy tm ta sql execute elapsed time 0
SERVICE_MODULE_ACTION easy tm ta opened cursors cumulative 0
SERVICE_MODULE_ACTION easy tm ta session logical reads 0
SERVICE_MODULE_ACTIO
N easy tm ta physical reads 0
SERVICE_MODULE_ACTION easy tm ta physical writes 0
AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
SERVICE_MODULE_ACTION easy tm ta redo size 0
SERVICE_MODULE_ACTION easy tm ta user commits 0
SERVICE_MODULE_ACTION easy tm ta workarea executions - optimal 0
SERVICE_MODULE_ACTION easy tm ta workarea executions - onepass 0
SERVICE_MODULE_ACTION easy tm ta workarea executions - multipas 0
s
SERVICE_MODULE_ACTION easy tm ta session cursor cache hits 0
SERVICE_MODULE_ACTION easy tm ta user rollbacks 0
SERVICE_MODULE_ACTION easy tm ta db block changes 0
SERVICE_MODULE_ACTION easy tm ta gc cr blocks received 0
AGGREGATION_TYPE SERVICE_NA MODULE ACTION STAT_NAME VALUE
--------------------- ---------- ---------- -------------------- ------------------------------ ----------
SERVICE_MODULE_ACTION easy tm ta gc cr block receive time 0
SERVICE_MODULE_ACTION easy tm ta gc current blocks received 0
SERVICE_MODULE_ACTION easy tm ta gc current block receive time 0
SERVICE_MODULE_ACTION easy tm ta cluster wait time 0
SERVICE_MODULE_ACTION easy tm ta concurrency wait time 0
SERVICE_MODULE_ACTION easy tm ta application wait time 0
SERVICE_MODULE_ACTION easy tm ta user I/O wait time 0
SERVICE_MODULE easy tm user calls 0
SERVICE_MODULE easy tm DB time 0
SERVICE_MODULE easy tm DB CPU 0
SERVICE_MODULE easy tm parse count (total) 0