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$ACCESS: Synonym for V_$ACCESS

 

iSelfSchooling-SQL> desc V$ACCESS;

 Name                          Null?    Type

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

 SID                                    NUMBER

 OWNER                                  VARCHAR2(64)

 OBJECT                                 VARCHAR2(1000)

 TYPE                                   VARCHAR2(24)

 

V$ACTIVE_INSTANCES: Synonym for V_$ACTIVE_INSTANCES

 

iSelfSchooling-SQL> desc V$ACTIVE_INSTANCES;

 Name                          Null?    Type

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

 INST_NUMBER                            NUMBER

 INST_NAME                              VARCHAR2(60)

 

V$ACTIVE_SERVICES: Synonym for V_$ACTIVE_SERVICES

 

iSelfSchooling-SQL> desc V$ACTIVE_SERVICES;

 Name                          Null?    Type

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

 SERVICE_ID                             NUMBER

 NAME                                   VARCHAR2(64)

 NAME_HASH                              NUMBER

 NETWORK_NAME                           VARCHAR2(512)

 CREATION_DATE                          DATE

 CREATION_DATE_HASH                     NUMBER

 GOAL                                   VARCHAR2(12)

 DTP                                    VARCHAR2(1)

 BLOCKED                                VARCHAR2(3)

 AQ_HA_NOTIFICATION                     VARCHAR2(3)

 CLB_GOAL                               VARCHAR2(5)

 

V$ACTIVE_SESSION_HISTORY: Synonym for V_$ACTIVE_SESSION_HISTORY

 

iSelfSchooling-SQL> desc V$ACTIVE_SESSION_HISTORY;

 Name                          Null?    Type

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

 SAMPLE_ID                              NUMBER

 SAMPLE_TIME                            TIMESTAMP(3)

 SESSION_ID                             NUMBER

 SESSION_SERIAL#                        NUMBER

 USER_ID                                NUMBER

 SQL_ID                                 VARCHAR2(13)

 SQL_CHILD_NUMBER                       NUMBER

 SQL_PLAN_HASH_VALUE                    NUMBER

 FORCE_MATCHING_SIGNATURE               NUMBER

 SQL_OPCODE                             NUMBER

 SERVICE_HASH                           NUMBER

 SESSION_TYPE                           VARCHAR2(10)

 SESSION_STATE                          VARCHAR2(7)

 QC_SESSION_ID                          NUMBER

 QC_INSTANCE_ID                         NUMBER

 BLOCKING_SESSION                       NUMBER

 BLOCKING_SESSION_STATUS                VARCHAR2(11)

 BLOCKING_SESSION_SERIAL#               NUMBER

 EVENT                                  VARCHAR2(64)

 EVENT_ID                               NUMBER

 EVENT#                                 NUMBER

 SEQ#                                   NUMBER

 P1TEXT                                 VARCHAR2(64)

 P1                                     NUMBER

 P2TEXT                                 VARCHAR2(64)

 P2                                     NUMBER

 P3TEXT                                 VARCHAR2(64)

 P3                                     NUMBER

 WAIT_CLASS                             VARCHAR2(64)

 WAIT_CLASS_ID                          NUMBER

 WAIT_TIME                              NUMBER

 TIME_WAITED                            NUMBER

 XID                                    RAW(8)

 CURRENT_OBJ#                           NUMBER

 CURRENT_FILE#                          NUMBER

 CURRENT_BLOCK#                         NUMBER

 PROGRAM                                VARCHAR2(48)

 MODULE                                 VARCHAR2(48)

 ACTION                                 VARCHAR2(32)

 CLIENT_ID                              VARCHAR2(64)

 

V$ACTIVE_SESS_POOL_MTH: Synonym for V_$ACTIVE_SESS_POOL_MTH

 

iSelfSchooling-SQL> desc V$ACTIVE_SESS_POOL_MTH;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(40)

 

V$ADVISOR_PROGRESS: Synonym for V_$ADVISOR_PROGRESS

 

