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... | BUF... | DEL... | FLA... | LOG... | MTT... | PX... | SEG... | SOR... | SQL... | TEM...

 

V$LOG: Synonym for V_$LOG

 

iSelfSchooling-SQL> desc V$LOG;

 Name                          Null?    Type

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

 GROUP#                                 NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 BYTES                                  NUMBER

 MEMBERS                                NUMBER

 ARCHIVED                               VARCHAR2(3)

 STATUS                                 VARCHAR2(16)

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 

V$LOGFILE: Synonym for V_$LOGFILE

 

iSelfSchooling-SQL> desc V$LOGFILE;

 Name                          Null?    Type

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

 GROUP#                                 NUMBER

 STATUS                                 VARCHAR2(7)

 TYPE                                   VARCHAR2(7)

 MEMBER                                 VARCHAR2(513)

 IS_RECOVERY_DEST_FILE                  VARCHAR2(3)

 

V$LOGHIST: Synonym for V_$LOGHIST

 

iSelfSchooling-SQL> desc V$LOGHIST;

 Name                          Null?    Type

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

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 SWITCH_CHANGE#                         NUMBER

 

V$LOGMNR_CALLBACK: Synonym for V_$LOGMNR_CALLBACK

 

iSelfSchooling-SQL> desc V$LOGMNR_CALLBACK;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 FUNCTION_ID                            NUMBER

 DESCRIPTION                            VARCHAR2(64)

 TYPE                                   VARCHAR2(15)

 

V$LOGMNR_CONTENTS: Synonym for V_$LOGMNR_CONTENTS

 

iSelfSchooling-SQL> desc V$LOGMNR_CONTENTS;

 Name                          Null?    Type

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

 SCN                                    NUMBER

 CSCN                                   NUMBER

 TIMESTAMP                              DATE

 COMMIT_TIMESTAMP                       DATE

 THREAD#                                NUMBER

 LOG_ID                                 NUMBER

 XIDUSN                                 NUMBER

 XIDSLT                                 NUMBER

 XIDSQN                                 NUMBER

 PXIDUSN                                NUMBER

 PXIDSLT                                NUMBER

 PXIDSQN                                NUMBER

 RBASQN                                 NUMBER

 RBABLK                                 NUMBER

 RBABYTE                                NUMBER

 UBAFIL                                 NUMBER

 UBABLK                                 NUMBER

 UBAREC                                 NUMBER

 UBASQN                                 NUMBER

 ABS_FILE#                              NUMBER

 REL_FILE#                              NUMBER

 DATA_BLK#                              NUMBER

 DATA_OBJ#                              NUMBER

 DATA_OBJD#                             NUMBER

 SEG_OWNER                              VARCHAR2(32)

 SEG_NAME                               VARCHAR2(256)

 TABLE_NAME                             VARCHAR2(32)

 SEG_TYPE                               NUMBER

 SEG_TYPE_NAME                          VARCHAR2(32)

 TABLE_SPACE                            VARCHAR2(32)

 ROW_ID                                 VARCHAR2(18)

 SESSION#                               NUMBER

 SERIAL#                                NUMBER

 USERNAME                               VARCHAR2(30)

 SESSION_INFO                           VARCHAR2(4000)

 TX_NAME                                VARCHAR2(256)

 ROLLBACK                               NUMBER

 OPERATION                              VARCHAR2(32)

 OPERATION_CODE                         NUMBER

 SQL_REDO                               VARCHAR2(4000)

 SQL_UNDO                               VARCHAR2(4000)

 RS_ID                                  VARCHAR2(32)

 SEQUENCE#                              NUMBER

 SSN                                    NUMBER

 CSF                                    NUMBER

 INFO                                   VARCHAR2(32)

 STATUS                                 NUMBER

 REDO_VALUE                             NUMBER

 UNDO_VALUE                             NUMBER

 SQL_COLUMN_TYPE                        VARCHAR2(30)

 SQL_COLUMN_NAME                        VARCHAR2(30)

 REDO_LENGTH                            NUMBER

 REDO_OFFSET                            NUMBER

 UNDO_LENGTH                            NUMBER

 UNDO_OFFSET                            NUMBER

 DATA_OBJV#                             NUMBER

 SAFE_RESUME_SCN                        NUMBER

 XID                                    RAW(8)

 PXID                                   RAW(8)

 AUDIT_SESSIONID                        NUMBER

 

