这篇文章给大家分享的是有关oracle 12c如何查看CDB&PDBs信息的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。查看CDB&PDBs信息（sql*PLUS
这篇文章给大家分享的是有关oracle 12c如何查看CDB&PDBs信息的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。
V$，GV$，CDB_，CONTaiNER_DATA的属性决定了对哪些PDB可见；
每个容器数据对象都有CON_ID列，列值代表整个CDB可见，1代表root对象，2代表seed对象,3~254代表PDB对象；
以下视图的行为不同于其他[G]V$视图:
·
[G]V$SYSSTAT
·
[G]V$SYS_TIME_MODEL
·
[G]V$SYSTEM_EVENT
·
[G]V$SYSTEM_WAIT_CLASS
从root查询时，这些视图返回实例范围的数据，返回的每一行CON_ID列中都有。但是，您可以查询与其他容器数据对象行为相同的等效视图。以下视图可以为CDB中的每个容器返回特定的数据:[G]V$CON_SYSSTAT、[G]V$CON_SYS_TIME_MODEL、[G]V$CON_SYSTEM_EVENT和[G]V$CON_SYSTEM_WAIT_CLASS。
Table 43-2 Views for a CDB
View | Description |
Container data objects, including: l
l
l
l
| Container data objects can display infORMation about multiple PDBs. Each container data object includes a There is a |
| Displays information about the PDBs associated with the CDB, including the status of each PDB. |
| Displays the permanent properties of each container in a CDB. |
| Displays the history of each PDB. |
| Displays information about the user-level and object-level |
| Displays the PDBs and instances in the Workload Repository. |
| Displays information about the current saved PDB states in the CDB. |
| Displays information about all the CDB resource plans. |
| Displays information about all the CDB resource plan directives. |
| Contains descriptions of reasons for PDB alerts. |
| Displays information about incompatibilities between a PDB and the CDB to which it belongs. This view is also used to display information generated by executing |
| Displays information about database objects, and the |
| Displays information about database services, and the |
| The |
| The |
| The |
| The |
| Displays information about the database from the control file. If the database is a CDB, then CDB-related information is included. |
| Displays information about the containers associated with the current CDB, including the root and all PDBs. |
| Displays information about the PDBs associated with the current CDB, including the open mode of each PDB. |
| Displays displays information about all PDB incarnations. Oracle creates a new PDB incarnation whenever a PDB is opened with the |
| Displays information about initialization parameters, and the |
SELECT CDB FROM V$DATABASE;
Example 43-2 Viewing Identifying Information About Each Container in a CDB
COLUMN NAME FORMAT A8
SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
Example 43-3 Viewing Container ID, Name, and Status of Each PDB
COLUMN PDB_NAME FORMAT A15
SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
COLUMN NAME FORMAT A15
COLUMN RESTRICTED FORMAT A10
COLUMN OPEN_TIME FORMAT A30
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
Example 43-5 Showing the Tables Owned by Specific Schemas in Multiple PDBs
COLUMN PDB_NAME FORMAT A15
COLUMN OWNER FORMAT A15
COLUMN TABLE_NAME FORMAT A30
SELECT p.PDB_ID, p.PDB_NAME, t.OWNER, t.TABLE_NAME
FROM DBA_PDBS p, CDB_TABLES t
WHERE p.PDB_ID > 2 AND
t.OWNER IN('HR','OE') AND
p.PDB_ID = t.CON_ID
ORDER BY p.PDB_ID;
Example 43-6 Showing the Users in Multiple PDBs
COLUMN PDB_NAME FORMAT A15
COLUMN USERNAME FORMAT A30
SELECT p.PDB_ID, p.PDB_NAME, u.USERNAME
FROM DBA_PDBS p, CDB_USERS u
WHERE p.PDB_ID > 2 AND
p.PDB_ID = u.CON_ID
ORDER BY p.PDB_ID;
Example 43-7 Showing the Data Files for Each PDB in a CDB
COLUMN PDB_ID FORMAT 999
COLUMN PDB_NAME FORMAT A8
COLUMN FILE_ID FORMAT 9999
COLUMN TABLESPACE_NAME FORMAT A10
COLUMN FILE_NAME FORMAT A45
SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME
FROM DBA_PDBS p, CDB_DATA_FILES d
WHERE p.PDB_ID = d.CON_ID
ORDER BY p.PDB_ID;
Example 43-8 Showing the Temp Files in a CDB
COLUMN CON_ID FORMAT 999
COLUMN FILE_ID FORMAT 9999
COLUMN TABLESPACE_NAME FORMAT A15
COLUMN FILE_NAME FORMAT A45
SELECT CON_ID, FILE_ID, TABLESPACE_NAME, FILE_NAME
FROM CDB_TEMP_FILES
ORDER BY CON_ID;
Example 43-9 Showing the Services Associated with PDBs
COLUMN NETWORK_NAME FORMAT A30
COLUMN PDB FORMAT A15
COLUMN CON_ID FORMAT 999
SELECT PDB, NETWORK_NAME, CON_ID FROM CDB_SERVICES
WHERE PDB IS NOT NULL AND
CON_ID > 2
ORDER BY PDB;
Example 43-10 Querying a Table Owned by a Common User Across All PDBs
SELECT * FROM CONTAINERS(employees);Example 43-11 Querying a Table Owned by Local Users Across All PDBs
CREATE OR REPLACE VIEW employees AS SELECT * FROM hr.employees;SELECT * FROM CONTAINERS(employees);SELECT * FROM CONTAINERS(employees) WHERE CON_ID IN(3,4);SHOW CON_IDSHOW CON_NAMEExample 43-12 Returning the Container ID Based on the Container Name
SELECT CON_NAME_TO_ID('HRPDB') FROM DUAL;Example 43-13 Returning the Container ID Based on the Container DBID
SELECT CON_DBID_TO_ID(2226957846) FROM DUAL;Function | Description |
| Returns the container ID based on the container's name. |
| Returns the container ID based on the container's DBID. |
| Returns the container ID based on the container's unique identifier (UID). |
| Returns the container ID based on the container's globally unique identifier (GUID). |
SELECT NAME FROM V$SYSTEM_PARAMETER WHERE ISPDB_MODIFIABLE = 'TRUE' ORDER BY NAME;COLUMN DB_NAME FORMAT A10COLUMN CON_ID FORMAT 999COLUMN PDB_NAME FORMAT A15COLUMN OPERATION FORMAT A16COLUMN OP_TIMESTAMP FORMAT A10COLUMN CLONED_FROM_PDB_NAME FORMAT A15
SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME FROM CDB_PDB_HISTORY WHERE CON_ID > 2 ORDER BY CON_ID;感谢各位的阅读！关于“Oracle 12c如何查看CDB&PDBs信息”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！
--结束END--
本文标题: Oracle 12c如何查看CDB&PDBs信息
本文链接: https://www.lsjlt.com/news/63787.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑，方便收藏和打印～
2024-05-22
2024-05-22
2024-05-22
2024-05-22
2024-05-22
2024-05-22
2024-05-22
2024-05-21
2024-05-21
2024-05-21
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
一口价域名售卖能注册吗？域名是网站的标识，简短且易于记忆，为在线用户提供了访问我们网站的简单路径。一口价是在域名交易中一种常见的模式，而这种通常是针对已经被注册的域名转售给其他人的一种方式。
一口价域名买卖的过程通常包括以下几个步骤：
1.寻找：买家需要在域名售卖平台上找到心仪的一口价域名。平台通常会为每个可售的域名提供详细的描述，包括价格、年龄、流
443px" 443px) https://www.west.cn/docs/wp-content/uploads/2024/04/SEO图片294.jpg https://www.west.cn/docs/wp-content/uploads/2024/04/SEO图片294-768x413.jpg 域名售卖 域名一口价售卖 游戏音频 赋值/切片 框架优势 评估指南 项目规模
官方手机版
微信公众号
商务合作
0