iSelfSchooling-SQL> desc V$ADVISOR_PROGRESS;

 Name                          Null?    Type

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

 SID                                    NUMBER

 SERIAL#                                NUMBER

 USERNAME                               VARCHAR2(30)

 OPNAME                                 VARCHAR2(64)

 ADVISOR_NAME                           VARCHAR2(64)

 TASK_ID                                NUMBER

 TARGET_DESC                            VARCHAR2(32)

 SOFAR                                  NUMBER

 TOTALWORK                              NUMBER

 UNITS                                  VARCHAR2(32)

 BENEFIT_SOFAR                          NUMBER

 BENEFIT_MAX                            NUMBER

 FINDINGS                               NUMBER

 RECOMMENDATIONS                        NUMBER

 TIME_REMAINING                         NUMBER

 START_TIME                             DATE

 LAST_UPDATE_TIME                       DATE

 ELAPSED_SECONDS                        NUMBER

 ADVISOR_METRIC1                        NUMBER

 METRIC1_DESC                           VARCHAR2(64)

 

V$ALERT_TYPES: Synonym for V_$ALERT_TYPES

 

iSelfSchooling-SQL> desc V$ALERT_TYPES;

 Name                          Null?    Type

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

 REASON_ID                              NUMBER

 OBJECT_TYPE                            VARCHAR2(64)

 TYPE                                   VARCHAR2(9)

 GROUP_NAME                             VARCHAR2(64)

 SCOPE                                  VARCHAR2(8)

 INTERNAL_METRIC_CATEGORY               VARCHAR2(64)

 INTERNAL_METRIC_NAME                   VARCHAR2(64)

 

V$AQ: Synonym for V_$AQ

 

iSelfSchooling-SQL> desc V$AQ;

 Name                          Null?    Type

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

 QID                                    NUMBER

 WAITING                                NUMBER

 READY                                  NUMBER

 EXPIRED                                NUMBER

 TOTAL_WAIT                             NUMBER

 AVERAGE_WAIT                           NUMBER

 

V$AQ1: Synonym for V_$AQ1

 

iSelfSchooling-SQL> desc V$AQ1;

 Name                          Null?    Type

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

 QID                                    NUMBER

 WAITING                                NUMBER

 READY                                  NUMBER

 EXPIRED                                NUMBER

 TOTAL_CONSUMERS                        NUMBER

 TOTAL_WAIT                             NUMBER

 AVERAGE_WAIT                           NUMBER

 

V$ARCHIVE: Synonym for V_$ARCHIVE

 

iSelfSchooling-SQL> desc V$ARCHIVE;

 Name                          Null?    Type

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

 GROUP#                                 NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 ISCURRENT                              VARCHAR2(3)

 CURRENT                                VARCHAR2(3)

 FIRST_CHANGE#                          NUMBER

 

V$ARCHIVED_LOG: Synonym for V_$ARCHIVED_LOG

 

iSelfSchooling-SQL> desc V$ARCHIVED_LOG;

 Name                          Null?    Type

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

 RECID                                  NUMBER

 STAMP                                  NUMBER

 NAME                                   VARCHAR2(513)

 DEST_ID                                NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 RESETLOGS_ID                           NUMBER

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 NEXT_CHANGE#                           NUMBER

 NEXT_TIME                              DATE

 BLOCKS                                 NUMBER

 BLOCK_SIZE                             NUMBER

 CREATOR                                VARCHAR2(7)

 REGISTRAR                              VARCHAR2(7)

 STANDBY_DEST                           VARCHAR2(3)

 ARCHIVED                               VARCHAR2(3)

 APPLIED                                VARCHAR2(3)

 DELETED                                VARCHAR2(3)

 STATUS                                 VARCHAR2(1)

 COMPLETION_TIME                        DATE

 DICTIONARY_BEGIN                       VARCHAR2(3)

 DICTIONARY_END                         VARCHAR2(3)

 END_OF_REDO                            VARCHAR2(3)

 BACKUP_COUNT                           NUMBER

 ARCHIVAL_THREAD#                       NUMBER

 ACTIVATION#                            NUMBER

 IS_RECOVERY_DEST_FILE                  VARCHAR2(3)

 COMPRESSED                             VARCHAR2(3)

 FAL                                    VARCHAR2(3)

 END_OF_REDO_TYPE                       VARCHAR2(10)

 

V$ARCHIVE_DEST: Synonym for V_$ARCHIVE_DEST

 

iSelfSchooling-SQL> desc V$ARCHIVE_DEST;

 Name                          Null?    Type

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

 DEST_ID                                NUMBER

 DEST_NAME                              VARCHAR2(256)

 STATUS                                 VARCHAR2(9)

 BINDING                                VARCHAR2(9)

 NAME_SPACE                             VARCHAR2(7)

 TARGET                                 VARCHAR2(7)

 ARCHIVER                               VARCHAR2(10)

 SCHEDULE                               VARCHAR2(8)

 DESTINATION                            VARCHAR2(256)

 LOG_SEQUENCE                           NUMBER

 REOPEN_SECS                            NUMBER

 DELAY_MINS                             NUMBER

 MAX_CONNECTIONS                        NUMBER

 NET_TIMEOUT                            NUMBER

 PROCESS                                VARCHAR2(10)

 REGISTER                               VARCHAR2(3)

 FAIL_DATE                              DATE

 FAIL_SEQUENCE                          NUMBER

 FAIL_BLOCK                             NUMBER

 FAILURE_COUNT                          NUMBER

 MAX_FAILURE                            NUMBER

 ERROR                                  VARCHAR2(256)

 ALTERNATE                              VARCHAR2(256)

 DEPENDENCY                             VARCHAR2(256)

 REMOTE_TEMPLATE                        VARCHAR2(256)

 QUOTA_SIZE                             NUMBER

 QUOTA_USED                             NUMBER

 MOUNTID                                NUMBER

 TRANSMIT_MODE                          VARCHAR2(12)

 ASYNC_BLOCKS                           NUMBER

 AFFIRM                                 VARCHAR2(3)

 TYPE                                   VARCHAR2(7)

 VALID_NOW                              VARCHAR2(16)

 VALID_TYPE                             VARCHAR2(15)

 VALID_ROLE                             VARCHAR2(12)

 DB_UNIQUE_NAME                         VARCHAR2(30)

 VERIFY                                 VARCHAR2(3)

 

V$ARCHIVE_DEST_STATUS: Synonym for V_$ARCHIVE_DEST_STATUS

 

iSelfSchooling-SQL> desc V$ARCHIVE_DEST_STATUS;

 Name                          Null?    Type

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

 DEST_ID                                NUMBER

 DEST_NAME                              VARCHAR2(256)

 STATUS                                 VARCHAR2(9)

 TYPE                                   VARCHAR2(14)

 DATABASE_MODE                          VARCHAR2(15)

 RECOVERY_MODE                          VARCHAR2(23)

 PROTECTION_MODE                        VARCHAR2(20)

 DESTINATION                            VARCHAR2(256)

 STANDBY_LOGFILE_COUNT                  NUMBER

 STANDBY_LOGFILE_ACTIVE                 NUMBER

 ARCHIVED_THREAD#                       NUMBER

 ARCHIVED_SEQ#                          NUMBER

 APPLIED_THREAD#                        NUMBER

 APPLIED_SEQ#                           NUMBER

 ERROR                                  VARCHAR2(256)

 SRL                                    VARCHAR2(3)

 DB_UNIQUE_NAME                         VARCHAR2(30)

 SYNCHRONIZATION_STATUS                 VARCHAR2(22)

 SYNCHRONIZED                           VARCHAR2(3)

 

V$ARCHIVE_GAP: Synonym for V_$ARCHIVE_GAP

 

iSelfSchooling-SQL> desc V$ARCHIVE_GAP;

 Name                          Null?    Type

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

 THREAD#                                NUMBER

 LOW_SEQUENCE#                          NUMBER

 HIGH_SEQUENCE#                         NUMBER

 

V$ARCHIVE_PROCESSES: Synonym for V_$ARCHIVE_PROCESSES

 

iSelfSchooling-SQL> desc V$ARCHIVE_PROCESSES;

 Name                          Null?    Type

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

 PROCESS                                NUMBER

 STATUS                                 VARCHAR2(10)

 LOG_SEQUENCE                           NUMBER

 STATE                                  VARCHAR2(4)

 

V$ASM_ALIAS: Synonym for V_$ASM_ALIAS

 

iSelfSchooling-SQL> desc V$ASM_ALIAS;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(48)

 GROUP_NUMBER                           NUMBER

 FILE_NUMBER                            NUMBER

 FILE_INCARNATION                       NUMBER

 ALIAS_INDEX                            NUMBER

 ALIAS_INCARNATION                      NUMBER

 PARENT_INDEX                           NUMBER

 REFERENCE_INDEX                        NUMBER

 ALIAS_DIRECTORY                        VARCHAR2(1)

 SYSTEM_CREATED                         VARCHAR2(1)

 

