Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

DBA_TAB_COLUMNS view tips Oracle Tips by Burleson Consulting

DBA_TAB_COLUMNS

<< Return to the index

Oracle 11g makes the following comments about the DBA_TAB_COLUMNS table: "Columns of user's tables, views and clusters"

Related notes on DBA_TAB_COLUMNS:

• Oracle Concepts - Data Dictionary
• Archiving Oracle Data in easily restorable non-Oracle structures
• Monitoring Table Columns - Monitoring Table Keys - Monitoring ...
• Oracle v$ scripts & Oracle DBA scripts & Oracle schema scripts
• Oracle table scripts & Oracle view scripts & Oracle cluster ...
• Identifying Oracle Tables with Chained Rows
• Using gather_stats_job
• Free Oracle Poster

Column description of the DBA_TAB_COLUMNS view:

No comments exist for the OWNER column of the DBA_TAB_COLUMNS table.

Description of DBA_TAB_COLUMNS.TABLE_NAME: "Table, view or cluster name"

Description of DBA_TAB_COLUMNS.COLUMN_NAME: "Column name"

Description of DBA_TAB_COLUMNS.DATA_TYPE: "Datatype of the column"

Description of DBA_TAB_COLUMNS.DATA_TYPE_MOD: "Datatype modifier of the column"

Description of DBA_TAB_COLUMNS.DATA_TYPE_OWNER: "Owner of the datatype of the column"

Description of DBA_TAB_COLUMNS.DATA_LENGTH: "Length of the column in bytes"

Description of DBA_TAB_COLUMNS.DATA_PRECISION: "Length: decimal digits (NUMBER) or binary digits (FLOAT)"

Description of DBA_TAB_COLUMNS.DATA_SCALE: "Digits to right of decimal point in a number"

Description of DBA_TAB_COLUMNS.NULLABLE: "Does column allow NULL values?"

Description of DBA_TAB_COLUMNS.COLUMN_ID: "Sequence number of the column as created"

Description of DBA_TAB_COLUMNS.DEFAULT_LENGTH: "Length of default value for the column"

Description of DBA_TAB_COLUMNS.DATA_DEFAULT: "Default value for the column"

Description of DBA_TAB_COLUMNS.NUM_DISTINCT: "The number of distinct values in the column"

Description of DBA_TAB_COLUMNS.LOW_VALUE: "The low value in the column"

Description of DBA_TAB_COLUMNS.HIGH_VALUE: "The high value in the column"

Description of DBA_TAB_COLUMNS.DENSITY: "The density of the column"

Description of DBA_TAB_COLUMNS.NUM_NULLS: "The number of nulls in the column"

Description of DBA_TAB_COLUMNS.NUM_BUCKETS: "The number of buckets in histogram for the column"

Description of DBA_TAB_COLUMNS.LAST_ANALYZED: "The date of the most recent time this column was analyzed"

Description of DBA_TAB_COLUMNS.SAMPLE_SIZE: "The sample size used in analyzing this column"

Description of DBA_TAB_COLUMNS.CHARACTER_SET_NAME: "Character set name"

Description of DBA_TAB_COLUMNS.CHAR_COL_DECL_LENGTH: "Declaration length of character type column"

Description of DBA_TAB_COLUMNS.GLOBAL_STATS: "Are the statistics calculated without merging underlying partitions?"

Description of DBA_TAB_COLUMNS.USER_STATS: "Were the statistics entered directly by the user?"

Description of DBA_TAB_COLUMNS.AVG_COL_LEN: "The average length of the column in bytes"

Description of DBA_TAB_COLUMNS.CHAR_LENGTH: "The maximum length of the column in characters"

Description of DBA_TAB_COLUMNS.CHAR_USED: "C if the width was specified in characters, B if in bytes"

Description of DBA_TAB_COLUMNS.V80_FMT_IMAGE: "Is column data in 8.0 image format?"

Description of DBA_TAB_COLUMNS.DATA_UPGRADED: "Has column data been upgraded to the latest type version format?"

No comments exist for the HISTOGRAM column of the DBA_TAB_COLUMNS table.

DBA_TAB_COLUMNS View Source

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA