Friday, November 14, 2008

DBA_OBJECT_TABLES

DBA_OBJECT_TABLES describes all object tables in the database. Its columns are the same as those in ALL_OBJECT_TABLES.

Related Views

· ALL_OBJECT_TABLES describes the object tables accessible to the current user.

· USER_OBJECT_TABLES describes the object tables owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace containing the table; NULL for partitioned, temporary, and index-organized tables

CLUSTER_NAME

VARCHAR2(30)

Name of the cluster, if any, to which the table belongs

IOT_NAME

VARCHAR2(30)

Name of the index-organized table, if any, to which the overflow or mapping table entry belongs. If the IOT_TYPE column is not NULL, then this column contains the base table name.

STATUS

VARCHAR2(8)

If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID)

PCT_FREE

NUMBER

Minimum percentage of free space in a block; NULL for partitioned tables

PCT_USED

NUMBER

Minimum percentage of used space in a block; NULL for partitioned tables

INI_TRANS

NUMBER

Initial number of transactions; NULL for partitioned tables

MAX_TRANS

NUMBER

Maximum number of transactions; NULL for partitioned tables

INITIAL_EXTENT

NUMBER

Size of the initial extent (in bytes); NULL for partitioned tables

NEXT_EXTENT

NUMBER

Size of secondary extents (in bytes); NULL for partitioned tables

MIN_EXTENTS

NUMBER

Minimum number of extents allowed in the segment; NULL for partitioned tables

MAX_EXTENTS

NUMBER

Maximum number of extents allowed in the segment; NULL for partitioned tables

PCT_INCREASE

NUMBER

Percentage increase in extent size; NULL for partitioned tables

FREELISTS

NUMBER

Number of process freelists allocated to the segment; NULL for partitioned tables

FREELIST_GROUPS

NUMBER

Number of freelist groups allocated to the segment; NULL for partitioned tables

LOGGING

VARCHAR2(3)

Indicates whether or not changes to the table are logged:

· YES

· NO

BACKED_UP

VARCHAR2(1)

Indicates whether the table has been backed up since the last modification (Y) or not (N)

NUM_ROWS

NUMBER

Number of rows in the table

BLOCKS

NUMBER

Number of used blocks in the table

EMPTY_BLOCKS

NUMBER

Number of empty (never used) blocks in the table

AVG_SPACE

NUMBER

Average available free space in the table

CHAIN_CNT

NUMBER

Number of chained rows in the table

AVG_ROW_LEN

NUMBER

Average row length, including row overhead

AVG_SPACE_FREELIST_BLOCKS

NUMBER

Average free space of all blocks on a freelist

NUM_FREELIST_BLOCKS

NUMBER

Number of blocks on the freelist

DEGREE

VARCHAR2(10)

Number of parallel execution processes per instance for scanning the table, or DEFAULT

INSTANCES

VARCHAR2(10)

Number of instances across which the table is to be scanned, or DEFAULT

CACHE

VARCHAR2(5)

Indicates whether the table is to be cached in the buffer cache (Y) or not (N)

TABLE_LOCK

VARCHAR2(8)

Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED)

SAMPLE_SIZE

NUMBER

Sample size used in analyzing this table

LAST_ANALYZED

DATE

Date on which this table was most recently analyzed

PARTITIONED

VARCHAR2(3)

Indicates whether the table is partitioned (YES) or not (NO)

IOT_TYPE

VARCHAR2(12)

If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. If the table is not an index-organized table, then IOT_TYPE is NULL.

OBJECT_ID_TYPE

VARCHAR2(16)

Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED

TABLE_TYPE_OWNER

VARCHAR2(30)

Owner of the type of the table

TABLE_TYPE

VARCHAR2(30)

Type of the table

TEMPORARY

VARCHAR2(1)

Indicates whether this is a temporary table (Y) or not (N)

SECONDARY

VARCHAR2(1)

Indicates whether the object table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)

NESTED

VARCHAR2(3)

Indicates whether the table is a nested table (YES) or not (NO)

BUFFER_POOL

VARCHAR2(7)

Default buffer pool to be used for table blocks:

· DEFAULT

· KEEP

· RECYCLE

· NULL

ROW_MOVEMENT

VARCHAR2(8)

Indicates whether partitioned row movement is enabled (ENABLED) or disabled (DISABLED)

GLOBAL_STATS

VARCHAR2(3)

For partitioned object tables, indicates whether statistics were collected for the table as a whole (YES) or were estimated from statistics on underlying partitions and subpartitions (NO)

