Where can I find a documentation that explains all the various columns/sections of v$ and dba tables?
e.g. dba_tablespaces for example,
the table_name, owner,initial_extent,next_extent,etc are all explained.
Printable View
Where can I find a documentation that explains all the various columns/sections of v$ and dba tables?
e.g. dba_tablespaces for example,
the table_name, owner,initial_extent,next_extent,etc are all explained.
If you are using Oracle 8i, navigate thru the followin links...
Oracle8i Server, Release 8.1.5 --> Oracle8i Reference
You'll have sections STATIC DATA DICTIONARY VIEWS,
DYNAMIC PERFORMANCE (V$) VIEWS
You'll see the briefing about all the DD tables, not a detailed explanation.
- Nanda.
You can query DICT_COLUMNS table.
Here you will get description for columns of the dictionary tables/views.
Sanjay