Table Of Contents#
- Preface
- About This Manual
- 1. The Data Dictionary
- Meta Tables
- SYS_AUDIT_
- SYS_AUDIT_OPTS_
- SYS_COLUMNS_
- SYS_COMMENTS_
- SYS_COMPRESSION_TABLES_
- SYS_CONSTRAINTS_
- SYS_CONSTRAINT_COLUMNS_
- SYS_CONSTRAINT_RELATED_
- SYS_DATABASE_
- SYS_DATABASE_LINKS_
- SYS_DIRECTORIES_
- SYS_ENCRYPTED_COLUMNS_
- SYS_GRANT_OBJECT_
- SYS_GRANT_SYSTEM_
- SYS_INDEX_COLUMNS_
- SYS_INDEX_PARTITIONS_
- SYS_INDEX_RELATED_
- SYS_INDICES_
- SYS_JOBS_
- SYS_LIBRARIES_
- SYS_LOBS_
- SYS_MATERIALIZED_VIEWS_
- SYS_PACKAGES_
- SYS_PACKAGE_PARAS_
- SYS_PACKAGE_PARSE_
- SYS_PACKAGE_RELATED_
- SYS_PART_INDICES_
- SYS_PART_KEY_COLUMNS_
- SYS_PART_LOBS_
- SYS_PART_TABLES_
- SYS_PASSWORD_HISTORY_
- SYS_PASSWORD_LIMITS_
- SYS_PRIVILEGES_
- SYS_PROCEDURES_
- SYS_PROC_PARAS_
- SYS_PROC_PARSE_
- SYS_PROC_RELATED_
- SYS_RECYCLEBIN_
- SYS_REPLICATIONS_
- SYS_REPL_HOSTS_
- SYS_REPL_ITEMS_
- SYS_REPL_OFFLINE_DIR_
- SYS_REPL_OLD_CHECKS_
- SYS_REPL_OLD_CHECK_COLUMNS_
- SYS_REPL_OLD_COLUMNS_
- SYS_REPL_OLD_INDEX_COLUMNS_
- SYS_REPL_OLD_INDICES_
- SYS_REPL_OLD_ITEMS_
- SYS_REPL_TABLE_OID_IN_USE_
- SYS_REPL_RECOVERY_INFOS_
- SYS_SECURITY_
- SYS_SYNONYMS_
- SYS_TABLES_
- SYS_TABLE_PARTITIONS_
- SYS_TABLE_SIZE_
- SYS_TBS_USERS_
- SYS_TRIGGERS_
- SYS_TRIGGER_DML_TABLES_
- SYS_TRIGGER_STRINGS_
- SYS_TRIGGER_UPDATE_COLUMNS_
- SYS_USERS_
- DBA_USERS_
- SYS_USER_ROLES_
- SYS_VIEWS_
- SYS_VIEW_PARSE_
- SYS_VIEW_RELATED_
- SYS_XA_HEURISTIC_TRANS_
- SYS_GEOMETRIES_
- SYS_GEOMETRY_COLUMNS_
- USER_SRS_
- Performance Views
- V\$ACCESS_LIST
- V\$ALLCOLUMN
- V\$ARCHIVE
- V\$BACKUP_INFO
- V\$BUFFPAGEINFO
- V\$BUFFPOOL_STAT
- V\$CATALOG
- V\$DATABASE
- V\$DATAFILES
- V\$DATATYPE
- V\$DBA_2PC_PENDING
- V\$DBLINK_ALTILINKER_STATUS
- V\$DBLINK_DATABASE_LINK_INFO
- V\$DBLINK_GLOBAL_TRANSACTION_INFO
- V\$DBLINK_LINKER_CONTROL_SESSION_INFO
- V\$DBLINK_LINKER_DATA_SESSION_INFO
- V\$DBLINK_LINKER_SESSION_INFO
- V\$DBLINK_NOTIFIER_TRANSACTION_INFO
- V\$DBLINK_REMOTE_STATEMENT_INFO
- V\$DBLINK_REMOTE_TRANSACTION_INFO
- V\$DBMS_STATS
- V\$DB_FREEPAGELISTS
- V\$DB_PROTOCOL
- V\$DIRECT_PATH_INSERT
- V\$DISKTBL_INFO
- V\$DISK_BTREE_HEADER
- V\$DISK_TEMP_INFO
- V\$DISK_TEMP_STAT
- V\$DISK_UNDO_USAGE
- V\$EVENT_NAME
- V\$EXTPROC_AGENT
- V\$FILESTAT
- V\$FLUSHER
- V\$FLUSHINFO
- V\$INDEX
- V\$INSTANCE
- V\$INTERNAL_SESSION
- V\$LATCH
- V\$LIBRARY
- V\$LFG
- V\$LOCK
- V\$LOCK_STATEMENT
- V\$LOG
- V\$LOCK_WAIT
- V\$MEMGC
- V\$MEMSTAT
- V\$MEMTBL_INFO
- V\$MEM_BTREE_HEADER
- V\$MEM_BTREE_NODEPOOL
- V\$MEM_RTREE_HEADER
- V\$MEM_RTREE_NODEPOOL
- V\$MEM_TABLESPACES
- V\$MEM_TABLESPACE_CHECKPOINT_PATHS
- V\$MEM_TABLESPACE_STATUS_DESC
- V\$MUTEX
- V\$NLS_PARAMETERS
- V\$NLS_TERRITORY
- V\$OBSOLETE_BACKUP_INFO
- V\$PKGTEXT
- V\$PLANTEXT
- V\$PROCTEXT
- V\$PROCINFO
- V\$PROPERTY
- V\$REPEXEC
- V\$REPGAP
- V\$REPGAP_PARALLEL
- V\$REPLOGBUFFER
- V\$REPOFFLINE_STATUS
- V\$REPRECEIVER
- V\$REPRECEIVER_COLUMN
- V\$REPRECEIVER_PARALLEL
- V\$REPRECEIVER_PARALLEL_APPLY
- V\$REPRECEIVER_STATISTICS
- V\$REPRECEIVER_TRANSTBL
- V\$REPRECEIVER_TRANSTBL_PARALLEL
- V\$REPRECOVERY
- V\$REPSENDER
- V\$REPSENDER_PARALLEL
- V\$REPSENDER_SENT_LOG_COUNT
- V\$REPSENDER_SENT_LOG_COUNT_PARALLEL
- V\$REPSENDER_STATISTICS
- V\$REPSENDER_TRANSTBL
- V\$REPSENDER_TRANSTBL_PARALLEL
- V\$REPSYNC
- V\$RESERVED_WORDS
- V\$SBUFFER_STAT
- V\$SEGMENT
- V\$SEQ
- V\$SERVICE_THREAD
- V\$SERVICE_THREAD_MGR
- V\$SESSION
- V\$SESSION_EVENT
- V\$SESSION_WAIT
- V\$SESSION_WAIT_CLASS
- V\$SESSIONMGR
- V\$SESSTAT
- V\$SFLUSHER
- V\$SFLUSHINFO
- V\$SNAPSHOT
- V\$SQLTEXT
- V\$SQL_PLAN_CACHE
- V\$SQL_PLAN_CACHE_PCO
- V\$SQL_PLAN_CACHE_SQLTEXT
- V\$STABLE_MEM_DATAFILES
- V\$STATEMENT
- V\$STATNAME
- V\$SYSSTAT
- V\$SYSTEM_CONFLICT_PAGE
- V\$SYSTEM_EVENT
- V\$SYSTEM_WAIT_CLASS
- V\$TABLE
- V\$TABLESPACES
- V\$TIME_ZONE_NAMES
- V\$TRACELOG
- V\$TRANSACTION
- V\$TRANSACTION_MGR
- V\$TSSEGS
- V\$TXSEGS
- V\$UDSEGS
- V\$UNDO_BUFF_STAT
- V\$USAGE
- V\$VERSION
- V\$VOL_TABLESPACES
- V\$WAIT_CLASS_NAME
- V\$XID
- 2. Sample Schema
- Information about the Sample Schema
- E-R Entity-Relationship (ER) Diagram and Sample Data