iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

 

Oracle Dictionary Tables

ALL_  |  DBA_  |  USER_  |  GV$  |  V$  |  Others

ACC... | BAC... | DAT... | ENQ... | INS... | LOG... | PGA... | ROW... | SES... | SQL... | SYS...

 

GV$SESSION_WAIT_HISTORY: Synonym for GV_$SESSION_WAIT_HISTORY

 

iSelfSchooling-SQL> desc GV$SESSION_WAIT_HISTORY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SID                                    NUMBER

 SEQ#                                   NUMBER

 EVENT#                                 NUMBER

 EVENT                                  VARCHAR2(64)

 P1TEXT                                 VARCHAR2(64)

 P1                                     NUMBER

 P2TEXT                                 VARCHAR2(64)

 P2                                     NUMBER

 P3TEXT                                 VARCHAR2(64)

 P3                                     NUMBER

 WAIT_TIME                              NUMBER

 WAIT_COUNT                             NUMBER

 

GV$SESSMETRIC: Synonym for GV_$SESSMETRIC

 

iSelfSchooling-SQL> desc GV$SESSMETRIC;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 BEGIN_TIME                             DATE

 END_TIME                               DATE

 INTSIZE_CSEC                           NUMBER

 SESSION_ID                             NUMBER

 SERIAL_NUM                             NUMBER

 CPU                                    NUMBER

 PHYSICAL_READS                         NUMBER

 LOGICAL_READS                          NUMBER

 PGA_MEMORY                             NUMBER

 HARD_PARSES                            NUMBER

 SOFT_PARSES                            NUMBER

 PHYSICAL_READ_PCT                      NUMBER

 LOGICAL_READ_PCT                       NUMBER

 

GV$SESSTAT: Synonym for GV_$SESSTAT

 

iSelfSchooling-SQL> desc GV$SESSTAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SID                                    NUMBER

 STATISTIC#                             NUMBER

 VALUE                                  NUMBER

 

GV$SESS_IO: Synonym for GV_$SESS_IO

 

iSelfSchooling-SQL> desc GV$SESS_IO;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SID                                    NUMBER

 BLOCK_GETS                             NUMBER

 CONSISTENT_GETS                        NUMBER

 PHYSICAL_READS                         NUMBER

 BLOCK_CHANGES                          NUMBER

 CONSISTENT_CHANGES                     NUMBER

 

GV$SESS_TIME_MODEL: Synonym for GV_$SESS_TIME_MODEL

 

iSelfSchooling-SQL> desc GV$SESS_TIME_MODEL;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SID                                    NUMBER

 STAT_ID                                NUMBER

 STAT_NAME                              VARCHAR2(64)

 VALUE                                  NUMBER

 

GV$SES_OPTIMIZER_ENV: Synonym for GV_$SES_OPTIMIZER_ENV

 

iSelfSchooling-SQL> desc GV$SES_OPTIMIZER_ENV;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SID                                    NUMBER

 ID                                     NUMBER

 NAME                                   VARCHAR2(40)

 ISDEFAULT                              VARCHAR2(3)

 VALUE                                  VARCHAR2(25)

 

GV$SGA: Synonym for GV_$SGA

 

iSelfSchooling-SQL> desc GV$SGA;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(20)

 VALUE                                  NUMBER

 

GV$SGAINFO: Synonym for GV_$SGAINFO

 

iSelfSchooling-SQL> desc GV$SGAINFO;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(32)

 BYTES                                  NUMBER

 RESIZEABLE                             VARCHAR2(3)

 

GV$SGASTAT: Synonym for GV_$SGASTAT

 

iSelfSchooling-SQL> desc GV$SGASTAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 POOL                                   VARCHAR2(12)

 NAME                                   VARCHAR2(26)

 BYTES                                  NUMBER

 

GV$SGA_CURRENT_RESIZE_OPS: Synonym for GV_$SGA_CURRENT_RESIZE_OPS

 