V$ASM_CLIENT: Synonym for V_$ASM_CLIENT

 

iSelfSchooling-SQL> desc V$ASM_CLIENT;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 INSTANCE_NAME                          VARCHAR2(64)

 DB_NAME                                VARCHAR2(8)

 STATUS                                 VARCHAR2(12)

 SOFTWARE_VERSION                       VARCHAR2(60)

 COMPATIBLE_VERSION                     VARCHAR2(60)

 

V$ASM_DISK: Synonym for V_$ASM_DISK

 

iSelfSchooling-SQL> desc V$ASM_DISK;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 DISK_NUMBER                            NUMBER

 COMPOUND_INDEX                         NUMBER

 INCARNATION                            NUMBER

 MOUNT_STATUS                           VARCHAR2(7)

 HEADER_STATUS                          VARCHAR2(12)

 MODE_STATUS                            VARCHAR2(7)

 STATE                                  VARCHAR2(8)

 REDUNDANCY                             VARCHAR2(7)

 LIBRARY                                VARCHAR2(64)

 TOTAL_MB                               NUMBER

 FREE_MB                                NUMBER

 NAME                                   VARCHAR2(30)

 FAILGROUP                              VARCHAR2(30)

 LABEL                                  VARCHAR2(31)

 PATH                                   VARCHAR2(256)

 UDID                                   VARCHAR2(64)

 PRODUCT                                VARCHAR2(32)

 CREATE_DATE                            DATE

 MOUNT_DATE                             DATE

 REPAIR_TIMER                           NUMBER

 READS                                  NUMBER

 WRITES                                 NUMBER

 READ_ERRS                              NUMBER

 WRITE_ERRS                             NUMBER

 READ_TIME                              NUMBER

 WRITE_TIME                             NUMBER

 BYTES_READ                             NUMBER

 BYTES_WRITTEN                          NUMBER

 

V$ASM_DISKGROUP: Synonym for V_$ASM_DISKGROUP

 

iSelfSchooling-SQL> desc V$ASM_DISKGROUP;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 NAME                                   VARCHAR2(30)

 SECTOR_SIZE                            NUMBER

 BLOCK_SIZE                             NUMBER

 ALLOCATION_UNIT_SIZE                   NUMBER

 STATE                                  VARCHAR2(11)

 TYPE                                   VARCHAR2(6)

 TOTAL_MB                               NUMBER

 FREE_MB                                NUMBER

 REQUIRED_MIRROR_FREE_MB                NUMBER

 USABLE_FILE_MB                         NUMBER

 OFFLINE_DISKS                          NUMBER

 UNBALANCED                             VARCHAR2(1)

 COMPATIBILITY                          VARCHAR2(60)

 DATABASE_COMPATIBILITY                 VARCHAR2(60)

 

V$ASM_DISKGROUP_STAT: Synonym for V_$ASM_DISKGROUP_STAT

 

iSelfSchooling-SQL> desc V$ASM_DISKGROUP_STAT;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 NAME                                   VARCHAR2(30)

 SECTOR_SIZE                            NUMBER

 BLOCK_SIZE                             NUMBER

 ALLOCATION_UNIT_SIZE                   NUMBER

 STATE                                  VARCHAR2(11)

 TYPE                                   VARCHAR2(6)

 TOTAL_MB                               NUMBER

 FREE_MB                                NUMBER

 REQUIRED_MIRROR_FREE_MB                NUMBER

 USABLE_FILE_MB                         NUMBER

 OFFLINE_DISKS                          NUMBER

 UNBALANCED                             VARCHAR2(1)

 COMPATIBILITY                          VARCHAR2(60)

 DATABASE_COMPATIBILITY                 VARCHAR2(60)

 

V$ASM_DISK_STAT: Synonym for V_$ASM_DISK_STAT

 