V$LOGMNR_DICTIONARY: Synonym for V_$LOGMNR_DICTIONARY

 

iSelfSchooling-SQL> desc V$LOGMNR_DICTIONARY;

 Name                          Null?    Type

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

 DB_NAME                                VARCHAR2(9)

 DB_ID                                  NUMBER

 DB_CREATED                             DATE

 TIMESTAMP                              DATE

 RESET_SCN                              NUMBER

 RESET_SCN_TIME                         DATE

 DB_VERSION_TIME                        DATE

 DB_CHARACTER_SET                       VARCHAR2(30)

 DB_VERSION                             VARCHAR2(64)

 DB_STATUS                              VARCHAR2(64)

 DICTIONARY_SCN                         NUMBER

 ENABLED_THREAD_MAP                     RAW(16)

 DB_TXN_SCN                             NUMBER

 FILENAME                               VARCHAR2(512)

 INFO                                   VARCHAR2(32)

 STATUS                                 NUMBER

 

V$LOGMNR_DICTIONARY_LOAD: Synonym for V_$LOGMNR_DICTIONARY_LOAD

 

iSelfSchooling-SQL> desc V$LOGMNR_DICTIONARY_LOAD;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 LOGMNR_UID                             NUMBER

 ACTION#                                NUMBER

 OPCODE                                 NUMBER

 COMMAND                                VARCHAR2(161)

 CURRENT_STATE                          VARCHAR2(32)

 COMPLETED_ACTIONS                      NUMBER

 TOTAL_ACTIONS                          NUMBER

 LOADED                                 VARCHAR2(7)

 PERCENT_DONE                           NUMBER

 

V$LOGMNR_LATCH: Synonym for V_$LOGMNR_LATCH

 

iSelfSchooling-SQL> desc V$LOGMNR_LATCH;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 NAME                                   VARCHAR2(32)

 CHILD_ADDR                             RAW(8)

 STATE                                  VARCHAR2(6)

 

V$LOGMNR_LOGFILE: Synonym for V_$LOGMNR_LOGFILE

 

iSelfSchooling-SQL> desc V$LOGMNR_LOGFILE;

 Name                          Null?    Type

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

 LOG_ID                                 NUMBER

 FILENAME                               VARCHAR2(513)

 LOW_TIME                               NUMBER

 NEXT_TIME                              NUMBER

 DB_ID                                  NUMBER

 DB_NAME                                VARCHAR2(8)

 RESET_SCNWRP                           NUMBER

 RESET_SCNBAS                           NUMBER

 RESET_SCN_TIME                         NUMBER

 THREAD_ID                              NUMBER

 THREAD_SQN                             NUMBER

 LOW_SCNWRP                             NUMBER

 LOW_SCNBAS                             NUMBER

 NEXT_SCNWRP                            NUMBER

 NEXT_SCNBAS                            NUMBER

 FILE_STATE                             VARCHAR2(13)

 

V$LOGMNR_LOGS: Synonym for V_$LOGMNR_LOGS

 

iSelfSchooling-SQL> desc V$LOGMNR_LOGS;

 Name                          Null?    Type

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

 LOG_ID                                 NUMBER

 FILENAME                               VARCHAR2(512)

 LOW_TIME                               DATE

 HIGH_TIME                              DATE

 DB_ID                                  NUMBER

 DB_NAME                                VARCHAR2(8)

 RESET_SCN                              NUMBER

 RESET_SCN_TIME                         DATE

 THREAD_ID                              NUMBER

 THREAD_SQN                             NUMBER

 LOW_SCN                                NUMBER

 NEXT_SCN                               NUMBER

 DICTIONARY_BEGIN                       VARCHAR2(3)

 DICTIONARY_END                         VARCHAR2(3)

 TYPE                                   VARCHAR2(7)

 BLOCKSIZE                              NUMBER

 FILESIZE                               NUMBER

 INFO                                   VARCHAR2(32)

 STATUS                                 NUMBER

 