USER_STATS

VARCHAR2(3)

Indicates whether statistics were entered directly by the user (YES) or not (NO)

DURATION

VARCHAR2(15)

Indicates the duration of a temporary table:

· SYS$SESSION - Rows are preserved for the duration of the session

· SYS$TRANSACTION - Rows are deleted after COMMIT

Null - Permanent table

SKIP_CORRUPT

VARCHAR2(8)

Indicates whether Oracle Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED). To enable this feature, run the DBMS_REPAIR.SKIP_CORRUPT_BLOCKS procedure.

MONITORING

VARCHAR2(3)

Indicates whether the table has the MONITORING attribute set (YES) or not (NO)

CLUSTER_OWNER

VARCHAR2(30)

Owner of the cluster, if any, to which the table belongs

DEPENDENCIES

VARCHAR2(8)

Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)

COMPRESSION

VARCHAR2(8)

Indicates whether table compression is enabled (ENABLED) or not (DISABLED); NULL for partitioned tables

COMPRESS_FOR

VARCHAR2(18)

Default compression for what kind of operations:

· DIRECT LOAD ONLY

· FOR ALL OPERATIONS

· NULL

DROPPED

VARCHAR2(3)

Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO); NULL for partitioned tables

Note:

1. SELECT owner, table_name, status, table_type

FROM DBA_OBJECT_TABLES order by owner;

OWNER

TABLE_NAME

STATUS

TABLE_TYPE

MDSYS

SDO_GR_RDT_2

VALID

SDO_RASTER

SYS

SYSNTLCMA3vg9TlLgRAAUTyMV9w==

VALID

KUPC$_FILEINFO

SYS

KOTAD$

VALID

KOTAD

SYS

KOTMD$

VALID

KOTMD

SYS

KOTTBX$

VALID

KOTTBX

SYS

KOTADX$

VALID

KOTADX

SYS

KOTTD$

VALID

KOTTD

SYS

KOTTB$

VALID

KOTTB

SYS

SYSNTFqMXMbeuFOvgRAADuiMN8g==

VALID

KU$_LOGLINE1010

SYS

SYSNTFqMXMbesFOvgRAADuiMN8g==

VALID

KU$_LOGLINE1010

SYS

SYSNTFqMXMbeqFOvgRAADuiMN8g==

VALID

KUPC$_FILEINFO

SYS

SYSNTLCMA3vhBTlLgRAAUTyMV9w==

VALID

KU$_LOGLINE1010

SYS

SYSNTLCMA3vg/TlLgRAAUTyMV9w==

VALID

KU$_LOGLINE1010

SYS

WRI$_SQLSET_WORKSPACE_CPLANS

VALID

SQL_PLAN_ROW_TYPE

WMSYS

WM$EVENT_AUX_PARAMS_NT

VALID

WM$NV_PAIR_TYPE

WMSYS

WM$VERSIONED_TABLES_UNDO_CODE

VALID

WM$ED_UNDO_CODE_NODE_TYPE

XDB

SERVLET

VALID

XMLTYPE

XDB

xdb-log9_TAB

VALID

XMLTYPE

XDB

XDB$ALL_MODEL

VALID

XMLTYPE

XDB

XDB$ATTRGROUP_REF

VALID

XMLTYPE

XDB

XDB$SCHEMA

VALID

XMLTYPE

XDB

XDB$COMPLEX_TYPE

VALID

XMLTYPE

XDB

ftp-log14_TAB

VALID

XMLTYPE

XDB

http-log20_TAB

VALID

XMLTYPE

XDB

XDB$RESOURCE

VALID

XMLTYPE

XDB

XDB$NLOCKS

VALID

XDB$NLOCKS_T

XDB

XDB$CONFIG

VALID

XMLTYPE

XDB

XDB$H_LINK

VALID

XDB$LINK_T

XDB

XDB$SIMPLE_TYPE

VALID

XMLTYPE

XDB

XDB$CHOICE_MODEL

VALID

XMLTYPE

XDB

XDB$STATS

VALID

XMLTYPE

XDB

XDB$GROUP_REF

VALID

XMLTYPE

XDB

XDB$GROUP_DEF

VALID

XMLTYPE

XDB

XDB$ANY

VALID

XMLTYPE

XDB

XDB$ANYATTR

VALID

XMLTYPE

XDB

XDB$ATTRIBUTE

VALID

XMLTYPE

XDB

XDB$ELEMENT