iSelfSchooling-SQL> desc GV$SGA_CURRENT_RESIZE_OPS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 COMPONENT                              VARCHAR2(64)

 OPER_TYPE                              VARCHAR2(13)

 OPER_MODE                              VARCHAR2(9)

 PARAMETER                              VARCHAR2(80)

 INITIAL_SIZE                           NUMBER

 TARGET_SIZE                            NUMBER

 CURRENT_SIZE                           NUMBER

 START_TIME                             DATE

 LAST_UPDATE_TIME                       DATE

 

GV$SGA_DYNAMIC_COMPONENTS: Synonym for GV_$SGA_DYNAMIC_COMPONENTS

 

iSelfSchooling-SQL> desc GV$SGA_DYNAMIC_COMPONENTS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 COMPONENT                              VARCHAR2(64)

 CURRENT_SIZE                           NUMBER

 MIN_SIZE                               NUMBER

 MAX_SIZE                               NUMBER

 USER_SPECIFIED_SIZE                    NUMBER

 OPER_COUNT                             NUMBER

 LAST_OPER_TYPE                         VARCHAR2(13)

 LAST_OPER_MODE                         VARCHAR2(9)

 LAST_OPER_TIME                         DATE

 GRANULE_SIZE                           NUMBER

 

GV$SGA_DYNAMIC_FREE_MEMORY: Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY

 

iSelfSchooling-SQL> desc GV$SGA_DYNAMIC_FREE_MEMORY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 CURRENT_SIZE                           NUMBER

 

GV$SGA_RESIZE_OPS: Synonym for GV_$SGA_RESIZE_OPS

 

iSelfSchooling-SQL> desc GV$SGA_RESIZE_OPS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 COMPONENT                              VARCHAR2(64)

 OPER_TYPE                              VARCHAR2(13)

 OPER_MODE                              VARCHAR2(9)

 PARAMETER                              VARCHAR2(80)

 INITIAL_SIZE                           NUMBER

 TARGET_SIZE                            NUMBER

 FINAL_SIZE                             NUMBER

 STATUS                                 VARCHAR2(9)

 START_TIME                             DATE

 END_TIME                               DATE

iSelfSchooling-SQL> desc GV$SGA_RESIZE_OPS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 COMPONENT                              VARCHAR2(64)

 OPER_TYPE                              VARCHAR2(13)

 OPER_MODE                              VARCHAR2(9)

 PARAMETER                              VARCHAR2(80)

 INITIAL_SIZE                           NUMBER

 TARGET_SIZE                            NUMBER

 FINAL_SIZE                             NUMBER

 STATUS                                 VARCHAR2(9)

 START_TIME                             DATE

 END_TIME                               DATE

 

GV$SGA_TARGET_ADVICE: Synonym for GV_$SGA_TARGET_ADVICE

 

iSelfSchooling-SQL> desc GV$SGA_TARGET_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SGA_SIZE                               NUMBER

 SGA_SIZE_FACTOR                        NUMBER

 ESTD_DB_TIME                           NUMBER

 ESTD_DB_TIME_FACTOR                    NUMBER

 ESTD_PHYSICAL_READS                    NUMBER

 

GV$SHARED_POOL_ADVICE: Synonym for GV_$SHARED_POOL_ADVICE

 

iSelfSchooling-SQL> desc GV$SHARED_POOL_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SHARED_POOL_SIZE_FOR_ESTIMATE          NUMBER

 SHARED_POOL_SIZE_FACTOR                NUMBER

 ESTD_LC_SIZE                           NUMBER

 ESTD_LC_MEMORY_OBJECTS                 NUMBER

 ESTD_LC_TIME_SAVED                     NUMBER

 ESTD_LC_TIME_SAVED_FACTOR              NUMBER

 ESTD_LC_LOAD_TIME                      NUMBER

 ESTD_LC_LOAD_TIME_FACTOR               NUMBER

 ESTD_LC_MEMORY_OBJECT_HITS             NUMBER

 

