v$sqlarea

SQL> desc v$sqlarea;
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 SQL_TEXT					    VARCHAR2(1000)
 SQL_FULLTEXT					    CLOB
 SQL_ID 					    VARCHAR2(13)
 SHARABLE_MEM	 cursor使用的共享内存总数		    NUMBER
 PERSISTENT_MEM 				    NUMBER
 RUNTIME_MEM					    NUMBER
 SORTS						    NUMBER
 VERSION_COUNT		语句cursor的数量		    NUMBER
 LOADED_VERSIONS				    NUMBER
 OPEN_VERSIONS					    NUMBER
 USERS_OPENING					    NUMBER
 FETCHES					    NUMBER
 EXECUTIONS					    NUMBER
 PX_SERVERS_EXECUTIONS				    NUMBER
 END_OF_FETCH_COUNT				    NUMBER
 USERS_EXECUTING				    NUMBER
 LOADS						    NUMBER
 FIRST_LOAD_TIME				    VARCHAR2(76)
 INVALIDATIONS					    NUMBER
 PARSE_CALLS					    NUMBER
 DISK_READS					    NUMBER
 DIRECT_WRITES					    NUMBER
 BUFFER_GETS					    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
 ROWS_PROCESSED 				    NUMBER
 COMMAND_TYPE					    NUMBER
 OPTIMIZER_MODE 				    VARCHAR2(10)
 OPTIMIZER_COST 				    NUMBER
 OPTIMIZER_ENV					    RAW(2000)
 OPTIMIZER_ENV_HASH_VALUE			    NUMBER
 PARSING_USER_ID				    NUMBER
 PARSING_SCHEMA_ID				    NUMBER
 PARSING_SCHEMA_NAME				    VARCHAR2(30)
 KEPT_VERSIONS					    NUMBER
 ADDRESS	sql语句在sga中的地址		    RAW(8)    
 HASH_VALUE	sql语句的hash值			    NUMBER
 OLD_HASH_VALUE 				    NUMBER
 PLAN_HASH_VALUE				    NUMBER
 MODULE 					    VARCHAR2(64)
 MODULE_HASH					    NUMBER
 ACTION 					    VARCHAR2(64)
 ACTION_HASH					    NUMBER
 SERIALIZABLE_ABORTS				    NUMBER
 OUTLINE_CATEGORY				    VARCHAR2(64)
 CPU_TIME					    NUMBER
 ELAPSED_TIME					    NUMBER
 OUTLINE_SID					    VARCHAR2(40)
 LAST_ACTIVE_CHILD_ADDRESS			    RAW(8)
 REMOTE 					    VARCHAR2(1)
 OBJECT_STATUS					    VARCHAR2(19)
 LITERAL_HASH_VALUE				    NUMBER
 LAST_LOAD_TIME 				    DATE
 IS_OBSOLETE					    VARCHAR2(1)
 IS_BIND_SENSITIVE				    VARCHAR2(1)
 IS_BIND_AWARE					    VARCHAR2(1)
 CHILD_LATCH					    NUMBER
 SQL_PROFILE					    VARCHAR2(64)
 SQL_PATCH					    VARCHAR2(30)
 SQL_PLAN_BASELINE				    VARCHAR2(30)
 PROGRAM_ID					    NUMBER
 PROGRAM_LINE#					    NUMBER
 EXACT_MATCHING_SIGNATURE			    NUMBER
 FORCE_MATCHING_SIGNATURE			    NUMBER
 LAST_ACTIVE_TIME				    DATE
 BIND_DATA					    RAW(2000)
 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
 OPTIMIZED_PHY_READ_REQUESTS			    NUMBER
 LOCKED_TOTAL					    NUMBER
 PINNED_TOTAL					    NUMBER
 IO_CELL_UNCOMPRESSED_BYTES			    NUMBER
 IO_CELL_OFFLOAD_RETURNED_BYTES 		    NUMBER

SQL> 

本视图持续跟踪所有shared pool中的共享cursor，在shared pool中的每一条SQL语句都对应一列。本视图在分析SQL语句资源使用方面非常重要。