V$LOGMNR_PARAMETERS: Synonym for V_$LOGMNR_PARAMETERS

 

iSelfSchooling-SQL> desc V$LOGMNR_PARAMETERS;

 Name                          Null?    Type

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

 START_DATE                             DATE

 REQUIRED_START_DATE                    DATE

 END_DATE                               DATE

 START_SCN                              NUMBER

 REQUIRED_START_SCN                     NUMBER

 END_SCN                                NUMBER

 OPTIONS                                NUMBER

 INFO                                   VARCHAR2(32)

 STATUS                                 NUMBER

 

V$LOGMNR_PROCESS: Synonym for V_$LOGMNR_PROCESS

 

iSelfSchooling-SQL> desc V$LOGMNR_PROCESS;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 PID                                    NUMBER

 SPID                                   VARCHAR2(12)

 ROLE                                   VARCHAR2(32)

 USERNAME                               VARCHAR2(15)

 SID                                    NUMBER

 SERIAL#                                NUMBER

 LATCHWAIT                              VARCHAR2(16)

 LATCHSPIN                              VARCHAR2(16)

 WORK_MICROSEC                          VARCHAR2(21)

 OVERHEAD_MICROSEC                      VARCHAR2(21)

 

V$LOGMNR_REGION: Synonym for V_$LOGMNR_REGION

 

iSelfSchooling-SQL> desc V$LOGMNR_REGION;

 Name                          Null?    Type

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

 MEMSTATE                               NUMBER

 STATE                                  VARCHAR2(9)

 OWNING_PROCESS                         NUMBER

 

V$LOGMNR_SESSION: Synonym for V_$LOGMNR_SESSION

 

iSelfSchooling-SQL> desc V$LOGMNR_SESSION;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 SESSION_NAME                           VARCHAR2(32)

 SESSION_STATE                          VARCHAR2(9)

 DB_NAME                                VARCHAR2(128)

 DB_ID                                  NUMBER

 RESET_SCN                              NUMBER

 RESET_TIMESTAMP                        NUMBER

 NUM_PROCESS                            NUMBER

 CHUNK_SIZE                             NUMBER

 START_SCN                              NUMBER

 END_SCN                                NUMBER

 SPILL_SCN                              NUMBER

 PROCESSED_SCN                          NUMBER

 PREPARED_SCN                           NUMBER

 READ_SCN                               NUMBER

 LOW_MARK_SCN                           NUMBER

 CONSUMED_SCN                           NUMBER

 MAX_MEMORY_SIZE                        NUMBER

 USED_MEMORY_SIZE                       NUMBER

 PREPARED_WORK_SIZE                     NUMBER

 AVAILABLE_WORK_SIZE                    NUMBER

 AVAILABLE_TXN                          NUMBER

 AVAILABLE_COMMITTED_TXN                NUMBER

 DELIVERED_TXN                          NUMBER

 DELIVERED_COMMITTED_TXN                NUMBER

 PINNED_TXN                             NUMBER

 PINNED_COMMITTED_TXN                   NUMBER

 CHECKPOINT_INTERVAL                    NUMBER

 

V$LOGMNR_STATS: Synonym for V_$LOGMNR_STATS

 

iSelfSchooling-SQL> desc V$LOGMNR_STATS;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 NAME                                   VARCHAR2(32)

 VALUE                                  VARCHAR2(21)

 

V$LOGMNR_TRANSACTION: Synonym for V_$LOGMNR_TRANSACTION

 

iSelfSchooling-SQL> desc V$LOGMNR_TRANSACTION;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 XID                                    RAW(8)

 XIDUSN                                 NUMBER

 XIDSLT                                 NUMBER

 XIDSQN                                 NUMBER

 PARENT_XID                             RAW(8)

 PARENT_XIDUSN                          NUMBER

 PARENT_XIDSLT                          NUMBER

 PARENT_XIDSQN                          NUMBER

 START_TIME                             DATE

 START_SCN                              NUMBER

 CHUNK#                                 NUMBER

 TOTAL_CHUNKS                           NUMBER

 REDO_THREAD                            NUMBER

 LOW_TIME                               DATE

 LOW_SCN                                NUMBER

 HIGH_TIME                              DATE

 HIGH_SCN                               NUMBER

 LCR_COUNT                              NUMBER

 SPILLED_LCR_COUNT                      NUMBER

 DFLAG                                  NUMBER

 MFLAG                                  NUMBER

 MFLAG2                                 NUMBER

 STATE                                  VARCHAR2(32)

 TYPE                                   VARCHAR2(32)

 MINING_STATUS                          VARCHAR2(32)

 QUEUE                                  VARCHAR2(32)

 