GV$SHARED_POOL_RESERVED: Synonym for GV_$SHARED_POOL_RESERVED

 

iSelfSchooling-SQL> desc GV$SHARED_POOL_RESERVED;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 FREE_SPACE                             NUMBER

 AVG_FREE_SIZE                          NUMBER

 FREE_COUNT                             NUMBER

 MAX_FREE_SIZE                          NUMBER

 USED_SPACE                             NUMBER

 AVG_USED_SIZE                          NUMBER

 USED_COUNT                             NUMBER

 MAX_USED_SIZE                          NUMBER

 REQUESTS                               NUMBER

 REQUEST_MISSES                         NUMBER

 LAST_MISS_SIZE                         NUMBER

 MAX_MISS_SIZE                          NUMBER

 REQUEST_FAILURES                       NUMBER

 LAST_FAILURE_SIZE                      NUMBER

 ABORTED_REQUEST_THRESHOLD              NUMBER

 ABORTED_REQUESTS                       NUMBER

 LAST_ABORTED_SIZE                      NUMBER

 

GV$SHARED_SERVER: Synonym for GV_$SHARED_SERVER

 

iSelfSchooling-SQL> desc GV$SHARED_SERVER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 NAME                                   VARCHAR2(4)

 PADDR                                  RAW(8)

 STATUS                                 VARCHAR2(16)

 MESSAGES                               NUMBER

 BYTES                                  NUMBER

 BREAKS                                 NUMBER

 CIRCUIT                                RAW(8)

 IDLE                                   NUMBER

 BUSY                                   NUMBER

 REQUESTS                               NUMBER

 

GV$SHARED_SERVER_MONITOR: Synonym for GV_$SHARED_SERVER_MONITOR

 

iSelfSchooling-SQL> desc GV$SHARED_SERVER_MONITOR;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 MAXIMUM_CONNECTIONS                    NUMBER

 MAXIMUM_SESSIONS                       NUMBER

 SERVERS_STARTED                        NUMBER

 SERVERS_TERMINATED                     NUMBER

 SERVERS_HIGHWATER                      NUMBER

 

GV$SORT_SEGMENT: Synonym for GV_$SORT_SEGMENT

 

iSelfSchooling-SQL> desc GV$SORT_SEGMENT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 TABLESPACE_NAME                        VARCHAR2(31)

 SEGMENT_FILE                           NUMBER

 SEGMENT_BLOCK                          NUMBER

 EXTENT_SIZE                            NUMBER

 CURRENT_USERS                          NUMBER

 TOTAL_EXTENTS                          NUMBER

 TOTAL_BLOCKS                           NUMBER

 USED_EXTENTS                           NUMBER

 USED_BLOCKS                            NUMBER

 FREE_EXTENTS                           NUMBER

 FREE_BLOCKS                            NUMBER

 ADDED_EXTENTS                          NUMBER

 EXTENT_HITS                            NUMBER

 FREED_EXTENTS                          NUMBER

 FREE_REQUESTS                          NUMBER

 MAX_SIZE                               NUMBER

 MAX_BLOCKS                             NUMBER

 MAX_USED_SIZE                          NUMBER

 MAX_USED_BLOCKS                        NUMBER

 MAX_SORT_SIZE                          NUMBER

 MAX_SORT_BLOCKS                        NUMBER

 RELATIVE_FNO                           NUMBER

 

GV$SORT_USAGE: Synonym for GV_$SORT_USAGE

 

iSelfSchooling-SQL> desc GV$SORT_USAGE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 USERNAME                               VARCHAR2(30)

 USER                                   VARCHAR2(30)

 SESSION_ADDR                           RAW(8)

 SESSION_NUM                            NUMBER

 SQLADDR                                RAW(8)

 SQLHASH                                NUMBER

 SQL_ID                                 VARCHAR2(13)

 TABLESPACE                             VARCHAR2(31)

 CONTENTS                               VARCHAR2(9)

 SEGTYPE                                VARCHAR2(9)

 SEGFILE#                               NUMBER

 SEGBLK#                                NUMBER

 EXTENTS                                NUMBER

 BLOCKS                                 NUMBER

 SEGRFNO#                               NUMBER

 