iSelfSchooling-SQL> desc V$ASM_DISK_STAT;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 DISK_NUMBER                            NUMBER

 COMPOUND_INDEX                         NUMBER

 INCARNATION                            NUMBER

 MOUNT_STATUS                           VARCHAR2(7)

 HEADER_STATUS                          VARCHAR2(12)

 MODE_STATUS                            VARCHAR2(7)

 STATE                                  VARCHAR2(8)

 REDUNDANCY                             VARCHAR2(7)

 LIBRARY                                VARCHAR2(64)

 TOTAL_MB                               NUMBER

 FREE_MB                                NUMBER

 NAME                                   VARCHAR2(30)

 FAILGROUP                              VARCHAR2(30)

 LABEL                                  VARCHAR2(31)

 PATH                                   VARCHAR2(256)

 UDID                                   VARCHAR2(64)

 PRODUCT                                VARCHAR2(32)

 CREATE_DATE                            DATE

 MOUNT_DATE                             DATE

 REPAIR_TIMER                           NUMBER

 READS                                  NUMBER

 WRITES                                 NUMBER

 READ_ERRS                              NUMBER

 WRITE_ERRS                             NUMBER

 READ_TIME                              NUMBER

 WRITE_TIME                             NUMBER

 BYTES_READ                             NUMBER

 BYTES_WRITTEN                          NUMBER

 

V$ASM_FILE: Synonym for V_$ASM_FILE

 

iSelfSchooling-SQL> desc V$ASM_FILE;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 FILE_NUMBER                            NUMBER

 COMPOUND_INDEX                         NUMBER

 INCARNATION                            NUMBER

 BLOCK_SIZE                             NUMBER

 BLOCKS                                 NUMBER

 BYTES                                  NUMBER

 SPACE                                  NUMBER

 TYPE                                   VARCHAR2(64)

 REDUNDANCY                             VARCHAR2(6)

 STRIPED                                VARCHAR2(6)

 CREATION_DATE                          DATE

 MODIFICATION_DATE                      DATE

 REDUNDANCY_LOWERED                     VARCHAR2(1)

 

V$ASM_OPERATION: Synonym for V_$ASM_OPERATION

 

iSelfSchooling-SQL> desc V$ASM_OPERATION;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 OPERATION                              VARCHAR2(5)

 STATE                                  VARCHAR2(4)

 POWER                                  NUMBER

 ACTUAL                                 NUMBER

 SOFAR                                  NUMBER

 EST_WORK                               NUMBER

 EST_RATE                               NUMBER

 EST_MINUTES                            NUMBER

 

V$ASM_TEMPLATE: Synonym for V_$ASM_TEMPLATE

 

iSelfSchooling-SQL> desc V$ASM_TEMPLATE;

 Name                          Null?    Type

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

 GROUP_NUMBER                           NUMBER

 ENTRY_NUMBER                           NUMBER

 REDUNDANCY                             VARCHAR2(6)

 STRIPE                                 VARCHAR2(6)

 SYSTEM                                 VARCHAR2(1)

 NAME                                   VARCHAR2(30)

 

V$AW_AGGREGATE_OP: Synonym for V_$AW_AGGREGATE_OP

 

iSelfSchooling-SQL> desc V$AW_AGGREGATE_OP;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(14)

 LONGNAME                               VARCHAR2(30)

 DEFAULT_WEIGHT                         NUMBER

 

V$AW_ALLOCATE_OP: Synonym for V_$AW_ALLOCATE_OP

 

iSelfSchooling-SQL> desc V$AW_ALLOCATE_OP;

 Name                          Null?    Type

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

 NAME                                   VARCHAR2(14)

 LONGNAME                               VARCHAR2(30)

 

V$AW_CALC: Synonym for V_$AW_CALC

 

iSelfSchooling-SQL> desc V$AW_CALC;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 AGGREGATE_CACHE_HITS                   NUMBER

 AGGREGATE_CACHE_MISSES                 NUMBER

 SESSION_CACHE_HITS                     NUMBER

 SESSION_CACHE_MISSES                   NUMBER

 POOL_HITS                              NUMBER

 POOL_MISSES                            NUMBER

 POOL_NEW_PAGES                         NUMBER

 POOL_RECLAIMED_PAGES                   NUMBER

 CACHE_WRITES                           NUMBER

 POOL_SIZE                              NUMBER

 CURR_DML_COMMAND                       VARCHAR2(64)

 PREV_DML_COMMAND                       VARCHAR2(64)

 AGGR_FUNC_LOGICAL_NA                   NUMBER

 AGGR_FUNC_PRECOMPUTE                   NUMBER

 AGGR_FUNC_CALCS                        NUMBER

 

