7.7.12.25 LIST PLUGGABLEDATABASE

Purpose

Displays the specified attributes for active pluggable databases.

Syntax

LIST PLUGGABLEDATABASE [name | attribute_filters] [attribute_list]  [DETAIL]

Usage Notes

You can use the DESCRIBE PLUGGABLEDATABASE command to view the complete list of PLUGGABLEDATABASE attributes.

Examples

The following example shows the LIST PLUGGABLEDATABASE command and the corresponding output.

Example 7-200 Listing Pluggable Database Attributes

CellCLI> LIST PLUGGABLEDATABASE
         PDB$SEED
         CDB1_PDB1
         NEWPDB1
         NEWPDB2

CellCLI> LIST PLUGGABLEDATABASE DETAIL
         name:                   PDB$SEED
         asmClusterName:         SALESDBS_ASMCLUSTER
         containerName:          CDB1
         flashCacheLimit:        515M
         flashCacheMin:          0
         flashCacheSize:         0
         iormLimit:              0.0
         iormShare:              2
         pdbID:                  385656752
         pmemCacheMin:           0
         pmemCacheLimit:         256M
         pmemCacheSize:          0


         name:                   CDB1_PDB1
         asmClusterName:         SALESDBS_ASMCLUSTER
         containerName:          CDB1
         flashCacheLimit:        315G
         flashCacheMin:          200G
         flashCacheSize:         0
         iormLimit:              0.0
         iormShare:              5
         pdbID:                  2850864136
         pmemCacheMin:           0
         pmemCacheLimit:         256M
         pmemCacheSize:          0


         name:                   NEWPDB1
         asmClusterName:         SALESDBS_ASMCLUSTER
         containerName:          CDB1
         flashCacheLimit:        157G
         flashCacheMin:          20G
         flashCacheSize:         0
         iormLimit:              80.0
         iormShare:              1
         pdbID:                  167491455
         pmemCacheMin:           0
         pmemCacheLimit:         256M
         pmemCacheSize:          0

         name:                   NEWPDB2
         asmClusterName:         SALESDBS_ASMCLUSTER
         containerName:          CDB1
         flashCacheLimit:        157G
         flashCacheMin:          20G
         flashCacheSize:         0
         iormLimit:              60.0
         iormShare:              2
         pdbID:                  2392787216
         pmemCacheMin:           0
         pmemCacheLimit:         256M
         pmemCacheSize:          0