PDB 快照
快照是数据库基于时间点的完整镜像,主要用于快速恢复和PDB复制。
利用PDB快照创建新PDB的语法如下:
[oracle@oracle-db-19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Dec 2 09:45:45 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
5 CNDBAPDB MOUNTED
6 CNDBAPDB3 MOUNTED
7 CNDBAPDB2 MOUNTED
8 CNDBAPDB4_FRESH MOUNTED
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> alter session set container=PDB1;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB1 READ WRITE NO
SQL> alter pluggable database snapshot CNDBAPDB5_20221202;
Pluggable database altered.
SQL>
SQL> conn / as sysdba
Connected.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
5 CNDBAPDB MOUNTED
6 CNDBAPDB3 MOUNTED
7 CNDBAPDB2 MOUNTED
8 CNDBAPDB4_FRESH MOUNTED
SQL>
SQL> CREATE PLUGGABLE DATABASE CNDBAPDB6 FROM PDB1 USING SNAPSHOT CNDBAPDB5_20221202;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
5 CNDBAPDB MOUNTED
6 CNDBAPDB3 MOUNTED
7 CNDBAPDB2 MOUNTED
8 CNDBAPDB4_FRESH MOUNTED
9 CNDBAPDB6 MOUNTED
SQL>
可以手动生成快照,也可以指定每隔多长时间自动生成一次快照,最多可以存储8个快照。
创建PDB快照
1. 设置自动创建PDB快照
可以设置每隔一段时间自动创建一个PDB。
EVERY snapshot_interval [ MINUTES | HOURS ]
查看当前PDB快照模式
SQL>
SQL> SELECT SNAPSHOT_MODE "S_MODE",SNAPSHOT_INTERVAL/60 "SNAP_INT_HRS" FROM DBA_PDBS;
S_MODE SNAP_INT_HRS
------ ------------
MANUAL
SQL>
设置每隔24小时就创建一个快照,需要在相应的PDB下执行命令:
SQL>
SQL> ALTER PLUGGABLE DATABASE SNAPSHOT MODE EVERY 24 HOURS;
Pluggable database altered.
SQL>
再次查看快照模式,代码如下:
SQL> SELECT SNAPSHOT_MODE "S_MODE",SNAPSHOT_INTERVAL/60 "SNAP_INT_HRS" FROM DBA_PDBS;
S_MODE SNAP_INT_HRS
------ ------------
AUTO 24
SQL>
2.手动创建PDB快照
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> alter session set container=PDB1;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB1 READ WRITE NO
SQL> alter pluggable database snapshot CNDBAPDB5_20221202;
Pluggable database altered.
SQL>
查看快照信息
SQL> set LINESIZE 150
SQL> col con_name format a10
SQL> col snapshot_name format a30
SQL> col full_snapshot_path format a55
SQL> col snap_scn default
SQL> select con_id,con_name,snapshot_name,snapshot_scn as snap_scn,full_snapshot_path from dba_pdb_snapshots order by snap_scn;
CON_ID CON_NAME SNAPSHOT_NAME SNAP_SCN FULL_SNAPSHOT_PATH
------ ---------- ------------------------------ ---------- -------------------------------------------------------
3 PDB1 CNDBAPDB5_20221202 18991475 /u02/oradata/snap_2714456025_18991475.pdb
3 PDB1 SNAP_2714456025_1122376588 18997049 /u02/oradata/snap_2714456025_18997049.pdb
SQL>
删除快照
- 可以一个一个地删除快照,也可以一次性删除所有快照。
SQL>
SQL> select con_id,con_name,snapshot_name,snapshot_scn as snap_scn,full_snapshot_path from dba_pdb_snapshots order by snap_scn;
CON_ID CON_NAME SNAPSHOT_NAME SNAP_SCN FULL_SNAPSHOT_PATH
------ ---------- ------------------------------ ---------- -------------------------------------------------------
3 PDB1 CNDBAPDB5_20221202 18991475 /u02/oradata/snap_2714456025_18991475.pdb
3 PDB1 SNAP_2714456025_1122376588 18997049 /u02/oradata/snap_2714456025_18997049.pdb
SQL> ALTER PLUGGABLE DATABASE DROP SNAPSHOT SNAP_2714456025_1122376588;
Pluggable database altered.
SQL> select con_id,con_name,snapshot_name,snapshot_scn as snap_scn,full_snapshot_path from dba_pdb_snapshots order by snap_scn;
CON_ID CON_NAME SNAPSHOT_NAME SNAP_SCN FULL_SNAPSHOT_PATH
------ ---------- ------------------------------ ---------- -------------------------------------------------------
3 PDB1 CNDBAPDB5_20221202 18991475 /u02/oradata/snap_2714456025_18991475.pdb
SQL>
- 删除所有快照,将MAX_PDB_SNAPSHOTS参数设置为0就会自动删除该PDB的所有快照,删除速度也快很多。
SQL> select con_id,con_name,snapshot_name,snapshot_scn as snap_scn,full_snapshot_path from dba_pdb_snapshots order by snap_scn;
CON_ID CON_NAME SNAPSHOT_NAME SNAP_SCN FULL_SNAPSHOT_PATH
------ ---------- ------------------------------ ---------- -------------------------------------------------------
3 PDB1 CNDBAPDB5_20221202 18991475 /u02/oradata/snap_2714456025_18991475.pdb
SQL> ALTER PLUGGABLE DATABASE SET MAX_PDB_SNAPSHOTS=0;
Pluggable database altered.
SQL> select con_id,con_name,snapshot_name,snapshot_scn as snap_scn,full_snapshot_path from dba_pdb_snapshots order by snap_scn;
no rows selected
SQL> ALTER PLUGGABLE DATABASE SET MAX_PDB_SNAPSHOTS=8;
Pluggable database altered.
SQL>
监控CDB和PDB
- 容器数据对象,包括:
- v$视图
- GV$视图
- CDB_视图
- DBA_HIST*视图
容器数据对象用于显示关于多租户的相关信息。每个容器数据对象通过CON_ID 来区分不同的容器
- {CDB|DBA}_PDBS
显示与CDB相关的PDB的信息,包括每个PDB的状态
SQL> set pagesize 200
SQL> set linesize 200
SQL> desc CDB_PDBS;
Name Null? Type
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
PDB_ID NOT NULL NUMBER
PDB_NAME NOT NULL VARCHAR2(128)
DBID NOT NULL NUMBER
CON_UID NOT NULL NUMBER
GUID RAW(16)
STATUS VARCHAR2(10)
CREATION_SCN NUMBER
VSN NUMBER
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(39)
FORCE_NOLOGGING VARCHAR2(3)
APPLICATION_ROOT VARCHAR2(3)
APPLICATION_PDB VARCHAR2(3)
APPLICATION_SEED VARCHAR2(3)
APPLICATION_ROOT_CON_ID NUMBER
IS_PROXY_PDB VARCHAR2(3)
CON_ID NOT NULL NUMBER
UPGRADE_PRIORITY NUMBER
APPLICATION_CLONE VARCHAR2(3)
FOREIGN_CDB_DBID NUMBER
UNPLUG_SCN NUMBER
FOREIGN_PDB_ID NUMBER
CREATION_TIME NOT NULL DATE
REFRESH_MODE VARCHAR2(6)
REFRESH_INTERVAL NUMBER
TEMPLATE VARCHAR2(3)
LAST_REFRESH_SCN NUMBER
TENANT_ID VARCHAR2(255)
SNAPSHOT_MODE VARCHAR2(6)
SNAPSHOT_INTERVAL NUMBER
CREDENTIAL_NAME VARCHAR2(262)
SQL> desc DBA_PDBS;
Name Null? Type
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
PDB_ID NOT NULL NUMBER
PDB_NAME NOT NULL VARCHAR2(128)
DBID NOT NULL NUMBER
CON_UID NOT NULL NUMBER
GUID RAW(16)
STATUS VARCHAR2(10)
CREATION_SCN NUMBER
VSN NUMBER
LOGGING VARCHAR2(9)
FORCE_LOGGING VARCHAR2(39)
FORCE_NOLOGGING VARCHAR2(3)
APPLICATION_ROOT VARCHAR2(3)
APPLICATION_PDB VARCHAR2(3)
APPLICATION_SEED VARCHAR2(3)
APPLICATION_ROOT_CON_ID NUMBER
IS_PROXY_PDB VARCHAR2(3)
CON_ID NOT NULL NUMBER
UPGRADE_PRIORITY NUMBER
APPLICATION_CLONE VARCHAR2(3)
FOREIGN_CDB_DBID NUMBER
UNPLUG_SCN NUMBER
FOREIGN_PDB_ID NUMBER
CREATION_TIME NOT NULL DATE
REFRESH_MODE VARCHAR2(6)
REFRESH_INTERVAL NUMBER
TEMPLATE VARCHAR2(3)
LAST_REFRESH_SCN NUMBER
TENANT_ID VARCHAR2(255)
SNAPSHOT_MODE VARCHAR2(6)
SNAPSHOT_INTERVAL NUMBER
CREDENTIAL_NAME VARCHAR2(262)
SQL>
- CDB_PROPERTIES 显示CDB中每个容器的属性
SQL>
SQL> desc CDB_PROPERTIES
Name Null? Type
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
PROPERTY_NAME VARCHAR2(128)
PROPERTY_VALUE VARCHAR2(4000)
DESCRIPTION VARCHAR2(4000)
CON_ID NUMBER
SQL>
- {CDB|DBA}_PDB_HISTORY 显示每个PDB的历史记录信息
SQL>
SQL> desc DBA_PDB_HISTORY
Name Null? Type
----------------------------------------- -------- ----------------------------
PDB_NAME NOT NULL VARCHAR2(128)
PDB_ID NOT NULL NUMBER
PDB_DBID NOT NULL NUMBER
PDB_GUID NOT NULL RAW(16)
OP_SCNBAS NOT NULL NUMBER
OP_SCNWRP NOT NULL NUMBER
OP_TIMESTAMP NOT NULL DATE
OPERATION NOT NULL VARCHAR2(16)
DB_VERSION NOT NULL NUMBER
CLONED_FROM_PDB_NAME VARCHAR2(128)
CLONED_FROM_PDB_DBID NUMBER
CLONED_FROM_PDB_GUID RAW(16)
DB_NAME VARCHAR2(128)
DB_UNIQUE_NAME VARCHAR2(128)
DB_DBID NUMBER
CLONETAG VARCHAR2(128)
DB_VERSION_STRING VARCHAR2(204)
SQL> desc CDB_PDB_HISTORY
Name Null? Type
----------------------------------------- -------- ----------------------------
PDB_NAME NOT NULL VARCHAR2(128)
PDB_ID NOT NULL NUMBER
PDB_DBID NOT NULL NUMBER
PDB_GUID NOT NULL RAW(16)
OP_SCNBAS NOT NULL NUMBER
OP_SCNWRP NOT NULL NUMBER
OP_TIMESTAMP NOT NULL DATE
OPERATION NOT NULL VARCHAR2(16)
DB_VERSION NOT NULL NUMBER
CLONED_FROM_PDB_NAME VARCHAR2(128)
CLONED_FROM_PDB_DBID NUMBER
CLONED_FROM_PDB_GUID RAW(16)
DB_NAME VARCHAR2(128)
DB_UNIQUE_NAME VARCHAR2(128)
DB_DBID NUMBER
CLONETAG VARCHAR2(128)
DB_VERSION_STRING VARCHAR2(204)
CON_ID NUMBER
SQL>
- CDB_HIST_PDB_INSTANCE | DBA_HIST_PDB_INSTANCE 显示PDB和实例的负载信息库。
SQL> desc CDB_HIST_PDB_INSTANCE
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
CON_DBID NOT NULL NUMBER
OPEN_TIME NOT NULL TIMESTAMP(3)
OPEN_MODE VARCHAR2(16)
PDB_NAME VARCHAR2(128)
CON_ID NUMBER
SNAP_ID NUMBER
STARTUP_TIME_TZ TIMESTAMP(3) WITH TIME ZONE
OPEN_TIME_TZ TIMESTAMP(3) WITH TIME ZONE
SQL> desc DBA_HIST_PDB_INSTANCE
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NOT NULL NUMBER
INSTANCE_NUMBER NOT NULL NUMBER
STARTUP_TIME NOT NULL TIMESTAMP(3)
CON_DBID NOT NULL NUMBER
OPEN_TIME NOT NULL TIMESTAMP(3)
OPEN_MODE VARCHAR2(16)
PDB_NAME VARCHAR2(128)
CON_ID NUMBER
SNAP_ID NUMBER
STARTUP_TIME_TZ TIMESTAMP(3) WITH TIME ZONE
OPEN_TIME_TZ TIMESTAMP(3) WITH TIME ZONE
SQL>
- {CDB|DBA}_PDB_SAVED_STATES 显示CDB中当前保存的PDB的状态的信息。
SQL>
SQL> desc CDB_PDB_SAVED_STATES
Name Null? Type
----------------------------------------- -------- ----------------------------
CON_ID NOT NULL NUMBER
CON_NAME NOT NULL VARCHAR2(128)
INSTANCE_NAME NOT NULL VARCHAR2(128)
CON_UID NOT NULL NUMBER
GUID RAW(16)
STATE VARCHAR2(14)
RESTRICTED VARCHAR2(3)
SQL> desc DBA_PDB_SAVED_STATES
Name Null? Type
----------------------------------------- -------- ----------------------------
CON_ID NOT NULL NUMBER
CON_NAME NOT NULL VARCHAR2(128)
INSTANCE_NAME NOT NULL VARCHAR2(128)
CON_UID NOT NULL NUMBER
GUID RAW(16)
STATE VARCHAR2(14)
RESTRICTED VARCHAR2(3)
SQL>
- {CDB|DBA}_APPLICATIONS 记录应用程序容器中的所有应用程序。
SQL>
SQL> desc CDB_APPLICATIONS
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NAME VARCHAR2(128)
APP_ID NUMBER
APP_VERSION VARCHAR2(30)
APP_STATUS VARCHAR2(12)
APP_IMPLICIT VARCHAR2(1)
APP_CAPTURE_SERVICE VARCHAR2(64)
APP_CAPTURE_MODULE VARCHAR2(64)
APP_CAPTURE_ERROR VARCHAR2(1)
CON_ID NUMBER
SQL> desc DBA_APPLICATIONS
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NAME VARCHAR2(128)
APP_ID NUMBER
APP_VERSION VARCHAR2(30)
APP_STATUS VARCHAR2(12)
APP_IMPLICIT VARCHAR2(1)
APP_CAPTURE_SERVICE VARCHAR2(64)
APP_CAPTURE_MODULE VARCHAR2(64)
APP_CAPTURE_ERROR VARCHAR2(1)
SQL>
- CDB_APP_STATEMENTS | DBA_APP_STATEMENTS 记录应用程序容器中应用程序安装、升级和补丁操作的所有语句。
SQL> DESC CDB_APP_STATEMENTS
Name Null? Type
----------------------------------------- -------- ----------------------------
ORIGIN_CON_ID NUMBER
STATEMENT_ID NOT NULL NUMBER
CAPTURE_TIME NOT NULL DATE
APP_STATEMENT CLOB
APP_NAME VARCHAR2(128)
APP_STATUS VARCHAR2(12)
PATCH_NUMBER NUMBER
VERSION_NUMBER NUMBER
SESSION_ID NUMBER
OPCODE NOT NULL NUMBER
CON_ID NUMBER
SQL> DESC DBA_APP_STATEMENTS
Name Null? Type
----------------------------------------- -------- ----------------------------
ORIGIN_CON_ID NUMBER
STATEMENT_ID NOT NULL NUMBER
CAPTURE_TIME NOT NULL DATE
APP_STATEMENT CLOB
APP_NAME VARCHAR2(128)
APP_STATUS VARCHAR2(12)
PATCH_NUMBER NUMBER
VERSION_NUMBER NUMBER
SESSION_ID NUMBER
OPCODE NOT NULL NUMBER
SQL>
- {CDB|DBA}_APP_PATCHES 记录应用程序容器中所有应用程序的补丁信息
SQL>
SQL> DESC CDB_APP_PATCHES
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NAME VARCHAR2(128)
PATCH_NUMBER NUMBER
PATCH_MIN_VERSION VARCHAR2(30)
PATCH_STATUS VARCHAR2(10)
PATCH_COMMENT VARCHAR2(4000)
PATCH_CHECKSUM NUMBER
CON_ID NUMBER
SQL> DESC DBA_APP_PATCHES
Name Null? Type
----------------------------------------- -------- ----------------------------
APP_NAME VARCHAR2(128)
PATCH_NUMBER NUMBER
PATCH_MIN_VERSION VARCHAR2(30)
PATCH_STATUS VARCHAR2(10)
PATCH_COMMENT VARCHAR2(4000)
PATCH_CHECKSUM NUMBER
SQL>
- {CDB | DBA}_CDB_RSRC_PLANS 显示所有关于CDB资源计划的信息
SQL> desc CDB_CDB_RSRC_PLANS
Name Null? Type
----------------------------------------- -------- ----------------------------
PLAN_ID NOT NULL NUMBER
PLAN VARCHAR2(128)
COMMENTS VARCHAR2(2000)
STATUS VARCHAR2(128)
MANDATORY VARCHAR2(3)
CON_ID NUMBER
SQL> desc DBA_CDB_RSRC_PLANS
Name Null? Type
----------------------------------------- -------- ----------------------------
PLAN_ID NOT NULL NUMBER
PLAN VARCHAR2(128)
COMMENTS VARCHAR2(2000)
STATUS VARCHAR2(128)
MANDATORY VARCHAR2(3)
SQL>
- CDB_CDB_RSRC_PLAN_DIRECTIVES | DBA_CDB_RSRC_PLAN_DIRECTIVES
SQL> desc DBA_CDB_RSRC_PLAN_DIRECTIVES
Name Null? Type
----------------------------------------- -------- ----------------------------
PLAN VARCHAR2(128)
PLUGGABLE_DATABASE VARCHAR2(128)
PROFILE VARCHAR2(128)
DIRECTIVE_TYPE VARCHAR2(30)
SHARES NUMBER
UTILIZATION_LIMIT NUMBER
PARALLEL_SERVER_LIMIT NUMBER
MEMORY_MIN NUMBER
MEMORY_LIMIT NUMBER
COMMENTS VARCHAR2(2000)
STATUS VARCHAR2(128)
MANDATORY VARCHAR2(3)
SQL> desc CDB_CDB_RSRC_PLAN_DIRECTIVES
Name Null? Type
----------------------------------------- -------- ----------------------------
PLAN VARCHAR2(128)
PLUGGABLE_DATABASE VARCHAR2(128)
PROFILE VARCHAR2(128)
DIRECTIVE_TYPE VARCHAR2(30)
SHARES NUMBER
UTILIZATION_LIMIT NUMBER
PARALLEL_SERVER_LIMIT NUMBER
MEMORY_MIN NUMBER
MEMORY_LIMIT NUMBER
COMMENTS VARCHAR2(2000)
STATUS VARCHAR2(128)
MANDATORY VARCHAR2(3)
CON_ID NUMBER
SQL>
- PDB_ALERTS 记录PDB的告警信息
SQL>
SQL> desc PDB_ALERTS
Name Null? Type
----------------------------------------- -------- ----------------------------
TIME NOT NULL TIMESTAMP(6)
NAME NOT NULL VARCHAR2(128)
CAUSE_NO NOT NULL NUMBER
TYPE_NO NOT NULL NUMBER
ERROR NUMBER
LINE NOT NULL NUMBER
MESSAGE NOT NULL VARCHAR2(4000)
STATUS NUMBER
ACTION VARCHAR2(4000)
SQL>
- PDB_PLUG_IN_VIOLATIONS 显示PDB与其所属的CDB之间不兼容的信息。此视图还显示执行DBMS_PDB.CHECK_PLUG_COMPATIBILITY命令生成的信息。
SQL> desc PDB_PLUG_IN_VIOLATIONS
Name Null? Type
----------------------------------------- -------- ----------------------------
TIME NOT NULL TIMESTAMP(6)
NAME NOT NULL VARCHAR2(128)
CAUSE VARCHAR2(64)
TYPE VARCHAR2(9)
ERROR_NUMBER NUMBER
LINE NOT NULL NUMBER
MESSAGE NOT NULL VARCHAR2(4000)
STATUS VARCHAR2(9)
ACTION VARCHAR2(4000)
CON_ID NUMBER
SQL>
- all_objects | user_objects | DBA_OBJECTS | CDB_OBJECTS 显示数据库的对象信息
SQL> desc all_objects
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(128)
OBJECT_NAME NOT NULL VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(23)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NOT NULL NUMBER
EDITION_NAME VARCHAR2(128)
SHARING VARCHAR2(18)
EDITIONABLE VARCHAR2(1)
ORACLE_MAINTAINED VARCHAR2(1)
APPLICATION VARCHAR2(1)
DEFAULT_COLLATION VARCHAR2(100)
DUPLICATED VARCHAR2(1)
SHARDED VARCHAR2(1)
CREATED_APPID NUMBER
CREATED_VSNID NUMBER
MODIFIED_APPID NUMBER
MODIFIED_VSNID NUMBER
SQL> desc user_objects
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(23)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(128)
SHARING VARCHAR2(18)
EDITIONABLE VARCHAR2(1)
ORACLE_MAINTAINED VARCHAR2(1)
APPLICATION VARCHAR2(1)
DEFAULT_COLLATION VARCHAR2(100)
DUPLICATED VARCHAR2(1)
SHARDED VARCHAR2(1)
CREATED_APPID NUMBER
CREATED_VSNID NUMBER
MODIFIED_APPID NUMBER
MODIFIED_VSNID NUMBER
SQL> desc DBA_OBJECTS
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(128)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(23)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(128)
SHARING VARCHAR2(18)
EDITIONABLE VARCHAR2(1)
ORACLE_MAINTAINED VARCHAR2(1)
APPLICATION VARCHAR2(1)
DEFAULT_COLLATION VARCHAR2(100)
DUPLICATED VARCHAR2(1)
SHARDED VARCHAR2(1)
CREATED_APPID NUMBER
CREATED_VSNID NUMBER
MODIFIED_APPID NUMBER
MODIFIED_VSNID NUMBER
SQL> desc CDB_OBJECTS
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(128)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(23)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(128)
SHARING VARCHAR2(18)
EDITIONABLE VARCHAR2(1)
ORACLE_MAINTAINED VARCHAR2(1)
APPLICATION VARCHAR2(1)
DEFAULT_COLLATION VARCHAR2(100)
DUPLICATED VARCHAR2(1)
SHARDED VARCHAR2(1)
CREATED_APPID NUMBER
CREATED_VSNID NUMBER
MODIFIED_APPID NUMBER
MODIFIED_VSNID NUMBER
CON_ID NUMBER
SQL>
- 显示数据库Service的信息,并且PDB列显示的是与PDB相关的Service
SQL>
SQL> desc ALL_SERVICES
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
FAILOVER_METHOD VARCHAR2(64)
FAILOVER_TYPE VARCHAR2(64)
FAILOVER_RETRIES NUMBER(10)
FAILOVER_DELAY NUMBER(10)
MIN_CARDINALITY NUMBER
MAX_CARDINALITY NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
ENABLED VARCHAR2(3)
AQ_HA_NOTIFICATIONS VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
EDITION VARCHAR2(128)
COMMIT_OUTCOME VARCHAR2(3)
RETENTION_TIMEOUT NUMBER
REPLAY_INITIATION_TIMEOUT NUMBER
SESSION_STATE_CONSISTENCY VARCHAR2(128)
GLOBAL_SERVICE VARCHAR2(3)
PDB VARCHAR2(128)
SQL_TRANSLATION_PROFILE VARCHAR2(261)
MAX_LAG_TIME VARCHAR2(128)
GSM_FLAGS NUMBER
PQ_SVC VARCHAR2(64)
STOP_OPTION VARCHAR2(13)
FAILOVER_RESTORE VARCHAR2(6)
DRAIN_TIMEOUT NUMBER
TABLE_FAMILY_ID NUMBER
PLACEMENT_POLICY NUMBER
RESET_STATE VARCHAR2(6)
VCSPARE1 VARCHAR2(1024)
NSPARE1 NUMBER
SQL> desc DBA_SERVICES
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
FAILOVER_METHOD VARCHAR2(64)
FAILOVER_TYPE VARCHAR2(64)
FAILOVER_RETRIES NUMBER(10)
FAILOVER_DELAY NUMBER(10)
MIN_CARDINALITY NUMBER
MAX_CARDINALITY NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
ENABLED VARCHAR2(3)
AQ_HA_NOTIFICATIONS VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
EDITION VARCHAR2(128)
COMMIT_OUTCOME VARCHAR2(3)
RETENTION_TIMEOUT NUMBER
REPLAY_INITIATION_TIMEOUT NUMBER
SESSION_STATE_CONSISTENCY VARCHAR2(128)
GLOBAL_SERVICE VARCHAR2(3)
PDB VARCHAR2(128)
SQL_TRANSLATION_PROFILE VARCHAR2(261)
MAX_LAG_TIME VARCHAR2(128)
GSM_FLAGS NUMBER
PQ_SVC VARCHAR2(64)
STOP_OPTION VARCHAR2(13)
FAILOVER_RESTORE VARCHAR2(6)
DRAIN_TIMEOUT NUMBER
TABLE_FAMILY_ID NUMBER
PLACEMENT_POLICY NUMBER
RESET_STATE VARCHAR2(6)
VCSPARE1 VARCHAR2(1024)
NSPARE1 NUMBER
SQL> desc CDB_SERVICES
Name Null? Type
----------------------------------------- -------- ----------------------------
SERVICE_ID NUMBER
NAME VARCHAR2(64)
NAME_HASH NUMBER
NETWORK_NAME VARCHAR2(512)
CREATION_DATE DATE
CREATION_DATE_HASH NUMBER
FAILOVER_METHOD VARCHAR2(64)
FAILOVER_TYPE VARCHAR2(64)
FAILOVER_RETRIES NUMBER(10)
FAILOVER_DELAY NUMBER(10)
MIN_CARDINALITY NUMBER
MAX_CARDINALITY NUMBER
GOAL VARCHAR2(12)
DTP VARCHAR2(1)
ENABLED VARCHAR2(3)
AQ_HA_NOTIFICATIONS VARCHAR2(3)
CLB_GOAL VARCHAR2(5)
EDITION VARCHAR2(128)
COMMIT_OUTCOME VARCHAR2(3)
RETENTION_TIMEOUT NUMBER
REPLAY_INITIATION_TIMEOUT NUMBER
SESSION_STATE_CONSISTENCY VARCHAR2(128)
GLOBAL_SERVICE VARCHAR2(3)
PDB VARCHAR2(128)
SQL_TRANSLATION_PROFILE VARCHAR2(261)
MAX_LAG_TIME VARCHAR2(128)
GSM_FLAGS NUMBER
PQ_SVC VARCHAR2(64)
STOP_OPTION VARCHAR2(13)
FAILOVER_RESTORE VARCHAR2(6)
DRAIN_TIMEOUT NUMBER
TABLE_FAMILY_ID NUMBER
PLACEMENT_POLICY NUMBER
RESET_STATE VARCHAR2(6)
VCSPARE1 VARCHAR2(1024)
NSPARE1 NUMBER
CON_ID NUMBER
SQL>
- 显示与当前CDB相关的信息,包括root和所有PDB
SQL> desc V$CONTAINERS
Name Null? Type
----------------------------------------- -------- ----------------------------
CON_ID NUMBER
DBID NUMBER
CON_UID NUMBER
GUID RAW(16)
NAME VARCHAR2(128)
OPEN_MODE VARCHAR2(10)
RESTRICTED VARCHAR2(3)
OPEN_TIME TIMESTAMP(3) WITH TIME ZONE
CREATE_SCN NUMBER
TOTAL_SIZE NUMBER
BLOCK_SIZE NUMBER
RECOVERY_STATUS VARCHAR2(8)
SNAPSHOT_PARENT_CON_ID NUMBER
APPLICATION_ROOT VARCHAR2(3)
APPLICATION_PDB VARCHAR2(3)
APPLICATION_SEED VARCHAR2(3)
APPLICATION_ROOT_CON_ID NUMBER
APPLICATION_ROOT_CLONE VARCHAR2(3)
PROXY_PDB VARCHAR2(3)
LOCAL_UNDO NUMBER
UNDO_SCN NUMBER
UNDO_TIMESTAMP DATE
CREATION_TIME DATE
PDB_COUNT NUMBER
AUDIT_FILES_SIZE NUMBER
MAX_SIZE NUMBER
MAX_DIAGNOSTICS_SIZE NUMBER
MAX_AUDIT_SIZE NUMBER
LAST_CHANGED_BY VARCHAR2(11)
MEMBER_CDB VARCHAR2(3)
TENANT_ID VARCHAR2(256)
UPGRADE_LEVEL NUMBER
GUID_BASE64 VARCHAR2(30)
SQL> desc GV$CONTAINERS
Name Null? Type
----------------------------------------- -------- ----------------------------
INST_ID NUMBER
CON_ID NUMBER
DBID NUMBER
CON_UID NUMBER
GUID RAW(16)
NAME VARCHAR2(128)
OPEN_MODE VARCHAR2(10)
RESTRICTED VARCHAR2(3)
OPEN_TIME TIMESTAMP(3) WITH TIME ZONE
CREATE_SCN NUMBER
TOTAL_SIZE NUMBER
BLOCK_SIZE NUMBER
RECOVERY_STATUS VARCHAR2(8)
SNAPSHOT_PARENT_CON_ID NUMBER
APPLICATION_ROOT VARCHAR2(3)
APPLICATION_PDB VARCHAR2(3)
APPLICATION_SEED VARCHAR2(3)
APPLICATION_ROOT_CON_ID NUMBER
APPLICATION_ROOT_CLONE VARCHAR2(3)
PROXY_PDB VARCHAR2(3)
LOCAL_UNDO NUMBER
UNDO_SCN NUMBER
UNDO_TIMESTAMP DATE
CREATION_TIME DATE
PDB_COUNT NUMBER
AUDIT_FILES_SIZE NUMBER
MAX_SIZE NUMBER
MAX_DIAGNOSTICS_SIZE NUMBER
MAX_AUDIT_SIZE NUMBER
LAST_CHANGED_BY VARCHAR2(11)
MEMBER_CDB VARCHAR2(3)
TENANT_ID VARCHAR2(256)
UPGRADE_LEVEL NUMBER
GUID_BASE64 VARCHAR2(30)
SQL>
- 显示与当前CDB相关的所有PDB的信息,包括PDB的打开模式
SQL> set linesize 150
SQL> set pagesize 150
SQL> desc GV$PDBS
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
INST_ID NUMBER
CON_ID NUMBER
DBID NUMBER
CON_UID NUMBER
GUID RAW(16)
NAME VARCHAR2(128)
OPEN_MODE VARCHAR2(10)
RESTRICTED VARCHAR2(3)
OPEN_TIME TIMESTAMP(3) WITH TIME ZONE
CREATE_SCN NUMBER
TOTAL_SIZE NUMBER
BLOCK_SIZE NUMBER
RECOVERY_STATUS VARCHAR2(8)
SNAPSHOT_PARENT_CON_ID NUMBER
APPLICATION_ROOT VARCHAR2(3)
APPLICATION_PDB VARCHAR2(3)
APPLICATION_SEED VARCHAR2(3)
APPLICATION_ROOT_CON_ID NUMBER
APPLICATION_ROOT_CLONE VARCHAR2(3)
PROXY_PDB VARCHAR2(3)
LOCAL_UNDO NUMBER
UNDO_SCN NUMBER
UNDO_TIMESTAMP DATE
CREATION_TIME DATE
DIAGNOSTICS_SIZE NUMBER
PDB_COUNT NUMBER
AUDIT_FILES_SIZE NUMBER
MAX_SIZE NUMBER
MAX_DIAGNOSTICS_SIZE NUMBER
MAX_AUDIT_SIZE NUMBER
LAST_CHANGED_BY VARCHAR2(11)
TEMPLATE VARCHAR2(3)
TENANT_ID VARCHAR2(256)
UPGRADE_LEVEL NUMBER
GUID_BASE64 VARCHAR2(30)
SQL>
显示关于初始化参数的信息,其中列ISPDB_MODIFIABLE的值表示该参数是否可以在PDB中修改。
SQL>
SQL> desc V$SYSTEM_PARAMETER
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(4000)
DISPLAY_VALUE VARCHAR2(4000)
DEFAULT_VALUE VARCHAR2(255)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISPDB_MODIFIABLE VARCHAR2(5)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(8)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
ISBASIC VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER
CON_ID NUMBER
SQL> desc V$PARAMETER
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(4000)
DISPLAY_VALUE VARCHAR2(4000)
DEFAULT_VALUE VARCHAR2(255)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISPDB_MODIFIABLE VARCHAR2(5)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(10)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
ISBASIC VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER
CON_ID NUMBER
SQL>
- 显示CDB中当前容器的Trace文件和告警日志信息。
SQL>
SQL> desc V$DIAG_ALERT_EXT
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ORIGINATING_TIMESTAMP TIMESTAMP(9) WITH TIME ZONE
NORMALIZED_TIMESTAMP TIMESTAMP(9) WITH TIME ZONE
ORGANIZATION_ID VARCHAR2(67)
COMPONENT_ID VARCHAR2(67)
HOST_ID VARCHAR2(67)
HOST_ADDRESS VARCHAR2(49)
MESSAGE_TYPE NUMBER
MESSAGE_LEVEL NUMBER
MESSAGE_ID VARCHAR2(67)
MESSAGE_GROUP VARCHAR2(67)
CLIENT_ID VARCHAR2(67)
MODULE_ID VARCHAR2(67)
PROCESS_ID VARCHAR2(35)
THREAD_ID VARCHAR2(67)
USER_ID VARCHAR2(131)
INSTANCE_ID VARCHAR2(67)
DETAILED_LOCATION VARCHAR2(163)
UPSTREAM_COMP_ID VARCHAR2(103)
DOWNSTREAM_COMP_ID VARCHAR2(103)
EXECUTION_CONTEXT_ID VARCHAR2(103)
EXECUTION_CONTEXT_SEQUENCE NUMBER
ERROR_INSTANCE_ID NUMBER
ERROR_INSTANCE_SEQUENCE NUMBER
MESSAGE_TEXT VARCHAR2(2051)
MESSAGE_ARGUMENTS VARCHAR2(515)
SUPPLEMENTAL_ATTRIBUTES VARCHAR2(515)
SUPPLEMENTAL_DETAILS VARCHAR2(515)
PARTITION NUMBER
RECORD_ID NUMBER
FILENAME VARCHAR2(515)
LOG_NAME VARCHAR2(67)
PROBLEM_KEY VARCHAR2(553)
VERSION NUMBER
CON_UID NUMBER
CONTAINER_ID NUMBER
CONTAINER_NAME VARCHAR2(67)
CON_ID NUMBER
SQL>
SQL> desc V$DIAG_APP_TRACE_FILE
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
CHANGE_TIME TIMESTAMP(3) WITH TIME ZONE
MODIFY_TIME TIMESTAMP(3) WITH TIME ZONE
SQL_TRACE VARCHAR2(1)
OPTIMIZER_TRACE VARCHAR2(1)
CON_ID NUMBER
SQL> desc v$diag_opt_trace_records
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
RECORD_LEVEL NUMBER
PARENT_LEVEL NUMBER
RECORD_TYPE NUMBER
TIMESTAMP TIMESTAMP(3) WITH TIME ZONE
PAYLOAD VARCHAR2(4000)
SECTION_ID NUMBER
SECTION_NAME VARCHAR2(64)
COMPONENT_NAME VARCHAR2(64)
OPERATION_NAME VARCHAR2(64)
FILE_NAME VARCHAR2(64)
FUNCTION_NAME VARCHAR2(64)
LINE_NUMBER NUMBER
THREAD_ID VARCHAR2(64)
SESSION_ID NUMBER
SERIAL# NUMBER
CON_UID NUMBER
CONTAINER_NAME VARCHAR2(64)
CON_ID NUMBER
SQL> desc v$diag_sess_opt_trace_records
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
RECORD_LEVEL NUMBER
PARENT_LEVEL NUMBER
RECORD_TYPE NUMBER
TIMESTAMP TIMESTAMP(3) WITH TIME ZONE
PAYLOAD VARCHAR2(4000)
SECTION_ID NUMBER
SECTION_NAME VARCHAR2(64)
COMPONENT_NAME VARCHAR2(64)
OPERATION_NAME VARCHAR2(64)
FILE_NAME VARCHAR2(64)
FUNCTION_NAME VARCHAR2(64)
LINE_NUMBER NUMBER
THREAD_ID VARCHAR2(64)
SESSION_ID NUMBER
SERIAL# NUMBER
CON_UID NUMBER
CONTAINER_NAME VARCHAR2(64)
CON_ID NUMBER
SQL> desc v$diag_sess_sql_trace_records
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
RECORD_LEVEL NUMBER
PARENT_LEVEL NUMBER
RECORD_TYPE NUMBER
TIMESTAMP TIMESTAMP(3) WITH TIME ZONE
PAYLOAD VARCHAR2(4000)
SECTION_ID NUMBER
SECTION_NAME VARCHAR2(64)
COMPONENT_NAME VARCHAR2(64)
OPERATION_NAME VARCHAR2(64)
FILE_NAME VARCHAR2(64)
FUNCTION_NAME VARCHAR2(64)
LINE_NUMBER NUMBER
THREAD_ID VARCHAR2(64)
SESSION_ID NUMBER
SERIAL# NUMBER
CON_UID NUMBER
CONTAINER_NAME VARCHAR2(64)
CON_ID NUMBER
SQL> desc v$diag_sql_trace_records
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
RECORD_LEVEL NUMBER
PARENT_LEVEL NUMBER
RECORD_TYPE NUMBER
TIMESTAMP TIMESTAMP(3) WITH TIME ZONE
PAYLOAD VARCHAR2(4000)
SECTION_ID NUMBER
SECTION_NAME VARCHAR2(64)
COMPONENT_NAME VARCHAR2(64)
OPERATION_NAME VARCHAR2(64)
FILE_NAME VARCHAR2(64)
FUNCTION_NAME VARCHAR2(64)
LINE_NUMBER NUMBER
THREAD_ID VARCHAR2(64)
SESSION_ID NUMBER
SERIAL# NUMBER
CON_UID NUMBER
CONTAINER_NAME VARCHAR2(64)
CON_ID NUMBER
SQL> desc v$diag_trace_file
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
CHANGE_TIME TIMESTAMP(3) WITH TIME ZONE
MODIFY_TIME TIMESTAMP(3) WITH TIME ZONE
CON_ID NUMBER
SQL> desc v$diag_trace_file_contents
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ADR_HOME VARCHAR2(444)
TRACE_FILENAME VARCHAR2(68)
RECORD_LEVEL NUMBER
PARENT_LEVEL NUMBER
RECORD_TYPE NUMBER
TIMESTAMP TIMESTAMP(3) WITH TIME ZONE
PAYLOAD VARCHAR2(4000)
SECTION_ID NUMBER
SECTION_NAME VARCHAR2(64)
COMPONENT_NAME VARCHAR2(64)
OPERATION_NAME VARCHAR2(64)
FILE_NAME VARCHAR2(64)
FUNCTION_NAME VARCHAR2(64)
LINE_NUMBER NUMBER
THREAD_ID VARCHAR2(64)
SESSION_ID NUMBER
SERIAL# NUMBER
CON_UID NUMBER
CONTAINER_NAME VARCHAR2(64)
CON_ID NUMBER
SQL>
- 显示CDB中关于当前容器的问题和故障信息
SQL>
SQL> desc V$DIAG_INCIDENT
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
INCIDENT_ID NUMBER
PROBLEM_ID NUMBER
CREATE_TIME TIMESTAMP(9) WITH TIME ZONE
CLOSE_TIME TIMESTAMP(9) WITH TIME ZONE
STATUS NUMBER
FLAGS NUMBER
FLOOD_CONTROLLED NUMBER
ERROR_FACILITY VARCHAR2(12)
ERROR_NUMBER NUMBER
ERROR_ARG1 VARCHAR2(66)
ERROR_ARG2 VARCHAR2(66)
ERROR_ARG3 VARCHAR2(66)
ERROR_ARG4 VARCHAR2(66)
ERROR_ARG5 VARCHAR2(66)
ERROR_ARG6 VARCHAR2(66)
ERROR_ARG7 VARCHAR2(66)
ERROR_ARG8 VARCHAR2(66)
SIGNALLING_COMPONENT VARCHAR2(66)
SIGNALLING_SUBCOMPONENT VARCHAR2(66)
SUSPECT_COMPONENT VARCHAR2(66)
SUSPECT_SUBCOMPONENT VARCHAR2(66)
ECID VARCHAR2(66)
IMPACT NUMBER
ERROR_ARG9 VARCHAR2(66)
ERROR_ARG10 VARCHAR2(66)
ERROR_ARG11 VARCHAR2(66)
ERROR_ARG12 VARCHAR2(66)
CON_UID NUMBER
CON_ID NUMBER
SQL> desc V$DIAG_PROBLEM
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
PROBLEM_ID NUMBER
PROBLEM_KEY VARCHAR2(552)
FIRST_INCIDENT NUMBER
FIRSTINC_TIME TIMESTAMP(9) WITH TIME ZONE
LAST_INCIDENT NUMBER
LASTINC_TIME TIMESTAMP(9) WITH TIME ZONE
IMPACT1 NUMBER
IMPACT2 NUMBER
IMPACT3 NUMBER
IMPACT4 NUMBER
SERVICE_REQUEST VARCHAR2(66)
BUG_NUMBER VARCHAR2(66)
CON_UID NUMBER
CON_ID NUMBER
SQL>