V$LOGSTDBY: Synonym for V_$LOGSTDBY

 

iSelfSchooling-SQL> desc V$LOGSTDBY;

 Name                          Null?    Type

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

 SERIAL#                                NUMBER

 LOGSTDBY_ID                            NUMBER

 PID                                    VARCHAR2(12)

 TYPE                                   VARCHAR2(30)

 STATUS_CODE                            NUMBER

 STATUS                                 VARCHAR2(256)

 HIGH_SCN                               NUMBER

 

V$LOGSTDBY_PROCESS: Synonym for V_$LOGSTDBY_PROCESS

 

iSelfSchooling-SQL> desc V$LOGSTDBY_PROCESS;

 Name                          Null?    Type

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

 SID                                    NUMBER

 SERIAL#                                NUMBER

 LOGSTDBY_ID                            NUMBER

 SPID                                   VARCHAR2(12)

 TYPE                                   VARCHAR2(30)

 STATUS_CODE                            NUMBER

 STATUS                                 VARCHAR2(256)

 HIGH_SCN                               NUMBER

 

V$LOGSTDBY_PROGRESS: Synonym for V_$LOGSTDBY_PROGRESS

 

iSelfSchooling-SQL> desc V$LOGSTDBY_PROGRESS;

 Name                          Null?    Type

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

 APPLIED_SCN                            NUMBER

 APPLIED_TIME                           DATE

 RESTART_SCN                            NUMBER

 RESTART_TIME                           DATE

 LATEST_SCN                             NUMBER

 LATEST_TIME                            DATE

 MINING_SCN                             NUMBER

 MINING_TIME                            DATE

 

V$LOGSTDBY_STATE: Synonym for V_$LOGSTDBY_STATE

 

iSelfSchooling-SQL> desc V$LOGSTDBY_STATE;

 Name                          Null?    Type

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

 PRIMARY_DBID                           NUMBER

 SESSION_ID                             NUMBER

 REALTIME_APPLY                         VARCHAR2(64)

 STATE                                  VARCHAR2(64)

 

V$LOGSTDBY_STATS: Synonym for V_$LOGSTDBY_STATS

 

iSelfSchooling-SQL> desc V$LOGSTDBY_STATS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(64)

 VALUE                                  VARCHAR2(64)

 

V$LOGSTDBY_TRANSACTION: Synonym for V_$LOGSTDBY_TRANSACTION

 

iSelfSchooling-SQL> desc V$LOGSTDBY_TRANSACTION;

 Name                          Null?    Type

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

 PRIMARY_XID                            RAW(8)

 PRIMARY_START_SCN                      NUMBER

 PRIMARY_START_TIME                     DATE

 PRIMARY_PARENT_XID                     RAW(8)

 MINING_STATUS                          VARCHAR2(32)

 APPLY_STATUS                           VARCHAR2(6)

 SID                                    NUMBER

 SERIAL#                                NUMBER

 

V$LOG_HISTORY: Synonym for V_$LOG_HISTORY

 

iSelfSchooling-SQL> desc V$LOG_HISTORY;

 Name                          Null?    Type

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

 RECID                                  NUMBER

 STAMP                                  NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 NEXT_CHANGE#                           NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 

V$MANAGED_STANDBY: Synonym for V_$MANAGED_STANDBY

 

