SQL> desc v$sqlarea
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SQL_TEXT                                  VARCHAR2(1000)
 SQL_FULLTEXT                              CLOB
 SQL_ID                                    VARCHAR2(13)
 SHARABLE_MEM                              NUMBER
 PERSISTENT_MEM                            NUMBER
 RUNTIME_MEM                               NUMBER
 SORTS                                     NUMBER
 VERSION_COUNT                             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(19 CHAR)
 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 CHAR)
 OPTIMIZER_COST                            NUMBER
 OPTIMIZER_ENV                             RAW(882)
 OPTIMIZER_ENV_HASH_VALUE                  NUMBER
 PARSING_USER_ID                           NUMBER
 PARSING_SCHEMA_ID                         NUMBER
 PARSING_SCHEMA_NAME                       VARCHAR2(30)
 KEPT_VERSIONS                             NUMBER
 ADDRESS                                   RAW(4)
 HASH_VALUE                                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 CHAR)
 LAST_ACTIVE_CHILD_ADDRESS                 RAW(4)
 REMOTE                                    VARCHAR2(1 CHAR)
 OBJECT_STATUS                             VARCHAR2(19 CHAR)
 LITERAL_HASH_VALUE                        NUMBER
 LAST_LOAD_TIME                            DATE
 IS_OBSOLETE                               VARCHAR2(1 CHAR)
 CHILD_LATCH                               NUMBER
 SQL_PROFILE                               VARCHAR2(64)
 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

SQL> desc v$sql
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SQL_TEXT                                  VARCHAR2(1000)
 SQL_FULLTEXT                              CLOB
 SQL_ID                                    VARCHAR2(13)
 SHARABLE_MEM                              NUMBER
 PERSISTENT_MEM                            NUMBER
 RUNTIME_MEM                               NUMBER
 SORTS                                     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(19 CHAR)
 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 CHAR)
 OPTIMIZER_COST                            NUMBER
 OPTIMIZER_ENV                             RAW(882)
 OPTIMIZER_ENV_HASH_VALUE                  NUMBER
 PARSING_USER_ID                           NUMBER
 PARSING_SCHEMA_ID                         NUMBER
 PARSING_SCHEMA_NAME                       VARCHAR2(30)
 KEPT_VERSIONS                             NUMBER
 ADDRESS                                   RAW(4)
 TYPE_CHK_HEAP                             RAW(4)
 HASH_VALUE                                NUMBER
 OLD_HASH_VALUE                            NUMBER
 PLAN_HASH_VALUE                           NUMBER
 CHILD_NUMBER                              NUMBER
 SERVICE                                   VARCHAR2(64)
 SERVICE_HASH                              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                               NUMBER
 CHILD_ADDRESS                             RAW(4)
 SQLTYPE                                   NUMBER
 REMOTE                                    VARCHAR2(1 CHAR)
 OBJECT_STATUS                             VARCHAR2(19 CHAR)
 LITERAL_HASH_VALUE                        NUMBER
 LAST_LOAD_TIME                            VARCHAR2(19 CHAR)
 IS_OBSOLETE                               VARCHAR2(1 CHAR)
 CHILD_LATCH                               NUMBER
 SQL_PROFILE                               VARCHAR2(64)
 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

SQL> desc v$sqlstats
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 SQL_TEXT                                  VARCHAR2(1000)
 SQL_FULLTEXT                              CLOB
 SQL_ID                                    VARCHAR2(13)
 LAST_ACTIVE_TIME                          DATE
 LAST_ACTIVE_CHILD_ADDRESS                 RAW(4)
 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
 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