Home » Server Options » Multitenant » how to get the storage limit of pluggable database (oracle 12c ,12.0.1.2.0,Aix 7.1)
icon5.gif  how to get the storage limit of pluggable database [message #653961] Sun, 24 July 2016 09:21 Go to next message
lzfhope
Messages: 69
Registered: July 2006
Member
HI,ALL
FOR some reason,i need to get all storage limit infos about pdbs in cdb.

Re: how to get the storage limit of pluggable database [message #653962 is a reply to message #653961] Sun, 24 July 2016 12:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
lzfhope wrote on Sun, 24 July 2016 07:21
HI,ALL
FOR some reason,i need to get all storage limit infos about pdbs in cdb.



I do not understand what exactly you desire.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: how to get the storage limit of pluggable database [message #653966 is a reply to message #653962] Sun, 24 July 2016 14:34 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
The storage limits for PDBs (like MAX_PDB_STORAGE and MAX_SHARED_TEMP_SIZE) are stored in CDB_PROPERTIES.

SQL> SELECT name,
  2  	    total_size,
  3  	    NVL(property_value, 'UNLIMITED') AS "MAX_SIZE"
  4  FROM v$containers c, cdb_properties p
  5  WHERE p.con_id(+) = c.con_id
  6  AND p.property_name(+) = 'MAX_PDB_STORAGE'
  7  /

NAME			       TOTAL_SIZE MAX_SIZE
------------------------------ ---------- --------------------
FUDDB				288358400 1073741824
PDBORCL 				0 UNLIMITED
CDB$ROOT			977272832 UNLIMITED
PDB$SEED			283115520 UNLIMITED
icon14.gif  Re: how to get the storage limit of pluggable database [message #654061 is a reply to message #653966] Tue, 26 July 2016 09:49 Go to previous message
lzfhope
Messages: 69
Registered: July 2006
Member
Laughing ,Thank you very much!
Previous Topic: APEX in a multitenant database
Next Topic: Query Regarding Transportable Tablespaces (merged)
Goto Forum:
  


Current Time: Thu Mar 28 06:48:39 CDT 2024