Oracle 12c CON_ID 值概述

標籤：CON_ID

細心的小夥伴可以發現，我們在gv$pdbs中，並沒有發現con_id=1,con_id=0

其實如果仔細猜一下也應該能猜到：
因為CDB 是由root container,seed pdb container,0個或者多個pdb container組成的。

查詢官檔 v$pdbs視圖：

CON_ID

The ID of the container to which the data pertains. Possible values include:

?0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

?1: This value is used for rows containing data that pertain to only the root

?n: Where n is the applicable container ID for the rows containing data

所以CON_ID =1 是rootcontainer，

Oracle 12c CON_ID 值概述