In the final
analysis, Oracle makes this issue largely unimportant to users and administrators, as
database management using Enterprise Manager is consistent regardless of platform.
The Data Dictionary | 55
Table 2-1. Partial list of database components and their related data dictionary views
Component Data dictionary tables and views
Database
Shared server
V$DATABASE, V$VERSION, V$INSTANCE
V$QUEUE, V$DISPATCHER, V$SHARED_SERVER
Connection pooling DBA_CPOOL_INFO, V$CPOOL_STAT, V$CPOOL_CC_STATS
Tablespaces USER_FREE_SPACE, DBA_FREE_SPACE, V$TEMPFILE, DBA_USERS, DBA_TS_QUOTAS
Control files V$CONTROLFILE, V$PARAMETER, V$CONTROLFILE_RECORD_SECTION
Datafiles V$DATAFILE, V$DATAFILE_HEADER, DBA_DATA_FILES, DBA_EXTENTS, USER_EXTENTS
Segments DBA_SEGMENTS, USER_SEGMENTS
Extents DBA_EXTENTS, USER_EXTENTS
Redo logs V$THREAD, V$LOG, V$LOGFILE, V$LOG_HISTORY
Undo V$UNDOSTAT, V$ROLLSTAT, V$TRANSACTION
Archiving status V$DATABASE, V$LOG, V$ARCHIVED_LOG, V$ARCHIVE_DEST
Database instance V$INSTANCE, V$PARAMETER, V$SYSTEM_PARAMETER
Memory structure V$SGA, V$SGASTAT, V$SGAINFO, V$SGA_DYNAMIC_COMPONENTS, V$SGA_DYNAMIC_FREE_
MEMORY, V$SGA_RESIZE_OPS, V$SGA_RESIZE_CURRENT_OPS, V$MEMORY_TARGET_
ADVICE, V$SGA_TARGET_ADVICE, V$PGA_TARGET_ADVICE
Work area memory V$PGASTAT, V$SYSSTAT
Processes V$PROCESS, V$BGPROCESS, V$SESSION
Alerting DBA_THRESHOLDS, DBA_OUTSTANDING_ALERTS, DBA_ALERT_HISTORY, V$ALERT_TYPES,
V$METRIC
Performance monitoring V$LOCK, DBA_LOCK, V$SESSION_WAIT, V$SQLAREA, V$LATCH
RMAN recovery V$RECOVER_FILE
User passwords V$PWFILE_USERS
Tables DBA_TABLES, ALL_TABLES, USER_TABLES
Indexes DBA_INDEXES, ALL_INDEXES, USER_INDEXES
Data dictionary DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
56
Chapter 3 CHAPTER 3
Installing and Running Oracle 3
If you??™ve been reading this book sequentially, you should understand the basics of
the Oracle database architecture by now.
Pages:
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145