VALID

XMLTYPE

XDB

XDB$SEQUENCE_MODEL

VALID

XMLTYPE

XDB

XDB$ATTRGROUP_DEF

VALID

XMLTYPE

XDB

XDB$ACL

VALID

XMLTYPE

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/14/2008 02:12:00 PM 0 comments

Labels: ,

DBA_INDEXTYPES

DBA_INDEXTYPES describes all indextypes in the database. Its columns are the same as those in ALL_INDEXTYPES.

Related Views

· ALL_INDEXTYPES displays information about the indextypes accessible to the current user.

· USER_INDEXTYPES displays information about the indextypes owned by the current user.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the indextype

INDEXTYPE_NAME

VARCHAR2(30)

NOT NULL

Name of the indextype

IMPLEMENTATION_SCHEMA

VARCHAR2(30)

NOT NULL

Name of the schema for the indextype implementation (that is, containing the indextype operators)

IMPLEMENTATION_NAME

VARCHAR2(30)

NOT NULL

Name of the indextype implementation type

INTERFACE_VERSION

NUMBER

Version of the indextype interface

IMPLEMENTATION_VERSION

NUMBER

NOT NULL

Version of the indextype implementation

NUMBER_OF_OPERATORS

NUMBER

Number of operators associated with the indextype

PARTITIONING

VARCHAR2(10)

Kinds of local partitioning supported by the indextype:

· NONE

· RANGE

· HASH

· HASH,RANGE

ARRAY_DML

VARCHAR2(3)

Indicates whether the indextype supports array DML (YES) or not (NO)

MAINTENANCE_TYPE

VARCHAR2(14)

Indicates whether the indextype is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED)

Note:

1. SELECT * FROM DBA_INDEXTYPES;

OWNER

INDEXTYPE_

NAME

IMPLEMENTATION_

SCHEMA

IMPLEMENTATION_

NAME

INTERFACE_

VERSION

IMPLEMEN

TATION_

VERSION

NUMBER_

OF_

OPERATORS

PARTI

TIONING

ARRAY_

DML

CTXSYS

CTXCAT

CTXSYS

CATINDEXMETHODS

2

1

2

NONE

YES

CTXSYS

CTXXPATH

CTXSYS

XPATHINDEXMETHODS

2

1

1

NONE

YES

CTXSYS

CTXRULE

CTXSYS

RULEINDEXMETHODS

2

1

6

NONE

YES

CTXSYS

CONTEXT

CTXSYS

TEXTINDEXMETHODS

2

1

6

RANGE

YES

MDSYS

RTREE_INDEX

MDSYS

RTREE_INDEX_METHOD

2

1

2

RANGE

NO

MDSYS

SPATIAL_INDEX

MDSYS

SDO_INDEX_METHOD_10I

2

1

60

RANGE

NO

ORDSYS

ORDIMAGEINDEX

ORDSYS

ORDIMGIDXMETHODS

2

1

1

NONE

NO

XDB

XMLINDEX

XDB

XMLINDEXMETHODS

2

1

1

NONE

NO

XDB

XDBHI_IDXTYP

XDB

XDBHI_IM

2

1

3

NONE

NO

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/14/2008 02:07:00 PM 0 comments

Labels: ,

DBA_IDENTIFIERS

DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database. Its columns are the same as those in ALL_IDENTIFIERS.

Related Views

· ALL_IDENTIFIERS displays information about the identifiers in the stored objects accessible to the current user.

· USER_IDENTIFIERS displays information about the identifiers in the stored objects owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the identifier

NAME

VARCHAR2(30)

Name of the identifier

SIGNATURE

VARCHAR2(32)

Signature of the identifier

TYPE

VARCHAR2(18)

Type of the identifier

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Name of the object where the identifier action occurred

OBJECT_TYPE

VARCHAR2(13)

Type of the object where the identifier action occurred

USAGE

VARCHAR2(11)

Type of the identifier usage:

· DECLARATION

· DEFINITION

· CALL

· REFERENCE

· ASSIGNMENT

USAGE_ID

NUMBER

Unique key for the identifier usage within the object

LINE

NUMBER

Line number of the identifier action

COL

NUMBER

Column number of the identifier action

USAGE_CONTEXT_ID

NUMBER

Context USAGE_ID of the identifier usage

Oracle data dictionary views

Oracle dynamic performance views

Posted by Admin at 11/14/2008 02:05:00 PM 0 comments

Labels: ,

Subscribe to: Posts (Atom)