请教：v$sql,v$sqltext,v$sqlarea这三个view有什么分别？在何种情况下使用？ 谢谢!

Question

V$SQL Information about Sql processes running now. Columns
   ___________________________
 
   SQL_TEXT

Answer 1

V$SQLTEXT Data Dictionary View Columns
   ___________________________
 
   ADDRESS
   HASH_VALUE
   COMMAND_TYPE
   PIECE
   SQL_TEXT

Answer 2

V$SQLAREA Data Dictionary View Columns
   ___________________________
 
   SQL_TEXT
   SHARABLE_MEM
   PERSISTENT_MEM
   RUNTIME_MEM
   SORTS
   VERSION_COUNT
   LOADED_VERSIONS
   OPEN_VERSIONS
   USERS_OPENING
   FETCHES
   EXECUTIONS
   USERS_EXECUTING
   LOADS
   FIRST_LOAD_TIME
   INVALIDATIONS
   PARSE_CALLS
   DISK_READS
   BUFFER_GETS
   ROWS_PROCESSED
   COMMAND_TYPE
   OPTIMIZER_MODE
   PARSING_USER_ID
   PARSING_SCHEMA_ID
   KEPT_VERSIONS
   ADDRESS
   HASH_VALUE
   MODULE
   MODULE_HASH
   ACTION
   ACTION_HASH
   SERIALIZABLE_ABORTS
   CPU_TIME
   ELAPSED_TIME
   IS_OBSOLETE
   CHILD_LATCH