GV$SPPARAMETER: Synonym for GV_$SPPARAMETER

 

iSelfSchooling-SQL> desc GV$SPPARAMETER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SID                                    VARCHAR2(80)

 NAME                                   VARCHAR2(80)

 VALUE                                  VARCHAR2(255)

 DISPLAY_VALUE                          VARCHAR2(255)

 ISSPECIFIED                            VARCHAR2(6)

 ORDINAL                                NUMBER

 UPDATE_COMMENT                         VARCHAR2(255)

 

GV$SQL: Synonym for GV_$SQL

 

iSelfSchooling-SQL> desc GV$SQL;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 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)

 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(797)

 OPTIMIZER_ENV_HASH_VALUE               NUMBER

 PARSING_USER_ID                        NUMBER

 PARSING_SCHEMA_ID                      NUMBER

 PARSING_SCHEMA_NAME                    VARCHAR2(30)

 KEPT_VERSIONS                          NUMBER

 ADDRESS                                RAW(8)

 TYPE_CHK_HEAP                          RAW(8)

 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(8)

 SQLTYPE                                NUMBER

 REMOTE                                 VARCHAR2(1)

 OBJECT_STATUS                          VARCHAR2(19)

 LITERAL_HASH_VALUE                     NUMBER

 LAST_LOAD_TIME                         VARCHAR2(19)

 IS_OBSOLETE                            VARCHAR2(1)

 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)

 

GV$SQLAREA: Synonym for GV_$SQLAREA

 

iSelfSchooling-SQL> desc GV$SQLAREA;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 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)

 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(797)

 OPTIMIZER_ENV_HASH_VALUE               NUMBER

 PARSING_USER_ID                        NUMBER

 PARSING_SCHEMA_ID                      NUMBER

 PARSING_SCHEMA_NAME                    VARCHAR2(30)

 KEPT_VERSIONS                          NUMBER

 ADDRESS                                RAW(8)

 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)

 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)

 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)

 

GV$SQLAREA_PLAN_HASH: Synonym for GV_$SQLAREA_PLAN_HASH

 

iSelfSchooling-SQL> desc GV$SQLAREA_PLAN_HASH;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SQL_TEXT                               VARCHAR2(1000)

 SQL_FULLTEXT                           CLOB

 ADDRESS                                RAW(8)

 HASH_VALUE                             NUMBER

 SQL_ID                                 VARCHAR2(13)

 PLAN_HASH_VALUE                        NUMBER

 VERSION_COUNT                          NUMBER

 LAST_ACTIVE_CHILD_ADDRESS              RAW(8)

 SHARABLE_MEM                           NUMBER

 PERSISTENT_MEM                         NUMBER

 RUNTIME_MEM                            NUMBER

 SORTS                                  NUMBER

 LOADED_VERSIONS                        NUMBER

 OPEN_VERSIONS                          NUMBER

 USERS_OPENING                          NUMBER

 USERS_EXECUTING                        NUMBER

 FETCHES                                NUMBER

 EXECUTIONS                             NUMBER

 PX_SERVERS_EXECUTIONS                  NUMBER

 END_OF_FETCH_COUNT                     NUMBER

 LOADS                                  NUMBER

 FIRST_LOAD_TIME                        DATE

 LAST_LOAD_TIME                         DATE

 LAST_ACTIVE_TIME                       DATE

 INVALIDATIONS                          NUMBER

 PARSE_CALLS                            NUMBER

 DISK_READS                             NUMBER

 DIRECT_WRITES                          NUMBER

 BUFFER_GETS                            NUMBER

 CPU_TIME                               NUMBER

 ELAPSED_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

 ROWS_PROCESSED                         NUMBER

 COMMAND_TYPE                           NUMBER

 OPTIMIZER_MODE                         VARCHAR2(10)

 OPTIMIZER_COST                         NUMBER

 OPTIMIZER_ENV                          RAW(797)

 OPTIMIZER_ENV_HASH_VALUE               NUMBER

 PARSING_USER_ID                        NUMBER

 PARSING_SCHEMA_ID                      NUMBER

 PARSING_SCHEMA_NAME                    VARCHAR2(30)

 KEPT_VERSIONS                          NUMBER

 MODULE                                 VARCHAR2(64)

 MODULE_HASH                            NUMBER

 ACTION                                 VARCHAR2(64)

 ACTION_HASH                            NUMBER

 SERIALIZABLE_ABORTS                    NUMBER

 OUTLINE_CATEGORY                       VARCHAR2(64)

 OUTLINE_SID                            VARCHAR2(40)

 REMOTE                                 VARCHAR2(1)

 OBJECT_STATUS                          VARCHAR2(19)

 LITERAL_HASH_VALUE                     NUMBER

 SQL_PROFILE                            VARCHAR2(64)

 PROGRAM_ID                             NUMBER

 PROGRAM_LINE#                          NUMBER

 EXACT_MATCHING_SIGNATURE               NUMBER

 FORCE_MATCHING_SIGNATURE               NUMBER

 BIND_DATA                              RAW(2000)

 

