DBA Hub

📋Steps in this guide1/1

Status of PDBS in multitenant

SQL> select dbid,name,open_mode,TOTAL_SIZE/1024/1024 from v$pdbs;

oracle configurationintermediate
by OracleDba
13 views
1

Status of PDBS in multitenant

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
SQL>
select dbid,name,open_mode,TOTAL_SIZE/1024/1024 from v$pdbs;
DBID NAME OPEN_MODE TOTAL_SIZE/1024/1024
---------- ------------------------------ ---------- --------------------
3987628790 PDB$SEED READ ONLY 830
1360187792 PDB1 READ WRITE 905
3819422575 PDB2 MOUNTED 0
SQL>
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED

Comments (0)

Please to add comments

No comments yet. Be the first to comment!