[Home] [Help] [Dependency Information]
Object Name: | CDB_ASSOCIATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All associations in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_OWNER | VARCHAR2 | (30) | Yes | Owner of the object for which the association is being defined |
OBJECT_NAME | VARCHAR2 | (30) | Yes | Object name for which the association is being defined |
COLUMN_NAME | VARCHAR2 | (30) | Column name in the object for which the association is being defined | |
OBJECT_TYPE | VARCHAR2 | (9) | Schema type of the object - table, type, package or function | |
STATSTYPE_SCHEMA | VARCHAR2 | (30) | Owner of the statistics type | |
STATSTYPE_NAME | VARCHAR2 | (30) | Name of Statistics type which contains the cost, selectivity or stats funcs | |
DEF_SELECTIVITY | NUMBER | Default Selectivity if any of the object | ||
DEF_CPU_COST | NUMBER | Default CPU cost if any of the object | ||
DEF_IO_COST | NUMBER | Default I/O cost if any of the object | ||
DEF_NET_COST | NUMBER | Default Networking cost if any of the object | ||
INTERFACE_VERSION | NUMBER | Version number of Statistics type interface implemented | ||
MAINTENANCE_TYPE | VARCHAR2 | (14) | Whether it is system managed or user managed | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_OWNER
, OBJECT_NAME
, COLUMN_NAME
, OBJECT_TYPE
, STATSTYPE_SCHEMA
, STATSTYPE_NAME
, DEF_SELECTIVITY
, DEF_CPU_COST
, DEF_IO_COST
, DEF_NET_COST
, INTERFACE_VERSION
, MAINTENANCE_TYPE
, CON_ID
FROM SYS.CDB_ASSOCIATIONS;
SYS.CDB_ASSOCIATIONS does not reference any database object
SYS.CDB_ASSOCIATIONS is referenced by following:
|
|
|