DICTIONARY_SCHEMA
DICTIONARY_SCHEMA 스키마는 시스템 내의 SQL 객체와 이와 관련된 정보를 얻기 위한 view나 테이블을 포함하고 있다.
DICTIONARY_SCHEMA의 view와 테이블들은 open 단계부터 조회할 수 있다.
해당 view들을 사용하려면 다음과 같이 DictionarySchema.sql을 실행해야 한다.
Standalone의 경우
% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/standalone/DictionarySchema.sql
Cluster의 경우
% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/cluster/DictionarySchema.sql
View나 테이블의 이름에 따라 다음과 같은 정보를 얻을 수 있다.
ALL 계열 view
ALL_로 시작하는 이름을 가진 view
현재 사용자가 접근 가능한 객체에 대한 정보
DBA 계열 view
DBA_로 시작하는 이름을 가진 view
DBA 권한 (ACCESS CONTROL ON DATABASE)을 가지고 있는 현재 사용자의 모든 객체에 대한 정보
USER 계열 view
USER_로 시작하는 이름을 가진 view
현재 사용자가 소유한 객체에 대한 정보
ALL 계열 View
현재 사용자가 접근 가능한 객체에 대한 정보를 얻을 수 있다.
ALL_ALL_TABLES
ALL_ALL_TABLES describes the object tables and relational tables accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the table |
CLUSTER_NAME | VARCHAR(128) |
Name of the cluster |
IOT_NAME | VARCHAR(128) |
Name of the index-organized table |
STATUS | VARCHAR(32) | 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 |
PCT_USED | NUMBER | Minimum percentage of used space in a block |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes) |
NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes) |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
FREELISTS | NUMBER |
Number of process freelists allocated to the segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to the segment |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the table are logged |
BACKED_UP | VARCHAR(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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
AVG_ROW_LEN | NUMBER |
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS | NUMBER |
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS | NUMBER |
Number of blocks on the freelist |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the table, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the table is to be scanned, or DEFAULT |
CACHE | VARCHAR(1) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
TABLE_LOCK | VARCHAR(32) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing the table |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
PARTITIONED | VARCHAR(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
IOT_TYPE | VARCHAR(32) |
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. |
OBJECT_ID_TYPE | VARCHAR(32) |
Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED |
TABLE_TYPE_OWNER | VARCHAR(128) |
If an object table, owner of the type from which the table is created |
TABLE_TYPE | VARCHAR(128) |
If an object table, type of the table |
TEMPORARY | VARCHAR(1) | Indicates whether the table is temporary (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the table is a secondary object created by cartridge |
NESTED | VARCHAR(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for table blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for table blocks |
CELL_FLASH_CACHE | VARCHAR(32) | Cell flash cache hint to be used for table blocks |
ROW_MOVEMENT | VARCHAR(32) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
SKIP_CORRUPT | VARCHAR(32) |
Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED) |
MONITORING | VARCHAR(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
CLUSTER_OWNER | VARCHAR(128) |
Owner of the cluster, if any |
DEPENDENCIES | VARCHAR(32) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
COMPRESSION | VARCHAR(32) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED) |
COMPRESS_FOR | VARCHAR(32) |
Default compression for what kind of operations |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
READ_ONLY | VARCHAR(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the table segment has been created (YES) or not (NO) |
ALL_ARGUMENTS
ALL_ARGUMENTS lists all arguments of functions, procedures.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of function, procedures or package |
SCHEMA_NAME | VARCHAR(128) | Schema Name of function, procedures or package |
OBJECT_NAME | VARCHAR(128) | Name of function, procedures |
PACKAGE_NAME | VARCHAR(128) | Package Name of function, procedures |
OBJECT_ID | NUMBER | ID of a function, procedures |
SUBPROGRAM_ID | NUMBER | ID of procedures in package |
ARGUMENT_NAME | VARCHAR(128) | Name of argument or attribute name of record type argument |
POSITION | NUMBER | Position of argument or position of attribute in record type |
SEQUENCE | NUMBER | Sequential order of argument and its attributes |
DATA_LEVEL | NUMBER | Nesting depth of the argument for composite types |
DATA_TYPE | VARCHAR(128) | Data Type of the argument |
DEFAULTED | VARCHAR(1) | Whether or not the argument is defaulted |
DEFAULT_VALUE | VARCHAR(1) | Reserved for future use |
DEFAULT_LENGTH | VARCHAR(1) | Reserved for future use |
IN_OUT | VARCHAR(32) | Direction of the argument (IN, OUT, IN/OUT) |
DATA_LENGTH | NUMBER | Length of the column(in bytes) |
DATA_PRECISION | NUMBER | Length in decimal digits(NUMBER) or binary digits(FLOAT) |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
RADIX | NUMBER | Argument radix for a number |
CHARACTER_SET_NAME | VARCHAR(128) | Character set name for the argument |
TYPE_OWNER | VARCHAR(128) | Owner of the type of the argument |
TYPE_NAME | VARCHAR(128) | Name of the type of the argument |
TYPE_SUBNAME | VARCHAR(128) | Name of the type of the argument declared in package |
TYPE_LINK | VARCHAR(128) | Name of the type of the argument declared in a remote package |
PLS_TYPE | VARCHAR(128) | Name of the type of the argument at PSM |
CHAR_LENGTH | NUMBER | Character limit for string datatypes |
CHAR_USED | VARCHAR(1) | Whether the byte limit(B) or char limit(C) is official for the string |
ORIGIN_CON_ID | VARCHAR(256) | ID of the container where the data originates |
ALL_CATALOG
ALL_CATALOG displays the tables, views, synonyms, and sequences accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_SCHEMA | VARCHAR(128) | Schema of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_NAME | VARCHAR(128) | Name of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_TYPE | VARCHAR(32) | Type of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
ALL_CLUSTER_TABLES
ALL_CLUSTER_TABLES describes all cluster tables accessible to the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
SHARD_STRATEGY | VARCHAR(32) | Sharding strategy of the table: the value in (CLONED, HASH SHARDING, RANGE SHARDING, LIST SHARDING) |
SHARD_PLACEMENT | VARCHAR(32) | Shard placement of the table: the value in (AT CLUSTER WIDE or AT CLUSTER GROUP) |
SHARD_COUNT | NUMBER | Shard count of the table (if cloned table, the value is null) |
SHARD_KEY_COUNT | NUMBER | Shard key column count of the table (if cloned table, the value is null) |
HAS_GSI | VARCHAR(3) | Indicate whether the table has global secondary index: (YES) or (NO) |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
ALL_COL_COMMENTS
ALL_COL_COMMENTS displays comments on the columns of the tables and views accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
COMMENTS | VARCHAR(1024) | Comment on the column |
ALL_COL_PRIVS
ALL_COL_PRIVS describes the object grants, for which the current user is the object owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
PRIVILEGE | VARCHAR(32) | Privilege on the column |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_MADE describes the column object grants for which the current user is the object owner or grantor.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the column |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_COL_PRIVS_RECD
ALL_COL_PRIVS_RECD describes the column object grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the column |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_CONSTRAINTS
ALL_CONSTRAINTS describes constraint definitions on tables accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the constraint definition |
CONSTRAINT_SCHEMA | VARCHAR(128) | Schema of the constraint definition |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint definition |
CONSTRAINT_TYPE | VARCHAR(1) | Type of the constraint definition: the value in ( C: check constraint, P: Primary key, U: Unique Key, R: Referential intgrity ) |
TABLE_OWNER | VARCHAR(128) | Owner of the table (or view) associated with the constraint definition |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table (or view) associated with the constraint definition |
TABLE_NAME | VARCHAR(128) | Name of the table (or view) associated with the constraint definition |
SEARCH_CONDITION | LONG VARCHAR | Text of search condition for a check constraint |
R_OWNER | VARCHAR(128) | Owner of the unique constraint definition for the referenced table |
R_SCHEMA | VARCHAR(128) | Schema of the unique constraint definition for the referenced table |
R_CONSTRAINT_NAME | VARCHAR(128) | Name of the unique constraint definition for the referenced table |
DELETE_RULE | VARCHAR(32) | Delete rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
UPDATE_RULE | VARCHAR(32) | Update rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
STATUS | VARCHAR(32) | Enforcement status of the constraint: the value in ( ENABLED, DISABLE ) |
DEFERRABLE | VARCHAR(32) | Indicates whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE) |
DEFERRED | VARCHAR(32) | Indicates whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE) |
VALIDATED | VARCHAR(32) | Indicates whether all data may obey the constraint or not: the value in ( VALIDATED, NOT VALIDATED ) |
GENERATED | VARCHAR(32) | Indicates whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME) |
BAD | VARCHAR(32) |
Indicates whether this constraint specifies a century in an ambiguous manner (BAD) or not (NULL) |
RELY | VARCHAR(32) |
When NOT VALIDATED, indicates whether the constraint is to be taken into account for query rewrite (RELY) or not (NULL) |
LAST_CHANGE | TIMESTAMP(2) WITHOUT TIME ZONE | When the constraint was last enabled or disabled |
INDEX_OWNER | VARCHAR(128) | Owner of the index associated with the key constraint |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index associated with the key constraint |
INDEX_NAME | VARCHAR(128) | Name of the index associated with the key constraint |
INVALID | VARCHAR(32) | Indicates whether the constraint is invalid (INVALID) or not (NULL) |
VIEW_RELATED | VARCHAR(32) | Indicates whether the constraint depends on a view (DEPEND ON VIEW) or not (NULL) |
DROPPED | VARCHAR(3) | Indicates whether the constraint has been dropped and is in the recycle bin (YES) or not (NO) |
COMMENTS | VARCHAR(1024) | Comments of the constraint definition |
ALL_CONS_COLUMNS
ALL_CONS_COLUMNS describes columns that are accessible to the current user and that are specified in constraints.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the constraint definition |
CONSTRAINT_SCHEMA | VARCHAR(128) | Schema of the constraint definition |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint definition |
TABLE_OWNER | VARCHAR(128) | Owner of the table with the constraint definition |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table with the constraint definition |
TABLE_NAME | VARCHAR(128) | Name of the table with the constraint definition |
COLUMN_NAME | VARCHAR(128) | Name of the column or attribute of the object type column specified in the constraint definition |
POSITION | NUMBER | Original position of the column or attribute in the definition of the object |
ALL_DB_PRIVS
ALL_DB_PRIVS describes the database grants, for which the current user is the grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PRIVILEGE | VARCHAR(32) | Privilege on the database |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_DB_PRIVS_MADE
ALL_DB_PRIVS_MADE describes the database grants for which the current user is the grantor.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the database |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_DB_PRIVS_RECD
ALL_DB_PRIVS_RECD describes the database grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the database |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_DEPENDENCIES
ALL_DEPENDENCIES describes dependencies between objects accessible to the current user
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of object |
SCHEMA_NAME | VARCHAR(128) | Schema Name of object |
NAME | VARCHAR(128) | Name of object |
TYPE | VARCHAR(32) | Type of object: FUNCTION, PROCEDURE, VIEW, PACKAGE, PACKAGE BODY, TRIGGER |
REFERENCED_OWNER | VARCHAR(128) | Owner of the referenced object |
REFERENCED_SCHEMA_NAME | VARCHAR(128) | Schema Name of the referenced object |
REFERENCED_TYPE | VARCHAR(32) | Type of the referenced object: FUNCTION, PROCEDURE, TABLE, VIEW, SEQUENCE, PACKAGE, PACKAGE BODY, TRIGGER |
REFERENCED_LINK_NAME | VARCHAR(128) | Name of the link to the parent object |
REFERENCED_NAME | VARCHAR(128) | Name of the referenced object |
DEPENDENCY_TYPE | VARCHAR(32) | Indicates whether the dependency is a REF dependency (REF) or not (HARD) |
ALL_GLOBAL_SECONDARY_INDEXES
ALL_GLOBAL_SECONDARY_INDEXES describes the global secondary indexes on the tables accessible to the current user.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_OWNER | VARCHAR(128) | Owner of the global secondary indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the global secondary indexed object |
TABLE_NAME | VARCHAR(128) | Name of the global secondary indexed object |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the global secondary index |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent |
NEXT_EXTENT | NUMBER | Size of secondary extents |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_FREE | NUMBER | Minimum percentage of free space in a block |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the global secondary index are logged: (YES) or (NO) |
BLOCKS | NUMBER | Number of used blocks in the global secondary index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the global secondary index |
DROPPED | VARCHAR(3) | Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO) |
ALL_GSI_PLACE
ALL_GSI_PLACE describes node placement of all global secondary indexes on the tables accessible to the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_OWNER | VARCHAR(128) | Owner of the global secondary indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the global secondary indexed object |
TABLE_NAME | VARCHAR(128) | Name of the global secondary indexed object |
GROUP_ID | NUMBER | Group identifier of the node where the global secondary index placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the global secondary index placed |
MEMBER_ID | NUMBER | Member identifier of the node where the global secondary index placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the global secondary index placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
DROPPED | VARCHAR(3) | Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO) |
BLOCKS | NUMBER | Number of used blocks of the node where the global secondary index placed |
ALL_INDEXES
ALL_INDEXES describes the indexes on the tables accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the index |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
INDEX_TYPE | VARCHAR(32) | Type of the index: the value in ( NORMAL, NORMAL/REV, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED NORMAL/REV, FUNCTION-BASED BITMAP, IOT - TOP, DOMAIN ) |
TABLE_OWNER | VARCHAR(128) | Owner of the indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the indexed object |
TABLE_NAME | VARCHAR(128) | Name of the indexed object |
TABLE_TYPE | VARCHAR(32) | Type of the indexed object: the value in ( NEXT OBJECT, INDEX, TABLE, VIEW, SYNONYM, SEQUENCE ) |
UNIQUENESS | VARCHAR(32) | Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE) |
COMPRESSION | VARCHAR(32) |
Indicates whether index compression is enabled (ENABLED) or not (DISABLED) |
PREFIX_LENGTH | NUMBER |
Number of columns in the prefix of the compression key |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the index |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent |
NEXT_EXTENT | NUMBER | Size of secondary extents |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
PCT_THRESHOLD | NUMBER |
Threshold percentage of block space allowed per index entry |
INCLUDE_COLUMN | NUMBER |
Column ID of the last column to be included in index-organized table primary key (non-overflow) index |
FREELISTS | NUMBER |
Number of process freelists allocated to this segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to this segment |
PCT_FREE | NUMBER | Minimum percentage of free space in a block |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the index are logged: (YES) or (NO) |
BLOCKS | NUMBER | Number of used blocks in the index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the index |
BLEVEL | NUMBER |
B-Tree level (depth of the index from its root block to its leaf blocks) |
LEAF_BLOCKS | NUMBER |
Number of leaf blocks in the index |
DISTINCT_KEYS | NUMBER | Number of distinct indexed values. |
AVG_LEAF_BLOCKS_PER_KEY | NUMBER |
Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer |
AVG_DATA_BLOCKS_PER_KEY | NUMBER |
Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer |
CLUSTERING_FACTOR | NUMBER |
Indicates the amount of order of the rows in the table based on the values of the index |
STATUS | VARCHAR(32) | Indicates whether a nonpartitioned index is VALID or UNUSABLE |
NUM_ROWS | NUMBER |
Number of rows in the index |
SAMPLE_SIZE | NUMBER | Size of the sample used to analyze the index |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this index was most recently analyzed |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the index, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the indexes to be scanned, or DEFAULT |
PARTITIONED | VARCHAR(3) |
Indicates whether the index is partitioned (YES) or not (NO) |
TEMPORARY | VARCHAR(1) | Indicates whether the index is on a temporary table (Y) or not (N) |
GENERATED | VARCHAR(1) | Indicates whether the name of the index is system-generated (Y) or not (N) |
SECONDARY | VARCHAR(1) | Indicates whether the index is a secondary object created by the method of the Data Cartridge (Y) or not (N) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for index blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for index blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for index blocks |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
PCT_DIRECT_ACCESS | NUMBER |
For a secondary index on an index-organized table, the percentage of rows with VALID guess |
ITYP_OWNER | VARCHAR(128) |
For a domain index, the owner of the indextype |
ITYP_NAME | VARCHAR(128) |
For a domain index, the name of the indextype |
PARAMETERS | VARCHAR(1024) |
For a domain index, the parameter string |
GLOBAL_STATS | VARCHAR(3) |
For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO) |
DOMIDX_STATUS | VARCHAR(32) |
Status of a domain index |
DOMIDX_OPSTATUS | VARCHAR(32) |
Status of the operation on a domain index |
FUNCIDX_STATUS | VARCHAR(32) |
Status of a function-based index |
JOIN_INDEX | VARCHAR(3) |
Indicates whether the index is a join index (YES) or not (NO) |
IOT_REDUNDANT_PKEY_ELIM | VARCHAR(3) |
Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO) |
DROPPED | VARCHAR(3) | Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO) |
VISIBILITY | VARCHAR(3) |
Indicates whether the index is VISIBLE or INVISIBLE to the optimizer |
DOMIDX_MANAGEMENT | VARCHAR(32) |
If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the index segment has been created (YES) or not (NO) |
COMMENTS | VARCHAR(1024) | Comments of the index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the index |
ALL_IND_COLUMNS
ALL_IND_COLUMNS describes the columns of indexes on all tables accessible to the current user.
Column name | Data type | Description |
|---|---|---|
INDEX_OWNER | VARCHAR(128) | Owner of the index |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
TABLE_OWNER | VARCHAR(128) | Owner of the table or cluster |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table or cluster |
TABLE_NAME | VARCHAR(128) | Name of the table or cluster |
COLUMN_NAME | VARCHAR(128) | Column name or attribute of the object type column |
COLUMN_POSITION | NUMBER | Position of the column or attribute within the index |
COLUMN_LENGTH | NUMBER | Indexed length of the column |
CHAR_LENGTH | NUMBER | Maximum codepoint length of the column |
DESCEND | VARCHAR(32) | Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC) |
NULL_ORDER | VARCHAR(32) | Indicates whether the null value of the column is sorted in nulls first order (NULLS FIRST) or nulls last order (NULLS LAST) |
ALL_IND_PLACE
ALL_IND_PLACE describes node placement of the indexes on the tables accessible to the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the index |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
TABLE_OWNER | VARCHAR(128) | Owner of the indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the indexed object |
TABLE_NAME | VARCHAR(128) | Name of the indexed object |
GROUP_ID | NUMBER | Group identifier of the node where the index placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the index placed |
MEMBER_ID | NUMBER | Member identifier of the node where the index placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the index placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
DROPPED | VARCHAR(3) | Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO) |
DISTINCT_KEYS | NUMBER | (deprecated) |
SAMPLE_SIZE | NUMBER | (deprecated) |
BLOCKS | NUMBER | Number of used blocks of the node where the index placed |
LAST_ANALYZED | TIMESTAMP(2) WITHOUT TIME ZONE | (deprecated) |
ALL_NONSCHEMA_COMMENTS
ALL_NONSCHEMA_COMMENTS displays comments on all non-schema objects (database, authorizations, schemas, tablespaces) accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OBJECT_NAME | VARCHAR(128) | Name of the non-schema object |
OBJECT_TYPE | VARCHAR(32) | Type of the non-schema object: DATABASE, AUTHORIZATION, SCHEMA, TABLESPACE |
COMMENTS | VARCHAR(1024) | Comments of the non-schema object |
ALL_OBJECTS
ALL_OBJECTS describes all objects accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
SCHEMA_NAME | VARCHAR(128) | Schema of the object |
OBJECT_NAME | VARCHAR(128) | Name of the object |
SUBOBJECT_NAME | VARCHAR(128) | Name of the subobject (for example, partition) |
OBJECT_ID | NUMBER | Dictionary object number of the object |
DATA_OBJECT_ID | NUMBER | Dictionary object number of the segment that contains the object |
OBJECT_TYPE | VARCHAR(32) | Type of the object (such as TABLE, INDEX) |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp for the creation of the object |
LAST_DDL_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp for the last modification of the object resulting from a DDL statement |
TIMESTAMP | VARCHAR(32) | Timestamp for the specification of the object (character data) |
STATUS | VARCHAR(32) | Status of the object: the value in ( VALID, INVALID, N/A ) |
TEMPORARY | VARCHAR(1) | Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N) |
GENERATED | VARCHAR(1) |
Indicates whether the name of this object was system-generated (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N) |
NAMESPACE | NUMBER | Namespace for the object |
EDITION_NAME | VARCHAR(128) |
Name of the edition in which the object is actual |
DROPPED | VARCHAR(3) | Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO) |
ALL_PACKAGE_PRIVS
ALL_PACKAGE_PRIVS describes the package grants, for which the current user is the package owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the package |
PROCEDURE_NAME | VARCHAR(128) | Name of the package |
PRIVILEGE | VARCHAR(32) | Privilege on the package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_PACKAGE_PRIVS_MADE
ALL_PACKAGE_PRIVS_MADE describes the package grants for which the current user is the package owner or grantor.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the package |
PROCEDURE_NAME | VARCHAR(128) | Name of the package |
PRIVILEGE | VARCHAR(32) | Privilege on the package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_PACKAGE_PRIVS_RECD
ALL_PACKAGE_PRIVS_RECD describes the package grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the package |
PROCEDURE_NAME | VARCHAR(128) | Name of the package |
PRIVILEGE | VARCHAR(32) | Privilege on the package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_PROCEDURES
ALL_PROCEDURES lists all function, procedures or package
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of function, procedures or package |
SCHEMA_NAME | VARCHAR(128) | Schema Name of function, procedures or package |
OBJECT_NAME | VARCHAR(128) | Name of function, procedures or package |
PROCEDURE_NAME | VARCHAR(128) | Name when a procedures in package |
OBJECT_ID | NUMBER | ID of a function, procedures or package |
SUBPROGRAM_ID | NUMBER | ID of procedures in package |
OVERLOAD | VARCHAR(32) | ID of overloading procedure in package |
OBJECT_TYPE | VARCHAR(32) | Type of function, procedures or package |
AGGREGATE | VARCHAR(3) | Indicate whether the procedure is an aggreage function(YES) or not(NO) |
PIPELINED | VARCHAR(3) | Indicate whether the procedure is a pipelined table function(YES) or not(NO) |
IMPLTYPEOWNER | VARCHAR(128) | Name of the owner of the implementation type, if any |
IMPLTYPENAME | VARCHAR(128) | Name of the implementation type, if any |
PARALLEL | VARCHAR(3) | Indicates whether the procedure or function is parallel-enabled (YES) or not (NO) |
INTERFACE | VARCHAR(3) | YES, if the procedure/function is a table function implemented using the SQLCLI interface; otherwise NO |
DETERMINISTIC | VARCHAR(3) | YES, if the procedure/function is declared to be deterministic; otherwise NO |
AUTHID | VARCHAR(32) | Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker) |
ALL_PROC_PRIVS
ALL_PROC_PRIVS describes the procedure grants, for which the current user is the procedure owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure and function |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure and function |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure and function |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure and function |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_PROC_PRIVS_MADE
ALL_PROC_PRIVS_MADE describes the procedure grants for which the current user is the procedure owner or grantor.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure and function |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure and function |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure and function |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure and function |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_PROC_PRIVS_RECD
ALL_PROC_PRIVS_RECD describes the procedure grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure and function |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure and function |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure and function |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure and function |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SCHEMAS
Identify the schemata in a catalog that are owned by given user or accessible to given user or role.
Column name | Data type | Description |
|---|---|---|
SCHEMA_OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Created time of the schema |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Last modified time of the schema |
COMMENTS | VARCHAR(1024) | Comments of the schema |
ALL_SCHEMA_PATH
ALL_SCHEMA_PATH describes the schema search order of the current user and PUBLIC, for naming resolution of unqualified SQL schema objects.
Column name | Data type | Description |
|---|---|---|
AUTH_NAME | VARCHAR(128) | Name of the authorization |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
SEARCH_ORDER | NUMBER | Schema search order of the authorization |
ALL_SCHEMA_PRIVS
ALL_SCHEMA_PRIVS describes the schema grants, for which the current user is the schema owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SCHEMA_PRIVS_MADE
ALL_SCHEMA_PRIVS_MADE describes the schema grants, for which the current user is the grantor.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SCHEMA_PRIVS_RECD
ALL_SCHEMA_PRIVS_RECD describes the schema grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SEQUENCES
ALL_SEQUENCES describes all sequences accessible to the current user.
Column name | Data type | Description |
|---|---|---|
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Sequence name |
MIN_VALUE | NUMBER | Minimum value of the sequence |
MAX_VALUE | NUMBER | Maximum value of the sequence |
INCREMENT_BY | NUMBER | Value by which sequence is incremented |
CYCLE_FLAG | VARCHAR(1) | Indicates whether the sequence wraps around on reaching the limit (Y) or not (N) |
ORDER_FLAG | VARCHAR(1) | Indicates whether sequence numbers are generated in order (Y) or not (N) |
CACHE_SIZE | NUMBER | Number of sequence numbers to cache |
LAST_NUMBER | NUMBER | Last sequence number written to database. If a sequence uses caching, the number written to database is the last number placed in the sequence cache. |
COMMENTS | VARCHAR(1024) | Comments of the sequence |
ALL_SEQ_PRIVS
ALL_SEQ_PRIVS describes the sequence grants, for which the current user is the sequence owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SEQ_PRIVS_MADE
ALL_SEQ_PRIVS_MADE describes the sequence grants for which the current user is the sequence owner or grantor.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SEQ_PRIVS_RECD
ALL_SEQ_PRIVS_RECD describes the sequence grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_SHARD_KEY_COLUMNS
ALL_SHARD_KEY_COLUMNS describes shard key columns of all shareded tables accessible to the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
COLUMN_NAME | VARCHAR(128) | Column name of the shard key |
COLUMN_POSITION | NUMBER | Position of the column within the shard key |
ALL_SOURCE
ALL_SOURCE describes the text source of the stored objects accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of object |
SCHEMA_NAME | VARCHAR(128) | Schema Name of object |
NAME | VARCHAR(128) | Name of object |
TYPE | VARCHAR(32) | Type of object: FUNCTION, PROCEDURE, PACKAGE, PACKAGE BODY, TRIGGER |
LINE | NUMBER | Line number of this line of source |
TEXT | LONG VARCHAR | Text source of the strored object |
ORIGIN_CON_ID | VARCHAR(256) | ID of the container where the data originates |
ALL_SYNONYMS
ALL_SYNONYMS describes all synonyms.
Column name | Data type | Description |
|---|---|---|
SYNONYM_OWNER | VARCHAR(128) | Owner of the synonym |
SYNONYM_SCHEMA | VARCHAR(128) | Schema of the synonym |
SYNONYM_NAME | VARCHAR(128) | Synonym name |
OBJECT_SCHEMA_NAME | VARCHAR(128) | Object schema name |
OBJECT_NAME | VARCHAR(128) | Object name |
DB_LINK | VARCHAR(128) | Reserved for future use |
ALL_TABLES
ALL_TABLES describes the relational tables accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the table |
CLUSTER_NAME | VARCHAR(128) |
Name of the cluster |
IOT_NAME | VARCHAR(128) |
Name of the index-organized table |
STATUS | VARCHAR(32) |
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 |
PCT_USED | NUMBER | Minimum percentage of used space in a block |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes) |
NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes) |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
FREELISTS | NUMBER |
Number of process freelists allocated to the segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to the segment |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the table are logged |
BACKED_UP | VARCHAR(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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
AVG_ROW_LEN | NUMBER |
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS | NUMBER |
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS | NUMBER |
Number of blocks on the freelist |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the table, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the table is to be scanned, or DEFAULT |
CACHE | VARCHAR(1) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
TABLE_LOCK | VARCHAR(32) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing the table |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
PARTITIONED | VARCHAR(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
IOT_TYPE | VARCHAR(32) |
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. |
TEMPORARY | VARCHAR(1) | Indicates whether the table is temporary (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the table is a secondary object created by cartridge |
NESTED | VARCHAR(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for table blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for table blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for table blocks |
ROW_MOVEMENT | VARCHAR(32) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
SKIP_CORRUPT | VARCHAR(32) |
Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED) |
MONITORING | VARCHAR(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
CLUSTER_OWNER | VARCHAR(128) |
Owner of the cluster, if any |
DEPENDENCIES | VARCHAR(32) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
COMPRESSION | VARCHAR(32) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED) |
COMPRESS_FOR | VARCHAR(32) |
Default compression for what kind of operations |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
READ_ONLY | VARCHAR(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the table segment has been created (YES) or not (NO) |
RESULT_CACHE | VARCHAR(32) |
Result cache mode annotation for the table: the value in ( NULL, DEFAULT, FORCE, MANUAL ) |
ALL_TAB_COLS
ALL_TAB_COLS describes the columns (including hidden columns) of the tables, views, and clusters accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Column name |
DATA_TYPE | VARCHAR(128) | Datatype of the column |
DATA_TYPE_MOD | VARCHAR(3) |
Datatype modifier of the column |
DATA_TYPE_OWNER | VARCHAR(128) |
Owner of the datatype of the column |
DATA_LENGTH | NUMBER | Length of the column (in bytes) |
DATA_PRECISION | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
NULLABLE | VARCHAR(1) | Indicates whether a column allows NULLs. |
COLUMN_ID | NUMBER | Sequence number of the column as created |
DEFAULT_LENGTH | NUMBER | Length of the default value for the column |
DATA_DEFAULT | LONG VARCHAR | Default value for the column |
NUM_DISTINCT | NUMBER | Number of distinct values in the column |
LOW_VALUE | VARBINARY(32) | Low value in the column |
HIGH_VALUE | VARBINARY(32) | High value in the column |
DENSITY | NUMBER |
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. |
NUM_NULLS | NUMBER | Number of NULLs in the column |
NUM_BUCKETS | NUMBER |
Number of buckets in the histogram for the column |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this column was most recently analyzed |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing this column |
CHARACTER_SET_NAME | VARCHAR(128) |
Name of the character set |
CHAR_COL_DECL_LENGTH | NUMBER |
Declaration length of the character type column |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether column statistics were collected for the table |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN | NUMBER | Average length of the column (in bytes) |
CHAR_LENGTH | NUMBER | Displays the length of the column in characters. |
CHAR_USED | VARCHAR(1) | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C) |
V80_FMT_IMAGE | VARCHAR(3) |
Indicates whether the column data is in release older image format (YES) or not (NO) |
DATA_UPGRADED | VARCHAR(3) |
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO) |
HIDDEN_COLUMN | VARCHAR(3) | Indicates whether the column is a hidden column (YES) or not (NO) |
VIRTUAL_COLUMN | VARCHAR(3) |
Indicates whether the column is a virtual column (YES) or not (NO) |
SEGMENT_COLUMN_ID | NUMBER | Sequence number of the column in the segment |
INTERNAL_COLUMN_ID | NUMBER | Internal sequence number of the column |
HISTOGRAM | VARCHAR(32) |
Indicates existence/type of histogram |
QUALIFIED_COL_NAME | VARCHAR(4000) | Qualified column name |
IDENTITY_COLUMN | VARCHAR(3) | Indicates whether this is an identity column (YES) or not (NO) |
ALL_TAB_COLUMNS
ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Column name |
DATA_TYPE | VARCHAR(128) | Datatype of the column |
DATA_TYPE_MOD | VARCHAR(3) |
Datatype modifier of the column |
DATA_TYPE_OWNER | VARCHAR(128) |
Owner of the datatype of the column |
DATA_LENGTH | NUMBER | Length of the column (in bytes) |
DATA_PRECISION | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
NULLABLE | VARCHAR(1) | Indicates whether a column allows NULLs. |
COLUMN_ID | NUMBER | Sequence number of the column as created |
DEFAULT_LENGTH | NUMBER | Length of the default value for the column |
DATA_DEFAULT | LONG VARCHAR | Default value for the column |
NUM_DISTINCT | NUMBER | Number of distinct values in the column |
LOW_VALUE | VARBINARY(32) | Low value in the column |
HIGH_VALUE | VARBINARY(32) | High value in the column |
DENSITY | NUMBER |
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. |
NUM_NULLS | NUMBER | Number of NULLs in the column |
NUM_BUCKETS | NUMBER |
Number of buckets in the histogram for the column |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this column was most recently analyzed |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing this column |
CHARACTER_SET_NAME | VARCHAR(128) |
Name of the character set |
CHAR_COL_DECL_LENGTH | NUMBER | Declaration length of the character type column |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether column statistics were collected for the table |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN | NUMBER | Average length of the column (in bytes) |
CHAR_LENGTH | NUMBER | Displays the length of the column in characters. |
CHAR_USED | VARCHAR(1) | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C) |
V80_FMT_IMAGE | VARCHAR(3) |
Indicates whether the column data is in release older image format (YES) or not (NO) |
DATA_UPGRADED | VARCHAR(3) |
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO) |
HISTOGRAM | VARCHAR(32) |
Indicates existence/type of histogram |
IDENTITY_COLUMN | VARCHAR(3) | Indicates whether this is an identity column (YES) or not (NO) |
ALL_TAB_COMMENTS
ALL_TAB_COMMENTS displays comments on the tables and views accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
TABLE_TYPE | VARCHAR(32) | Type of the object |
COMMENTS | VARCHAR(1024) | Comment on the object |
ALL_TAB_IDENTITY_COLS
ALL_TAB_IDENTITY_COLS describes all table identity columns.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
COLUMN_NAME | VARCHAR(128) | Name of the identity column |
GENERATION_TYPE | VARCHAR(32) | Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT |
IDENTITY_OPTIONS | VARCHAR(1024) | Options for the identity column sequence generator |
ALL_TAB_PLACE
ALL_TAB_PLACE describes node placement of all cluster tables accessible to the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
GROUP_ID | NUMBER | Group identifier of the node where the table placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the table placed |
MEMBER_ID | NUMBER | Member identifier of the node where the table placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the table placed |
MEMBER_POSITION | NUMBER | Member position of the node where the table placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
IS_UPDATE_MASTER | BOOLEAN | whether the cluster member is update master or not |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
SCN | VARCHAR(64) | table scn of the node where the table placed |
NUM_ROWS | NUMBER | Number of rows in the table |
BLOCKS | NUMBER | Number of used blocks of the node where the table placed |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
ALL_TAB_SHARDS
ALL_TAB_SHARDS describes shard information of sharded tables accessible to the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
SHARD_STRATEGY | VARCHAR(32) | Sharding strategy of the table: the value in (HASH SHARDING, RANGE SHARDING, LIST SHARDING) |
SHARD_NAME | VARCHAR(128) | Shard name |
SHARD_NUMBER | NUMBER | Shard number |
SHARD_DEFINITION | LONG VARCHAR | Shard definition (if hash sharded, the value is null) |
GROUP_ID | NUMBER | Group identifier where the shard placed |
GROUP_NAME | VARCHAR(128) | Group Name where the shard placed |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
ALL_TAB_PRIVS
ALL_TAB_PRIVS describes the object grants, for which the current user is the object owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner or grantor.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
ALL_TAB_PRIVS_RECD
ALL_TAB_PRIVS_RECD describes object grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
ALL_TBS_PRIVS
ALL_TBS_PRIVS describes the tablespace grants, for which the current user is the grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace |
PRIVILEGE | VARCHAR(32) | Privilege on the tablespace |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_TBS_PRIVS_MADE
ALL_TBS_PRIVS_MADE describes the tablespace grants for which the current user is the grantor.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace |
PRIVILEGE | VARCHAR(32) | Privilege on the tablespace |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_TBS_PRIVS_RECD
ALL_TBS_PRIVS_RECD describes the tablespace grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace |
PRIVILEGE | VARCHAR(32) | Privilege on the tablespace |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ALL_USERS
ALL_USERS lists all users of the database visible to the current user.
Column name | Data type | Description |
|---|---|---|
USERNAME | VARCHAR(128) | Name of the user |
USER_ID | NUMBER | ID number of the user |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | User creation timestamp |
ALL_VIEWS
ALL_VIEWS describes the views accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the view |
VIEW_SCHEMA | VARCHAR(128) | Schema of the view |
VIEW_NAME | VARCHAR(128) | Name of the view |
TEXT_LENGTH | NUMBER | Length of the view text |
TEXT | LONG VARCHAR | View text |
TYPE_TEXT_LENGTH | NUMBER |
Length of the type clause of the typed view |
TYPE_TEXT | VARCHAR(4000) |
Type clause of the typed view |
OID_TEXT_LENGTH | NUMBER |
Length of the WITH OID clause of the typed view |
OID_TEXT | VARCHAR(4000) |
WITH OID clause of the typed view |
VIEW_TYPE_OWNER | VARCHAR(128) |
Owner of the type of the view if the view is a typed view |
VIEW_TYPE | VARCHAR(32) |
Type of the view if the view is a typed view |
SUPERVIEW_NAME | VARCHAR(128) |
Name of the superview |
EDITIONING_VIEW | VARCHAR(1) |
Reserved for future use |
READ_ONLY | VARCHAR(1) | Indicates whether the view is read-only (Y) or not (N) |
DBA 계열 View
DBA 권한 (ACCESS CONTROL ON DATABASE)을 가지고 있는 현재 사용자의 모든 객체에 대한 정보를 얻을 수 있다.
DBA_ALL_TABLES
DBA_ALL_TABLES describes all object tables and relational tables in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the table |
CLUSTER_NAME | VARCHAR(128) |
Name of the cluster |
IOT_NAME | VARCHAR(128) |
Name of the index-organized table |
STATUS | VARCHAR(32) |
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 |
PCT_USED | NUMBER | Minimum percentage of used space in a block |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes) |
NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes) |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
FREELISTS | NUMBER |
Number of process freelists allocated to the segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to the segment |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the table are logged |
BACKED_UP | VARCHAR(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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
AVG_ROW_LEN | NUMBER |
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS | NUMBER |
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS | NUMBER |
Number of blocks on the freelist |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the table, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the table is to be scanned, or DEFAULT |
CACHE | VARCHAR(1) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
TABLE_LOCK | VARCHAR(32) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing the table |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
PARTITIONED | VARCHAR(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
IOT_TYPE | VARCHAR(32) |
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. |
OBJECT_ID_TYPE | VARCHAR(32) |
Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED |
TABLE_TYPE_OWNER | VARCHAR(128) |
If an object table, owner of the type from which the table is created |
TABLE_TYPE | VARCHAR(128) |
If an object table, type of the table |
TEMPORARY | VARCHAR(1) | Indicates whether the table is temporary (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the table is a secondary object created by cartridge |
NESTED | VARCHAR(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for table blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for table blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for table blocks |
ROW_MOVEMENT | VARCHAR(32) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
SKIP_CORRUPT | VARCHAR(32) |
Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED) |
MONITORING | VARCHAR(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
CLUSTER_OWNER | VARCHAR(128) |
Owner of the cluster, if any |
DEPENDENCIES | VARCHAR(32) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
COMPRESSION | VARCHAR(32) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED) |
COMPRESS_FOR | VARCHAR(32) |
Default compression for what kind of operations |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
READ_ONLY | VARCHAR(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the table segment has been created (YES) or not (NO) |
DBA_ARGUMENTS
DBA_ARGUMENTS lists all arguments of functions, procedures.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of function, procedures or package |
SCHEMA_NAME | VARCHAR(128) | Schema Name of function, procedures or package |
OBJECT_NAME | VARCHAR(128) | Name of function, procedures |
PACKAGE_NAME | VARCHAR(128) | Package Name of function, procedures |
OBJECT_ID | NUMBER | ID of a function, procedures |
SUBPROGRAM_ID | NUMBER | ID of procedures in package |
ARGUMENT_NAME | VARCHAR(128) | Name of argument or attribute name of record type argument |
POSITION | NUMBER | Position of argument or position of attribute in record type |
SEQUENCE | NUMBER | Sequential order of argument and its attributes |
DATA_LEVEL | NUMBER | Nesting depth of the argument for composite types |
DATA_TYPE | VARCHAR(128) | Data Type of the argument |
DEFAULTED | VARCHAR(1) | Whether or not the argument is defaulted |
DEFAULT_VALUE | VARCHAR(1) | Reserved for future use |
DEFAULT_LENGTH | VARCHAR(1) | Reserved for future use |
IN_OUT | VARCHAR(32) | Direction of the argument (IN, OUT, IN/OUT) |
DATA_LENGTH | NUMBER | Length of the column(in bytes) |
DATA_PRECISION | NUMBER | Length in decimal digits(NUMBER) or binary digits(FLOAT) |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
RADIX | NUMBER | Argument radix for a number |
CHARACTER_SET_NAME | VARCHAR(128) | Character set name for the argument |
TYPE_OWNER | VARCHAR(128) | Owner of the type of the argument |
TYPE_NAME | VARCHAR(128) | Name of the type of the argument |
TYPE_SUBNAME | VARCHAR(128) | Name of the type of the argument declared in package |
TYPE_LINK | VARCHAR(128) | Name of the type of the argument declared in a remote package |
PLS_TYPE | VARCHAR(128) | Name of the type of the argument at PSM |
CHAR_LENGTH | NUMBER | Character limit for string datatypes |
CHAR_USED | VARCHAR(1) | Whether the byte limit(B) or char limit(C) is official for the string |
ORIGIN_CON_ID | VARCHAR(256) | ID of the container where the data originates |
DBA_CATALOG
DBA_CATALOG lists all tables, views, synonyms, and sequences in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_SCHEMA | VARCHAR(128) | Schema of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_NAME | VARCHAR(128) | Name of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_TYPE | VARCHAR(32) | Type of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
DBA_CLUSTER
DBA_CLUSTER describes all cluster members in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
GROUP_ID | NUMBER | Group identifier of the cluster member |
GROUP_NAME | VARCHAR(128) | Group name of the cluster member |
MEMBER_ID | NUMBER | Member identifier of the cluster member |
MEMBER_NAME | VARCHAR(128) | Member name of the cluster member |
MEMBER_HOST | VARCHAR(128) | Host address of the cluster member |
MEMBER_PORT | NUMBER | Port number of the cluster member |
MEMBER_POSITION | NUMBER | Member position number of the cluster member |
DBA_CLUSTER_COMMENTS
DBA_CLUSTER_COMMENTS displays comments on the cluster objects in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OBJECT_NAME | VARCHAR(128) | Name of the cluster object |
OBJECT_TYPE | VARCHAR(32) | Type of the cluster object: CLUSTER GROUP, CLUSTER MEMBER |
COMMENTS | VARCHAR(1024) | Comment on the cluster object |
DBA_CLUSTER_TABLES
DBA_CLUSTER_TABLES describes all cluster tables in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
SHARD_STRATEGY | VARCHAR(32) | Sharding strategy of the table: the value in (CLONED, HASH SHARDING, RANGE SHARDING, LIST SHARDING) |
SHARD_PLACEMENT | VARCHAR(32) | Shard placement of the table: the value in (AT CLUSTER WIDE or AT CLUSTER GROUP) |
SHARD_COUNT | NUMBER | Shard count of the table (if cloned table, the value is null) |
SHARD_KEY_COUNT | NUMBER | Shard key column count of the table (if cloned table, the value is null) |
HAS_GSI | VARCHAR(3) | Indicate whether the table has global secondary index: (YES) or (NO) |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
DBA_COL_COMMENTS
DBA_COL_COMMENTS displays comments on the columns of all tables and views in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
COMMENTS | VARCHAR(1024) | Comment on the column |
DBA_COL_PRIVS
DBA_COL_PRIVS describes all column object grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTOR | CHARACTER VARYING(128) | Name of the user who performed the grant |
GRANTEE | CHARACTER VARYING(128) | Name of the user or role to whom access was granted |
OWNER | CHARACTER VARYING(128) | Owner of the object |
TABLE_SCHEMA | CHARACTER VARYING(128) | Schema of the object |
TABLE_NAME | CHARACTER VARYING(128) | Name of the object |
COLUMN_NAME | CHARACTER VARYING(128) | Name of the column |
PRIVILEGE | CHARACTER VARYING(32) | Privilege on the column |
GRANTABLE | CHARACTER VARYING(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_CONSTRAINTS
DBA_CONSTRAINTS describes all constraint definitions on all tables in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the constraint definition |
CONSTRAINT_SCHEMA | VARCHAR(128) | Schema of the constraint definition |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint definition |
CONSTRAINT_TYPE | VARCHAR(1) | Type of the constraint definition: the value in ( C: check constraint, P: Primary key, U: Unique Key, R: Referential intgrity ) |
TABLE_OWNER | VARCHAR(128) | Owner of the table (or view) associated with the constraint definition |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table (or view) associated with the constraint definition |
TABLE_NAME | VARCHAR(128) | Name of the table (or view) associated with the constraint definition |
SEARCH_CONDITION | LONG VARCHAR | Text of search condition for a check constraint |
R_OWNER | VARCHAR(128) | Owner of the unique constraint definition for the referenced table |
R_SCHEMA | VARCHAR(128) | Schema of the unique constraint definition for the referenced table |
R_CONSTRAINT_NAME | VARCHAR(128) | Name of the unique constraint definition for the referenced table |
DELETE_RULE | VARCHAR(32) | Delete rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
UPDATE_RULE | VARCHAR(32) | Update rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
STATUS | VARCHAR(32) | Enforcement status of the constraint: the value in ( ENABLED, DISABLE ) |
DEFERRABLE | VARCHAR(32) | Indicates whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE) |
DEFERRED | VARCHAR(32) | Indicates whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE) |
VALIDATED | VARCHAR(32) | Indicates whether all data may obey the constraint or not: the value in ( VALIDATED, NOT VALIDATED ) |
GENERATED | VARCHAR(32) | Indicates whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME) |
BAD | VARCHAR(32) |
Indicates whether this constraint specifies a century in an ambiguous manner (BAD) or not (NULL) |
RELY | VARCHAR(32) |
When NOT VALIDATED, indicates whether the constraint is to be taken into account for query rewrite (RELY) or not (NULL) |
LAST_CHANGE | TIMESTAMP(2) WITHOUT TIME ZONE | When the constraint was last enabled or disabled |
INDEX_OWNER | VARCHAR(128) | Owner of the index associated with the key constraint |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index associated with the key constraint |
INDEX_NAME | VARCHAR(128) | Name of the index associated with the key constraint |
INVALID | VARCHAR(32) | Indicates whether the constraint is invalid (INVALID) or not (NULL) |
VIEW_RELATED | VARCHAR(32) |
Indicates whether the constraint depends on a view (DEPEND ON VIEW) or not (NULL) |
DROPPED | VARCHAR(3) | Indicates whether the constraint has been dropped and is in the recycle bin (YES) or not (NO) |
COMMENTS | VARCHAR(1024) | Comments of the constraint definition |
DBA_CONS_COLUMNS
DBA_CONS_COLUMNS describes all columns in the database that are specified in constraints.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the constraint definition |
CONSTRAINT_SCHEMA | VARCHAR(128) | Schema of the constraint definition |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint definition |
TABLE_OWNER | VARCHAR(128) | Owner of the table with the constraint definition |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table with the constraint definition |
TABLE_NAME | VARCHAR(128) | Name of the table with the constraint definition |
COLUMN_NAME | VARCHAR(128) | Name of the column or attribute of the object type column specified in the constraint definition |
POSITION | NUMBER | Original position of the column or attribute in the definition of the object |
DBA_DB_PRIVS
DBA_DB_PRIVS describes all database grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PRIVILEGE | VARCHAR(32) | Privilege on the database |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_DEPENDENCIES
DBA_DEPENDENCIES describes all dependencies between objects in the database
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of object |
SCHEMA_NAME | VARCHAR(128) | Schema Name of object |
NAME | VARCHAR(128) | Name of object |
TYPE | VARCHAR(32) | Type of object: FUNCTION, PROCEDURE, VIEW, PACKAGE, PACKAGE BODY, TRIGGER |
REFERENCED_OWNER | VARCHAR(128) | Owner of the referenced object |
REFERENCED_SCHEMA_NAME | VARCHAR(128) | Schema Name of the referenced object |
REFERENCED_TYPE | VARCHAR(32) | Type of the referenced object: FUNCTION, PROCEDURE, TABLE, VIEW, SEQUENCE, PACKAGE, PACKAGE BODY, TRIGGER |
REFERENCED_LINK_NAME | VARCHAR(128) | Name of the link to the parent object |
REFERENCED_NAME | VARCHAR(128) | Name of the referenced object |
DEPENDENCY_TYPE | VARCHAR(32) | Indicates whether the dependency is a REF dependency (REF) or not (HARD) |
DBA_EXTENTS
DBA_EXTENTS describes the extents comprising the segments in all tablespaces in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the segment associated with the extent |
SEGMENT_SCHEMA | VARCHAR(128) | Schema of the segment associated with the extent |
SEGMENT_NAME | VARCHAR(128) | Name of the segment associated with the extent |
PARTITION_NAME | VARCHAR(128) |
Object Partition Name (Set to NULL for non-partitioned objects) |
SEGMENT_TYPE | VARCHAR(32) | Type of the segment: TABLE, INDEX |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the extent |
EXTENT_ID | NUMBER |
Extent number in the segment |
FILE_ID | NUMBER |
File identifier number of the file containing the extent |
BLOCK_ID | NUMBER |
Starting block number of the extent |
BYTES | NUMBER | Size of the extent in bytes |
BLOCKS | NUMBER | Size of the extent in Oracle blocks |
RELATIVE_FNO | NUMBER |
Relative file number of the first extent block |
DBA_GLOBAL_SECONDARY_INDEXES
DBA_GLOBAL_SECONDARY_INDEXES describes all global secondary indexes in the database.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_OWNER | VARCHAR(128) | Owner of the global secondary indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the global secondary indexed object |
TABLE_NAME | VARCHAR(128) | Name of the global secondary indexed object |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the global secondary index |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent |
NEXT_EXTENT | NUMBER | Size of secondary extents |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_FREE | NUMBER | Minimum percentage of free space in a block |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the global secondary index are logged: (YES) or (NO) |
BLOCKS | NUMBER | Number of used blocks in the global secondary index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the global secondary index |
DROPPED | VARCHAR(3) | Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO) |
DBA_GSI_PLACE
DBA_GSI_PLACE describes node placement of all global secondary indexes in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_OWNER | VARCHAR(128) | Owner of the global secondary indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the global secondary indexed object |
TABLE_NAME | VARCHAR(128) | Name of the global secondary indexed object |
GROUP_ID | NUMBER | Group identifier of the node where the global secondary index placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the global secondary index placed |
MEMBER_ID | NUMBER | Member identifier of the node where the global secondary index placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the global secondary index placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
DROPPED | VARCHAR(3) | Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO) |
BLOCKS | NUMBER | Number of used blocks of the node where the global secondary index placed |
DBA_INDEXES
DBA_INDEXES describes all indexes in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the index |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
INDEX_TYPE | VARCHAR(32) | Type of the index: the value in ( NORMAL, NORMAL/REV, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED NORMAL/REV, FUNCTION-BASED BITMAP, IOT - TOP, DOMAIN ) |
TABLE_OWNER | VARCHAR(128) | Owner of the indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the indexed object |
TABLE_NAME | VARCHAR(128) | Name of the indexed object |
TABLE_TYPE | VARCHAR(32) | Type of the indexed object: the value in ( NEXT OBJECT, INDEX, TABLE, VIEW, SYNONYM, SEQUENCE ) |
UNIQUENESS | VARCHAR(32) | Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE) |
COMPRESSION | VARCHAR(32) |
Indicates whether index compression is enabled (ENABLED) or not (DISABLED) |
PREFIX_LENGTH | NUMBER |
Number of columns in the prefix of the compression key |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the index |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent |
NEXT_EXTENT | NUMBER | Size of secondary extents |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
PCT_THRESHOLD | NUMBER |
Threshold percentage of block space allowed per index entry |
INCLUDE_COLUMN | NUMBER |
Column ID of the last column to be included in index-organized table primary key (non-overflow) index |
FREELISTS | NUMBER |
Number of process freelists allocated to this segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to this segment |
PCT_FREE | NUMBER | Minimum percentage of free space in a block |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the index are logged: (YES) or (NO) |
BLOCKS | NUMBER | Number of used blocks in the index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the index |
BLEVEL | NUMBER |
B-Tree level (depth of the index from its root block to its leaf blocks) |
LEAF_BLOCKS | NUMBER |
Number of leaf blocks in the index |
DISTINCT_KEYS | NUMBER | Number of distinct indexed values. |
AVG_LEAF_BLOCKS_PER_KEY | NUMBER |
Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer |
AVG_DATA_BLOCKS_PER_KEY | NUMBER |
Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer |
CLUSTERING_FACTOR | NUMBER |
Indicates the amount of order of the rows in the table based on the values of the index |
STATUS | VARCHAR(32) |
Indicates whether a nonpartitioned index is VALID or UNUSABLE |
NUM_ROWS | NUMBER |
Number of rows in the index |
SAMPLE_SIZE | NUMBER | Size of the sample used to analyze the index |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this index was most recently analyzed |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the index, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the indexes to be scanned, or DEFAULT |
PARTITIONED | VARCHAR(3) |
Indicates whether the index is partitioned (YES) or not (NO) |
TEMPORARY | VARCHAR(1) | Indicates whether the index is on a temporary table (Y) or not (N) |
GENERATED | VARCHAR(1) | Indicates whether the name of the index is system-generated (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the index is a secondary object created by the method of the Data Cartridge (Y) or not (N) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for index blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for index blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for index blocks |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
PCT_DIRECT_ACCESS | NUMBER |
For a secondary index on an index-organized table, the percentage of rows with VALID guess |
ITYP_OWNER | VARCHAR(128) |
For a domain index, the owner of the indextype |
ITYP_NAME | VARCHAR(128) |
For a domain index, the name of the indextype |
PARAMETERS | VARCHAR(1024) |
For a domain index, the parameter string |
GLOBAL_STATS | VARCHAR(3) |
For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO) |
DOMIDX_STATUS | VARCHAR(32) |
Status of a domain index |
DOMIDX_OPSTATUS | VARCHAR(32) |
Status of the operation on a domain index |
FUNCIDX_STATUS | VARCHAR(32) |
Status of a function-based index |
JOIN_INDEX | VARCHAR(3) |
Indicates whether the index is a join index (YES) or not (NO) |
IOT_REDUNDANT_PKEY_ELIM | VARCHAR(3) |
Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO) |
DROPPED | VARCHAR(3) | Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO) |
VISIBILITY | VARCHAR(3) |
Indicates whether the index is VISIBLE or INVISIBLE to the optimizer |
DOMIDX_MANAGEMENT | VARCHAR(32) |
If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the index segment has been created (YES) or not (NO) |
COMMENTS | VARCHAR(1024) | Comments of the index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the index |
DBA_IND_COLUMNS
DBA_IND_COLUMNS describes the columns of all the indexes on all tables and clusters in the database.
Column name | Data type | Description |
|---|---|---|
INDEX_OWNER | VARCHAR(128) | Owner of the index |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
TABLE_OWNER | VARCHAR(128) | Owner of the table or cluster |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table or cluster |
TABLE_NAME | VARCHAR(128) | Name of the table or cluster |
COLUMN_NAME | VARCHAR(128) | Column name or attribute of the object type column |
COLUMN_POSITION | NUMBER | Position of the column or attribute within the index |
COLUMN_LENGTH | NUMBER | Indexed length of the column |
CHAR_LENGTH | NUMBER |
Maximum codepoint length of the column |
DESCEND | VARCHAR(32) | Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC) |
NULL_ORDER | VARCHAR(32) | Indicates whether the null value of the column is sorted in nulls first order (NULLS FIRST) or nulls last order (NULLS LAST) |
DBA_IND_PLACE
DBA_IND_PLACE describes node placement of all indexes in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the index |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
TABLE_OWNER | VARCHAR(128) | Owner of the indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the indexed object |
TABLE_NAME | VARCHAR(128) | Name of the indexed object |
GROUP_ID | NUMBER | Group identifier of the node where the index placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the index placed |
MEMBER_ID | NUMBER | Member identifier of the node where the index placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the index placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
DROPPED | VARCHAR(3) | Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO) |
DISTINCT_KEYS | NUMBER | (deprecated) |
SAMPLE_SIZE | NUMBER | (deprecated) |
BLOCKS | NUMBER | Number of used blocks of the node where the index placed |
LAST_ANALYZED | TIMESTAMP(2) WITHOUT TIME ZONE | (deprecated) |
DBA_NONSCHEMA_COMMENTS
DBA_NONSCHEMA_COMMENTS displays comments on all non-schema objects (database, authorizations, schemas, tablespaces).
Column name | Data type | Description |
|---|---|---|
OBJECT_NAME | VARCHAR(128) | Name of the non-schema object |
OBJECT_TYPE | VARCHAR(32) | Type of the non-schema object: DATABASE, PROFILE, AUTHORIZATION, SCHEMA, TABLESPACE |
COMMENTS | VARCHAR(1024) | Comments of the non-schema object |
DBA_OBJECTS
DBA_OBJECTS describes all objects in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
SCHEMA_NAME | VARCHAR(128) | Schema of the object |
OBJECT_NAME | VARCHAR(128) | Name of the object |
SUBOBJECT_NAME | VARCHAR(128) | Name of the subobject (for example, partition) |
OBJECT_ID | NUMBER | Dictionary object number of the object |
DATA_OBJECT_ID | NUMBER | Dictionary object number of the segment that contains the object |
OBJECT_TYPE | VARCHAR(32) | Type of the object (such as TABLE, INDEX) |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp for the creation of the object |
LAST_DDL_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp for the last modification of the object resulting from a DDL statement |
TIMESTAMP | VARCHAR(32) | Timestamp for the specification of the object (character data) |
STATUS | VARCHAR(32) | Status of the object: the value in ( VALID, INVALID, N/A ) |
TEMPORARY | VARCHAR(1) | Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N) |
GENERATED | VARCHAR(1) | Indicates whether the name of this object was system-generated (Y) or not (N) |
SECONDARY | VARCHAR(1) | Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N) |
NAMESPACE | NUMBER | Namespace for the object |
EDITION_NAME | VARCHAR(128) |
Name of the edition in which the object is actual |
DROPPED | VARCHAR(3) | Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO) |
DBA_PACKAGE_PRIVS
DBA_PACKAGE_PRIVS describes all packages grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure, function or package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure, function or package |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure, function or package |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure, function or package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_PROCEDURES
DBA_PROCEDURES lists all function, procedures or package
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of function, procedures or package |
SCHEMA_NAME | VARCHAR(128) | Schema Name of function, procedures or package |
OBJECT_NAME | VARCHAR(128) | Name of function, procedures or package |
PROCEDURE_NAME | VARCHAR(128) | Name when a procedures in package |
OBJECT_ID | NUMBER | ID of a function, procedures or package |
SUBPROGRAM_ID | NUMBER | ID of procedures in package |
OVERLOAD | VARCHAR(32) | ID of overloading procedure in package |
OBJECT_TYPE | VARCHAR(32) | Type of function, procedures or package |
AGGREGATE | VARCHAR(3) | Indicate whether the procedure is an aggreage function(YES) or not(NO) |
PIPELINED | VARCHAR(3) | Indicate whether the procedure is a pipelined table function(YES) or not(NO) |
IMPLTYPEOWNER | VARCHAR(128) | Name of the owner of the implementation type, if any |
IMPLTYPENAME | VARCHAR(128) | Name of the implementation type, if any |
PARALLEL | VARCHAR(3) | Indicates whether the procedure or function is parallel-enabled (YES) or not (NO) |
INTERFACE | VARCHAR(3) | YES, if the procedure/function is a table function implemented using the SQLCLI interface; otherwise NO |
DETERMINISTIC | VARCHAR(3) | YES, if the procedure/function is declared to be deterministic; otherwise NO |
AUTHID | VARCHAR(32) | Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker) |
DBA_PROC_PRIVS
DBA_PROC_PRIVS describes the procedure grants, for which the current user is the procedure owner, grantor, or grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure, function or package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure, function or package |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure, function or package |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure, function or package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_PROFILES
DBA_PROFILES displays all profiles and their limits.
Column name | Data type | Description |
|---|---|---|
PROFILE_NAME | VARCHAR(128) | Profile name |
RESOURCE_NAME | VARCHAR(128) | Resource name |
RESOURCE_TYPE | VARCHAR(32) | Indicates whether the resource profile is a KERNEL or a PASSWORD parameter |
LIMIT_VALUE | LONG VARCHAR | Limit placed on this resource for this profile |
COMMON | VARCHAR(3) | Indicates whether a given profile is common. (YES or NO) |
DBA_RECYCLEBIN
DBA_RECYCLEBIN describes all recycle bins in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
SCHEMA_NAME | VARCHAR(128) | Schema name of the object |
OBJECT_NAME | VARCHAR(128) | Name of the object |
ORIGINAL_NAME | VARCHAR(128) | Original name of the object |
OPERATION | VARCHAR(4) | Operation carried out on the object |
OBJECT_TYPE | VARCHAR(32) | Type of the object |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the object |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Created time of the object |
DROPPED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Dropped time of the object |
DROP_SCN | VARCHAR(128) | System change number (SCN) of the transaction which moved the object to the recycle bin |
DROP_GCN | NUMBER | Global change number (GCN) of the transaction which moved the object to the recycle bin |
DROP_DCN | NUMBER | Domain change number (DCN) of the transaction which moved the object to the recycle bin |
DROP_LCN | NUMBER | Local change number (LCN) of the transaction which moved the object to the recycle bin |
CAN_UNDROP | VARCHAR(3) | Indicates whether the object can be undropped (YES) or not (NO) |
CAN_PURGE | VARCHAR(3) | Indicates whether the object can be purged (YES) or not (NO) |
BASE_OBJECT | NUMBER | Object number of the base object |
PURGE_OBJECT | NUMBER | Object number for the object which gets purged |
DBA_SCHEMAS
Identify the schemata in the database.
Column name | Data type | Description |
|---|---|---|
SCHEMA_OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Created time of the schema |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Last modified time of the schema |
COMMENTS | VARCHAR(1024) | Comments of the schema |
DBA_SCHEMA_PATH
DBA_SCHEMA_PATH describes the schema search order of all authorizations in the database.
Column name | Data type | Description |
|---|---|---|
AUTH_NAME | VARCHAR(128) | Name of the authorization |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
SEARCH_ORDER | NUMBER | Schema search order of the authorization |
DBA_SCHEMA_PRIVS
DBA_SCHEMA_PRIVS describes all schema grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_SEQUENCES
DBA_SEQUENCES describes all sequences in the database.
Column name | Data type | Description |
|---|---|---|
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Sequence name |
MIN_VALUE | NUMBER | Minimum value of the sequence |
MAX_VALUE | NUMBER | Maximum value of the sequence |
INCREMENT_BY | NUMBER | Value by which sequence is incremented |
CYCLE_FLAG | VARCHAR(1) | Indicates whether the sequence wraps around on reaching the limit (Y) or not (N) |
ORDER_FLAG | VARCHAR(1) |
Indicates whether sequence numbers are generated in order (Y) or not (N) |
CACHE_SIZE | NUMBER | Number of sequence numbers to cache |
LAST_NUMBER | NUMBER | Last sequence number written to database. If a sequence uses caching, the number written to database is the last number placed in the sequence cache. |
COMMENTS | VARCHAR(1024) | Comments of the sequence |
DBA_SEQ_PRIVS
DBA_SEQ_PRIVS describes all sequence grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_SHARD_KEY_COLUMNS
DBA_SHARD_KEY_COLUMNS describes shard key columns of all shareded tables in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
COLUMN_NAME | VARCHAR(128) | Column name of the shard key |
COLUMN_POSITION | NUMBER | Position of the column within the shard key |
DBA_SOURCE
DBA_SOURCE describes the text source of the stored objects accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of object |
SCHEMA_NAME | VARCHAR(128) | Schema Name of object |
NAME | VARCHAR(128) | Name of object |
TYPE | VARCHAR(32) | Type of object: FUNCTION, PROCEDURE, PACKAGE, PACKAGE BODY, TRIGGER |
LINE | NUMBER | Line number of this line of source |
TEXT | LONG VARCHAR | Text source of the strored object |
ORIGIN_CON_ID | VARCHAR(256) | ID of the container where the data originates |
DBA_STAT_SYSTEM
DBA_STAT_SYSTEM describes analyzed system statistics.
Column name | Data type | Description |
|---|---|---|
CPU_OPS | NATIVE_BIGINT | OPS(operations per second) of CPU |
NETWORK_IOPS | NATIVE_BIGINT | IOPS(I/O operations per second) of Cluster NETWORK |
NETWORK_BUFSIZE | NATIVE_BIGINT | buffer size of Cluster NETWORK when analyzed |
LAST_ANALYZED | TIMESTAMP(2) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
DBA_SYS_PRIVS
DBA_SYS_PRIVS describes all system (database, tablespace, schema) privileges in the database.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the grantee |
PRIVILEGE | VARCHAR(256) | System(database, tablespace, schema) privilege |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ADMIN_OPTION | VARCHAR(3) | equal to GRANTABLE column |
DBA_SYNONYMS
DBA_SYNONYMS describes all synonyms in the database.
Column name | Data type | Description |
|---|---|---|
SYNONYM_OWNER | VARCHAR(128) | Owner of the synonym |
SYNONYM_SCHEMA | VARCHAR(128) | Schema of the synonym |
SYNONYM_NAME | VARCHAR(128) | Synonym name |
OBJECT_SCHEMA_NAME | VARCHAR(128) | Object schema name |
OBJECT_NAME | VARCHAR(128) | Object name |
DB_LINK | VARCHAR(128) | Reserved for future use |
DBA_TABLES
DBA_TABLES describes all relational tables in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the table |
CLUSTER_NAME | VARCHAR(128) |
Name of the cluster |
IOT_NAME | VARCHAR(128) |
Name of the index-organized table |
STATUS | VARCHAR(32) |
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 |
PCT_USED | NUMBER | Minimum percentage of used space in a block |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes) |
NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes) |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
FREELISTS | NUMBER |
Number of process freelists allocated to the segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to the segment |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the table are logged |
BACKED_UP | VARCHAR(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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
AVG_ROW_LEN | NUMBER |
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS | NUMBER |
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS | NUMBER |
Number of blocks on the freelist |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the table, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the table is to be scanned, or DEFAULT |
CACHE | VARCHAR(1) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
TABLE_LOCK | VARCHAR(32) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing the table |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
PARTITIONED | VARCHAR(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
IOT_TYPE | VARCHAR(32) |
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. |
TEMPORARY | VARCHAR(1) | Indicates whether the table is temporary (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the table is a secondary object created by cartridge |
NESTED | VARCHAR(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for table blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for table blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for table blocks |
ROW_MOVEMENT | VARCHAR(32) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
SKIP_CORRUPT | VARCHAR(32) |
Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED) |
MONITORING | VARCHAR(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
CLUSTER_OWNER | VARCHAR(128) |
Owner of the cluster, if any |
DEPENDENCIES | VARCHAR(32) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
COMPRESSION | VARCHAR(32) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED) |
COMPRESS_FOR | VARCHAR(32) |
Default compression for what kind of operations |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
READ_ONLY | VARCHAR(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the table segment has been created (YES) or not (NO) |
RESULT_CACHE | VARCHAR(32) |
Result cache mode annotation for the table: the value in ( NULL, DEFAULT, FORCE, MANUAL ) |
DBA_TABLESPACES
DBA_TABLESPACES describes all tablespaces in the database.
Column name | Data type | Description |
|---|---|---|
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace |
BLOCK_SIZE | NUMBER | Tablespace block size |
INITIAL_EXTENT | NUMBER |
Default initial extent size (in bytes) |
NEXT_EXTENT | NUMBER |
Default incremental extent size (in bytes) |
MIN_EXTENTS | NUMBER |
Default minimum number of extents |
MAX_EXTENTS | NUMBER |
Default maximum number of extents |
MAX_SIZE | NUMBER |
Default maximum size of segments |
PCT_INCREASE | NUMBER |
Default percent increase for extent size |
MIN_EXTLEN | NUMBER |
Minimum extent size for this tablespace (in bytes) |
STATUS | VARCHAR(32) | Tablespace status: the value in ( ONLINE, OFFLINE, READ ONLY ) |
CONTENTS | VARCHAR(32) | Tablespace contents: the value in ( SYSTEM, DATA, TEMPORARY, UNDO ) |
LOGGING | VARCHAR(32) | Default logging attribute: LOGGING, NOLOGGING |
FORCE_LOGGING | VARCHAR(3) |
Indicates whether the tablespace is under force logging mode (YES) or not (NO) |
EXTENT_MANAGEMENT | VARCHAR(32) |
Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL) |
ALLOCATION_TYPE | VARCHAR(32) |
Type of extent allocation in effect for the tablespace: the value in ( SYSTEM, UNIFORM, USER ) |
PLUGGED_IN | VARCHAR(3) |
Indicates whether the tablespace is plugged in (YES) or not (NO) |
SEGMENT_SPACE_MANAGEMENT | VARCHAR(32) |
Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO) |
DEF_TAB_COMPRESSION | VARCHAR(32) |
Indicates whether default table compression is enabled (ENABLED) or not (DISABLED) |
RETENTION | VARCHAR(32) |
Undo tablespace retention: the value in ( GUARANTEE, NOGUARANTEE, NOT APPLY ) |
BIGFILE | VARCHAR(3) |
Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO) |
PREDICATE_EVALUATION | VARCHAR(32) |
Indicates whether predicates are evaluated by host (HOST) or by storage (STORAGE) |
ENCRYPTED | VARCHAR(3) |
Indicates whether the tablespace is encrypted (YES) or not (NO) |
COMPRESS_FOR | VARCHAR(32) |
Indicates whether the tablespace is encrypted (YES) or not (NO) |
DBA_TAB_COLS
DBA_TAB_COLS describes the columns (including hidden columns) of all tables, views, and clusters in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Column name |
DATA_TYPE | VARCHAR(128) | Datatype of the column |
DATA_TYPE_MOD | VARCHAR(3) |
Datatype modifier of the column |
DATA_TYPE_OWNER | VARCHAR(128) |
Owner of the datatype of the column |
DATA_LENGTH | NUMBER | Length of the column (in bytes) |
DATA_PRECISION | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
NULLABLE | VARCHAR(1) | Indicates whether a column allows NULLs. |
COLUMN_ID | NUMBER | Sequence number of the column as created |
DEFAULT_LENGTH | NUMBER | Length of the default value for the column |
DATA_DEFAULT | LONG VARCHAR | Default value for the column |
NUM_DISTINCT | NUMBER | Number of distinct values in the column |
LOW_VALUE | VARBINARY(32) | Low value in the column |
HIGH_VALUE | VARBINARY(32) | High value in the column |
DENSITY | NUMBER |
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. |
NUM_NULLS | NUMBER | Number of NULLs in the column |
NUM_BUCKETS | NUMBER |
Number of buckets in the histogram for the column |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this column was most recently analyzed |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing this column |
CHARACTER_SET_NAME | VARCHAR(128) |
Name of the character set |
CHAR_COL_DECL_LENGTH | NUMBER | Declaration length of the character type column |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether column statistics were collected for the table |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN | NUMBER | Average length of the column (in bytes) |
CHAR_LENGTH | NUMBER | Displays the length of the column in characters. |
CHAR_USED | VARCHAR(1) | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C) |
V80_FMT_IMAGE | VARCHAR(3) |
Indicates whether the column data is in release older image format (YES) or not (NO) |
DATA_UPGRADED | VARCHAR(3) |
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO) |
HIDDEN_COLUMN | VARCHAR(3) | Indicates whether the column is a hidden column (YES) or not (NO) |
VIRTUAL_COLUMN | VARCHAR(3) |
Indicates whether the column is a virtual column (YES) or not (NO) |
SEGMENT_COLUMN_ID | NUMBER | Sequence number of the column in the segment |
INTERNAL_COLUMN_ID | NUMBER | Internal sequence number of the column |
HISTOGRAM | VARCHAR(32) |
Indicates existence/type of histogram |
QUALIFIED_COL_NAME | VARCHAR(4000) | Qualified column name |
IDENTITY_COLUMN | VARCHAR(3) | Indicates whether this is an identity column (YES) or not (NO) |
DBA_TAB_COLUMNS
DBA_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Column name |
DATA_TYPE | VARCHAR(128) | Datatype of the column |
DATA_TYPE_MOD | VARCHAR(3) |
Datatype modifier of the column |
DATA_TYPE_OWNER | VARCHAR(128) |
Owner of the datatype of the column |
DATA_LENGTH | NUMBER | Length of the column (in bytes) |
DATA_PRECISION | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
NULLABLE | VARCHAR(1) | Indicates whether a column allows NULLs. |
COLUMN_ID | NUMBER | Sequence number of the column as created |
DEFAULT_LENGTH | NUMBER | Length of the default value for the column |
DATA_DEFAULT | LONG VARCHAR | Default value for the column |
NUM_DISTINCT | NUMBER | Number of distinct values in the column |
LOW_VALUE | VARBINARY(32) | Low value in the column |
HIGH_VALUE | VARBINARY(32) | High value in the column |
DENSITY | NUMBER |
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. |
NUM_NULLS | NUMBER | Number of NULLs in the column |
NUM_BUCKETS | NUMBER |
Number of buckets in the histogram for the column |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this column was most recently analyzed |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing this column |
CHARACTER_SET_NAME | VARCHAR(128) |
Name of the character set |
CHAR_COL_DECL_LENGTH | NUMBER | Declaration length of the character type column |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether column statistics were collected for the table |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN | NUMBER | Average length of the column (in bytes) |
CHAR_LENGTH | NUMBER | Displays the length of the column in characters. |
CHAR_USED | VARCHAR(1) | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C) |
V80_FMT_IMAGE | VARCHAR(3) |
Indicates whether the column data is in release older image format (YES) or not (NO) |
DATA_UPGRADED | VARCHAR(3) |
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO) |
HISTOGRAM | VARCHAR(32) |
Indicates existence/type of histogram |
IDENTITY_COLUMN | VARCHAR(3) | Indicates whether this is an identity column (YES) or not (NO) |
DBA_TAB_COMMENTS
DBA_TAB_COMMENTS displays comments on all tables and views in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
TABLE_TYPE | VARCHAR(32) | Type of the object |
COMMENTS | VARCHAR(1024) | Comment on the object |
DBA_TAB_IDENTITY_COLS
DBA_TAB_IDENTITY_COLS describes all table identity columns.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
COLUMN_NAME | VARCHAR(128) | Name of the identity column |
GENERATION_TYPE | VARCHAR(32) | Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT |
IDENTITY_OPTIONS | VARCHAR(1024) | Options for the identity column sequence generator |
DBA_TAB_PLACE
DBA_TAB_PLACE describes node placement of all cluster tables in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
GROUP_ID | NUMBER | Group identifier of the node where the table placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the table placed |
MEMBER_ID | NUMBER | Member identifier of the node where the table placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the table placed |
MEMBER_POSITION | NUMBER | Member position of the node where the table placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
IS_UPDATE_MASTER | BOOLEAN | whether the cluster member is update master or not |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
SCN | VARCHAR(64) | table scn of the node where the table placed |
NUM_ROWS | NUMBER | Number of rows in the table |
BLOCKS | NUMBER | Number of used blocks of the node where the table placed |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
DBA_TAB_PRIVS
DBA_TAB_PRIVS describes all object grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
DBA_TAB_SHARDS
DBA_TAB_SHARDS describes shard information of all sharded tables in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the table |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
SHARD_STRATEGY | VARCHAR(32) | Sharding strategy of the table: the value in (HASH SHARDING, RANGE SHARDING, LIST SHARDING) |
SHARD_NAME | VARCHAR(128) | Shard name |
SHARD_NUMBER | NUMBER | Shard number |
SHARD_DEFINITION | LONG VARCHAR | Shard definition (if hash sharded, the value is null) |
GROUP_ID | NUMBER | Group identifier where the shard placed |
GROUP_NAME | VARCHAR(128) | Group Name where the shard placed |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
DBA_TBS_PRIVS
DBA_TBS_PRIVS describes all tablespace grants in the database.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace |
PRIVILEGE | VARCHAR(32) | Privilege on the tablespace |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
DBA_USERS
DBA_USERS describes all users of the database.
Column name | Data type | Description |
|---|---|---|
USERNAME | VARCHAR(128) | Name of the user |
USER_ID | NUMBER | ID number of the user |
PASSWORD | VARCHAR(128) | encrypted password |
ACCOUNT_STATUS | VARCHAR(32) | Account status: the value in ( OPEN, EXPIRED, EXPIRED(GRACE), LOCKED(TIMED), LOCKED, EXPIRED & LOCKED(TIMED), EXPIRED(GRACE) & LOCKED(TIMED), EXPIRED & LOCKED, EXPIRED(GRACE) & LOCKED ) |
LOCK_DATE | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp the account was locked if account status was LOCKED |
EXPIRY_DATE | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp of expiration of the account |
FAILED_LOGIN_ATTEMPTS | NUMBER | Consecutive failed login attempts count |
DEFAULT_TABLESPACE | VARCHAR(128) | Default tablespace for data |
TEMPORARY_TABLESPACE | VARCHAR(128) | Name of the default tablespace for temporary tables or the name of a tablespace group |
INDEX_TABLESPACE | VARCHAR(128) | Default tablespace for index |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | User creation timestamp |
PROFIL_NAME | VARCHAR(128) | User resource profile name |
INITIAL_RSRC_CONSUMER_GROUP | VARCHAR(128) |
Initial resource consumer group for the user |
EXTERNAL_NAME | VARCHAR(128) |
User external name |
PASSWORD_VERSIONS | VARCHAR(32) |
Shows the list of versions of the password hashes (verifiers). |
EDITIONS_ENABLED | VARCHAR(1) | Indicates whether editions have been enabled for the corresponding user (Y) or not (N). |
AUTHENTICATION_TYPE | VARCHAR(32) |
Indicates the authentication mechanism for the user. |
DBA_VIEWS
DBA_VIEWS describes all views in the database.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the view |
VIEW_SCHEMA | VARCHAR(128) | Schema of the view |
VIEW_NAME | VARCHAR(128) | Name of the view |
TEXT_LENGTH | NUMBER | Length of the view text |
TEXT | LONG VARCHAR | View text |
TYPE_TEXT_LENGTH | NUMBER |
Length of the type clause of the typed view |
TYPE_TEXT | VARCHAR(4000) |
Type clause of the typed view |
OID_TEXT_LENGTH | NUMBER |
Length of the WITH OID clause of the typed view |
OID_TEXT | VARCHAR(4000) |
WITH OID clause of the typed view |
VIEW_TYPE_OWNER | VARCHAR(128) |
Owner of the type of the view if the view is a typed view |
VIEW_TYPE | VARCHAR(32) |
Type of the view if the view is a typed view |
SUPERVIEW_NAME | VARCHAR(128) |
Name of the superview |
EDITIONING_VIEW | VARCHAR(1) | Reserved for future use |
READ_ONLY | VARCHAR(1) | Indicates whether the view is read-only (Y) or not (N) |
USER 계열 View
현재 사용자가 소유한 객체에 대한 정보를 얻을 수 있다.
USER_ALL_TABLES
USER_ALL_TABLES describes the object tables and relational tables owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the table |
CLUSTER_NAME | VARCHAR(128) |
Name of the cluster |
IOT_NAME | VARCHAR(128) |
Name of the index-organized table |
STATUS | VARCHAR(32) |
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 |
PCT_USED | NUMBER | Minimum percentage of used space in a block |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes) |
NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes) |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
FREELISTS | NUMBER |
Number of process freelists allocated to the segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to the segment |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the table are logged |
BACKED_UP | VARCHAR(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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
AVG_ROW_LEN | NUMBER |
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS | NUMBER |
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS | NUMBER |
Number of blocks on the freelist |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the table, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the table is to be scanned, or DEFAULT |
CACHE | VARCHAR(1) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
TABLE_LOCK | VARCHAR(32) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing the table |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
PARTITIONED | VARCHAR(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
IOT_TYPE | VARCHAR(32) |
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. |
OBJECT_ID_TYPE | VARCHAR(32) |
Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED |
TABLE_TYPE_OWNER | VARCHAR(128) |
If an object table, owner of the type from which the table is created |
TABLE_TYPE | VARCHAR(128) |
If an object table, type of the table |
TEMPORARY | VARCHAR(1) | Indicates whether the table is temporary (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the table is a secondary object created by cartridge |
NESTED | VARCHAR(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for table blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for table blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for table blocks |
ROW_MOVEMENT | VARCHAR(32) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
SKIP_CORRUPT | VARCHAR(32) |
Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED) |
MONITORING | VARCHAR(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
CLUSTER_OWNER | VARCHAR(128) |
Owner of the cluster, if any |
DEPENDENCIES | VARCHAR(32) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
COMPRESSION | VARCHAR(32) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED) |
COMPRESS_FOR | VARCHAR(32) |
Default compression for what kind of operations |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
READ_ONLY | VARCHAR(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the table segment has been created (YES) or not (NO) |
USER_ARGUMENTS
USER_ARGUMENTS lists all arguments of functions, procedures.
Column name | Data type | Description |
|---|---|---|
SCHEMA_NAME | VARCHAR(128) | Schema Name of function, procedures or package |
OBJECT_NAME | VARCHAR(128) | Name of function, procedures |
PACKAGE_NAME | VARCHAR(128) | Package Name of function, procedures |
OBJECT_ID | NUMBER | ID of a function, procedures |
SUBPROGRAM_ID | NUMBER | ID of procedures in package |
ARGUMENT_NAME | VARCHAR(128) | Name of argument or attribute name of record type argument |
POSITION | NUMBER | Position of argument or position of attribute in record type |
SEQUENCE | NUMBER | Sequential order of argument and its attributes |
DATA_LEVEL | NUMBER | Nesting depth of the argument for composite types |
DATA_TYPE | VARCHAR(128) | Data Type of the argument |
DEFAULTED | VARCHAR(1) | Whether or not the argument is defaulted |
DEFAULT_VALUE | VARCHAR(1) | Reserved for future use |
DEFAULT_LENGTH | VARCHAR(1) | Reserved for future use |
IN_OUT | VARCHAR(32) | Direction of the argument (IN, OUT, IN/OUT) |
DATA_LENGTH | NUMBER | Length of the column(in bytes) |
DATA_PRECISION | NUMBER | Length in decimal digits(NUMBER) or binary digits(FLOAT) |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
RADIX | NUMBER | Argument radix for a number |
CHARACTER_SET_NAME | VARCHAR(128) | Character set name for the argument |
TYPE_OWNER | VARCHAR(128) | Owner of the type of the argument |
TYPE_NAME | VARCHAR(128) | Name of the type of the argument |
TYPE_SUBNAME | VARCHAR(128) | Name of the type of the argument declared in package |
TYPE_LINK | VARCHAR(128) | Name of the type of the argument declared in a remote package |
PLS_TYPE | VARCHAR(128) | Name of the type of the argument at PSM |
CHAR_LENGTH | NUMBER | Character limit for string datatypes |
CHAR_USED | VARCHAR(1) | Whether the byte limit(B) or char limit(C) is official for the string |
ORIGIN_CON_ID | VARCHAR(256) | ID of the container where the data originates |
USER_CATALOG
USER_CATALOG lists tables, views, synonyms, and sequences owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_NAME | VARCHAR(128) | Name of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
TABLE_TYPE | VARCHAR(32) | Type of the TABLE, VIEW, SYNONYM, SEQUENCE, or UNDEFINED |
USER_COL_COMMENTS
USER_COL_COMMENTS displays comments on the columns of the tables and views owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
COMMENTS | VARCHAR(1024) | Comment on the column |
USER_CLUSTER_TABLES
USER_CLUSTER_TABLES describes all cluster tables owned by the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
SHARD_STRATEGY | VARCHAR(32) | Sharding strategy of the table: the value in (CLONED, HASH SHARDING, RANGE SHARDING, LIST SHARDING) |
SHARD_PLACEMENT | VARCHAR(32) | Shard placement of the table: the value in (AT CLUSTER WIDE or AT CLUSTER GROUP) |
SHARD_COUNT | NUMBER | Shard count of the table (if cloned table, the value is null) |
SHARD_KEY_COUNT | NUMBER | Shard key column count of the table (if cloned table, the value is null) |
HAS_GSI | VARCHAR(3) | Indicate whether the table has global secondary index: (YES) or (NO) |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
USER_COL_PRIVS
USER_COL_PRIVS describes the column object grants for which the current user is the object owner, grantor, or grantee.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the column |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_COL_PRIVS_MADE
USER_COL_PRIVS_MADE describes the column object grants for which the current user is the object owner.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the column |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_COL_PRIVS_RECD
USER_COL_PRIVS_RECD describes the column object grants for which the current user is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Name of the column |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the column |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_CONSTRAINTS
USER_CONSTRAINTS describes all constraint definitions on tables owned by the current user.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the constraint definition |
CONSTRAINT_SCHEMA | VARCHAR(128) | Schema of the constraint definition |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint definition |
CONSTRAINT_TYPE | VARCHAR(1) | Type of the constraint definition: the value in ( C: check constraint, P: Primary key, U: Unique Key, R: Referential intgrity ) |
TABLE_OWNER | VARCHAR(128) | Owner of the table (or view) associated with the constraint definition |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table (or view) associated with the constraint definition |
TABLE_NAME | VARCHAR(128) | Name of the table (or view) associated with the constraint definition |
SEARCH_CONDITION | LONG VARCHAR | Text of search condition for a check constraint |
R_OWNER | VARCHAR(128) | Owner of the unique constraint definition for the referenced table |
R_SCHEMA | VARCHAR(128) | Schema of the unique constraint definition for the referenced table |
R_CONSTRAINT_NAME | VARCHAR(128) | Name of the unique constraint definition for the referenced table |
DELETE_RULE | VARCHAR(32) | Delete rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
UPDATE_RULE | VARCHAR(32) | Update rule for a referential constraint: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
STATUS | VARCHAR(32) | Enforcement status of the constraint: the value in ( ENABLED, DISABLE ) |
DEFERRABLE | VARCHAR(32) | Indicates whether the constraint is deferrable (DEFERRABLE) or not (NOT DEFERRABLE) |
DEFERRED | VARCHAR(32) | Indicates whether the constraint was initially deferred (DEFERRED) or not (IMMEDIATE) |
VALIDATED | VARCHAR(32) | Indicates whether all data may obey the constraint or not: the value in ( VALIDATED, NOT VALIDATED ) |
GENERATED | VARCHAR(32) | Indicates whether the name of the constraint is user-generated (USER NAME) or system-generated (GENERATED NAME) |
BAD | VARCHAR(32) |
Indicates whether this constraint specifies a century in an ambiguous manner (BAD) or not (NULL) |
RELY | VARCHAR(32) |
When NOT VALIDATED, indicates whether the constraint is to be taken into account for query rewrite (RELY) or not (NULL) |
LAST_CHANGE | TIMESTAMP(2) WITHOUT TIME ZONE | When the constraint was last enabled or disabled |
INDEX_OWNER | VARCHAR(128) | Owner of the index associated with the key constraint |
INDEX_SCHEMA | VARCHAR(128) | Schema of the index associated with the key constraint |
INDEX_NAME | VARCHAR(128) | Name of the index associated with the key constraint |
INVALID | VARCHAR(32) | Indicates whether the constraint is invalid (INVALID) or not (NULL) |
VIEW_RELATED | VARCHAR(32) |
Indicates whether the constraint depends on a view (DEPEND ON VIEW) or not (NULL) |
DROPPED | VARCHAR(3) | Indicates whether the constraint has been dropped and is in the recycle bin (YES) or not (NO) |
COMMENTS | VARCHAR(1024) | Comments of the constraint definition |
USER_CONS_COLUMNS
USER_CONS_COLUMNS describes columns that are owned by the current user and that are specified in constraint definitions.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the constraint definition |
CONSTRAINT_SCHEMA | VARCHAR(128) | Schema of the constraint definition |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint definition |
TABLE_OWNER | VARCHAR(128) | Owner of the table with the constraint definition |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table with the constraint definition |
TABLE_NAME | VARCHAR(128) | Name of the table with the constraint definition |
COLUMN_NAME | VARCHAR(128) | Name of the column or attribute of the object type column specified in the constraint definition |
POSITION | NUMBER | Original position of the column or attribute in the definition of the object |
USER_DEPENDENCIES
USER_DEPENDENCIES describes dependencies between objects accessible to the current user
Column name | Data type | Description |
|---|---|---|
SCHEMA_NAME | VARCHAR(128) | Schema Name of object |
NAME | VARCHAR(128) | Name of object |
TYPE | VARCHAR(32) | Type of object: FUNCTION, PROCEDURE, VIEW, PACKAGE, PACKAGE BODY, TRIGGER |
REFERENCED_OWNER | VARCHAR(128) | Owner of the referenced object |
REFERENCED_SCHEMA_NAME | VARCHAR(128) | Schema Name of the referenced object |
REFERENCED_TYPE | VARCHAR(32) | Type of the referenced object: FUNCTION, PROCEDURE, TABLE, VIEW, SEQUENCE, PACKAGE, PACKAGE BODY, TRIGGER |
REFERENCED_LINK_NAME | VARCHAR(128) | Name of the link to the parent object |
REFERENCED_NAME | VARCHAR(128) | Name of the referenced object |
DEPENDENCY_TYPE | VARCHAR(32) | Indicates whether the dependency is a REF dependency (REF) or not (HARD) |
USER_EXTENTS
USER_EXTENTS describes the extents comprising the segments owned by the current user's objects.
Column name | Data type | Description |
|---|---|---|
SEGMENT_SCHEMA | VARCHAR(128) | Schema of the segment associated with the extent |
SEGMENT_NAME | VARCHAR(128) | Name of the segment associated with the extent |
PARTITION_NAME | VARCHAR(128) |
Object Partition Name (Set to NULL for non-partitioned objects) |
SEGMENT_TYPE | VARCHAR(32) | Type of the segment: TABLE, INDEX |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the extent |
EXTENT_ID | NUMBER |
Extent number in the segment |
BYTES | NUMBER | Size of the extent in bytes |
BLOCKS | NUMBER | Size of the extent in Oracle blocks |
USER_GLOBAL_SECONDARY_INDEXES
USER_GLOBAL_SECONDARY_INDEXES describes the global secondary indexes on the tables owned by the current user.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the global secondary indexed object |
TABLE_NAME | VARCHAR(128) | Name of the global secondary indexed object |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the global secondary index |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent |
NEXT_EXTENT | NUMBER | Size of secondary extents |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_FREE | NUMBER | Minimum percentage of free space in a block |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the global secondary index are logged: (YES) or (NO) |
BLOCKS | NUMBER | Number of used blocks in the global secondary index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the global secondary index |
DROPPED | VARCHAR(3) | Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO) |
USER_GSI_PLACE
USER_GSI_PLACE describes node placement of all global secondary indexes on the tables owned by the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the global secondary indexed object |
TABLE_NAME | VARCHAR(128) | Name of the global secondary indexed object |
GROUP_ID | NUMBER | Group identifier of the node where the global secondary index placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the global secondary index placed |
MEMBER_ID | NUMBER | Member identifier of the node where the global secondary index placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the global secondary index placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
DROPPED | VARCHAR(3) | Indicates whether the global secondary index has been dropped and is in the recycle bin (YES) or not (NO) |
BLOCKS | NUMBER | Number of used blocks of the node where the global secondary index placed |
USER_INDEXES
USER_INDEXES describes indexes owned by the current user.
Column name | Data type | Description |
|---|---|---|
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
INDEX_TYPE | VARCHAR(32) | Type of the index: the value in ( NORMAL, NORMAL/REV, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED NORMAL/REV, FUNCTION-BASED BITMAP, IOT - TOP, DOMAIN ) |
TABLE_OWNER | VARCHAR(128) | Owner of the indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the indexed object |
TABLE_NAME | VARCHAR(128) | Name of the indexed object |
TABLE_TYPE | VARCHAR(32) | Type of the indexed object: the value in ( NEXT OBJECT, INDEX, TABLE, VIEW, SYNONYM, SEQUENCE ) |
UNIQUENESS | VARCHAR(32) | Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE) |
COMPRESSION | VARCHAR(32) |
Indicates whether index compression is enabled (ENABLED) or not (DISABLED) |
PREFIX_LENGTH | NUMBER |
Number of columns in the prefix of the compression key |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the index |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent |
NEXT_EXTENT | NUMBER | Size of secondary extents |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
PCT_THRESHOLD | NUMBER |
Threshold percentage of block space allowed per index entry |
INCLUDE_COLUMN | NUMBER |
Column ID of the last column to be included in index-organized table primary key (non-overflow) index |
FREELISTS | NUMBER |
Number of process freelists allocated to this segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to this segment |
PCT_FREE | NUMBER | Minimum percentage of free space in a block |
LOGGING | VARCHAR(3) | ndicates whether or not changes to the index are logged: (YES) or (NO) |
BLOCKS | NUMBER | Number of used blocks in the index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the index |
BLEVEL | NUMBER |
B-Tree level (depth of the index from its root block to its leaf blocks) |
LEAF_BLOCKS | NUMBER |
Number of leaf blocks in the index |
DISTINCT_KEYS | NUMBER | Number of distinct indexed values. |
AVG_LEAF_BLOCKS_PER_KEY | NUMBER |
Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer |
AVG_DATA_BLOCKS_PER_KEY | NUMBER |
Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer |
CLUSTERING_FACTOR | NUMBER |
Indicates the amount of order of the rows in the table based on the values of the index |
STATUS | VARCHAR(32) |
Indicates whether a nonpartitioned index is VALID or UNUSABLE |
NUM_ROWS | NUMBER |
Number of rows in the index |
SAMPLE_SIZE | NUMBER | Size of the sample used to analyze the index |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this index was most recently analyzed |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the index, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the indexes to be scanned, or DEFAULT |
PARTITIONED | VARCHAR(3) |
Indicates whether the index is partitioned (YES) or not (NO) |
TEMPORARY | VARCHAR(1) | Indicates whether the index is on a temporary table (Y) or not (N) |
GENERATED | VARCHAR(1) | Indicates whether the name of the index is system-generated (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the index is a secondary object created by the method of the Data Cartridge (Y) or not (N) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for index blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for index blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for index blocks |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
PCT_DIRECT_ACCESS | NUMBER |
For a secondary index on an index-organized table, the percentage of rows with VALID guess |
ITYP_OWNER | VARCHAR(128) |
For a domain index, the owner of the indextype |
ITYP_NAME | VARCHAR(128) |
For a domain index, the name of the indextype |
PARAMETERS | VARCHAR(1024) |
For a domain index, the parameter string |
GLOBAL_STATS | VARCHAR(3) |
For partitioned indexes, indicates whether statistics were collected by analyzing the index as a whole (YES) or were estimated from statistics on underlying index partitions and subpartitions (NO) |
DOMIDX_STATUS | VARCHAR(32) |
Status of a domain index |
DOMIDX_OPSTATUS | VARCHAR(32) |
Status of the operation on a domain index |
FUNCIDX_STATUS | VARCHAR(32) |
Status of a function-based index |
JOIN_INDEX | VARCHAR(3) |
Indicates whether the index is a join index (YES) or not (NO) |
IOT_REDUNDANT_PKEY_ELIM | VARCHAR(3) |
Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO) |
DROPPED | VARCHAR(3) | Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO) |
VISIBILITY | VARCHAR(3) |
Indicates whether the index is VISIBLE or INVISIBLE to the optimizer |
DOMIDX_MANAGEMENT | VARCHAR(32) |
If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the index segment has been created (YES) or not (NO) |
COMMENTS | VARCHAR(1024) | Comments of the index |
EMPTY_BLOCKS | NUMBER | Number of empty blocks in the index |
USER_IND_COLUMNS
USER_IND_COLUMNS describes the columns of the indexes owned by the current user and columns of indexes on tables owned by the current user.
Column name | Data type | Description |
|---|---|---|
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
TABLE_SCHEMA | VARCHAR(128) | Schema of the table or cluster |
TABLE_NAME | VARCHAR(128) | Name of the table or cluster |
COLUMN_NAME | VARCHAR(128) | Column name or attribute of the object type column |
COLUMN_POSITION | NUMBER | Position of the column or attribute within the index |
COLUMN_LENGTH | NUMBER | Indexed length of the column |
CHAR_LENGTH | NUMBER |
Maximum codepoint length of the column |
DESCEND | VARCHAR(32) | Indicates whether the column is sorted in descending order (DESC) or ascending order (ASC) |
NULL_ORDER | VARCHAR(32) | Indicates whether the null value of the column is sorted in nulls first order (NULLS FIRST) or nulls last order (NULLS LAST) |
USER_IND_PLACE
USER_IND_PLACE describes node placement of the indexes owned by the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
INDEX_SCHEMA | VARCHAR(128) | Schema of the index |
INDEX_NAME | VARCHAR(128) | Name of the index |
TABLE_OWNER | VARCHAR(128) | Owner of the indexed object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the indexed object |
TABLE_NAME | VARCHAR(128) | Name of the indexed object |
GROUP_ID | NUMBER | Group identifier of the node where the index placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the index placed |
MEMBER_ID | NUMBER | Member identifier of the node where the index placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the index placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
DROPPED | VARCHAR(3) | Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO) |
DISTINCT_KEYS | NUMBER | (deprecated) |
SAMPLE_SIZE | NUMBER | (deprecated) |
BLOCKS | NUMBER | Number of used blocks of the node where the index placed |
LAST_ANALYZED | TIMESTAMP(2) WITHOUT TIME ZONE | (deprecated) |
USER_OBJECTS
USER_OBJECTS describes all objects owned by the current user.
Column name | Data type | Description |
|---|---|---|
SCHEMA_NAME | VARCHAR(128) | Schema of the object |
OBJECT_NAME | VARCHAR(128) | Name of the object |
SUBOBJECT_NAME | VARCHAR(128) | Name of the subobject (for example, partition) |
OBJECT_ID | NUMBER | Dictionary object number of the object |
DATA_OBJECT_ID | NUMBER | Dictionary object number of the segment that contains the object |
OBJECT_TYPE | VARCHAR(32) | Type of the object (such as TABLE, INDEX) |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp for the creation of the object |
LAST_DDL_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp for the last modification of the object resulting from a DDL statement |
TIMESTAMP | VARCHAR(32) | Timestamp for the specification of the object (character data) |
STATUS | VARCHAR(32) |
Status of the object: the value in ( VALID, INVALID, N/A ) |
TEMPORARY | VARCHAR(1) | Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (Y) or not (N) |
GENERATED | VARCHAR(1) | Indicates whether the name of this object was system-generated (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N) |
NAMESPACE | NUMBER | Namespace for the object |
EDITION_NAME | VARCHAR(128) |
Name of the edition in which the object is actual |
DROPPED | VARCHAR(3) | Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO) |
USER_PACKAGE_PRIVS
USER_PACKAGE_PRIVS describes the package grants for which the current user is the package owner, grantor, or grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the package |
PROCEDURE_NAME | VARCHAR(128) | Name of the package |
PRIVILEGE | VARCHAR(32) | Privilege on the package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_PACKAGE_PRIVS_MADE
USER_PACKAGE_PRIVS_MADE describes the package grants for which the current user is the package owner.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the package |
PROCEDURE_NAME | VARCHAR(128) | Name of the package |
PRIVILEGE | VARCHAR(32) | Privilege on the package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_PACKAGE_PRIVS_RECD
USER_PACKAGE_PRIVS_RECD describes the package grants for which the current user is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the package |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the package |
PROCEDURE_NAME | VARCHAR(128) | Name of the package |
PRIVILEGE | VARCHAR(32) | Privilege on the package |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_PROCEDURES
USER_PROCEDURES lists of procedures owned by the current user.
Column name | Data type | Description |
|---|---|---|
SCHEMA_NAME | VARCHAR(128) | Schema Name of function, procedures or package |
OBJECT_NAME | VARCHAR(128) | Name of function, procedures or package |
PROCEDURE_NAME | VARCHAR(128) | Name when a procedures in package |
OBJECT_ID | NUMBER | ID of a function, procedures or package |
SUBPROGRAM_ID | NUMBER | ID of procedures in package |
OVERLOAD | VARCHAR(32) | ID of overloading procedure in package |
OBJECT_TYPE | VARCHAR(32) | Type of function, procedures or package |
AGGREGATE | VARCHAR(3) | Indicate whether the procedure is an aggreage function(YES) or not(NO) |
PIPELINED | VARCHAR(3) | Indicate whether the procedure is a pipelined table function(YES) or not(NO) |
IMPLTYPEOWNER | VARCHAR(128) | Name of the owner of the implementation type, if any |
IMPLTYPENAME | VARCHAR(128) | Name of the implementation type, if any |
PARALLEL | VARCHAR(3) | Indicates whether the procedure or function is parallel-enabled (YES) or not (NO) |
INTERFACE | VARCHAR(3) | YES, if the procedure/function is a table function implemented using the SQLCLI interface; otherwise NO |
DETERMINISTIC | VARCHAR(3) | YES, if the procedure/function is declared to be deterministic; otherwise NO |
AUTHID | VARCHAR(32) | Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker) |
USER_PROC_PRIVS
USER_PROC_PRIVS describes the procedure grants for which the current user is the procedure owner, grantor, or grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure and function |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure and function |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure and function |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure and function |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_PROC_PRIVS_MADE
USER_PROC_PRIVS_MADE describes the procedure grants for which the current user is the procedure owner or grantor.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure and function |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure and function |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure and function |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure and function |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_PROC_PRIVS_RECD
USER_PROC_PRIVS_RECD describes the procedure grants, for which the current user is the grantee, or for which an enabled role or PUBLIC is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
PROCEDURE_OWNER | VARCHAR(128) | Owner of the procedure and function |
PROCEDURE_SCHEMA | VARCHAR(128) | Schema of the procedure and function |
PROCEDURE_NAME | VARCHAR(128) | Name of the procedure and function |
PRIVILEGE | VARCHAR(32) | Privilege on the procedure and function |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_RECYCLEBIN
USER_RECYCLEBIN describes recycle bins owned by the current user.
Column name | Data type | Description |
|---|---|---|
SCHEMA_NAME | VARCHAR(128) | Schema name of the object |
OBJECT_NAME | VARCHAR(128) | Name of the object |
ORIGINAL_NAME | VARCHAR(128) | Original name of the object |
OPERATION | VARCHAR(4) | Operation carried out on the object |
OBJECT_TYPE | VARCHAR(32) | Type of the object |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the object |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Created time of the object |
DROPPED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Dropped time of the object |
DROP_SCN | VARCHAR(128) | System change number (SCN) of the transaction which moved the object to the recycle bin |
DROP_GCN | NUMBER | Global change number (GCN) of the transaction which moved the object to the recycle bin |
DROP_DCN | NUMBER | Domain change number (DCN) of the transaction which moved the object to the recycle bin |
DROP_LCN | NUMBER | Local change number (LCN) of the transaction which moved the object to the recycle bin |
CAN_UNDROP | VARCHAR(3) | Indicates whether the object can be undropped (YES) or not (NO) |
CAN_PURGE | VARCHAR(3) | Indicates whether the object can be purged (YES) or not (NO) |
BASE_OBJECT | NUMBER | Object number of the base object |
PURGE_OBJECT | NUMBER | Object number for the object which gets purged |
USER_SCHEMAS
Identify the schemata in a catalog that are owned by current user.
Column name | Data type | Description |
|---|---|---|
SCHEMA_OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Created time of the schema |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | Last modified time of the schema |
COMMENTS | VARCHAR(1024) | Comments of the schema |
USER_SCHEMA_PATH
USER_SCHEMA_PATH describes the schema search order of the current user, for naming resolution of unqualified SQL schema objects.
Column name | Data type | Description |
|---|---|---|
AUTH_NAME | VARCHAR(128) | Name of the user |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
SEARCH_ORDER | NUMBER | Schema search order of the user |
USER_SCHEMA_PRIVS
USER_SCHEMA_PRIVS describes the schema grants, for which the current user is the schema owner, grantor, or grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_SCHEMA_PRIVS_MADE
USER_SCHEMA_PRIVS_MADE describes the schema grants for which the current user is the schema owner.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_SCHEMA_PRIVS_RECD
USER_SCHEMA_PRIVS_RECD describes the schema grants for which the current user is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the schema |
SCHEMA_NAME | VARCHAR(128) | Name of the schema |
PRIVILEGE | VARCHAR(32) | Privilege on the schema |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_SEQUENCES
USER_SEQUENCES describes all sequences owned by the current user.
Column name | Data type | Description |
|---|---|---|
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Sequence name |
MIN_VALUE | NUMBER | Minimum value of the sequence |
MAX_VALUE | NUMBER | Maximum value of the sequence |
INCREMENT_BY | NUMBER | Value by which sequence is incremented |
CYCLE_FLAG | VARCHAR(1) | Indicates whether the sequence wraps around on reaching the limit (Y) or not (N) |
ORDER_FLAG | VARCHAR(1) |
Indicates whether sequence numbers are generated in order (Y) or not (N) |
CACHE_SIZE | NUMBER | Number of sequence numbers to cache |
LAST_NUMBER | NUMBER | Last sequence number written to database. If a sequence uses caching, the number written to database is the last number placed in the sequence cache. |
COMMENTS | VARCHAR(1024) | Comments of the sequence |
USER_SEQ_PRIVS
USER_SEQ_PRIVS describes the sequence grants for which the current user is the sequence owner, grantor, or grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_SEQ_PRIVS_MADE
USER_SEQ_PRIVS_MADE describes the sequence grants for which the current user is the sequence owner.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_SEQ_PRIVS_RECD
USER_SEQ_PRIVS_RECD describes the sequence grants for which the current user is the grantee.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
SEQUENCE_OWNER | VARCHAR(128) | Owner of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | Schema of the sequence |
SEQUENCE_NAME | VARCHAR(128) | Name of the sequence |
PRIVILEGE | VARCHAR(32) | Privilege on the sequence |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
USER_SHARD_KEY_COLUMNS
USER_SHARD_KEY_COLUMNS describes shard key columns of shareded tables owned by the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
COLUMN_NAME | VARCHAR(128) | Column name of the shard key |
COLUMN_POSITION | NUMBER | Position of the column within the shard key |
USER_SOURCE
USER_SOURCE describes the text source of the stored objects accessible to the current user.
Column name | Data type | Description |
|---|---|---|
SCHEMA_NAME | VARCHAR(128) | Schema Name of object |
NAME | VARCHAR(128) | Name of object |
TYPE | VARCHAR(32) | Type of object: FUNCTION, PROCEDURE, PACKAGE, PACKAGE BODY, TRIGGER |
LINE | NUMBER | Line number of this line of source |
TEXT | LONG VARCHAR | Text source of the strored object |
ORIGIN_CON_ID | VARCHAR(256) | ID of the container where the data originates |
USER_SYNONYMS
USER_SYNONYMS describes all synonyms owned by the current user.
Column name | Data type | Description |
|---|---|---|
SYNONYM_OWNER | VARCHAR(128) | Owner of the synonym |
SYNONYM_SCHEMA | VARCHAR(128) | Schema of the synonym |
SYNONYM_NAME | VARCHAR(128) | Synonym name |
OBJECT_SCHEMA_NAME | VARCHAR(128) | Object schema name |
OBJECT_NAME | VARCHAR(128) | Object name |
DB_LINK | VARCHAR(128) | Reserved for future use |
USER_SYS_PRIVS
USER_SYS_PRIVS describes system (database, tablespace, schema) privileges granted to the current user or PUBLIC.
Column name | Data type | Description |
|---|---|---|
USERNAME | VARCHAR(128) | Name of the user, or PUBLIC |
PRIVILEGE | VARCHAR(256) | System(database, tablespace, schema) privilege |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
ADMIN_OPTION | VARCHAR(3) | equal to GRANTABLE column |
USER_TABLES
USER_TABLES describes the relational tables owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace containing the table |
CLUSTER_NAME | VARCHAR(128) |
Name of the cluster |
IOT_NAME | VARCHAR(128) |
Name of the index-organized table |
STATUS | VARCHAR(32) |
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 |
PCT_USED | NUMBER | Minimum percentage of used space in a block |
INI_TRANS | NUMBER | Initial number of transactions |
MAX_TRANS | NUMBER | Maximum number of transactions |
INITIAL_EXTENT | NUMBER | Size of the initial extent (in bytes) |
NEXT_EXTENT | NUMBER | Size of secondary extents (in bytes) |
MIN_EXTENTS | NUMBER | Minimum number of extents allowed in the segment |
MAX_EXTENTS | NUMBER | Maximum number of extents allowed in the segment |
PCT_INCREASE | NUMBER |
Percentage increase in extent size |
FREELISTS | NUMBER |
Number of process freelists allocated to the segment |
FREELIST_GROUPS | NUMBER |
Number of freelist groups allocated to the segment |
LOGGING | VARCHAR(3) | Indicates whether or not changes to the table are logged |
BACKED_UP | VARCHAR(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 rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old rowid |
AVG_ROW_LEN | NUMBER |
Average row length, including row overhead |
AVG_SPACE_FREELIST_BLOCKS | NUMBER |
Average freespace of all blocks on a freelist |
NUM_FREELIST_BLOCKS | NUMBER |
Number of blocks on the freelist |
DEGREE | VARCHAR(32) |
Number of threads per instance for scanning the table, or DEFAULT |
INSTANCES | VARCHAR(32) |
Number of instances across which the table is to be scanned, or DEFAULT |
CACHE | VARCHAR(1) |
Indicates whether the table is to be cached in the buffer cache (Y) or not (N) |
TABLE_LOCK | VARCHAR(32) | Indicates whether table locking is enabled (ENABLED) or disabled (DISABLED) |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing the table |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
PARTITIONED | VARCHAR(3) |
Indicates whether the table is partitioned (YES) or not (NO) |
IOT_TYPE | VARCHAR(32) |
If the table is an index-organized table, then IOT_TYPE is IOT, IOT_OVERFLOW, or IOT_MAPPING. |
TEMPORARY | VARCHAR(1) | Indicates whether the table is temporary (Y) or not (N) |
SECONDARY | VARCHAR(1) |
Indicates whether the table is a secondary object created by cartridge |
NESTED | VARCHAR(3) |
Indicates whether the table is a nested table (YES) or not (NO) |
BUFFER_POOL | VARCHAR(32) |
Buffer pool to be used for table blocks |
FLASH_CACHE | VARCHAR(32) |
Database Smart Flash Cache hint to be used for table blocks |
CELL_FLASH_CACHE | VARCHAR(32) |
Cell flash cache hint to be used for table blocks |
ROW_MOVEMENT | VARCHAR(32) |
If a partitioned table, indicates whether row movement is enabled (ENABLED) or disabled (DISABLED) |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether statistics for the table as a whole (global statistics) are accurate (YES) |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
DURATION | VARCHAR(32) | Indicates the duration of a temporary table, the value is in ( TRANSACTION, SESSION ) |
SKIP_CORRUPT | VARCHAR(32) |
Indicates whether Database ignores blocks marked corrupt during table and index scans (ENABLED) or raises an error (DISABLED) |
MONITORING | VARCHAR(3) |
Indicates whether the table has the MONITORING attribute set (YES) or not (NO) |
CLUSTER_OWNER | VARCHAR(128) |
Owner of the cluster, if any |
DEPENDENCIES | VARCHAR(32) |
Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED) |
COMPRESSION | VARCHAR(32) |
Indicates whether table compression is enabled (ENABLED) or not (DISABLED) |
COMPRESS_FOR | VARCHAR(32) |
Default compression for what kind of operations |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
READ_ONLY | VARCHAR(3) | Indicates whether the table IS READ-ONLY (YES) or not (NO) |
SEGMENT_CREATED | VARCHAR(3) | Indicates whether the table segment has been created (YES) or not (NO) |
RESULT_CACHE | VARCHAR(32) |
Result cache mode annotation for the table: the value in ( NULL, DEFAULT, FORCE, MANUAL ) |
USER_TABLESPACES
USER_TABLESPACES describes the tablespaces accessible to the current user.
Column name | Data type | Description |
|---|---|---|
TABLESPACE_NAME | VARCHAR(128) | Name of the tablespace |
BLOCK_SIZE | NUMBER | Tablespace block size |
INITIAL_EXTENT | NUMBER |
Default initial extent size (in bytes) |
NEXT_EXTENT | NUMBER |
Default incremental extent size (in bytes) |
MIN_EXTENTS | NUMBER |
Default minimum number of extents |
MAX_EXTENTS | NUMBER |
Default maximum number of extents |
MAX_SIZE | NUMBER |
Default maximum size of segments |
PCT_INCREASE | NUMBER |
Default percent increase for extent size |
MIN_EXTLEN | NUMBER |
Minimum extent size for this tablespace (in bytes) |
STATUS | VARCHAR(32) | Tablespace status: the value in ( ONLINE, OFFLINE, READ ONLY ) |
CONTENTS | VARCHAR(32) | Tablespace contents: the value in ( SYSTEM, DATA, TEMPORARY, UNDO ) |
LOGGING | VARCHAR(32) | Default logging attribute: LOGGING, NOLOGGING |
FORCE_LOGGING | VARCHAR(3) |
Indicates whether the tablespace is under force logging mode (YES) or not (NO) |
EXTENT_MANAGEMENT | VARCHAR(32) |
Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL) |
ALLOCATION_TYPE | VARCHAR(32) |
Type of extent allocation in effect for the tablespace: the value in ( SYSTEM, UNIFORM, USER ) |
SEGMENT_SPACE_MANAGEMENT | VARCHAR(32) |
Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO) |
DEF_TAB_COMPRESSION | VARCHAR(32) |
Indicates whether default table compression is enabled (ENABLED) or not (DISABLED) |
RETENTION | VARCHAR(32) |
Undo tablespace retention: the value in ( GUARANTEE, NOGUARANTEE, NOT APPLY ) |
BIGFILE | VARCHAR(3) |
Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO) |
PREDICATE_EVALUATION | VARCHAR(32) |
Indicates whether predicates are evaluated by host (HOST) or by storage (STORAGE) |
ENCRYPTED | VARCHAR(3) |
Indicates whether the tablespace is encrypted (YES) or not (NO) |
COMPRESS_FOR | VARCHAR(32) |
Indicates whether the tablespace is encrypted (YES) or not (NO) |
USER_TAB_COLS
USER_TAB_COLS describes the columns (including hidden columns) of the tables, views, and clusters owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Column name |
DATA_TYPE | VARCHAR(128) | Datatype of the column |
DATA_TYPE_MOD | VARCHAR(3) |
Datatype modifier of the column |
DATA_TYPE_OWNER | VARCHAR(128) |
Owner of the datatype of the column |
DATA_LENGTH | NUMBER | Length of the column (in bytes) |
DATA_PRECISION | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
NULLABLE | VARCHAR(1) | Indicates whether a column allows NULLs. |
COLUMN_ID | NUMBER | Sequence number of the column as created |
DEFAULT_LENGTH | NUMBER | Length of the default value for the column |
DATA_DEFAULT | LONG VARCHAR | Default value for the column |
NUM_DISTINCT | NUMBER | Number of distinct values in the column |
LOW_VALUE | VARBINARY(32) | Low value in the column |
HIGH_VALUE | VARBINARY(32) | High value in the column |
DENSITY | NUMBER |
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. |
NUM_NULLS | NUMBER | Number of NULLs in the column |
NUM_BUCKETS | NUMBER |
Number of buckets in the histogram for the column |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this column was most recently analyzed |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing this column |
CHARACTER_SET_NAME | VARCHAR(128) |
Name of the character set |
CHAR_COL_DECL_LENGTH | NUMBER | Declaration length of the character type column |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether column statistics were collected for the table |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN | NUMBER | Average length of the column (in bytes) |
CHAR_LENGTH | NUMBER | Displays the length of the column in characters. |
CHAR_USED | VARCHAR(1) | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C) |
V80_FMT_IMAGE | VARCHAR(3) |
Indicates whether the column data is in release older image format (YES) or not (NO) |
DATA_UPGRADED | VARCHAR(3) |
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO) |
HIDDEN_COLUMN | VARCHAR(3) | Indicates whether the column is a hidden column (YES) or not (NO) |
VIRTUAL_COLUMN | VARCHAR(3) |
Indicates whether the column is a virtual column (YES) or not (NO) |
SEGMENT_COLUMN_ID | NUMBER | Sequence number of the column in the segment |
INTERNAL_COLUMN_ID | NUMBER | Internal sequence number of the column |
HISTOGRAM | VARCHAR(32) |
Indicates existence/type of histogram |
QUALIFIED_COL_NAME | VARCHAR(4000) | Qualified column name |
IDENTITY_COLUMN | VARCHAR(3) | Indicates whether this is an identity column (YES) or not (NO) |
USER_TAB_COLUMNS
USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COLUMN_NAME | VARCHAR(128) | Column name |
DATA_TYPE | VARCHAR(128) | Datatype of the column |
DATA_TYPE_MOD | VARCHAR(3) |
Datatype modifier of the column |
DATA_TYPE_OWNER | VARCHAR(128) |
Owner of the datatype of the column |
DATA_LENGTH | NUMBER | Length of the column (in bytes) |
DATA_PRECISION | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes |
DATA_SCALE | NUMBER | Digits to the right of the decimal point in a number |
NULLABLE | VARCHAR(1) | Indicates whether a column allows NULLs. |
COLUMN_ID | NUMBER | Sequence number of the column as created |
DEFAULT_LENGTH | NUMBER | Length of the default value for the column |
DATA_DEFAULT | LONG VARCHAR | Default value for the column |
NUM_DISTINCT | NUMBER | Number of distinct values in the column |
LOW_VALUE | VARBINARY(32) | Low value in the column |
HIGH_VALUE | VARBINARY(32) | High value in the column |
DENSITY | NUMBER |
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. |
NUM_NULLS | NUMBER | Number of NULLs in the column |
NUM_BUCKETS | NUMBER |
Number of buckets in the histogram for the column |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which this column was most recently analyzed |
SAMPLE_SIZE | NUMBER | Sample size used in analyzing this column |
CHARACTER_SET_NAME | VARCHAR(128) |
Name of the character set |
CHAR_COL_DECL_LENGTH | NUMBER | Declaration length of the character type column |
GLOBAL_STATS | VARCHAR(3) |
For partitioned tables, indicates whether column statistics were collected for the table |
USER_STATS | VARCHAR(3) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |
AVG_COL_LEN | NUMBER | Average length of the column (in bytes) |
CHAR_LENGTH | NUMBER | Displays the length of the column in characters. |
CHAR_USED | VARCHAR(1) | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C) |
V80_FMT_IMAGE | VARCHAR(3) |
Indicates whether the column data is in release older image format (YES) or not (NO) |
DATA_UPGRADED | VARCHAR(3) |
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO) |
HISTOGRAM | VARCHAR(32) |
Indicates existence/type of histogram |
IDENTITY_COLUMN | VARCHAR(3) | Indicates whether this is an identity column (YES) or not (NO) |
USER_TAB_COMMENTS
USER_TAB_COMMENTS displays comments on the tables and views owned by the current user.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
TABLE_TYPE | VARCHAR(32) | Type of the object |
COMMENTS | VARCHAR(1024) | Comment on the object |
USER_TAB_IDENTITY_COLS
USER_TAB_IDENTITY_COLS describes all table identity columns.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
COLUMN_NAME | VARCHAR(128) | Name of the identity column |
GENERATION_TYPE | VARCHAR(32) | Generation type of the identity column. Possible values are ALWAYS or BY DEFAULT |
IDENTITY_OPTIONS | VARCHAR(1024) | Options for the identity column sequence generator |
USER_TAB_PLACE
USER_TAB_PLACE describes node placement of cluster tables owned by the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
GROUP_ID | NUMBER | Group identifier of the node where the table placed |
GROUP_NAME | VARCHAR(128) | Group name of the node where the table placed |
MEMBER_ID | NUMBER | Member identifier of the node where the table placed |
MEMBER_NAME | VARCHAR(128) | Member name of the node where the table placed |
MEMBER_POSITION | NUMBER | Member position of the node where the table placed |
MEMBER_OFFLINE | BOOLEAN | data of the cluster member is offline or not |
IS_UPDATE_MASTER | BOOLEAN | whether the cluster member is update master or not |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
SCN | VARCHAR(64) | table scn of the node where the table placed |
NUM_ROWS | NUMBER | Number of rows in the table |
BLOCKS | NUMBER | Number of used blocks of the node where the table placed |
LAST_ANALYZED | TIMESTAMP(6) WITHOUT TIME ZONE | Date on which the table was most recently analyzed |
USER_TAB_PRIVS
USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS_MADE describes the object grants for which the current user is the object owner.
Column name | Data type | Description |
|---|---|---|
GRANTEE | VARCHAR(128) | Name of the user or role to whom access was granted |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
USER_TAB_PRIVS_RECD
USER_TAB_PRIVS_RECD describes the object grants for which the current user is the grantee.
Column name | Data type | Description |
|---|---|---|
OWNER | VARCHAR(128) | Owner of the object |
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
GRANTOR | VARCHAR(128) | Name of the user who performed the grant |
PRIVILEGE | VARCHAR(32) | Privilege on the object |
GRANTABLE | VARCHAR(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) |
HIERARCHY | VARCHAR(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) |
USER_TAB_SHARDS
USER_TAB_SHARDS describes shard information of sharded tables owned by the current user in the cluster system.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the table |
TABLE_NAME | VARCHAR(128) | Name of the table |
SHARD_STRATEGY | VARCHAR(32) | Sharding strategy of the table: the value in (HASH SHARDING, RANGE SHARDING, LIST SHARDING) |
SHARD_NAME | VARCHAR(128) | Shard name |
SHARD_NUMBER | NUMBER | Shard number |
SHARD_DEFINITION | LONG VARCHAR | Shard definition (if hash sharded, the value is null) |
GROUP_ID | NUMBER | Group identifier where the shard placed |
GROUP_NAME | VARCHAR(128) | Group Name where the shard placed |
DROPPED | VARCHAR(3) | Indicates whether the table has been dropped and is in the recycle bin (YES) or not (NO) |
USER_USERS
USER_USERS describes the current user.
Column name | Data type | Description |
|---|---|---|
USERNAME | VARCHAR(128) | Name of the user |
USER_ID | NUMBER | ID number of the user |
ACCOUNT_STATUS | VARCHAR(32) | Account status: the value in ( OPEN, EXPIRED, EXPIRED(GRACE), LOCKED(TIMED), LOCKED, EXPIRED & LOCKED(TIMED), EXPIRED(GRACE) & LOCKED(TIMED), EXPIRED & LOCKED, EXPIRED(GRACE) & LOCKED ) |
LOCK_DATE | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp the account was locked if account status was LOCKED |
EXPIRY_DATE | TIMESTAMP(2) WITHOUT TIME ZONE | Timestamp of expiration of the account |
DEFAULT_TABLESPACE | VARCHAR(128) | Default tablespace for data |
TEMPORARY_TABLESPACE | VARCHAR(128) | Name of the default tablespace for temporary tables or the name of a tablespace group |
INDEX_TABLESPACE | VARCHAR(128) | Default tablespace for index |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | User creation timestamp |
INITIAL_RSRC_CONSUMER_GROUP | VARCHAR(128) |
Initial resource consumer group for the user |
EXTERNAL_NAME | VARCHAR(128) |
User external name |
USER_VIEWS
USER_VIEWS describes the views owned by the current user.
Column name | Data type | Description |
|---|---|---|
VIEW_SCHEMA | VARCHAR(128) | Schema of the view |
VIEW_NAME | VARCHAR(128) | Name of the view |
TEXT_LENGTH | NUMBER | Length of the view text |
TEXT | LONG VARCHAR | View text |
TYPE_TEXT_LENGTH | NUMBER |
Length of the type clause of the typed view |
TYPE_TEXT | VARCHAR(4000) |
Type clause of the typed view |
OID_TEXT_LENGTH | NUMBER |
Length of the WITH OID clause of the typed view |
OID_TEXT | VARCHAR(4000) |
WITH OID clause of the typed view |
VIEW_TYPE_OWNER | VARCHAR(128) |
Owner of the type of the view if the view is a typed view |
VIEW_TYPE | VARCHAR(32) |
Type of the view if the view is a typed view |
SUPERVIEW_NAME | VARCHAR(128) |
Name of the superview |
EDITIONING_VIEW | VARCHAR(1) | Reserved for future use |
READ_ONLY | VARCHAR(1) | Indicates whether the view is read-only (Y) or not (N) |
기타 View
ALL 계열이나 DBA 계열, USER 계열이 아닌 view나 테이블이다.
AUDIT_POLICIES
AUDIT_POLICIES contains one row for each audit policy.
Column name | Data type | Description |
|---|---|---|
POLICY_NAME | VARCHAR(128) | audit policy name |
ENABLED | VARCHAR(3) | indicates whether the audit policy is enabled (YES) or not (NO) |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | created time of the audit policy |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | last modified time of the audit policy |
COMMENTS | VARCHAR(1024) | comments of the audit policy |
AUDIT_POLICY_OPTIONS
AUDIT_POLICY_OPTIONS describes all audit policies created in the database.
Column name | Data type | Description |
|---|---|---|
POLICY_NAME | VARCHAR(128) | audit policy name |
AUDIT_OPTION | VARCHAR(32) | auditing option defined in the audit policy |
AUDIT_OPTION_TYPE | VARCHAR(32) | The values of AUDIT_OPTION_TYPE_NAME in ( 'DATABASE PRIVILEGE', 'SYSTEM ACTION', 'OBJECT ACTION' ) |
OBJECT_SCHEMA | VARCHAR(128) | schema name, for an object-specific auditing option |
OBJECT_NAME | VARCHAR(128) | object name, for an object-specific auditing option |
OBJECT_TYPE | VARCHAR(32) | object type name, for an object-specific auditing option |
DROPPED | VARCHAR(3) | Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO) |
AUDIT_POLICY_ENABLED
AUDIT_POLICY_ENABLE describes all the audit policies that are enable in the database.
Column name | Data type | Description |
|---|---|---|
POLICY_NAME | VARCHAR(128) | audit policy name |
ENABLED_OPT | VARCHAR(32) | enable option of the audit policy, the possible values are BY, EXCEPT |
USER_NAME | VARCHAR(128) | user name for whom the audit policy is enable |
WHEN_SUCCESS | VARCHAR(3) | indicates whether the audit policy is enable for auditing successful events or not |
WHEN_FAILURE | VARCHAR(3) | indicates whether the audit policy is enable for auditing unsuccessful events or not |
AUDIT_TRAIL
AUDIT_TRAIL displays audit records from the audit trail.
Column name | Data type | Description |
|---|---|---|
MEMBER_NAME | VARCHAR(128) | cluster member name |
SESSION_ID | NUMBER | session identifier |
SESSION_SERIAL | NUMBER | session serial number |
LOGON_USERNAME | VARCHAR(128) | logon user name of the user whose actions were audited |
CURRENT_USERNAME | VARCHAR(128) | effective user for the statement execution |
SERVER_PROCESS | NUMBER | server process identifer for the session |
CLIENT_PROGRAM_NAME | VARCHAR(128) | client program used for session |
CLIENT_USERNAME | VARCHAR(128) | client operating system user name for the session |
CLIENT_PROCESS | NUMBER | client process identifer for the session |
CLIENT_HOST | VARCHAR(128) | client host ip address for the session |
CLIENT_PORT | NUMBER | client port number for the session |
CLIENT_TERMINAL | VARCHAR(128) | client terminal name for the session |
TRANSACTION_ID | NUMBER | transaction identifier |
SCN | VARCHAR(128) | system change number (SCN) string of the query at the time of the event |
GCN | NUMBER | global change number (GCN) of the query at the time of the event |
DCN | NUMBER | domain change number (DCN) of the query at the time of the event |
LCN | NUMBER | local change number (LCN) of the query at the time of the event |
STMT_NO | NUMBER | numeric number for each statement run in a session |
SQL_TEXT | LONG VARCHAR | SQL associated with the event |
SQL_BINDS | LONG VARCHAR | list of bind variables, if any, associated with SQL_TEXT |
RETURN_CODE | NUMBER | error code generated by the action, zero if the action succeeded |
ERROR_MESSAGE | VARCHAR(1024) | error message generated by the action, null if the action succeeded |
ENTRY_ID | NUMBER | audit trail entry identifier in the session |
EVENT_TIMESTAMP | TIMESTAMP(2) WITHOUT TIME ZONE | timestamp of the creation of the audit trail entry in local time zone |
POLICY_NAME | VARCHAR(128) | audit policy name that caused the current audit record |
PRIVILEGE_USED | VARCHAR(32) | database privilege used to execute the action |
ACTION_NAME | VARCHAR(32) | action name executed by the user |
OBJECT_TYPE | VARCHAR(32) | object type of object affected by the action |
OBJECT_SCHEMA | VARCHAR(128) | schema name of object affected by the action |
OBJECT_NAME | VARCHAR(128) | object name of object affected by the action |
DATABASE_PROPERTIES
DATABASE_PROPERTIES lists permanent database properties.
Column name | Data type | Description |
|---|---|---|
PROPERTY_NAME | VARCHAR(128) | Property name |
PROPERTY_VALUE | VARCHAR(4000) | Property value |
DESCRIPTION | VARCHAR(4000) | Property description |
DBC_TABLE_TYPE_INFO
Identify the ODBC/JDBC table types available in this database.
Column name | Data type | Description |
|---|---|---|
DBC_TABLE_TYPE_ID | NUMBER | number identifier of the table type in ODBC/JDBC |
DBC_TABLE_TYPE | VARCHAR(128) | name of the table type in ODBC/JDBC |
IS_SUPPORTED | BOOLEAN | is supported feature |
COMMENTS | VARCHAR(1024) | comments of the table type |
DICTIONARY
DICTIONARY contains descriptions of data dictionary tables and views.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
COMMENTS | VARCHAR(1024) | Text comment on the object |
DICT_COLUMNS
DICT_COLUMNS contains descriptions of columns in data dictionary tables and views.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object that contains the column |
TABLE_NAME | VARCHAR(128) | Name of the object that contains the column |
COLUMN_NAME | VARCHAR(128) | Name of the column |
COMMENTS | VARCHAR(1024) | Text comment on the column |
IMPLEMENTATION_INFO
IMPLEMENTATION_INFO contains information about various aspects that are left implementation-defined.
Column name | Data type | Description |
|---|---|---|
IMPLEMENTATION_INFO_ID | NUMBER | identifier of the implementation item |
IMPLEMENTATION_INFO_NAME | VARCHAR(1024) | descriptive name of the implementation item |
INTEGER_VALUE | NUMBER | Value of the implementation item, or null if the value is contained in the column CHARACTER_VALUE |
CHARACTER_VALUE | VARCHAR(1024) | Value of the implementation item, or null if the value is contained in the column INTEGER_VALUE |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the implementation item |
IMPLEMENTATION_INFO_BASE
The IMPLEMENTATION_INFO_BASE table has one row for each implementation information item.
Column name | Data type | Description |
|---|---|---|
ID | VARCHAR(32) | identifier string of the implementation item |
SUB_ID | VARCHAR(32) | identifier string of the implementation item |
NAME | VARCHAR(1024) | descriptive name of the implementation item |
SUB_NAME | VARCHAR(1024) | descriptive name of the implementation item |
IS_SUPPORTED | BOOLEAN | TRUE if the implementation item is supported, FALSE if not |
INTEGER_VALUE | NUMBER | Value of the implementation item, or null if the value is contained in the column CHARACTER_VALUE |
CHARACTER_VALUE | VARCHAR(1024) | Value of the implementation item, or null if the value is contained in the column INTEGER_VALUE |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the implementation item |
JDBC_CLIENT_PROPS
JDBC_CLIENT_PROPS is the set of jdbc client properties.
Column name | Data type | Description |
|---|---|---|
NAME | VARCHAR(128) | property name |
MAX_LEN | NATIVE_INTEGER | max length of a value |
DEFAULT_VALUE | VARCHAR(128) | default value |
DESCRIPTION | VARCHAR(256) | descrption on that property |
PRODUCT
PRODUCT is about the product name, version for ODBC, JDBC interface.
Column name | Data type | Description |
|---|---|---|
NAME | VARCHAR(32) | the product name |
VERSION | VARCHAR(128) | product full version information |
PRODUCT_VERSION | NUMBER | product version |
MAJOR_VERSION | NUMBER | major version |
MINOR_VERSION | NUMBER | minor version |
PATCH_VERSION | NUMBER | patch version |
SESSION_PRIVS
SESSION_PRIVS describes the privileges that are currently available to the user.
Column name | Data type | Description |
|---|---|---|
PRIVILEGE | VARCHAR(256) | Name of the privilege |
SUPPLEMENTAL_LOG_TABLE_INFO
SUPPLEMENTAL_LOG_TABLE_INFO describes table-level supplemental logging status.
Column name | Data type | Description |
|---|---|---|
TABLE_SCHEMA | VARCHAR(128) | Schema of the object |
TABLE_NAME | VARCHAR(128) | Name of the object |
SUPPLEMENTAL_LOG_DATA_PK | VARCHAR(32) | Status of table-level PRIMARY KEY COLUMNS supplemental logging: IMPLICIT, EXPLICIT, NO |
DROPPED | VARCHAR(3) | Indicates whether the object has been dropped and is in the recycle bin (YES) or not (NO) |
Aliased Synonym
DICTIONARY_SCHEMA 내의 view나 테이블을 가리키는 public synonym이다.
COLS
COLS is a public synonym for USER_TAB_COLUMNS.
DICT
DICT is a public synonym for DICTIONARY.
IND
IND is a public synonym for USER_INDEXES.
OBJ
OBJ is a public synonym for USER_OBJECTS.
SEQ
SEQ is a public synonym for USER_SEQUENCES.
TABS
TABS is a public synonym for USER_TABLES.
RECYCLEBIN
RECYCLEBIN is a public synonym for USER_RECYCLEBIN.
INFORMATION_SCHEMA
INFORMATION_SCHEMA 스키마의 view들은 SQL 표준에서 정의한 INFORMATION_SCHEMA의 view들과 동일한 정보를 제공한다.
해당 view들을 사용하려면 다음과 같이 InformationSchema.sql을 실행해야 한다.
Standalone의 경우
% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/standalone/InformationSchema.sql
Cluster의 경우
% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/cluster/InformationSchema.sql
INFORMATION_SCHEMA의 view와 테이블들은 open 단계부터 조회할 수 있다.
휴지통에 보관된 객체들은 INFORMATION_SCHEMA의 view에서 조회할 수 없다.
COLUMNS
Identify the columns of tables defined in this catalog that are accessible to given user or role.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the column |
TABLE_OWNER | VARCHAR(128) | owner name of the column |
TABLE_SCHEMA | VARCHAR(128) | schema name of the column |
TABLE_NAME | VARCHAR(128) | table name of the column |
COLUMN_NAME | VARCHAR(128) | column name |
ORDINAL_POSITION | NUMBER | the ordinal position (> 0) of the column in the table |
COLUMN_DEFAULT | LONG VARCHAR | the default for the column |
IS_NULLABLE | BOOLEAN | is nullable of the column |
DATA_TYPE | VARCHAR(128) | the standard name of the data type |
CHARACTER_MAXIMUM_LENGTH | NUMBER | the maximum length in characters |
CHARACTER_OCTET_LENGTH | NUMBER | the maximum length in octets |
NUMERIC_PRECISION | NUMBER | the numeric precision of the numerical Data type |
NUMERIC_PRECISION_RADIX | NUMBER | the radix ( 2 or 10 ) of the precision of the numerical data type |
NUMERIC_SCALE | NUMBER | the numeric scale of the exact numerical data type |
DATETIME_PRECISION | NUMBER | for a datetime or interval type, the value is the fractional seconds precision |
INTERVAL_TYPE | VARCHAR(32) | for a interval type, the value is in ( YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, YEAR TO MONTH, DAY TO HOUR, DAY TO MINUTE, DAY TO SECOND, HOUR TO MINUTE, HOUR TO SECOND, MINUTE TO SECOND ) |
INTERVAL_PRECISION | NUMBER | for a interval type, the value is the leading precision |
CHARACTER_SET_CATALOG | VARCHAR(128) | catalog name of the character set if is is a character string type |
CHARACTER_SET_SCHEMA | VARCHAR(128) | schema name of the character set if is is a character string type |
CHARACTER_SET_NAME | VARCHAR(128) | character set name of the character set if is is a character string type |
COLLATION_CATALOG | VARCHAR(128) | catalog name of the applicable collation if is is a character string type |
COLLATION_SCHEMA | VARCHAR(128) | schema name of the applicable collation if is is a character string type |
COLLATION_NAME | VARCHAR(128) | collation name of the applicable collation if is is a character string type |
DOMAIN_CATALOG | VARCHAR(128) | catalog name of the domain used by the column being described |
DOMAIN_SCHEMA | VARCHAR(128) | schema name of the domain used by the column being described |
DOMAIN_NAME | VARCHAR(128) | domain name of the domain used by the column being described |
UDT_CATALOG | VARCHAR(128) | catalog name of the user-defined type of the data type being described |
UDT_SCHEMA | VARCHAR(128) | schema name of the user-defined type of the data type being described |
UDT_NAME | VARCHAR(128) | user-defined type name of the user-defined type of the data type being described |
SCOPE_CATALOG | VARCHAR(128) | catalog name of the referenceable table if DATA_TYPE is REF |
SCOPE_SCHEMA | VARCHAR(128) | schema name of the referenceable table if DATA_TYPE is REF |
SCOPE_NAME | VARCHAR(128) | scope name of the referenceable table if DATA_TYPE is REF |
MAXIMUM_CARDINALITY | NUMBER | maximum cardinality if DATA_TYPE is ARRAY |
DTD_IDENTIFIER | NUMBER | data type descriptor identifier |
IS_SELF_REFERENCING | BOOLEAN | is a self-referencing column |
IS_IDENTITY | BOOLEAN | is an identity column |
IDENTITY_GENERATION | VARCHAR(32) | for an identity column, the value is in ( ALWAYS, BY DEFAULT ) |
IDENTITY_START | NUMBER | for an identity column, the start value of the identity column |
IDENTITY_INCREMENT | NUMBER | for an identity column, the increment of the identity column |
IDENTITY_MAXIMUM | NUMBER | for an identity column, the maximum value of the identity column |
IDENTITY_MINIMUM | NUMBER | for an identity column, the minimum value of the identity column |
IDENTITY_CYCLE | BOOLEAN | for an identity column, the cycle option |
IS_GENERATED | BOOLEAN | is a generated column |
GENERATION_EXPRESSION | VARCHAR(128) | for a generated column, the text of the generation expression |
IS_SYSTEM_VERSION_START | BOOLEAN | is a system-version start column |
IS_SYSTEM_VERSION_END | BOOLEAN | is a system-version end column |
SYSTEM_VERSION_TIMESTAMP_GENERATION | VARCHAR(32) | for a system-version column, the value is ALWAYS |
IS_UPDATABLE | BOOLEAN | is an updatable column |
DECLARED_DATA_TYPE | VARCHAR(128) | the data type name that a user declared |
DECLARED_NUMERIC_PRECISION | NUMBER | the precision value that a user declared |
DECLARED_NUMERIC_SCALE | NUMBER | the scale value that a user declared |
COMMENTS | VARCHAR(1024) | comments of the column |
COLUMN_PRIVILEGES
Identify the privileges on columns of tables defined in this catalog that are available to or granted by a given user or role.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | authorization name of the user who granted column privileges |
GRANTEE | VARCHAR(128) | authorization name of some user or role, or PUBLIC to indicate all users, to whom the column privilege being described is granted |
TABLE_CATALOG | VARCHAR(128) | catalog name of the column on which the privilege being described was granted |
TABLE_OWNER | VARCHAR(128) | table owner name of the column on which the privilege being described was granted |
TABLE_SCHEMA | VARCHAR(128) | schema name of the column on which the privilege being described was granted |
TABLE_NAME | VARCHAR(128) | table name of the column on which the privilege being described was granted |
COLUMN_NAME | VARCHAR(128) | column name of the column on which the privilege being described was granted |
PRIVILEGE_TYPE | VARCHAR(32) | the value is in ( SELECT, INSERT, UPDATE, REFERENCES ) |
IS_GRANTABLE | BOOLEAN | is grantable |
CONSTRAINT_COLUMN_USAGE
Identify the columns used by referential constraints, unique constraints, check constraints, and assertions defined in this catalog and owned by a given user or role.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the column that participates in the constraint being described |
TABLE_OWNER | VARCHAR(128) | owner name of the column that participates in the constraint being described |
TABLE_SCHEMA | VARCHAR(128) | schema name of the column that participates in the constraint being described |
TABLE_NAME | VARCHAR(128) | table name of the column that participates in the constraint being described |
COLUMN_NAME | VARCHAR(128) | column name that participates in the constraint being described |
CONSTRAINT_CATALOG | VARCHAR(128) | catalog name of the constraint |
CONSTRAINT_OWNER | VARCHAR(128) | owner name of the constraint |
CONSTRAINT_SCHEMA | VARCHAR(128) | schema name of the constraint |
CONSTRAINT_NAME | VARCHAR(128) | constraint name |
CONSTRAINT_TABLE_USAGE
Identify the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in this catalog and owned by a given user or role.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the table that participates in the constraint being described |
TABLE_OWNER | VARCHAR(128) | owner name of the table that participates in the constraint being described |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table that participates in the constraint being described |
TABLE_NAME | VARCHAR(128) | table name that participates in the constraint being described |
CONSTRAINT_CATALOG | VARCHAR(128) | catalog name of the constraint |
CONSTRAINT_OWNER | VARCHAR(128) | owner name of the constraint |
CONSTRAINT_SCHEMA | VARCHAR(128) | schema name of the constraint |
CONSTRAINT_NAME | VARCHAR(128) | constraint name |
INFORMATION_SCHEMA_CATALOG_NAME
Identify the catalog that contains the Information Schema.
Column name | Data type | Description |
|---|---|---|
CATALOG_NAME | VARCHAR(128) | the name of catalog in which this Information Schema resides |
KEY_COLUMN_USAGE
Identify the columns defined in this catalog that are constrained as keys and that are accessible by a given user or role.
Column name | Data type | Description |
|---|---|---|
CONSTRAINT_CATALOG | VARCHAR(128) | catalog name of the constraint |
CONSTRAINT_OWNER | VARCHAR(128) | owner name of the constraint |
CONSTRAINT_SCHEMA | VARCHAR(128) | schema name of the constraint |
CONSTRAINT_NAME | VARCHAR(128) | constraint name |
TABLE_CATALOG | VARCHAR(128) | catalog name of the column that participates in the constraint being described |
TABLE_OWNER | VARCHAR(128) | owner name of the column that participates in the constraint being described |
TABLE_SCHEMA | VARCHAR(128) | schema name of the column that participates in the constraint being described |
TABLE_NAME | VARCHAR(128) | table name of the column that participates in the constraint being described |
COLUMN_NAME | VARCHAR(128) | column name that participates in the constraint being described |
ORDINAL_POSITION | NUMBER | the ordinal position of the specific column in the constraint being described. If the constraint described is a key of cardinality 1 (one), then the value of ORDINAL_POSITION is always 1 (one). |
POSITION_IN_UNIQUE_CONSTRAINT | NUMBER | If the constraint being described is a foreign key constraint, then the value of POSITION_IN_UNIQUE_CONSTRAINT is the ordinal position of the referenced column corresponding to the referencing column being described, in the corresponding unique key constraint. |
MODULES
Identify the SQL-server modules in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
DEFAULT_CHARACTER_SET_CATALOG | VARCHAR(128) | default character set catalog name of the SQL-server module |
DEFAULT_CHARACTER_SET_SCHEMA | VARCHAR(128) | default character set schema name of the SQL-server module |
DEFAULT_CHARACTER_SET | VARCHAR(128) | default character set name of the SQL-server module |
DEFAULT_SCHEMA_CATALOG | VARCHAR(128) | catalog name of default schema of SQL-server module |
DEFAULT_SCHEMA_NAME | VARCHAR(128) | default scheam name of the SQL-server module |
MODULE_DEFINITION | LONG VARCHAR | definition of the SQL-server module |
MODULE_AUTHORIZATION | VARCHAR(32) | authorization of the SQL-server module(DEFINER/INVOKER) |
SQL_PATH | VARCHAR(1024) | described SQL PATH when the SQL-server module is defined |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | creation time of the SQL-server module |
LAST_ALTERED | TIMESTAMP(2) WITHOUT TIME ZONE | most lately altered time of the SQL-server module |
MODULE_BODY
Identify the SQL-server module bodies in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module' |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
MODULE_DEFINITION | LONG VARCHAR | definition of the SQL-server module body |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | creation time of the SQL-server module body |
LAST_ALTERED | TIMESTAMP(2) WITHOUT TIME ZONE | most lately altered time of the SQL-server module body |
MODULE_BODY_MODULE_USAGE
Identify the SQL-server modules owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
REF_MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module of contained in definition text of the SQL-server module body |
REF_MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module of contained in definition text of the SQL-server module body |
REF_MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module of contained in definition text of the SQL-server module body |
REF_MODULE_NAME | VARCHAR(128) | SQL-server module name of contained in definition text of the SQL-server module body |
MODULE_BODY_ROUTINE_USAGE
Identify the SQL-invoked routines owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
ROUTINE_CATALOG | VARCHAR(128) | catalog name of the SQL-invoked routine of contained in definition text of the SQL-server module body |
ROUTINE_OWNER | VARCHAR(128) | owner name of the SQL-invoked routine of contained in definition text of the SQL-server module body |
ROUTINE_SCHEMA | VARCHAR(128) | schema name of the SQL-invoked routine of contained in definition text of the SQL-server module body |
ROUTINE_NAME | VARCHAR(128) | SQL-invoked routine name of contained in definition text of the SQL-server module body |
MODULE_BODY_SEQUENCE_USAGE
Identify the sequences owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
SEQUENCE_CATALOG | VARCHAR(128) | catalog name of the sequence of contained in definition text of the SQL-server module body |
SEQUENCE_OWNER | VARCHAR(128) | owner name of the sequence of contained in definition text of the SQL-server module body |
SEQUENCE_SCHEMA | VARCHAR(128) | schema name of the sequence of contained in definition text of the SQL-server module body |
SEQUENCE_NAME | VARCHAR(128) | sequence name of contained in definition text of the SQL-server module body |
MODULE_BODY_TABLE_USAGE
Identify the tables owned by a given user or role on which SQL-server module bodies defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
TABLE_CATALOG | VARCHAR(128) | catalog name of the table of contained in definition text of the SQL-server module body |
TABLE_OWNER | VARCHAR(128) | owner name of the table of contained in definition text of the SQL-server module body |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table of contained in definition text of the SQL-server module body |
TABLE_NAME | VARCHAR(128) | table name of contained in definition text of the SQL-server module body |
MODULE_MODULE_USAGE
Identify the SQL-server modules owned by a given user or role on which SQL-server modules defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
REF_MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module of contained in definition text of the SQL-server module |
REF_MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module of contained in definition text of the SQL-server module |
REF_MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module of contained in definition text of the SQL-server module |
REF_MODULE_NAME | VARCHAR(128) | SQL-server module name of contained in definition text of the SQL-server module |
MODULE_PRIVILEGES
Identify the privileges on SQL-server modules defined in this catalog that are available to or granted by a given user or role.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | authorization name of the user who granted SQL-server module privileges |
GRANTEE | VARCHAR(128) | authorization name of some user or role, or PUBLIC to indicate all users, to whom the SQL-server module privilege being described is granted |
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module on which the privilege being described was granted |
MODULE_OWNER | VARCHAR(128) | owner name of the the SQL-server module on which the privilege being described was granted |
MODULE_SCHEMA | VARCHAR(128) | schema name of the the SQL-server module on which the privilege being described was granted |
MODULE_NAME | VARCHAR(128) | name of the the SQL-server module on which the privilege being described was granted |
PRIVILEGE_TYPE | VARCHAR(32) | the value is in ( EXECUTE ) |
IS_GRANTABLE | BOOLEAN | is grantable |
MODULE_ROUTINE_USAGE
Identify the SQL-invoked routines owned by a given user or role on which SQL-server modules defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
ROUTINE_CATALOG | VARCHAR(128) | catalog name of the SQL-invoked routine of contained in definition text of the SQL-server module |
ROUTINE_OWNER | VARCHAR(128) | owner name of the SQL-invoked routine of contained in definition text of the SQL-server module |
ROUTINE_SCHEMA | VARCHAR(128) | schema name of the SQL-invoked routine of contained in definition text of the SQL-server module |
ROUTINE_NAME | VARCHAR(128) | SQL-invoked routine name of contained in definition text of the SQL-server module |
MODULE_SEQUENCE_USAGE
Identify the sequences owned by a given user or role on which SQL-server modules defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
SEQUENCE_CATALOG | VARCHAR(128) | catalog name of the sequence of contained in definition text of the SQL-server module |
SEQUENCE_OWNER | VARCHAR(128) | owner name of the sequence of contained in definition text of the SQL-server module |
SEQUENCE_SCHEMA | VARCHAR(128) | schema name of the sequence of contained in definition text of the SQL-server module |
SEQUENCE_NAME | VARCHAR(128) | sequence name of contained in definition text of the SQL-server module |
MODULE_TABLE_USAGE
Identify the tables owned by a given user or role on which SQL-server modules defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module |
MODULE_NAME | VARCHAR(128) | name of the SQL-server module |
TABLE_CATALOG | VARCHAR(128) | catalog name of the table of contained in definition text of the SQL-server module |
TABLE_OWNER | VARCHAR(128) | owner name of the table of contained in definition text of the SQL-server module |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table of contained in definition text of the SQL-server module |
TABLE_NAME | VARCHAR(128) | table name of contained in definition text of the SQL-server module |
PARAMETERS
Identify the SQL parameters of SQL-invoked routines defined in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | catalog name of the specific name of the SQL- invoked routine that contains the SQL parameter being described |
SPECIFIC_OWNER | VARCHAR(128) | owner name of the specific name of the SQL- invoked routine that contains the SQL parameter being described |
SPECIFIC_SCHEMA | VARCHAR(128) | schema name of the specific name of the SQL- invoked routine that contains the SQL parameter being described |
SPECIFIC_NAME | VARCHAR(128) | specific name of the SQL- invoked routine that contains the SQL parameter being described |
ORDINAL_POSITION | NUMBER | ordinal position of the SQL- invoked routine that contains the SQL parameter being described |
PARAMETER_MODE | VARCHAR(32) | parameter mode of the SQL parameter being described |
IS_RESULT | BOOLEAN | the parameter is RESULT parameter of type-preserving function |
AS_LOCATOR | BOOLEAN | the parameter is passed as locator |
PARAMETER_NAME | VARCHAR(128) | name of the SQL parameter being descaibed |
FROM_SQL_SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the from-sql routine for the input parameter being described |
FROM_SQL_SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the from-sql routine for the input parameter being described |
FROM_SQL_SPECIFIC_NAME | VARCHAR(128) | specific name of the from-sql routine for the input parameter being described |
TO_SQL_SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the to-sql routine for the input parameter being described |
TO_SQL_SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the to-sql routine for the input parameter being described |
TO_SQL_SPECIFIC_NAME | VARCHAR(128) | specific name of the to-sql routine for the input parameter being described |
DATA_TYPE | VARCHAR(128) | data type of the SQL parameter being described |
CHARACTER_MAXIMUM_LENGTH | NUMBER | maximum length of the SQL parameter being described |
CHARACTER_OCTET_LENGTH | NUMBER | maximum length in octets of the SQL parameter being described |
CHARACTER_SET_CATALOG | VARCHAR(128) | character set catalog name of the data type of the SQL parameter being described |
CHARACTER_SET_SCHEMA | VARCHAR(128) | character set schema name of the data type of the SQL parameter being described |
CHARACTER_SET_NAME | VARCHAR(128) | character set name of the data type of the SQL parameter being described |
COLLATION_CATALOG | VARCHAR(128) | collation catalog name of the data type of the SQL parameter being described |
COLLATION_SCHEMA | VARCHAR(128) | collation schema name of the data type of the SQL parameter being described |
COLLATION_NAME | VARCHAR(128) | collation name of the data type of the SQL parameter being described |
NUMERIC_PRECISION | NUMBER | precision of the data type of the SQL parameter being described |
NUMERIC_PRECISION_RADIX | NUMBER | precision radix of the data type of the SQL parameter being described |
NUMERIC_SCALE | NUMBER | scale of the data type of the SQL parameter being described |
DATETIME_PRECISION | NUMBER | fractional second precisions of the data type of the SQL parameter being described |
INTERVAL_TYPE | VARCHAR(32) | interval qualifier of the data type of the SQL parameter being described |
INTERVAL_PRECISION | NUMBER | interval precision of the data type of the SQL parameter being described |
UDT_CATALOG | VARCHAR(128) | catalog name of UDT of the data type of the SQL parameter being described |
UDT_SCHEMA | VARCHAR(128) | schema name of UDT of the data type of the SQL parameter being described |
UDT_NAME | VARCHAR(128) | name of UDT of the data type of the SQL parameter being described |
SCOPE_CATALOG | VARCHAR(128) | catalog name of referenceable tables of the data type of the SQL parameter being described |
SCOPE_SCHEMA | VARCHAR(128) | schema name of referenceable tables of the data type of the SQL parameter being described |
SCOPE_NAME | VARCHAR(128) | name of referenceable tables of the data type of the SQL parameter being described |
MAXIMUM_CARDINALITY | NUMBER | maximum cardinality of the data type of the SQL parameter being described |
DTD_IDENTIFIER | NUMBER | dtd identifier of the data type of the SQL parameter being described |
DECLARED_DATA_TYPE | VARCHAR(128) | declared data type of the SQL parameter being described |
DECLARED_NUMERIC_PRECISION | NUMBER | precision of declared data type of the SQL parameter being described |
DECLARED_NUMERIC_SCALE | NUMBER | scale of declared data type of the SQL parameter being described |
PARAMETER_DEFAULT | LONG VARCHAR | default value of the SQL parameter being described |
REFERENTIAL_CONSTRAINTS
Identify the referential constraints defined on tables in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
CONSTRAINT_CATALOG | VARCHAR(128) | catalog name of the referential constraint |
CONSTRAINT_OWNER | VARCHAR(128) | owner name who owns the referential constraint |
CONSTRAINT_SCHEMA | VARCHAR(128) | schema name of the referential constraint being described |
CONSTRAINT_NAME | VARCHAR(128) | referential constraint name |
CONSTRAINT_TABLE_NAME | VARCHAR(128) | name of the table to which the referential constraint being described applies |
CONSTRAINT_COLUMN_NAME | VARCHAR(128) | column name of the table to which the referential constraint being described applies |
ORDINAL_POSITION | NUMBER | the ordinal position of the specific column in the referentail constraint being described. |
UNIQUE_CONSTRAINT_CATALOG | VARCHAR(128) | catalog name of the unique or primary key constraint applied to the referenced column list being described |
UNIQUE_CONSTRAINT_OWNER | VARCHAR(128) | owner name of the unique or primary key constraint applied to the referenced column list being described |
UNIQUE_CONSTRAINT_SCHEMA | VARCHAR(128) | schema name of the unique or primary key constraint applied to the referenced column list being described |
UNIQUE_CONSTRAINT_NAME | VARCHAR(128) | constraint name of the unique or primary key constraint applied to the referenced column list being described |
UNIQUE_CONSTRAINT_TABLE_NAME | VARCHAR(128) | table name of the unique or primary key constraint applied to the referenced column list being described |
UNIQUE_CONSTRAINT_COLUMN_NAME | VARCHAR(128) | column name of the unique or primary key constraint applied to the referenced column list being described |
IS_PRIMARY_KEY | BOOLEAN | whether the constraint applied to the referenced column list being described, is primary key or not |
MATCH_OPTION | VARCHAR(32) | the referential constraint that has a match option: the value in ( SIMPLE, PARTIAL, FULL ) |
UPDATE_RULE | VARCHAR(32) | the referential constraint that has an update rule: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
DELETE_RULE | VARCHAR(32) | the referential constraint that has a delete rule: the value in ( NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT ) |
IS_DEFERRABLE | BOOLEAN | is a deferrable constraint |
INITIALLY_DEFERRED | BOOLEAN | is an initially deferred constraint |
ROUTINES
Identify the SQL-invoked routines in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the routine |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of the routine |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the routine |
SPECIFIC_NAME | VARCHAR(128) | specific name of the routine |
ROUTINE_CATALOG | VARCHAR(128) | catalog name of the routine |
ROUTINE_OWNER | VARCHAR(128) | owner name of the routine |
ROUTINE_SCHEMA | VARCHAR(128) | schema name of the routine |
ROUTINE_NAME | VARCHAR(128) | null |
ROUTINE_TYPE | VARCHAR(128) | name of the routine |
MODULE_CATALOG | VARCHAR(128) | module name of the routine |
MODULE_SCHEMA | VARCHAR(128) | schema name of the module in which the routine is defined |
MODULE_NAME | VARCHAR(128) | name of the module in which the routine is defined |
UDT_CATALOG | VARCHAR(128) | catalog name of the user-defined data type which defined the routine as a method function |
UDT_SCHEMA | VARCHAR(128) | schema name of the user-defined data type which defined the routine as a method function |
UDT_NAME | VARCHAR(128) | name of the user-defined data type which defined the routine as a method function |
DATA_TYPE | VARCHAR(128) | data type the routine returns |
CHARACTER_MAXIMUM_LENGTH | NUMBER | maximum character length of data type the routine returns |
CHARACTER_OCTET_LENGTH | NUMBER | maximum character length in octets of data type the routine returns |
CHARACTER_SET_CATALOG | VARCHAR(128) | character set catalog name of data type the routine returns |
CHARACTER_SET_SCHEMA | VARCHAR(128) | character set schema name of data type the routine returns |
CHARACTER_SET_NAME | VARCHAR(128) | character set name of data type the routine returns |
COLLATION_CATALOG | VARCHAR(128) | collation catalog name of data type the routine returns |
COLLATION_SCHEMA | VARCHAR(128) | collation schema name of data type the routine returns |
COLLATION_NAME | VARCHAR(128) | collation name of data type the routine returns |
NUMERIC_PRECISION | NUMBER | precision of data type the routine returns |
NUMERIC_PRECISION_RADIX | NUMBER | precision radix of data type the routine returns |
NUMERIC_SCALE | NUMBER | scale of data type the routine returns |
DATETIME_PRECISION | NUMBER | fractional seconds precision of data type the routine returns |
INTERVAL_TYPE | VARCHAR(32) | interval qualifier for data type the routine returns |
INTERVAL_PRECISION | NUMBER | interval leading field precision of data type the routine returns |
TYPE_UDT_CATALOG | VARCHAR(128) | catalog name of the user-defined data type, which is the data type the routine returns |
TYPE_UDT_SCHEMA | VARCHAR(128) | schema name of the user-defined data type, which is the data type the routine returns |
TYPE_UDT_NAME | VARCHAR(128) | name of the user-defined data type, which is the data type the routine returns |
SCOPE_CATALOG | VARCHAR(128) | catalog name of referenceable table |
SCOPE_SCHEMA | VARCHAR(128) | schema name of referenceable table |
SCOPE_NAME | VARCHAR(128) | name of referenceable table |
MAXIMUM_CARDINALITY | NUMBER | maximum cardinality of data type the routine returns |
DTD_IDENTIFIER | NUMBER | dtd ientifier of data type the routine returns |
ROUTINE_BODY | VARCHAR(32) | type of the routine body |
ROUTINE_DEFINITION | LONG VARCHAR | catalog name of the routine |
EXTERNAL_NAME | VARCHAR(128) | external name of the external routine |
EXTERNAL_LANGUAGE | VARCHAR(32) | language of the external routine |
PARAMETER_STYLE | VARCHAR(32) | SQL parameter passing style of the external routine |
IS_DETERMINISTIC | BOOLEAN | the routine is deterministic or not |
SQL_DATA_ACCESS | VARCHAR(32) | routine possibly contains SQL or access data |
IS_NULL_CALL | BOOLEAN | routine returns NULL if any of parameter values are NULL |
SQL_PATH | VARCHAR(1024) | described SQL PATH when the routine is defined |
SCHEMA_LEVEL_ROUTINE | BOOLEAN | the routine is schema-level routine |
MAX_DYNAMIC_RESULT_SETS | NUMBER | max result set count of the routine |
IS_USER_DEFINED_CAST | BOOLEAN | the routine is a function that is a user-defined cast function |
IS_IMPLICITLY_INVOCABLE | BOOLEAN | the user-defined cast function is implicitly invocable |
SECURITY_TYPE | VARCHAR(32) | security type of the routine(DEFINER/INVOKER) |
TO_SQL_SPECIFIC_CATALOG | VARCHAR(128) | catalog name of the to-sql routine of the result type of routine |
TO_SQL_SPECIFIC_SCHEMA | VARCHAR(128) | schema name of the to-sql routine of the result type of routine |
TO_SQL_SPECIFIC_NAME | VARCHAR(128) | name of the to-sql routine of the result type of routine |
AS_LOCATOR | BOOLEAN | return value of the routine is passed as locator |
CREATED | TIMESTAMP(2) WITHOUT TIME ZONE | creation time of the routine |
LAST_ALTERED | TIMESTAMP(2) WITHOUT TIME ZONE | most lately altered time of the routine |
NEW_SAVEPOINT_LEVEL | BOOLEAN | specifiy new savepoint level or not |
IS_UDT_DEPENDENT | BOOLEAN | routine is dependent |
RESULT_CAST_FROM_DATA_TYPE | VARCHAR(128) | data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_AS_LOCATOR | BOOLEAN | locator indication which is specificed in result cast clause of the routine definition |
RESULT_CAST_CHAR_MAX_LENGTH | NUMBER | maximum character length of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_CHAR_OCTET_LENGTH | NUMBER | maximum character length in octets of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_CHAR_SET_CATALOG | VARCHAR(128) | character set catalog name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_CHAR_SET_SCHEMA | VARCHAR(128) | character set schema name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_CHARACTER_SET_NAME | VARCHAR(128) | character set name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_COLLATION_CATALOG | VARCHAR(128) | collation catalog name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_COLLATION_SCHEMA | VARCHAR(128) | collation schema name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_COLLATION_NAME | VARCHAR(128) | collation name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_NUMERIC_PRECISION | NUMBER | precision of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_NUMERIC_RADIX | NUMBER | precision radix of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_NUMERIC_SCALE | NUMBER | scale of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_DATETIME_PRECISION | NUMBER | fractional seconds precision of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_INTERVAL_TYPE | VARCHAR(32) | interval qualifier of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_INTERVAL_PRECISION | NUMBER | interval precision of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_TYPE_UDT_CATALOG | VARCHAR(128) | UDT catalog name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_TYPE_UDT_SCHEMA | VARCHAR(128) | UDT schema name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_TYPE_UDT_NAME | VARCHAR(128) | UDT name of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_SCOPE_CATALOG | VARCHAR(128) | catalog name of referenceable table described in result cast clause of the routine definition |
RESULT_CAST_SCOPE_SCHEMA | VARCHAR(128) | schema name of referenceable table described in result cast clause of the routine definition |
RESULT_CAST_SCOPE_NAME | VARCHAR(128) | name of referenceable table described in result cast clause of the routine definition |
RESULT_CAST_MAX_CARDINALITY | NUMBER | maximum cardinality of data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_DTD_IDENTIFIER | NUMBER | dtd identifier of data type which is specificed in result cast clause of the routine definition |
DECLARED_DATA_TYPE | VARCHAR(128) | declared data type of the routine returns |
DECLARED_NUMERIC_PRECISION | NUMBER | declared data type precision of the routine returns |
DECLARED_NUMERIC_SCALE | NUMBER | declared data type scale of the routine returns |
RESULT_CAST_FROM_DECLARED_DATA_TYPE | VARCHAR(128) | declared data type which is specificed in result cast clause of the routine definition |
RESULT_CAST_DECLARED_NUMERIC_PRECISION | NUMBER | declared data type precision which is specificed in result cast clause of the routine definition |
RESULT_CAST_DECLARED_NUMERIC_SCALE | NUMBER | declared data type scale which is specificed in result cast clause of the routine definition |
ROUTINE_MODULE_USAGE
Identify the SQL-server modules owned by a given user or role on which SQL routines defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the routine |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of the routine |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the routine |
SPECIFIC_NAME | VARCHAR(128) | specific name of the routine |
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module of contained in routine body of the SQL-invoked routine |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module of contained in routine body of the SQL-invoked routine |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module of contained in routine body of the SQL-invoked routine |
MODULE_NAME | VARCHAR(128) | SQL-server module name of contained in routine body of the SQL-invoked routine |
ROUTINE_PRIVILEGES
Identify the privileges on SQL-invoked routines defined in this catalog that are available to or granted by a given user or role.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | authorization name of the user who granted routine privileges |
GRANTEE | VARCHAR(128) | authorization name of some user or role, or PUBLIC to indicate all users, to whom the routine privilege being described is granted |
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the SQL-invoked routine on which the privilege being described was granted |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of the the SQL-invoked routine on which the privilege being described was granted |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the the SQL-invoked routine on which the privilege being described was granted |
SPECIFIC_NAME | VARCHAR(128) | specific name of the the SQL-invoked routine on which the privilege being described was granted |
ROUTINE_CATALOG | VARCHAR(128) | routine catalog name of the SQL-invoked routine on which the privilege being described was granted |
ROUTINE_OWNER | VARCHAR(128) | null |
ROUTINE_SCHEMA | VARCHAR(128) | routine schema name of the the SQL-invoked routine on which the privilege being described was granted |
ROUTINE_NAME | VARCHAR(128) | routine name of the the SQL-invoked routine on which the privilege being described was granted |
PRIVILEGE_TYPE | VARCHAR(32) | the value is in ( EXECUTE ) |
IS_GRANTABLE | BOOLEAN | is grantable |
ROUTINE_ROUTINE_USAGE
Identify each SQL-invoked routine owned by a given user or role on which an SQL routine defined in this catalog is dependent.
Column name | Data type | Description |
|---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the routine |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of the routine |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the routine |
SPECIFIC_NAME | VARCHAR(128) | specific name of the routine |
ROUTINE_CATALOG | VARCHAR(128) | routine catalog name of a routine contained in routine body of the SQL-invoked routine |
ROUTINE_OWNER | VARCHAR(128) | routine owner name of a routine contained in routine body of the SQL-invoked routine |
ROUTINE_SCHEMA | VARCHAR(128) | routine schema name of a routine contained in routine body of the SQL-invoked routine |
ROUTINE_NAME | VARCHAR(128) | routine name of a routine contained in routine body of the SQL-invoked routine |
ROUTINE_SEQUENCE_USAGE
Identify each external sequence generator owned by a given user or role on which some SQL routine defined in this catalog is dependent.
Column name | Data type | Description |
|---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the routine |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of the routine |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the routine |
SPECIFIC_NAME | VARCHAR(128) | specific name of the routine |
SEQUENCE_CATALOG | VARCHAR(128) | catalog name of the sequence of contained in routine body of the SQL-invoked routine |
SEQUENCE_OWNER | VARCHAR(128) | owner name of the sequence of contained in routine body of the SQL-invoked routine |
SEQUENCE_SCHEMA | VARCHAR(128) | schema name of the sequence of contained in routine body of the SQL-invoked routine |
SEQUENCE_NAME | VARCHAR(128) | sequence name of contained in routine body of the SQL-invoked routine |
ROUTINE_TABLE_USAGE
Identify the tables owned by a given user or role on which SQL routines defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of the routine |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of the routine |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of the routine |
SPECIFIC_NAME | VARCHAR(128) | specific name of the routine |
TABLE_CATALOG | VARCHAR(128) | catalog name of the table of contained in routine body of the SQL-invoked routine |
TABLE_OWNER | VARCHAR(128) | owner name of the table of contained in routine body of the SQL-invoked routine |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table of contained in routine body of the SQL-invoked routine |
TABLE_NAME | VARCHAR(128) | table name of contained in routine body of the SQL-invoked routine |
SCHEMATA
Identify the schemata in a catalog that are owned by given user or accessible to given user or role.
Column name | Data type | Description |
|---|---|---|
CATALOG_NAME | VARCHAR(128) | catalog name of the schema |
SCHEMA_NAME | VARCHAR(128) | schema name |
SCHEMA_OWNER | VARCHAR(128) | authorization name who owns the schema |
DEFAULT_CHARACTER_SET_CATALOG | VARCHAR(128) | catalog name of the default character set for columns and domains in the schemata |
DEFAULT_CHARACTER_SET_SCHEMA | VARCHAR(128) | schema name of the default character set for columns and domains in the schemata |
DEFAULT_CHARACTER_SET_NAME | VARCHAR(128) | character set name of the default character set for columns and domains in the schemata |
SQL_PATH | VARCHAR(1024) | character representation of schema path specification |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | created time of the schema |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | last modified time of the schema |
COMMENTS | VARCHAR(1024) | comments of the schema |
SEQUENCES
Identify the external sequence generators defined in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
SEQUENCE_CATALOG | VARCHAR(128) | catalog name of the sequence |
SEQUENCE_OWNER | VARCHAR(128) | owner name of the sequence |
SEQUENCE_SCHEMA | VARCHAR(128) | schema name of the sequence |
SEQUENCE_NAME | VARCHAR(128) | sequence name |
DATA_TYPE | VARCHAR(128) | the standard name of the data type |
NUMERIC_PRECISION | NUMBER | the numeric precision of the numerical data type |
NUMERIC_PRECISION_RADIX | NUMBER | the radix ( 2 or 10 ) of the precision of the numerical data type |
NUMERIC_SCALE | NUMBER | the numeric scale of the exact numerical data type |
START_VALUE | NUMBER | the start value of the sequence generator |
MINIMUM_VALUE | NUMBER | the minimum value of the sequence generator |
MAXIMUM_VALUE | NUMBER | the maximum value of the sequence generator |
INCREMENT | NUMBER | the increment of the sequence generator |
CYCLE_OPTION | BOOLEAN | cycle option |
CACHE_SIZE | NATIVE_INTEGER | number of sequence numbers to cache |
DECLARED_DATA_TYPE | VARCHAR(128) | the data type name that a user declared |
DECLARED_NUMERIC_PRECISION | NUMBER | the precision value that a user declared |
DECLARED_NUMERIC_SCALE | NUMBER | the scale value that a user declared |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | created time of the sequence generator |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | last modified time of the sequence generator |
COMMENTS | VARCHAR(1024) | comments of the sequence generator |
SQL_FEATURES
List the features and subfeatures of this ISO/IEC 9075 standard, and indicate which of these the SQL-implementation supports.
Column name | Data type | Description |
|---|---|---|
FEATURE_ID | VARCHAR(32) | identifier string of the conformance element |
FEATURE_NAME | VARCHAR(1024) | descriptive name of the conformance element |
SUB_FEATURE_ID | VARCHAR(32) | identifier string of the subfeature, or a single space if not a subfeature |
SUB_FEATURE_NAME | VARCHAR(1024) | descriptive name of the subfeature, or a single space if not a subfeature |
IS_SUPPORTED | BOOLEAN | TRUE if an SQL-implementation fully supports that conformance element described when SQL-data in the identified catalog is accessed through that implementation, FALSE if not |
IS_VERIFIED_BY | VARCHAR(1024) | If full support for the conformance element described has been verified by testing, then the IS_VERIFIED_BY column shall contain information identifying the conformance test used to verify the conformance claim; otherwise, IS_VERIFIED_BY shall be the null value |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the conformance element |
SQL_IMPLEMENTATION_INFO
List the SQL-implementation information items defined in this ISO/IEC 9075 standard and, for each of these, indicate the value supported by the SQL-implementation.
Column name | Data type | Description |
|---|---|---|
IMPLEMENTATION_INFO_ID | VARCHAR(32) | identifier string of the implementation information item |
IMPLEMENTATION_INFO_NAME | VARCHAR(1024) | descriptive name of the implementation information item |
INTEGER_VALUE | NATIVE_INTEGER | value of the implementation information item, or null if the value is contained in the column CHARACTER_VALUE |
CHARACTER_VALUE | VARCHAR(32) | value of the implementation information item, or null if the value is contained in the column INTEGER_VALUE |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the implementation information item |
SQL_PACKAGES
List the packages of this ISO/IEC 9075 standard, and indicate which of these the SQL-implementation supports.
Column name | Data type | Description |
|---|---|---|
ID | VARCHAR(32) | identifier string of the conformance element |
NAME | VARCHAR(1024) | descriptive name of the conformance element |
IS_SUPPORTED | BOOLEAN | TRUE if an SQL-implementation fully supports that conformance element described when SQL-data in the identified catalog is accessed through that implementation, FALSE if not |
IS_VERIFIED_BY | VARCHAR(1024) | If full support for the conformance element described has been verified by testing, then the IS_VERIFIED_BY column shall contain information identifying the conformance test used to verify the conformance claim; otherwise, IS_VERIFIED_BY shall be the null value |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the conformance element |
SQL_PARTS
List the parts of this ISO/IEC 9075 standard, and indicate which of these the SQL-implementation supports.
Column name | Data type | Description |
|---|---|---|
ID | VARCHAR(32) | identifier string of the conformance element |
NAME | VARCHAR(1024) | descriptive name of the conformance element |
IS_SUPPORTED | BOOLEAN | TRUE if an SQL-implementation fully supports that conformance element described when SQL-data in the identified catalog is accessed through that implementation, FALSE if not |
IS_VERIFIED_BY | VARCHAR(1024) | If full support for the conformance element described has been verified by testing, then the IS_VERIFIED_BY column shall contain information identifying the conformance test used to verify the conformance claim; otherwise, IS_VERIFIED_BY shall be the null value |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the conformance element |
SQL_SIZING
List the sizing items of this ISO/IEC 9075 standard, for each of these, indicate the size supported by the SQL-implementation.
Column name | Data type | Description |
|---|---|---|
SIZING_ID | NATIVE_INTEGER | identifier of the sizing item |
SIZING_NAME | VARCHAR(1024) | descriptive name of the sizing item |
SUPPORTED_VALUE | NATIVE_INTEGER | value of the sizing item, or 0 if the size is unlimited or cannot be determined, or null if the features for which the sizing item is applicable are not supported |
COMMENTS | VARCHAR(1024) | possibly a comment pertaining to the sizing item |
STATISTICS
Provide a list of statistics about a single table and the indexes associated with the table that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the table |
TABLE_OWNER | VARCHAR(128) | owner name of the table |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table |
TABLE_NAME | VARCHAR(128) | table name of the table |
STAT_TYPE | VARCHAR(32) | statistics type: the value in ( TABLE STAT, INDEX CLUSTERED, INDEX HASHED, INDEX OTHER ) |
NON_UNIQUE | BOOLEAN | indicates whether the index does not allow duplicate values |
INDEX_CATALOG | VARCHAR(128) | catalog name of the index |
INDEX_OWNER | VARCHAR(128) | owner name of the index |
INDEX_SCHEMA | VARCHAR(128) | schema name of the index |
INDEX_NAME | VARCHAR(128) | name of the index |
COLUMN_NAME | VARCHAR(128) | column name that participates in the index |
ORDINAL_POSITION | NUMBER | ordinal position of the specific column in the index described |
IS_ASCENDING_ORDER | BOOLEAN | index key column being described is sorted in ASCENDING(TRUE) or DESCENDING(FALSE) order |
IS_NULLS_FIRST | BOOLEAN | the null values of the key column are sorted before(TRUE) or after(FALSE) non-null values |
CARDINALITY | NUMBER | if STAT_TYPE is (TABLE TYPE), then this is the number of rows in the table; otherwise, it is the number of unique values in the index |
PAGES | NUMBER | if STAT_TYPE is (TABLE TYPE), then this is the number of pages used for the table; otherwise, it is the number of pages used for the current index. |
FILTER_CONDITION | VARCHAR(1024) | filter condition, if any. |
COMMENTS | VARCHAR(1024) | if STAT_TYPE is (TABLE TYPE), then this is the table comments; otherwise, it is the index comments. |
TABLES
Identify the tables defined in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the table |
TABLE_OWNER | VARCHAR(128) | owner name of the table |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table |
TABLE_NAME | VARCHAR(128) | table name of the table |
TABLE_TYPE | VARCHAR(32) | the value is in ( BASE TABLE, VIEW, GLOBAL TEMPORARY, LOCAL TEMPORARY, SYSTEM VERSIONED, FIXED TABLE, DUMP TABLE ) |
DBC_TABLE_TYPE | VARCHAR(32) | ODBC/JDBC table type: the value is in ( TABLE, VIEW, GLOBAL TEMPORARY, LOCAL TEMPORARY, IMMUTABLE TABLE, SYSTEM TABLE, ALIAS, SYNONYM ) |
TABLESPACE_NAME | VARCHAR(128) | tablespace name of the table, NULL if view |
SYSTEM_VERSION_START_COLUMN_NAME | VARCHAR(128) | if the table is a system-versioned table, then the name of the system-version start column of the table |
SYSTEM_VERSION_END_COLUMN_NAME | VARCHAR(128) | if the table is a system-versioned table, then the name of the system-version end column of the table |
SYSTEM_VERSION_RETENTION_PERIOD | VARCHAR(32) | if the table is a system-versioned table, then the character representation of the value of the retention period of the table |
SELF_REFERENCING_COLUMN_NAME | VARCHAR(128) | if the table is a typed table, then the name of the self-referencing column of the table |
REFERENCE_GENERATION | VARCHAR(32) | if the table has a self-referencing column, the value is in ( SYSTEM GENERATED, USER GENERATED, DERIVED ) |
USER_DEFINED_TYPE_CATALOG | VARCHAR(128) | if the table being described is a table of a structured type, the catalog name of the structured type |
USER_DEFINED_TYPE_SCHEMA | VARCHAR(128) | if the table being described is a table of a structured type, the schema name of the structured type |
USER_DEFINED_TYPE_NAME | VARCHAR(128) | if the table being described is a table of a structured type, the name of the structured type |
IS_INSERTABLE_INTO | BOOLEAN | is an insertable-into table |
IS_TYPED | BOOLEAN | is a typed table |
COMMIT_ACTION | VARCHAR(32) | if the table is a temporary table, the value is in ( DELETE, PRESERVE ) |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | created time of the table |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | last modified time of the table |
COMMENTS | VARCHAR(1024) | comments of the table |
TABLE_CONSTRAINTS
Identify the table constraints defined on tables in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
CONSTRAINT_CATALOG | VARCHAR(128) | catalog name of the constraint |
CONSTRAINT_OWNER | VARCHAR(128) | authorization name who owns the constraint |
CONSTRAINT_SCHEMA | VARCHAR(128) | schema name of the constraint being described |
CONSTRAINT_NAME | VARCHAR(128) | constraint name |
TABLE_CATALOG | VARCHAR(128) | catalog name of the table to which the table constraint being described applies |
TABLE_OWNER | VARCHAR(128) | authorization name who owns the table to to which the table constraint being described applies |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table to to which the table constraint being described applies |
TABLE_NAME | VARCHAR(128) | table name of the table to to which the table constraint being described applies |
CONSTRAINT_TYPE | VARCHAR(32) | the value is in ( PRIMARY KEY, UNIQUE, FOREIGN KEY, NOT NULL, CHECK ) |
IS_DEFERRABLE | BOOLEAN | is a deferrable constraint |
INITIALLY_DEFERRED | BOOLEAN | is an initially deferred constraint |
ENFORCED | BOOLEAN | is an enforced constraint |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | created time of the constraint |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | last modified time of the constraint |
COMMENTS | VARCHAR(1024) | comments of the constraint |
TABLE_PRIVILEGES
Identify the privileges on tables defined in this catalog that are available to or granted by a given user or role.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | authorization name of the user who granted table privileges |
GRANTEE | VARCHAR(128) | authorization name of some user or role, or PUBLIC to indicate all users, to whom the table privilege being described is granted |
TABLE_CATALOG | VARCHAR(128) | catalog name of the table on which the privilege being described was granted |
TABLE_OWNER | VARCHAR(128) | table owner name of the table on which the privilege being described was granted |
TABLE_SCHEMA | VARCHAR(128) | schema name of the table on which the privilege being described was granted |
TABLE_NAME | VARCHAR(128) | table name on which the privilege being described was granted |
PRIVILEGE_TYPE | VARCHAR(32) | the value is in ( CONTROL, SELECT, INSERT, UPDATE, DELETE, REFERENCES, LOCK, INDEX, ALTER ) |
IS_GRANTABLE | BOOLEAN | is grantable |
WITH_HIERARCHY | BOOLEAN | whether the privilege was granted WITH HIERARCHY OPTION or not |
USAGE_PRIVILEGES
Identify the USAGE privileges on objects defined in this catalog that are available to or granted by a given user or role.
Column name | Data type | Description |
|---|---|---|
GRANTOR | VARCHAR(128) | authorization name of the user who granted usage privileges, on the object of the type identified by OBJECT_TYPE |
GRANTEE | VARCHAR(128) | authorization identifier of some user or role, or PUBLIC to indicate all users, to whom the usage privilege being described is granted |
OBJECT_CATALOG | VARCHAR(128) | catalog name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted |
OBJECT_OWNER | VARCHAR(128) | owner name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted |
OBJECT_SCHEMA | VARCHAR(128) | schema name of the object of the type identified by OBJECT_TYPE on which the privilege being described was granted |
OBJECT_NAME | VARCHAR(128) | object name of the type identified by OBJECT_TYPE on which the privilege being described was granted |
OBJECT_TYPE | VARCHAR(32) | the value is in ( DOMAIN, CHARACTER SET, COLLATION, TRANSLATION, SEQUENCE ) |
PRIVILEGE_TYPE | VARCHAR(32) | the value is in ( USAGE ) |
IS_GRANTABLE | BOOLEAN | is grantable |
VIEWS
Identify the viewed tables defined in this catalog that are accessible to a given user or role.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the viewed table |
TABLE_OWNER | VARCHAR(128) | owner name of the viewed table |
TABLE_SCHEMA | VARCHAR(128) | schema name of the viewed table |
TABLE_NAME | VARCHAR(128) | view name of the viewed table |
VIEW_DEFINITION | LONG VARCHAR | the character representation of the user-specified query expression contained in the corresponding view descriptor |
CHECK_OPTION | VARCHAR(32) | the value is in ( CASCADED, LOCAL, NONE ) |
IS_UPDATABLE | BOOLEAN | is an updatable view |
INSERTABLE_INTO | BOOLEAN | is an insertable view |
IS_TRIGGER_UPDATABLE | BOOLEAN | whether an update INSTEAD OF trigger is defined on the view or not |
IS_TRIGGER_DELETABLE | BOOLEAN | whether a delete INSTEAD OF trigger is defined on the view or not |
IS_TRIGGER_INSERTABLE_INTO | BOOLEAN | whether an insert INSTEAD OF trigger is defined on the view or not |
IS_COMPILED | BOOLEAN | whether the view is compiled or not |
IS_AFFECTED | BOOLEAN | whether the view is affected by modification of underlying object or not |
COMMENTS | VARCHAR(1024) | comments of the view |
VIEW_MODULE_USAGE
Identify the SQL-server modules owned by a given user or role on which views defined in this catalog are dependent.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the viewed table |
TABLE_OWNER | VARCHAR(128) | owner name of the viewed table |
TABLE_SCHEMA | VARCHAR(128) | schema name of the viewed table |
TABLE_NAME | VARCHAR(128) | view name of the viewed table |
MODULE_CATALOG | VARCHAR(128) | catalog name of the SQL-server module of contained in definition text of the view |
MODULE_OWNER | VARCHAR(128) | owner name of the SQL-server module of contained in definition text of the view |
MODULE_SCHEMA | VARCHAR(128) | schema name of the SQL-server module of contained in definition text of the view' |
MODULE_NAME | VARCHAR(128) | SQL-server module name of contained in definition text of the view |
VIEW_ROUTINE_USAGE
Identify each routine owned by a given user or role on which a view defined in this catalog is dependent.
Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG | VARCHAR(128) | catalog name of the viewed table |
TABLE_OWNER | VARCHAR(128) | owner name of the viewed table |
TABLE_SCHEMA | VARCHAR(128) | schema name of the viewed table |
TABLE_NAME | VARCHAR(128) | view name of the viewed table |
SPECIFIC_CATALOG | VARCHAR(128) | specific catalog name of a routine contained in the query expression of the view being described |
SPECIFIC_OWNER | VARCHAR(128) | specific owner name of a routine contained in the query expression of the view being described |
SPECIFIC_SCHEMA | VARCHAR(128) | specific schema name of a routine contained in the query expression of the view being described |
SPECIFIC_NAME | VARCHAR(128) | specific name of a routine contained in the query expression of the view being described |
VIEW_TABLE_USAGE
Identify the tables on which viewed tables defined in this catalog and owned by a given user or role are dependent.
Column name | Data type | Description |
|---|---|---|
VIEW_CATALOG | VARCHAR(128) | catalog name of the viewed table |
VIEW_OWNER | VARCHAR(128) | owner name of the viewed table |
VIEW_SCHEMA | VARCHAR(128) | schema name of the viewed table |
VIEW_NAME | VARCHAR(128) | view name of the viewed table |
TABLE_CATALOG | VARCHAR(128) | catalog name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described |
TABLE_OWNER | VARCHAR(128) | owner name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described |
TABLE_SCHEMA | VARCHAR(128) | schema name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described |
TABLE_NAME | VARCHAR(128) | table name of a table that is explicitly or implicitly referenced in the original query expression of the compiled view being described |
PERFORMANCE_VIEW_SCHEMA
PERFORMANCE_VIEW_SCHEMA 스키마는 시스템의 현재 상태 정보를 조회할 수 있는 view들로 구성되어 있다.
해당 view들을 사용하려면 다음과 같이 PerformanceViewSchema.sql을 실행해야 한다.
Standalone의 경우
% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/standalone/PerformanceViewSchema.sql
Cluster의 경우
% gsql sys gliese --as sysdba --import $GOLDILOCKS_HOME/admin/cluster/PerformanceViewSchema.sql
PERFORMANCE_VIEW_SCHEMA의 view들은 startup 단계 (nomount, mount, open)별로 조회할 수 있는 정보가 다르다. 각각의 view를 어떤 시작 단계에서 조회할 수 있는지는 다음과 같은 질의를 통해 확인할 수 있다.
gSQL> select table_name, startup_phase from v$tables order by 1; TABLE_NAME STARTUP_PHASE -------------------------- ------------- V$AGABLE_INFO OPEN V$ARCHIVELOG MOUNT V$AUDITABLE_DB_PRIVILEGES NO_MOUNT V$AUDITABLE_SYSTEM_ACTIONS NO_MOUNT V$BACKUP MOUNT V$BALANCER OPEN V$BCH MOUNT V$BUFFER_STAT MOUNT V$COLUMNS OPEN V$CONTROLFILE MOUNT V$DATAFILE MOUNT V$DB_CHANGE_TRACKING MOUNT V$DB_FILE MOUNT V$DISPATCHER OPEN V$ERROR_CODE NO_MOUNT V$INCREMENTAL_BACKUP MOUNT V$INSTANCE NO_MOUNT V$KEYWORDS NO_MOUNT V$LATCH NO_MOUNT V$LOCK_WAIT OPEN TABLE_NAME STARTUP_PHASE ---------------------- ------------- V$LOGFILE MOUNT V$PLAN_HISTORY OPEN V$PLAN_HISTORY_LATEST OPEN V$PROCESS_MEM_STAT NO_MOUNT V$PROCESS_SQL_STAT NO_MOUNT V$PROCESS_STAT NO_MOUNT V$PROPERTY NO_MOUNT V$PSM_RESERVED_WORDS NO_MOUNT V$QUEUE OPEN V$RESERVED_WORDS NO_MOUNT V$SEQUENCE OPEN V$SESSION NO_MOUNT V$SESSION_AUDIT OPEN V$SESSION_CONNECT_INFO NO_MOUNT V$SESSION_EVENT OPEN V$SESSION_MEM_STAT NO_MOUNT V$SESSION_SQL_STAT NO_MOUNT V$SESSION_STAT NO_MOUNT V$SESSION_WAIT OPEN V$SHARED_MODE OPEN TABLE_NAME STARTUP_PHASE ----------------------- ------------- V$SHARED_SERVER OPEN V$SHM_SEGMENT NO_MOUNT V$SPROPERTY NO_MOUNT V$SQLFN_METADATA NO_MOUNT V$SQL_CACHE NO_MOUNT V$SQL_COMMAND NO_MOUNT V$SQL_HISTORY NO_MOUNT V$STATEMENT NO_MOUNT V$SYSTEM_EVENT OPEN V$SYSTEM_MEM_STAT NO_MOUNT V$SYSTEM_SQL_STAT NO_MOUNT V$SYSTEM_STAT NO_MOUNT V$TABLES NO_MOUNT V$TABLESPACE MOUNT V$TABLESPACE_STAT OPEN V$TRANSACTION OPEN V$WAIT_EVENT_CLASS_NAME OPEN V$WAIT_EVENT_NAME OPEN V$XA_TRANSACTION OPEN 59 rows selected.
GV$ Global View
Cluster에서는 거의 모든 V$ view에 대응하는 GV$ view를 제공한다. V$ view가 현재 접속한 서버의 정보를 조회하는 반면에 GV$ view는 모든 서버의 정보를 조회한다. GV$ view는 V$ view의 모든 column 정보를 포함하는데 이에 추가로 데이터를 획득한 서버 (cluster member)를 의미하는 ORIGIN_MEMBER_NAME column을 갖는다.
Cluster에서만 사용할 수 있다.
예를 들어, V$TRANSACTION 정보는 다음과 같이 현재 접속한 서버의 트랜잭션 정보를 보여준다.
gSQL> SELECT TRANS_ID, SESSION_ID, TRANS_VIEW_SCN, START_TIME FROM V$TRANSACTION; TRANS_ID SESSION_ID TRANS_VIEW_SCN START_TIME -------- ---------- -------------- -------------------------- 40501296 48 1098.1.26 2017-04-07 17:14:01.912637
이에 반해, GV$TRANSACTION 정보는 다음과 같이 모든 서버의 트랜잭션 정보를 보여준다.
gSQL> SELECT ORIGIN_MEMBER_NAME, TRANS_ID, SESSION_ID, TRANS_VIEW_SCN, START_TIME FROM GV$TRANSACTION; ORIGIN_MEMBER_NAME TRANS_ID SESSION_ID TRANS_VIEW_SCN START_TIME ------------------ -------- ---------- -------------- -------------------------- G1N1 40501296 48 1098.1.26 2017-04-07 17:14:01.912637 G2N2 40304688 48 1098.0.888 2017-04-07 17:14:55.134015 G2N1 42205232 48 1098.0.888 2017-04-07 17:14:55.135996 G1N2 40435760 48 1098.1.889 2017-04-07 17:14:01.910138
위의 예에서 ORIGIN_MEMBER_NAME 정보는 각 트랜잭션 정보를 G1N1, G2N1, G1N2, G2N2에 해당하는 cluster member로부터 획득했음을 알 수 있다.
특정 원격 서버에 대한 정보는 다음과 같이 ORIGIN_MEMBER_NAME column에 대한 조건을 사용하여 조회할 수 있다.
gSQL> SELECT ORIGIN_MEMBER_NAME, TRANS_ID, SESSION_ID, TRANS_VIEW_SCN, START_TIME FROM GV$TRANSACTION WHERE ORIGIN_MEMBER_NAME IN ( 'G2N1', 'G3N2' ); ORIGIN_MEMBER_NAME TRANS_ID SESSION_ID TRANS_VIEW_SCN START_TIME ------------------ -------- ---------- -------------- -------------------------- G3N2 32178224 48 1099.0.888 2017-04-07 17:33:10.934752 G2N1 42270768 48 1099.0.888 2017-04-07 17:31:14.726007 2 rows selected.
V$AGABLE_INFO
The V$AGABLE_INFO displays the system agable information.
Column name | Data type | Description |
|---|---|---|
SCN | VARCHAR(32) | system scn |
AGABLE_SCN | VARCHAR(32) | system agable scn |
AGABLE_SCN_GAP | VARCHAR(32) | gap between system scn and agable scn |
OLDEST_SESSION_ID | NUMBER | identifier of session blocking aging |
V$ARCHIVELOG
The V$ARCHIVELOG displays information of log archiving.
Column name | Data type | Description |
|---|---|---|
ARCHIVELOG_MODE | VARCHAR(32) | database log mode: the value in ( NOARCHIVELOG, ARCHIVELOG ) |
LAST_ARCHIVED_LOG | NUMBER | sequence number of last archived log file |
ARCHIVELOG_DIR | VARCHAR(1024) | archive destination path |
ARCHIVELOG_FILE_PREFIX | VARCHAR(128) | file prefix name of the archived log |
V$AUDITABLE_DB_PRIVILEGES
The V$AUDITABLE_DB_PRIVILEGES displays auditable database privileges.
Column name | Data type | Description |
|---|---|---|
PRIVILEGE_ID | NUMBER | database privilege identifier |
PRIVILEGE_NAME | VARCHAR(128) | database privilege name |
V$AUDITABLE_SYSTEM_ACTIONS
The V$AUDITABLE_SYSTEM_ACTIONS displays auditable system actions.
Column name | Data type | Description |
|---|---|---|
ACTION_ID | NUMBER | auditable system action identifier |
ACTION_NAME | VARCHAR(128) | auditable system action name |
V$BACKUP
The V$BACKUP displays information of backup.
Column name | Data type | Description |
|---|---|---|
TBS_NAME | VARCHAR(128) | tablespace name |
BACKUP_STATUS | VARCHAR(16) | indicates whether the tablespace begin backup ( ACTIVE ) or not ( INACTIVE ) |
BACKUP_LSN | NUMBER | the last checkpoint lsn of tablespace when backup started |
V$BALANCER
The V$BALANCER displays information of balancer.
Column name | Data type | Description |
|---|---|---|
PROCESS_ID | NUMBER | balancer process identifier |
CUR_CONNECTIONS | NUMBER | current number of connections |
CONNECTIONS | NUMBER | total number of connections |
CONNECTIONS_HIGHWATER | NUMBER | highest number of connections |
MAX_CONNECTIONS | NUMBER | maximum connections |
STATUS | VARCHAR(16) | status |
V$BCH
The V$BCH displays information of database buffer control header array.
Column name | Data type | Description |
|---|---|---|
BCH_SEQ | NUMBER | bch sequence |
TABLESPACE_ID | NUMBER | tablespace identifier of the page cached in the frame of bch |
PAGE_ID | NUMBER | page identifier of the page cached in the frame of bch |
LOGICAL_ADDRESS | VARCHAR(18) | logical address of the frame of bch |
DIRTY | BOOLEAN | dirty state of the page cached in the frame of bch |
PGAE_TYPE | VARCHAR(20) | page type of the page cached in the frame of bch |
FIRST_DIRTY_LSN | NUMBER | first dirty lsn of the page cached in the frame of bch |
RECOVERY_LSN | NUMBER | recovery lsn of the page cached in the frame of bch |
LAST_FLUSHED_LSN | NUMBER | last flushed lsn of the page cached in the frame of bch |
FIXED_COUNT | NUMBER | fixed count of the page cached in the frame of bch |
TOUCHED_COUNT | NUMBER | touched count of the page cached in the frame of bch |
RECENT_TOUCH_COUNT_INCREASED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | timestamp that touch count of the page cached in the frame of bch increased most recently |
BCH_LIST_TYPE | VARCHAR(16) | list type to which the bch belongs |
BCH_STATE | VARCHAR(16) | bch state |
V$BUFFER_STAT
The V$BUFFER_STAT displays database buffer statistics.
Column name | Data type | Description |
|---|---|---|
BUFFER_POOL_SIZE | NUMBER | total buffer frame size ( page count ) |
HASH_BUCKET_COUNT | NUMBER | buffer hash bucket count |
LRU_LIST_COUNT | NUMBER | buffer lru list count |
HOT_REGION_PERCENTAGE | NUMBER | percentage of lru hot region |
HOT_REGION_CRITERIA | NUMBER | touch count criteria of lru hot region |
CHECKPOINT_LIST_COUNT | NUMBER | buffer checkpoint list count |
FLUSH_LIST_COUNT | NUMBER | buffer flush list count |
FREE_LIST_COUNT | NUMBER | buffer free list count |
FREE_BUFFER_WAIT | NUMBER | total number of waiting for free list |
READ_COMPLETE_WAIT | NUMBER | total number of waiting for read page complete |
BUFFER_LOOKUPS | NUMBER | total number of lookups in the buffer for requested pages |
BUFFER_HIT | NUMBER | total number of hits in the buffer for requested pages |
BUFFER_MISS | NUMBER | total number of misses in the buffer for requested pages |
TOTAL_WRITES | NUMBER | total number of physical writes |
TOTAL_READS | NUMBER | total number of physical reads |
FLUSH_PER_SECOND | NUMBER | total number of disk writes per one second |
READ_PER_SECOND | NUMBER | total number of disk reads per one second |
AVERAGE_WRITE_LATENCY | NUMBER | average latency of disk writes |
AVERAGE_READ_LATENCY | NUMBER | average latency of disk reads |
V$CLUSTER_DISPATCHER
The V$CLUSTER_DISPATCHER displays cluster dispatcher information.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
DISPATCHER_ID | NUMBER | dispatcher identifier |
IS_SYNC | BOOLEAN | whether the dispatcher is sync or not |
RX_BYTES | NUMBER | total amount of data that has received through the dispatcher |
TX_BYTES | NUMBER | total amount of data that has transmitted through the dispatcher |
RX_JOBS | NUMBER | the total number of jobs received |
TX_JOBS | NUMBER | the total number of jobs transmitted |
V$CLUSTER_LOCATION
The V$CLUSTER_LOCATION displays cluster location information.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
MEMBER_NAME | VARCHAR(128) | member name |
HOST | VARCHAR(128) | host address of a member |
PORT | NUMBER | host port of a member |
V$CLUSTER_MEMBER
The V$CLUSTER_MEMBER displays cluster member information.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
MEMBER_ID | NUMBER | member identifier |
MEMBER_POSITION | NUMBER | member position |
STATUS | VARCHAR(64) | status of the member: the value in ( ACTIVE, INACTIVE ) |
IS_GLOBAL_COORD | BOOLEAN | indicates whether a member is global coordnator (TRUE) or not (FALSE) |
IS_GROUP_COORD | BOOLEAN | indicates whether a member is group coordnator (TRUE) or not (FALSE) |
V$COLUMNS
The V$COLUMNS has one row for each column of all the performance views (views beginning with V$).
V$COLUMNS를 사용할 수 없는 nomount와 mount 단계에서 performance view의 column 정보를 조회하려면 아래 예제와 같이 \desc를 사용한다.
gSQL> \desc V$INSTANCE COLUMN_NAME TYPE IS_NULLABLE --------------- ------------------------------ ----------- RELEASE_VERSION VARCHAR(64) FALSE STARTUP_TIME TIMESTAMP(2) WITHOUT TIME ZONE FALSE INSTANCE_STATUS VARCHAR(16) FALSE
Column name | Data type | Description |
|---|---|---|
TABLE_OWNER | VARCHAR(128) | owner name who owns the performance view |
TABLE_SCHEMA | VARCHAR(128) | schema name of the performance view |
TABLE_NAME | VARCHAR(128) | name of the performance view |
COLUMN_NAME | VARCHAR(128) | column name |
ORDINAL_POSITION | NUMBER | the ordinal position (> 0) of the column in the performance view |
DATA_TYPE | VARCHAR(128) | the data type name that a user declared |
DATA_PRECISION | NUMBER | the precision value that a user declared |
DATA_SCALE | NUMBER | the scale value that a user declared |
COMMENTS | VARCHAR(1024) | comments of the column |
V$CONTROLFILE
This view displays information about GOLDILOCKS control files.
Column name | Data type | Description |
|---|---|---|
STATUS | VARCHAR(16) | control file status ( VALID, CORRUPTED ) |
CONTROLFILE_NAME | VARCHAR(1152) | control file name ( absolute path ) |
LAST_CHECKPOINT_LSN | NATIVE_BIGINT | the last checkpoint lsn |
IS_PRIMARY | BOLLEAN | indicates whether the control file is primary |
V$DATAFILE
The V$DATAFILE displays information of all datafiles.
Column name | Data type | Description |
|---|---|---|
TBS_NAME | VARCHAR(128) | tablespace name |
DATAFILE_NAME | VARCHAR(1024) | datafile name ( absolute path ) |
CHECKPOINT_LSN | NUMBER | LSN at last checkpoint ( null if temporary tablespace ) |
CREATION_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | timestamp of the datafile creation |
FILE_SIZE | NUMBER | datafile size ( in bytes ) |
LOADED_CHECKPOINT_LSN | NUMBER | checkpoint LSN of the datafile loaded in memory |
CORRUPT_PAGE_COUNT | NUMBER | number of corrupt pages in the datafile |
V$DB_CHANGE_TRACKING
The V$DB_CHANGE_TRACKING displays information of database change tracking.
Column name | Data type | Description |
|---|---|---|
TABLESPACE_ID | NUMBER | tablespage identifier |
DATAFILE_ID | NUMBER | datafile identifier |
CHANGE_TRACKING_STATE | VARCHAR(32) | state of dtafile change tracking |
CHANGE_TRACKING_CHUNK_SEQ | NUMBER | sequence of change tracking chunk for datafile |
MAX_SIZE | NUMBER | maximum size of datafile (byte) |
BITMAP_BLOCK_COUNT | NUMBER | bitmap block count of change tracking chunk |
LAST_PAGE_SEQ | NUMBER | the last page sequence of change tracking chunk |
V$DB_FILE
The V$DB_FILE displays a list of all files using in database.
Column name | Data type | Description |
|---|---|---|
FILE_NAME | VARCHAR(1024) | file name |
FILE_TYPE | VARCHAR(16) | file type |
V$DISPATCHER
The V$DISPATCHER displays information of dispatchers.
Column name | Data type | Description |
|---|---|---|
PROCESS_ID | NUMBER | dispatcher process identifier |
RESPONSE_JOB_COUNT | NUMBER | response job count |
ACCEPT | NUMBER | indicates whether this dispatcher is accepting new connections |
START_TIME | NUMBER | process start time |
CUR_CONNECTIONS | NUMBER | current number of connections |
CONNECTIONS | NUMBER | total number of connections |
CONNECTIONS_HIGHWATER | NUMBER | highest number of connections |
MAX_CONNECTIONS | NUMBER | maximum connections |
RECV_STATUS | VARCHAR(16) | receive status |
RECV_BYTES | NUMBER | total bytes of received |
RECV_UNITS | NUMBER | total units of received |
RECV_IDLE | NUMBER | total idle time of receive (1/100 second) |
RECV_BUSY | NUMBER | total busy time of receive (1/100 second) |
SEND_STATUS | VARCHAR(16) | send status |
SEND_BYTES | NUMBER | total bytes of sent |
SEND_UNITS | NUMBER | total units of sent |
SEND_IDLE | NUMBER | total idle time of send (1/100 second) |
SEND_BUSY | NUMBER | total busy time of send (1/100 second) |
V$ERROR_CODE
The V$ERROR_CODE displays a list of all GOLDILOCKS error codes.
Column name | Data type | Description |
|---|---|---|
ERROR_CODE | NUMBER | GOLDILOCKS error code |
SQL_STATE | VARCHAR(32) | standard SQLSTATE code |
ERROR_MESSAGE | VARCHAR(1024) | error message |
V$GLOBAL_TRANSACTION
The V$GLOBAL_TRANSACTION displays information on the currently active global transactions.
Column name | Data type | Description |
|---|---|---|
GLOBAL_TRANS_ID | VARCHAR(1024) | global transaction identifier |
LOCAL_TRANS_ID | NUMBER | local transaction identifier |
GLOBAL_TRANS_STATE | VARCHAR(32) | state of the global transaction: the value in ( NOTR, ACTIVE, IDLE, PREPARED, ROLLBACK_ONLY, HEURISTIC_COMPLETED ) |
ASSO_STATE | VARCHAR(32) | associate state of the global transaction: the value in ( NOT_ASSOCIATED, ASSOCIATED, ASSOCIATION_SUSPENDED ) |
START_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | global transaction start time |
IS_REPREPARABLE | BOOLEAN | indicates whether the global transaction is repreparable |
V$INCREMENTAL_BACKUP
The V$INCREMENTAL_BACKUP displays information about control files and datafiles in backup sets from the control file.
Column name | Data type | Description |
|---|---|---|
BACKUP_NAME | VARCHAR(1024) | backup file name ( absolute path ) |
BACKUP_SCOPE | VARCHAR(128) | incremental backup scope: the value in ( database, tablespace, control ) |
INCREMENTAL_LEVEL | NUMBER | incremental backup level: the value in ( 0, 1, 2, 3, 4 ) |
INCREMENTAL_TYPE | VARCHAR(32) | incremental backup type: the value in ( DIFFERENTIAL, CUMULATIVE ) |
LSN | NUMBER | all changes up to checkpoint LSN are included in this backup |
BEGIN_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | incremental backup beginning time |
COMPLETION_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | incremental backup completion time |
V$INSTANCE
This view displays the state of the current instance.
데이터베이스가 open 단계로 전이될 때 READ ONLY나 READ WRITE를 선택할 수 있는데, 만약 생략할 경우 DATABASE_ACCESS_MODE 프로퍼티에 설정된 값을 이용하여 DATA_ACCESS_MODE를 결정한다. 따라서 DATA_ACCESS_MODE는 nomount나 mount 단계에서 NONE으로 표시된다.
Column name | Data type | Description |
|---|---|---|
RELEASE_VERSION | VARCHAR(64) | release version |
STARTUP_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | time when the instance was started |
INSTANCE_STATUS | VARCHAR(16) | status of the instance: the value in ( STARTED, MOUNTED, OPEN ) |
DATA_ACCESS_MODE | VARCHAR(16) | data access mode of the instance: the value in ( NONE, READ_ONLY, READ_WRITE ) |
V$JOURNALING
The V$JOURNALING displays journaling information.
Cluster에서만 사용할 수 있다.
Column name | Data type | Description |
|---|---|---|
TABLE_NAME | VARCHAR(128) | table name |
SHARD_ID | NUMBER | shard identifier |
RECORD_COUNT | NUMBER | journaled record count |
TOTAL_SIZE | NUMBER | total size of journaled records (byte) |
V$KEYWORDS
The V$KEYWORDS displays a list of all SQL keywords.
Column name | Data type | Description |
|---|---|---|
KEYWORD_NAME | VARCHAR(128) | name of keyword |
KEYWORD_LENGTH | NUMBER | length of the keyword |
IS_RESERVED | BOOLEAN | indicates whether the keyword cannot be used as an identifier (TRUE) or whether the keyword is not reserved (FALSE) |
V$LATCH
The V$LATCH shows latch information.
Column name | Data type | Description |
|---|---|---|
LATCH_DESCRIPTION | VARCHAR(64) | latch description |
REF_COUNT | NUMBER | reference count |
SPIN_LOCK | VARCHAR(3) | indicates whether the spin lock is locked ( YES ) or not ( NO ) |
WAIT_COUNT | NUMBER | wait count |
CURRENT_MODE | VARCHAR(32) | current latch mode: the value in ( INITIAL, SHARED, EXCLUSIVE ) |
V$LOGFILE
The V$LOGFILE displays information of all redo log members.
Column name | Data type | Description |
|---|---|---|
GROUP_ID | NUMBER | redo log group identifier |
FILE_NAME | VARCHAR(1024) | name of the log member |
GROUP_STATE | VARCHAR(32) | state of the log group: the value in ( UNUSED, ACTIVE, CURRENT, INACTIVE ) |
FILE_SEQ | NUMBER | file sequence number of the log member |
FILE_SIZE | NUMBER | file size of the log member ( in bytes ) |
V$LOCK_WAIT
This view lists the locks currently held and outstanding requests for a lock.
Column name | Data type | Description |
|---|---|---|
GRANT_TRANS_ID | NUMBER | transaction identifier that holds the lock |
REQUEST_TRANS_ID | NUMBER | transaction identifier that requests the lock |
V$LOCKED_OBJECT
This view shows locked object information.
Column name | Data type | Description |
|---|---|---|
LOCK_SLOT_ID | NUMBER | lock slot identifier |
TABLE_OWNER | VARCHAR(128) | owner name who owns the locked table |
TABLE_SCHEMA | VARCHAR(128) | schema of the locked table |
TABLE_NAME | VARCHAR(128) | locked table name |
LOCK_MODE | VARCHAR(8) | granted lock mode (IS, IX, S, X, SIX) |
V$PLAN_HISTORY
The V$PLAN_HISTORY displays information of SQL plans.
Column name | Data type | Description |
|---|---|---|
DRIVER_MEMBER_POS | NUMBER | driver member position |
DRIVER_SESSION_ID | NUMBER | driver session identifier |
SESSION_ID | NUMBER | session identifier |
STMT_ID | NUMBER | statement identifier in a session |
CL_STMT_ID | NUMBER | cluster statement identifier in a session |
DRIVER_CL_STMT_ID | NUMBER | driver cluster statement identifier in a session |
PLAN_HISTORY_POS | NUMBER | plan history position |
PLAN_HISTORY_ID | NUMBER | plan history identifier |
SQL_TEXT | LONG VARCHAR | SQL text for the statement |
PLAN_TEXT | LONG VARCHAR | plan text for the statement |
LAST_EXEC_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | statement last execution time |
V$PLAN_HISTORY_LATEST
The V$PLAN_HISTORY_LATEST displays information of the latest SQL plan.
Column name | Data type | Description |
|---|---|---|
DRIVER_MEMBER_POS | NUMBER | driver member position |
DRIVER_SESSION_ID | NUMBER | driver session identifier |
SESSION_ID | NUMBER | session identifier |
STMT_ID | NUMBER | statement identifier in a session |
CL_STMT_ID | NUMBER | cluster statement identifier in a session |
DRIVER_CL_STMT_ID | NUMBER | driver cluster statement identifier in a session |
PLAN_HISTORY_POS | NUMBER | plan history position |
PLAN_HISTORY_ID | NUMBER | plan history identifier |
SQL_TEXT | LONG VARCHAR | SQL text for the statement |
PLAN_TEXT | LONG VARCHAR | plan text for the statement |
LAST_EXEC_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | statement last execution time |
V$PROCESS_STAT
The V$PROCESS_STAT displays goldilocks process statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
PROC_ID | NUMBER | goldilocks process identifier |
STAT_VALUE | NUMBER | statistic value |
V$PROCESS_MEM_STAT
The V$PROCESS_MEM_STAT displays goldilocks process memory statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
PROC_ID | NUMBER | goldilocks process identifier |
STAT_VALUE | NUMBER | statistic value |
V$PROCESS_SQL_STAT
The V$PROCESS_SQL_STAT displays goldilocks process SQL statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
PROC_ID | NUMBER | goldilocks process identifier |
STAT_VALUE | NUMBER | statistic value |
V$PROPERTY
The V$PROPERTY displays a list of all properties at current session. Otherwise, the instance-wide value.
Column name | Data type | Description |
|---|---|---|
PROPERTY_NAME | VARCHAR(128) | name of the property |
DESCRIPTION | VARCHAR(2048) | description of the property |
DATA_TYPE | VARCHAR(32) | data type of the property |
STARTUP_PHASE | VARCHAR(32) | modifiable startup-phase: the value IN ( NO MOUNT / MOUNT / OPEN & [BELOW|ABOVE] ) |
VALUE_UNIT | VARCHAR(32) | unit of the property value: the value in ( NONE, BYTE, MS(milisec) ) |
PROPERTY_VALUE | VARCHAR(2048) | property value for the session. otherwise, the instance-wide value |
PROPERTY_SOURCE | VARCHAR(32) | source of the current property value: the value IN ( USER, DEFAULT, ENV_VAR, BINARY_FILE, FILE, SYSTEM ) |
INIT_VALUE | VARCHAR(2048) | property init value for the session |
INIT_SOURCE | VARCHAR(32) | source of the current property INIT_VALUE: the value IN ( USER, DEFAULT, ENV_VAR, BINARY_FILE, FILE, SYSTEM ) |
MIN_VALUE | NUMBER | minimum value for property. null if type is varchar |
MAX_VALUE | NUMBER | maximum value for property. null if type is varchar |
SES_MODIFIABLE | VARCHAR(32) | property can be changed with ALTER SESSION or not: the value in ( TRUE, FALSE ) |
SYS_MODIFIABLE | VARCHAR(32) | property can be changed with ALTER SYSTEM and when the change takes effect: the value in ( NONE, FALSE, IMMEDIATE, DEFERRED ) |
IS_MODIFIABLE | VARCHAR(32) | property can be changed or not: the value in ( TRUE, FALSE ) |
IS_DEPRECATED | VARCHAR(32) | whether a property is deprecated or not: the value in (TRUE, FALSE) |
IS_GLOBAL | VARCHAR(32) | whether a property scope is global or not: the value in (TRUE, FALSE) |
V$PSM_RESERVED_WORDS
The V$PSM_RESERVED_WORDS displays a list of all PSM reserved keywords. Reserved words cannot be used in variable name or procedure name.
Column name | Data type | Description |
|---|---|---|
KEYWORD_NAME | VARCHAR(128) | name of keyword |
KEYWORD_LENGTH | NUMBER | length of the keyword |
V$QUEUE
The V$QUEUE displays information of queue.
Column name | Data type | Description |
|---|---|---|
TYPE | NUMBER | queue type ( COMMON or DISPATCHER ) |
INDEX | NUMBER | index |
QUEUED | NUMBER | number of items in the queue |
WAIT | NUMBER | total time that all items in this queue have waited (1/100 second) |
TOTALQ | VARCHAR(128) | total number of items that have ever been in the queue |
V$RESERVED_WORDS
The V$RESERVED_WORDS displays a list of all SQL reserved keywords. Reserved words cannot be used in table name or column name.
Column name | Data type | Description |
|---|---|---|
KEYWORD_NAME | VARCHAR(128) | name of keyword |
KEYWORD_LENGTH | NUMBER | length of the keyword |
V$SEQUENCE
The V$SEQUENCE displays information of sequences
Column name | Data type | Description |
|---|---|---|
SEQUENCE_NAME | VARCHAR(128) | sequence name |
PHYSICAL_ID | NUMBER | sequence physical identifier |
START_WITH | NUMBER | start with value |
INCREMENT_BY | NUMBER | increment value |
MAXVALUE | NUMBER | maximum value |
MINVALUE | NUMBER | minimum value |
CACHE_SIZE | NUMBER | cache size |
LOCAL_NEXT_VALUE | NUMBER | local next value |
LOCAL_CURR_VALUE | NUMBER | local current value |
RESTART_VALUE | NUMBER | restart value |
CYCLE | BOOLEAN | allow cycle |
USE_LAST_VALUE | BOOLEAN | use last value or not |
LOCAL_CACHE_COUNT | NUMBER | current local cache count |
GLOBAL_NEXT_VALUE | NUMBER | global next cache chunk start value |
SYNC_COMPARE_SN | NUMBER | serial number for global sequence synchronization |
GLOBAL_LATCH_SESSION_ID | NUMBER | identifier of the session acquiring the global latch ( -1 if the latch is not acquired ) |
GLOBAL_LATCH_SESSION_SERIAL | NUMBER | serial number of the session acquiring the global latch ( -1 if the latch is not acquired ) |
DDL_LATCH_SESSION_ID | NUMBER | identifier of the session acquiring the ddl latch ( -1 if the latch is not acquired ) |
DDL_LATCH_SESSION_SERIAL | NUMBER | serial number of the session acquiring the ddl latch ( -1 if the latch is not acquired ) |
LOCAL_LATCH_SESSION_ID | NUMBER | identifier of the session acquiring the local latch ( -1 if the latch is not acquired ) |
LOCAL_LATCH_SESSION_SERIAL | NUMBER | serial number of the session acquiring the local latch ( -1 if the latch is not acquired ) |
IS_ONLINE | BOOLEAN | is online |
LAST_SYNC_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | last time the sequence was synchronized |
V$SESSION
The V$SESSION displays session information for each current session.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | session identifier |
SERIAL_NO | NUMBER | session serial number |
TRANS_ID | NUMBER | transaction identifier ( -1 if inactive transaction ) |
CONNECTION_TYPE | VARCHAR(32) | connection type: the value in ( DA, TCP ) |
USER_NAME | VARCHAR(128) | user name |
SESSION_STATUS | VARCHAR(32) | status of the session: the value in ( CONNECTED, SIGNALED, SNIPED, DEAD ) |
SERVER_TYPE | VARCHAR(32) | server type: the value in ( DEDICATED, SHARED ) |
PROCESS_ID | NUMBER | client process identifier |
LOGON_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | logon time |
PROGRAM_NAME | VARCHAR(128) | program name |
CLIENT_ADDRESS | VARCHAR(1024) | client address ( null if DA ) |
CLIENT_PORT | NUMBER | client port ( 0 if DA ) |
FAILOVER_TYPE | VARCHAR(13) | indicates whether and to what extent transparent application failover (TAF) is enabled for the session ( NONE, SESSION ) |
FAILED_OVER | VARCHAR(3) | indicates whether the session is running in failover mode and failover has occurred (YES) or not (NO) |
IS_AUDITED | VARCHAR(3) | indicates whether the session is audited (YES) or not (NO) |
V$SESSION_AUDIT
The V$SESSION_AUDIT displays audited session information.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | session identifier |
SERIAL_NO | NUMBER | session serial number |
POLICY_NAME | VARCHAR(128) | active audit policy name |
WHEN_SUCCESS | VARCHAR(3) | indicates whether the audit policy is enable for auditing successful events or not |
WHEN_FAILURE | VARCHAR(3) | indicates whether the audit policy is enable for auditing unsuccessful events or not |
V$SESSION_CONNECT_INFO
The V$SESSION_CONNECT_INFO displays information about network connections for the current session.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | session identifier |
SERIAL_NO | NUMBER | session serial number |
CLIENT_CHARSET | VARCHAR(40) | client character set |
V$SESSION_EVENT
The V$SESSION_EVENT displays information on waits for an event by a session.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | ID of the session |
WAIT_EVENT_ID | NUMBER | Identifier of the wait event |
WAIT_EVENT_NAME | VARCHAR(64) | Name of the wait event |
TOTAL_WAITS | NUMBER | Total number of waits for the event |
TOTAL_TIMEOUTS | NUMBER | Total number of timeouts for the event |
TIME_WAITED | NUMBER | Total amount of time waited for the event (microsecond) |
AVERAGE_WAIT | NUMBER | Average amount of time waited for the event (microsecond) |
MAX_WAIT | NUMBER | Maximum time waited for the event by the session (microsecond) |
CLASS_NAME | VARCHAR(64) | Name of the class of the wait event |
V$SESSION_STAT
The V$SESSION_STAT displays session statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
SESS_ID | NUMBER | session identifier |
STAT_VALUE | NUMBER | statistic value |
V$SESSION_MEM_STAT
The V$SESSION_MEM_STAT displays session memory statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
SESS_ID | NUMBER | session identifier |
STAT_VALUE | NUMBER | statistic value |
V$SESSION_MEM_USAGE
The V$SESSION_MEM_USAGE displays session memory usage for each session.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | session identifier |
ALLOCATOR_ID | NUMBER | memory allocator identifier |
ALLOCATOR_TYPE | VARCHAR(7) | memory allocator type ( REGION or DYNAMIC ) |
MEMORY_TYPE | VARCHAR(4) | memory type ( HEAP, SHM ) |
TOTAL_SIZE | NUMBER | total memory size |
V$SESSION_SQL_STAT
The V$SESSION_SQL_STAT displays session SQL statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
SESS_ID | NUMBER | session identifier |
STAT_VALUE | NUMBER | statistic value |
V$SESSION_WAIT
The V$SESSION_WAIT displays the current or last wait for each session.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | ID of the session |
SEQ_NO | NUMBER | Identifier of the wait event |
WAIT_EVENT_ID | NUMBER | Name of the wait event |
WAIT_EVENT_NAME | VARCHAR(64) | A number that uniquely identifies the current or last wait (incremented for each wait) |
P1TEXT | VARCHAR(64) | Description of the first parameter for the wait event |
P1 | NUMBER | First wait event parameter (in decimal) |
P1HEX | VARCHAR(32) | First wait event parameter (in hex) |
P2TEXT | VARCHAR(64) | Description of the second parameter for the wait event |
P2 | NUMBER | Second wait event parameter (in decimal) |
P2HEX | VARCHAR(32) | Second wait event parameter (in hex) |
P3TEXT | VARCHAR(64) | Description of the third parameter for the wait event |
P3 | NUMBER | Third wait event parameter (in decimal) |
P3HEX | VARCHAR(32) | Third wait event parameter (in hex) |
STATE | VARCHAR(64) | Wait state |
WAIT_TIME | NUMBER | If the session is currently waiting, then the value is time waited for the current wait. If the session is not in a wait, then the value is the duration of the last wait (in microseconds) |
TIME_SINCE_LAST_WAIT | NUMBER | Time elapsed since the end of the last wait (in microseconds). If the session is currently in a wait, then the value is 0. |
CLASS_NAME | VARCHAR(64) | Name of the class of the wait event |
V$SHARED_MODE
The V$SHARED_MODE displays information of shared mode.
Column name | Data type | Description |
|---|---|---|
NAME | VARCHAR(128) | name |
VALUE | VARCHAR(128) | value |
V$SHARED_SERVER
The V$SHARED_SERVER displays information of shared servers.
Column name | Data type | Description |
|---|---|---|
PROCESS_ID | NUMBER | shared server process identifier |
PROCESSED_JOB_COUNT | NUMBER | processed job count |
STATUS | VARCHAR(128) | status |
IDLE | NUMBER | total idle time (1/100 second) |
BUSY | NUMBER | total busy time (1/100 second) |
V$SHM_SEGMENT
The V$SHM_SEGMENT displays a list of all shared memory segments.
Column name | Data type | Description |
|---|---|---|
SHM_NAME | VARCHAR(32) | shared memory segment name |
SHM_ID | NUMBER | shared memory segment identifier |
SHM_SIZE | NUMBER | shared memory segment size ( in bytes ) |
SHM_KEY | NUMBER | shared memory segment key |
SHM_SEQ | NUMBER | shared memory segment sequence |
SHM_ADDR | VARCHAR(32) | start address of the shared memory segment |
LARGE_PAGES | BOOLEAN | indicates whether the shared memory segment use large pages |
V$SPROPERTY
The V$SPROPERTY displays a list of Properties. This is store a binary property file.
Column name | Data type | Description |
|---|---|---|
PROPERTY_NAME | VARCHAR(128) | name of the property |
DESCRIPTION | VARCHAR(2048) | description of the property |
DATA_TYPE | VARCHAR(32) | data type of the property |
STARTUP_PHASE | VARCHAR(32) | modifiable startup-phase: the value IN ( NO MOUNT / MOUNT / OPEN & [BELOW|ABOVE] ) |
VALUE_UNIT | VARCHAR(32) | unit of the property value: the value in ( NONE, BYTE, MS(milisec) ) |
PROPERTY_VALUE | VARCHAR(2048) | property value stored in the binary property file |
PROPERTY_SOURCE | VARCHAR(32) | source of the current property value: the value is BINARY_FILE |
INIT_VALUE | VARCHAR(2048) | property init value for the system |
INIT_SOURCE | VARCHAR(32) | source of the current property INIT_VALUE: the value IN ( USER, DEFAULT, ENV_VAR, BINARY_FILE, FILE, SYSTEM ) |
MIN_VALUE | NUMBER | minimum value for property. null if type is varchar |
MAX_VALUE | NUMBER | maximum value for property. null if type is varchar |
SES_MODIFIABLE | VARCHAR(32) | property can be changed with ALTER SESSION or not: the value in ( TRUE, FALSE ) |
SYS_MODIFIABLE | VARCHAR(32) | property can be changed with ALTER SYSTEM and when the change takes effect: the value in ( NONE, FALSE, IMMEDIATE, DEFERRED ) |
IS_MODIFIABLE | VARCHAR(32) | property can be changed or not: the value in ( TRUE, FALSE ) |
IS_DEPRECATED | VARCHAR(32) | whether a property is deprecated or not: the value in (TRUE, FALSE) |
IS_GLOBAL | VARCHAR(32) | whether a property scope is global or not: the value in (TRUE, FALSE) |
V$SQLFN_METADATA
The V$SQLFN_METADATA contains metadata about operators and built-in functions.
Column name | Data type | Description |
|---|---|---|
FUNC_NAME | VARCHAR(128) | name of the built-in function |
MINARGS | NUMBER | minimum number of arguments for the function |
MAXARGS | NUMBER | maximum number of arguments for the function |
IS_AGGREGATE | BOOLEAN | indicates whether the function is an aggregate function (TRUE) or not (FALSE) |
V$SQL_CACHE
The V$SQL_CACHE lists statistics of shared SQL plan.
Column name | Data type | Description |
|---|---|---|
SQL_HANDLE | NUMBER | SQL handle |
HASH_VALUE | NUMBER | hash value of the SQL statement |
REF_COUNT | NUMBER | count of prepared statements referencing the statement |
PLAN_SIZE | NUMBER | the total plan size of the SQL statement ( in bytes ) |
CLOCK_ID | NUMBER | clock identifier |
PLAN_AGE | NUMBER | plan age |
USER_NAME | VARCHAR(128) | user name |
BIND_PARAM_COUNT | NUMBER | count of bind parameters |
SQL_TEXT | LONG VARCHAR | SQL full text |
PLAN_COUNT | NUMBER | physical plan count of the SQL statement |
PLAN_ID | NUMBER | plan identifier |
PLAN_SIZE | NUMBER | the total plan size of the SQL statement ( in bytes ) |
PLAN_IS_ATOMIC | BOOLEAN | plan is atomic array insert or not |
PLAN_TEXT | LONG VARCHAR | plan text for SQL statement |
V$SQL_COMMAND
The V$SQL_COMMAND lists attribute information of each SQL command.
Column name | Data type | Description |
|---|---|---|
COMMAND | VARCHAR(128) | SQL command |
FROM_PHASE | VARCHAR(32) | executable from start-up phase |
UNTIL_PHASE | VARCHAR(32) | executable until start-up phase |
ACCESS_MODE | VARCHAR(32) | database access mode: values in (NONE, READ & WRITE, READ, READ & LOCK) |
NEED_FETCH | VARCHAR(32) | the command is a query which has result set and need fetch |
IS_DDL | VARCHAR(3) | the command is a DDL(Data Defintion Language) or not |
CLUSTER_LOCK_MODE | VARCHAR(32) | cluster lock mode: values in (NONE, SERIAL, MANUAL) |
AUTO_COMMIT | VARCHAR(3) | the command is auto-commit or not |
IS_CACHEABLE | VARCHAR(3) | the command is plan-cacheable or not |
AUDIT_ACTION | VARCHAR(128) | auditiable action name for the SQL command |
V$SQL_HISTORY
The V$SQL_HISTORY displays information of SQLs.
Column name | Data type | Description |
|---|---|---|
DRIVER_MEMBER_POS | NUMBER | driver member position |
SESSION_ID | NUMBER | session identifier |
START_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | statement start time |
EXEC_TIME | NUMBER | execution time(us) |
PREPARED | BOOLEAN | indicates whether the statement is prepared ( YES ) or not ( NO ) |
SUCCESS | BOOLEAN | indicates whether the statement is success ( YES ) or not ( NO ) |
STATUS | CHARACTER VARYING(16) | status of the statement: the value in ( RUNNING, DONE ) |
SQL_TEXT | CHARACTER VARYING(1024) | first 1024 bytes of the SQL text for the statement |
V$STATEMENT
The V$STATEMENT lists all statements.
Column name | Data type | Description |
|---|---|---|
SESSION_ID | NUMBER | session identifier |
STMT_ID | NUMBER | statement identifier in a session |
STMT_VIEW_SCN | NUMBER | statement view scn |
SQL_TEXT | VARCHAR(1024) | first 1024 bytes of the SQL text for the statement |
START_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | statement start time |
TOTAL_EXEC_TIME | NATIVE_BIGINT | total execution time(us) |
LAST_EXEC_TIME | NATIVE_BIGINT | last execution time(us) |
EXECUTIONS | NATIVE_BIGINT | number of executions |
V$SYSTEM_EVENT
The V$SYSTEM_EVENT displays information on total waits for an event.
Column name | Data type | Description |
|---|---|---|
WAIT_EVENT_ID | NUMBER | Identifier of the wait event |
WAIT_EVENT_NAME | VARCHAR(64) | Name of the wait event |
TOTAL_WAITS | NUMBER | Total number of waits for the event |
TOTAL_TIMEOUTS | NUMBER | Total number of timeouts for the event |
TIME_WAITED | NUMBER | Total amount of time waited for the event (microsecond) |
AVERAGE_WAIT | NUMBER | Average amount of time waited for the event (microsecond) |
CLASS_NAME | VARCHAR(64) | Name of the class of the wait event |
V$SYSTEM_STAT
The V$SYSTEM_STAT displays system statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
STAT_VALUE | NUMBER | statistic value |
COMMENTS | VARCHAR(1024) | comments |
V$SYSTEM_MEM_STAT
The V$SYSTEM_MEM_STAT displays system memory statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
STAT_VALUE | NUMBER | statistic value |
COMMENTS | VARCHAR(1024) | comments |
V$SYSTEM_SQL_STAT
The V$SYSTEM_SQL_STAT displays system SQL statistics.
Column name | Data type | Description |
|---|---|---|
STAT_NAME | VARCHAR(128) | statistic name |
STAT_VALUE | NUMBER | statistic value |
COMMENTS | VARCHAR(1024) | comments |
V$TABLES
The V$TABLES contains the definitions of all the performance views (views beginning with V$).
Column name | Data type | Description |
|---|---|---|
TABLE_OWNER | VARCHAR(128) | owner name who owns the performance view |
TABLE_SCHEMA | VARCHAR(128) | schema name of the performance view |
TABLE_NAME | VARCHAR(128) | name of the performance view |
STARTUP_PHASE | VARCHAR(32) | visible startup phase of the performance view |
CREATED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE |
created time of the performance view |
MODIFIED_TIME | TIMESTAMP(2) WITHOUT TIME ZONE |
modified time of the performance view |
COMMENTS | VARCHAR(1024) |
comments of the performance view |
V$TABLESPACE
This view displays tablespace information.
Column name | Data type | Description |
|---|---|---|
TBS_NAME | VARCHAR(128) | tablespace name |
TBS_ID | NUMBER | tablespace identifier |
TBS_ATTR | VARCHAR(128) | tablespace attribute: the value in ( device attribute (MEMORY) | temporary attribute (TEMPORARY, PERSISTENT) | usage attribute(DICT, UNDO, DATA, TEMPORARY) ) |
IS_LOGGING | BOOLEAN | indicates whether the tablespace is a logging tablespace ( YES ) or not ( NO ) |
IS_ONLINE | BOOLEAN | indicates whether the tablespace is ONLINE ( YES ) or OFFLINE ( NO ) |
OFFLINE_STATE | VARCHAR(32) | indicates whether the tablespace can be taken online normally ( CONSISTENT ) or not ( INCONSISTENT ). null if the tablespace is ONLINE |
EXTENT_SIZE | NUMBER | extent size of the tablespace ( in bytes ) |
PAGE_SIZE | NUMBER | page size of the tablespace ( in bytes ) |
V$TABLESPACE_STAT
This view displays tablespace statistical information.
Column name | Data type | Description |
|---|---|---|
TBS_NAME | VARCHAR(128) | tablespace name |
TBS_ID | NUMBER | tablespace identifier |
TOTAL_EXT_COUNT | NUMBER | total extent count of the tablespace |
USED_META_EXT_COUNT | NUMBER | meta extent count currently used on the tablespace |
USED_DATA_EXT_COUNT | NUMBER | data extent count currently used on the tablespace |
FREE_EXT_COUNT | NUMBER | free extent count of the tablespace |
EXTENT_SIZE | NUMBER | extent size of the tablespace ( in bytes ) |
V$TRANSACTION
The V$TRANSACTION lists the active transactions in the system.
Column name | Data type | Description |
|---|---|---|
TRANS_ID | NUMBER | transaction identifier |
SESSION_ID | NUMBER | session identifier ( null if the global transaction is unassociated |
TRANS_SLOT_ID | NUMBER | transaction slot identifier |
PHYSICAL_TRANS_ID | NUMBER | physical transaction identifier |
TRANS_STATE | VARCHAR(32) | transaction state: the value in ( ACTIVE, BLOCK, PREPARE, COMMIT, ROLLBACK, IDLE, PRECOMMIT ) |
IS_GLOBAL | BOOLEAN | indicates whether the transaction is global or not |
TRANS_ATTRIBUTE | VARCHAR(32) | transaction attribute: the value in ( READ_ONLY, UPDATABLE, LOCKABLE, UPDATABLE | LOCKABLE ) |
ISOLATION_LEVEL | VARCHAR(32) | transaction isolation level: the value in ( READ COMMITTED, SERIALIZABLE ) |
TRANS_VIEW_SCN | NUMBER | transaction view scn |
TCN | NUMBER | transaction change number |
TRANS_SEQ | NUMBER | transaction sequence number |
START_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | transaction start time |
V$WAIT_EVENT_CLASS_NAME
The V$WAIT_EVENT_CLASS_NAME displays information about Class of wait event.
Column name | Data type | Description |
|---|---|---|
CLASS_ID | NUMBER | Identifier of the class of the wait event |
NAME | VARCHAR(64) | Name of the class of the wait event |
DESCRIPTION | VARCHAR(128) | Description of the class of the wait event |
V$WAIT_EVENT_NAME
The V$WAIT_EVENT_NAME displays information about wait events.
Column name | Data type | Description |
|---|---|---|
CLASS_ID | NUMBER | Identifier of the wait event |
NAME | VARCHAR(64) | Name of the wait event |
DESCRIPTION | VARCHAR(128) | Description of the wait event |
PARAMETER1 | NUMBER | Description of the first parameter for the wait event |
PARAMETER1 | NUMBER | Description of the second parameter for the wait event |
PARAMETER1 | NUMBER | Description of the third parameter for the wait event |
CLASS_ID | NUMBER | Identifier of the class of the wait event |
CLASS_NAME | VARCHAR(64) | Name of the class of the wait event |
V$XA_TRANSACTION
The V$XA_TRANSACTION displays information on the currently active XA transactions.
Column name | Data type | Description |
|---|---|---|
XA_TRANS_ID | VARCHAR(1024) | XA transaction identifier |
LOCAL_TRANS_ID | NUMBER | local transaction identifier |
XA_TRANS_STATE | VARCHAR(32) | state of the XA transaction: the value in ( NOTR, ACTIVE, IDLE, PREPARED, ROLLBACK_ONLY, HEURISTIC_COMPLETED ) |
ASSO_STATE | VARCHAR(32) | associate state of the XA transaction: the value in ( NOT_ASSOCIATED, ASSOCIATED, ASSOCIATION_SUSPENDED ) |
START_TIME | TIMESTAMP(2) WITHOUT TIME ZONE | XA transaction start time |
IS_REPREPARABLE | BOOLEAN | indicates whether the XA transaction is repreparable |