GV$SQLSTATS: Synonym for GV_$SQL

 

iSelfSchooling-SQL> desc GV$SQLSTATS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 SQL_TEXT                               VARCHAR2(1000)

 SQL_FULLTEXT                           CLOB

 SQL_ID                                 VARCHAR2(13)

 LAST_ACTIVE_TIME                       DATE

 LAST_ACTIVE_CHILD_ADDRESS              RAW(8)

 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

 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

 

GV$SQLTEXT: Synonym for GV_$SQLTEXT

 

iSelfSchooling-SQL> desc GV$SQLTEXT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 ADDRESS                                RAW(8)

 HASH_VALUE                             NUMBER

 SQL_ID                                 VARCHAR2(13)

 COMMAND_TYPE                           NUMBER

 PIECE                                  NUMBER

 SQL_TEXT                               VARCHAR2(64)

 

GV$SQLTEXT_WITH_NEWLINES: Synonym for GV_$SQLTEXT_WITH_NEWLINES

 

iSelfSchooling-SQL> desc GV$SQLTEXT_WITH_NEWLINES;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 ADDRESS                                RAW(8)

 HASH_VALUE                             NUMBER

 SQL_ID                                 VARCHAR2(13)

 COMMAND_TYPE                           NUMBER

 PIECE                                  NUMBER

 SQL_TEXT                               VARCHAR2(64)

 

GV$SQL_BIND_CAPTURE: Synonym for GV_$SQL_BIND_CAPTURE

 

iSelfSchooling-SQL> desc GV$SQL_BIND_CAPTURE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 INST_ID                                NUMBER

 ADDRESS                                RAW(8)

 HASH_VALUE                             NUMBER

 SQL_ID                                 VARCHAR2(13)

 CHILD_ADDRESS                          RAW(8)

 CHILD_NUMBER                           NUMBER

 NAME                                   VARCHAR2(30)

 POSITION                               NUMBER

 DUP_POSITION                           NUMBER

 DATATYPE                               NUMBER

 DATATYPE_STRING                        VARCHAR2(15)

 CHARACTER_SID                          NUMBER

 PRECISION                              NUMBER

 SCALE                                  NUMBER

 MAX_LENGTH                             NUMBER

 WAS_CAPTURED                           VARCHAR2(3)

 LAST_CAPTURED                          DATE

 VALUE_STRING                           VARCHAR2(4000)

 VALUE_ANYDATA                          ANYDATA

 

 

 

Google
 
Web web site