iSelfSchooling-SQL> desc V$MANAGED_STANDBY;

 Name                          Null?    Type

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

 PROCESS                                VARCHAR2(9)

 PID                                    NUMBER

 STATUS                                 VARCHAR2(12)

 CLIENT_PROCESS                         VARCHAR2(8)

 CLIENT_PID                             VARCHAR2(40)

 CLIENT_DBID                            VARCHAR2(40)

 GROUP#                                 VARCHAR2(40)

 RESETLOG_ID                            NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 BLOCK#                                 NUMBER

 BLOCKS                                 NUMBER

 DELAY_MINS                             NUMBER

 KNOWN_AGENTS                           NUMBER

 ACTIVE_AGENTS                          NUMBER

 

V$MAP_COMP_LIST: Synonym for V_$MAP_COMP_LIST

 

iSelfSchooling-SQL> desc V$MAP_COMP_LIST;

 Name                          Null?    Type

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

 ELEM_IDX                               NUMBER

 NUM_COMP                               NUMBER

 COMP1_NAME                             VARCHAR2(256)

 COMP1_VAL                              VARCHAR2(256)

 COMP2_NAME                             VARCHAR2(256)

 COMP2_VAL                              VARCHAR2(256)

 COMP3_NAME                             VARCHAR2(256)

 COMP3_VAL                              VARCHAR2(256)

 COMP4_NAME                             VARCHAR2(256)

 COMP4_VAL                              VARCHAR2(256)

 COMP5_NAME                             VARCHAR2(256)

 COMP5_VAL                              VARCHAR2(256)

 

V$MAP_ELEMENT: Synonym for V_$MAP_ELEMENT

 

iSelfSchooling-SQL> desc V$MAP_ELEMENT;

 Name                          Null?    Type

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

 ELEM_NAME                              VARCHAR2(256)

 ELEM_IDX                               NUMBER

 ELEM_CFGID                             VARCHAR2(256)

 ELEM_TYPE                              VARCHAR2(12)

 ELEM_SIZE                              NUMBER

 ELEM_NSUBELEM                          NUMBER

 ELEM_DESCR                             VARCHAR2(256)

 STRIPE_SIZE                            NUMBER

 LIB_IDX                                NUMBER

 

V$MAP_EXT_ELEMENT: Synonym for V_$MAP_EXT_ELEMENT

 

iSelfSchooling-SQL> desc V$MAP_EXT_ELEMENT;

 Name                          Null?    Type

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

 ELEM_IDX                               NUMBER

 NUM_ATTRB                              NUMBER

 ATTRB1_NAME                            VARCHAR2(256)

 ATTRB1_VAL                             VARCHAR2(256)

 ATTRB2_NAME                            VARCHAR2(256)

 ATTRB2_VAL                             VARCHAR2(256)

 ATTRB3_NAME                            VARCHAR2(256)

 ATTRB3_VAL                             VARCHAR2(256)

 ATTRB4_NAME                            VARCHAR2(256)

 ATTRB4_VAL                             VARCHAR2(256)

 ATTRB5_NAME                            VARCHAR2(256)

 ATTRB5_VAL                             VARCHAR2(256)

 

V$MAP_FILE: Synonym for V_$MAP_FILE

 

iSelfSchooling-SQL> desc V$MAP_FILE;

 Name                          Null?    Type

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

 FILE_MAP_IDX                           NUMBER

 FILE_CFGID                             VARCHAR2(256)

 FILE_STATUS                            VARCHAR2(7)

 FILE_NAME                              VARCHAR2(256)

 FILE_TYPE                              VARCHAR2(11)

 FILE_STRUCTURE                         VARCHAR2(9)

 FILE_SIZE                              NUMBER

 FILE_NEXTS                             NUMBER

 LIB_IDX                                NUMBER

 

V$MAP_FILE_EXTENT: Synonym for V_$MAP_FILE_EXTENT

 

iSelfSchooling-SQL> desc V$MAP_FILE_EXTENT;

 Name                          Null?    Type

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

 FILE_MAP_IDX                           NUMBER

 EXT_NUM                                NUMBER

 EXT_ELEM_OFF                           NUMBER

 EXT_SIZE                               NUMBER

 EXT_FILE_OFF                           NUMBER

 EXT_TYPE                               VARCHAR2(6)

 ELEM_IDX                               NUMBER

 

V$MAP_FILE_IO_STACK: Synonym for V_$MAP_FILE_IO_STACK

 

