Forum Stats

  • 3,855,215 Users
  • 2,264,477 Discussions
  • 7,905,930 Comments

Discussions

Viewing PDB$SEED-related info in CDB_* views

3038990
3038990 Member Posts: 53
edited Nov 29, 2017 2:34PM in Multitenant

Hi,

In 12c (12.1) you'll see the following:

SQL> show con_name

CON_NAME

------------------------------

CDB$ROOT

SQL>  show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ABCP                           READ WRITE NO

SQL>  select con_id,patch_id,flags,action,status from cdb_registry_sqlpatch;

    CON_ID   PATCH_ID FLAGS      ACTION          STATUS

---------- ---------- ---------- --------------- ---------

         3   25397136 NB         APPLY           SUCCESS           <== PDB$SEED not visible

         3   26609798 NB         APPLY           SUCCESS

         1   25397136 NB         APPLY           SUCCESS

         1   26609798 NB         APPLY           SUCCESS

SQL> select con_id, name from v$pdbs;

    CON_ID NAME

---------- ------------------------------

         2 PDB$SEED

         3 ABCP

SQL> alter session set container=PDB$SEED;

Session altered.

SQL> select con_id,patch_id,flags,action,status from cdb_registry_sqlpatch;

    CON_ID   PATCH_ID FLAGS      ACTION          STATUS

---------- ---------- ---------- --------------- ---------------

         2   25397136 NB         APPLY           SUCCESS

         2   26609798 NB         APPLY           SUCCESS

Is there a way to see info pertaining to PDB$SEED from its container in CDB views

(to avoid doing an ALTER SESSION SET CONTAINER PDB$SEED) ?

Thanks.

Seb

vanpupi

Comments

This discussion has been closed.