Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
The Data Dictionary
|
133
Table, column, and view views
Tables are the most important building blocks of an Oracle
database. These views provide information about tables, col-
umns, clusters, and views:
Dynamic Views
The dynamic performance data dictionary views (the V$
views) mainly provide information about the Oracle
instance, as well as information that the instance maintains
about the database. The views in this category are consid-
ered dynamic because their contents change based upon how
the instance is performing. The contents of these views are
representative of the total instance or cluster workload,
rather than the performance of one specific SQL statement.
*_ALL_TABLES
Lists all object and relational tables.
*_CLU_COLUMNS
Lists all cluster keys.
*_CLUSTER_HASH_EXPRESSIONS
Lists the hash values used for the optional
cluster hash indexes.
*_CLUSTERS
Lists all clusters in the database.
*_COL_COMMENTS
Shows comments on all table and view columns.
*_EXTERNAL_LOCATIONS
Lists the sources for the external tables.
*_EXTERNAL_TABLES
Describes the attributes of external tables.
*_TAB_COL_STATISTICS
Contains column information about analyzed
columns.
*_TAB_COLUMNS
Shows all table and view columns.
*_TAB_COMMENTS
Shows all comments on tables and views.
*_TAB_HISTOGRAMS
Shows all table histograms.
*_TABLES
Shows all relational tables.
*_UPDATABLE_COLUMNS
Lists columns that can be updated in views
with joins.
134
|
Oracle DBA ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843