iSelfSchooling-SQL> desc V$MAP_FILE_IO_STACK;

 Name                          Null?    Type

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

 FILE_MAP_IDX                           NUMBER

 DEPTH                                  NUMBER

 ELEM_IDX                               NUMBER

 CU_SIZE                                NUMBER

 STRIDE                                 NUMBER

 NUM_CU                                 NUMBER

 ELEM_OFFSET                            NUMBER

 FILE_OFFSET                            NUMBER

 DATA_TYPE                              VARCHAR2(15)

 PARITY_POS                             NUMBER

 PARITY_PERIOD                          NUMBER

 ID                                     NUMBER

 PARENT_ID                              NUMBER

 

V$MAP_LIBRARY: Synonym for V_$MAP_LIBRARY

 

iSelfSchooling-SQL> desc V$MAP_LIBRARY;

 Name                          Null?    Type

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

 LIB_IDX                                NUMBER

 LIB_NAME                               VARCHAR2(256)

 VENDOR_NAME                            VARCHAR2(64)

 PROTOCOL_NUM                           NUMBER

 VERSION_NUM                            VARCHAR2(32)

 PATH_NAME                              VARCHAR2(1024)

 MAP_FILE                               VARCHAR2(1)

 FILE_CFGID                             VARCHAR2(13)

 MAP_ELEM                               VARCHAR2(1)

 ELEM_CFGID                             VARCHAR2(13)

 MAP_SYNC                               VARCHAR2(1)

 

V$MAP_SUBELEMENT: Synonym for V_$MAP_SUBELEMENT

 

iSelfSchooling-SQL> desc V$MAP_SUBELEMENT;

 Name                          Null?    Type

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

 CHILD_IDX                              NUMBER

 PARENT_IDX                             NUMBER

 SUB_NUM                                NUMBER

 SUB_SIZE                               NUMBER

 ELEM_OFFSET                            NUMBER

 SUB_FLAGS                              NUMBER

 

V$MAX_ACTIVE_SESS_TARGET_MTH: Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH

 

iSelfSchooling-SQL> desc V$MAX_ACTIVE_SESS_TARGET_MTH;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(40)

 

V$METRIC: Synonym for V_$METRIC

 

iSelfSchooling-SQL> desc V$METRIC;

 Name                          Null?    Type

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

 BEGIN_TIME                             DATE

 END_TIME                               DATE

 INTSIZE_CSEC                           NUMBER

 GROUP_ID                               NUMBER

 ENTITY_ID                              NUMBER

 ENTITY_SEQUENCE                        NUMBER

 METRIC_ID                              NUMBER

 METRIC_NAME                            VARCHAR2(64)

 VALUE                                  NUMBER

 METRIC_UNIT                            VARCHAR2(64)

 

V$METRICGROUP: Synonym for V_$METRICGROUP

 

iSelfSchooling-SQL> desc V$METRICGROUP;

 Name                          Null?    Type

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

 GROUP_ID                               NUMBER

 NAME                                   VARCHAR2(64)

 INTERVAL_SIZE                          NUMBER

 MAX_INTERVAL                           NUMBER

 

V$METRICNAME: Synonym for V_$METRICNAME

 

iSelfSchooling-SQL> desc V$METRICNAME;

 Name                          Null?    Type

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

 GROUP_ID                               NUMBER

 GROUP_NAME                             VARCHAR2(64)

 METRIC_ID                              NUMBER

 METRIC_NAME                            VARCHAR2(64)

 METRIC_UNIT                            VARCHAR2(64)

 

V$METRIC_HISTORY: Synonym for V_$METRIC_HISTORY

 

iSelfSchooling-SQL> desc V$METRIC_HISTORY;

 Name                          Null?    Type

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

 BEGIN_TIME                             DATE

 END_TIME                               DATE

 INTSIZE_CSEC                           NUMBER

 GROUP_ID                               NUMBER

 ENTITY_ID                              NUMBER

 ENTITY_SEQUENCE                        NUMBER

 METRIC_ID                              NUMBER

 METRIC_NAME                            VARCHAR2(64)

 VALUE                                  NUMBER

 METRIC_UNIT                            VARCHAR2(64)

 

 

 

Google
 
Web web site