oracle v$sqlstats 视图的使用

字段列表

列名	数据类型
SQL_TEXT	VARCHAR2
SQL_FULLTEXT	CLOB this column
SQL_ID	VARCHAR2
LAST_ACTIVE_TIME	DATE
LAST_ACTIVE_CHILD_ADDRESS	RAW
PLAN_HASH_VALUE	NUMBER
PARSE_CALLS	NUMBER
DISK_READS	NUMBER
DIRECT_WRITES	NUMBER
BUFFER_GETS	NUMBER
ROWS_PROCESSED	NUMBER
SERIALIZABLE_ABORTS	NUMBER
FETCHES	NUMBER
EXECUTIONS	NUMBER
END_OF_FETCH_COUNT	NUMBER
END_OF_FETCH_COUNT	column
LOADS	NUMBER
VERSION_COUNT	NUMBER
INVALIDATIONS	NUMBER
PX_SERVERS_EXECUTIONS	NUMBER
CPU_TIME	NUMBER
ELAPSED_TIME	NUMBER
AVG_HARD_PARSE_TIME	NUMBER
APPLICATION_WAIT_TIME	NUMBER
CONCURRENCY_WAIT_TIME	NUMBER
CLUSTER_WAIT_TIME	NUMBER
USER_IO_WAIT_TIME	NUMBER
PLSQL_EXEC_TIME	NUMBER
JAVA_EXEC_TIME	NUMBER
SORTS	NUMBER
SHARABLE_MEM	NUMBER
TOTAL_SHARABLE_MEM	NUMBER
TYPECHECK_MEM	NUMBER
IO_CELL_OFFLOAD_ELIGIBLE_BYTES	NUMBER
IO_INTERCONNECT_BYTES	NUMBER
PHYSICAL_READ_REQUESTS	NUMBER
PHYSICAL_READ_BYTES	NUMBER
PHYSICAL_WRITE_REQUESTS	NUMBER
PHYSICAL_WRITE_BYTES	NUMBER
EXACT_MATCHING_SIGNATURE	NUMBER
FORCE_MATCHING_SIGNATURE	NUMBER
IO_CELL_UNCOMPRESSED_BYTES	NUMBER
IO_CELL_OFFLOAD_RETURNED_BYTES	NUMBER