V$AW_LONGOPS: Synonym for V_$AW_LONGOPS

 

iSelfSchooling-SQL> desc V$AW_LONGOPS;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 CURSOR_NAME                            VARCHAR2(64)

 COMMAND                                VARCHAR2(7)

 STATUS                                 VARCHAR2(9)

 ROWS_PROCESSED                         NUMBER

 START_TIME                             TIMESTAMP(3)

 

V$AW_OLAP: Synonym for V_$AW_OLAP

 

iSelfSchooling-SQL> desc V$AW_OLAP;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 AW_NUMBER                              NUMBER

 ATTACH_MODE                            VARCHAR2(10)

 GENERATION                             NUMBER

 TEMP_SPACE_PAGES                       NUMBER

 TEMP_SPACE_READS                       NUMBER

 LOB_READS                              NUMBER

 POOL_CHANGED_PAGES                     NUMBER

 POOL_UNCHANGED_PAGES                   NUMBER

 

V$AW_SESSION_INFO: Synonym for V_$AW_SESSION_INFO

 

iSelfSchooling-SQL> desc V$AW_SESSION_INFO;

 Name                          Null?    Type

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

 SESSION_ID                             NUMBER

 CLIENT_TYPE                            VARCHAR2(64)

 SESSION_STATE                          VARCHAR2(64)

 SESSION_HANDLE                         NUMBER

 USERID                                 VARCHAR2(64)

 TOTAL_TRANSACTION                      NUMBER

 TRANSACTION_TIME                       NUMBER

 TOTAL_TRANSACTION_TIME                 NUMBER

 AVERAGE_TRANSACTION_TIME               NUMBER

 TRANSACTION_CPU_TIME                   NUMBER

 TOTAL_TRANSACTION_CPU_TIME             NUMBER

 AVERAGE_TRANSACTION_CPU_TIME           NUMBER

 

V$BACKUP: Synonym for V_$BACKUP

 

iSelfSchooling-SQL> desc V$BACKUP;

 Name                          Null?    Type

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

 FILE#                                  NUMBER

 STATUS                                 VARCHAR2(18)

 CHANGE#                                NUMBER

 TIME                                   DATE

 

V$BACKUP_ARCHIVELOG_DETAILS: Synonym for V_$BACKUP_ARCHIVELOG_DETAILS

 

iSelfSchooling-SQL> desc V$BACKUP_ARCHIVELOG_DETAILS;

 Name                          Null?    Type

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

 BTYPE                                  CHAR(9)

 BTYPE_KEY                              NUMBER

 SESSION_KEY                            NUMBER

 SESSION_RECID                          NUMBER

 SESSION_STAMP                          NUMBER

 ID1                                    NUMBER

 ID2                                    NUMBER

 THREAD#                                NUMBER

 SEQUENCE#                              NUMBER

 RESETLOGS_CHANGE#                      NUMBER

 RESETLOGS_TIME                         DATE

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 NEXT_CHANGE#                           NUMBER

 NEXT_TIME                              DATE

 FILESIZE                               NUMBER

 COMPRESSION_RATIO                      NUMBER

 FILESIZE_DISPLAY                       VARCHAR2(4000)

 

V$BACKUP_ARCHIVELOG_SUMMARY: Synonym for V_$BACKUP_ARCHIVELOG_SUMMARY

 

iSelfSchooling-SQL> desc V$BACKUP_ARCHIVELOG_SUMMARY;

 Name                          Null?    Type

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

 NUM_FILES_BACKED                       NUMBER

 NUM_DISTINCT_FILES_BACKED              NUMBER

 MIN_FIRST_CHANGE#                      NUMBER

 MAX_NEXT_CHANGE#                       NUMBER

 MIN_FIRST_TIME                         DATE

 MAX_NEXT_TIME                          DATE

 INPUT_BYTES                            NUMBER

 OUTPUT_BYTES                           NUMBER

 COMPRESSION_RATIO                      NUMBER

 INPUT_BYTES_DISPLAY                    VARCHAR2(4000)

 OUTPUT_BYTES_DISPLAY                   VARCHAR2(4000)

 

 

 

Google
 
Web web site