Get all pluggable databases
get
/database/pdbs/
Oracle Multitenant license is required when there is more than one user-created pluggable database. Returns records from GV$PDBS in the corresponding Container Database. This service requires db.cdb.adminUser credentials to be set in the pool configuration. A client requires SQL Administrator role to invoke this service.
Request
Query Parameters
-
limit(optional): integer(int32)
The maximum number of records to return.
-
q(optional): string
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
Response
Supported Media Types
- application/json
200 Response
Description of all Pluggable Databases in the Container database.
Root Schema : DatabasePluggableDatabases
Type:
Show Source
object-
count(optional):
integer
Total number of records in the current response.
-
hasMore(optional):
boolean
Indicates if there are more records to be retrieved.
-
items(optional):
array items
-
limit(optional):
integer
The actual page size limit on number of records applied by the server.
-
links(optional):
array links
-
offset(optional):
integer
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array-
Array of:
object DatabasePluggableDatabasesItem
This object describes a Pluggable Database associated with the current instance. The list of attributes may vary depending on database version.
Nested Schema : DatabasePluggableDatabasesItem
Type:
objectThis object describes a Pluggable Database associated with the current instance. The list of attributes may vary depending on database version.
Show Source
-
application_pdb(optional):
string
Indicates whether the PDB is an application PDB.
-
application_root(optional):
string
Indicates whether the PDB is an application root.
-
application_root_clone(optional):
string
Indicates whether this PDB is an application root clone (YES) or not (NO).
-
application_root_con_id(optional):
integer
If this PDB is an application PDB, the container ID of an application root to which this application PDB belongs. If this PDB is an application root clone, the container ID of an application root to which this application root clone belongs. Otherwise, NULL.
-
application_seed(optional):
string
Indicates whether the PDB is an application seed (an application seed is also an application PDB).
-
audit_files_size(optional):
integer
Shows the current disk space usage (in bytes) by Unified Audit files (.bin format) in the current PDB.
-
block_size(optional):
integer
The current block size for the PDB.
-
con_id(optional):
integer
The ID of the container to which the data pertains.
-
con_uid(optional):
integer
Unique identifier associated with the PDB.
-
create_scn(optional):
integer
System change number (SCN) for the creation of this PDB.
-
creation_time(optional):
string
Date and time at which the PDB was created.
-
dbid(optional):
integer
PDB identifier calculated when the PDB is created and stored in all file headers associated with the PDB.
-
diagnostics_size(optional):
integer
Shows the current disk space usage (in bytes) of the diagnostic traces generated in the PDB, which is represented by the CON_ID column of the row.
-
guid(optional):
string
Globally unique identifier (GUID) of this PDB.
-
guid_base64(optional):
string
The GUID of the PDB, encoded in base64.
-
inst_id(optional):
integer
Instance number from which the associated GV$PDBS view information was obtained.
-
last_changed_by(optional):
string
Indicates what type of user last changed the PDB.
-
links(optional):
array links
-
local_undo(optional):
integer
Shows whether the PDB is in local undo. This column is not relevant for CDB$ROOT.
-
max_audit_size(optional):
integer
Shows the maximum amount of disk space (in bytes) that can be used by Unified Audit files (.bin format) in the PDB.
-
max_diagnostics_size(optional):
integer
Shows the maximum amount of disk space (in bytes) that can be used by diagnostic traces generated in the PDB.
-
max_size(optional):
integer
Shows the maximum amount of disk space (in bytes) that can be used by data and temp files in the PDB.
-
name(optional):
string
Name of the PDB.
-
open_mode(optional):
string
Open mode information.
-
open_time(optional):
string
Date and time when the database was last opened.
-
pdb_count(optional):
integer
The number of user-created PDBs belonging to a given application root or CDB$ROOT. For all other containers, its value is 0.
-
proxy_pdb(optional):
string
Indicates whether this PDB is a proxy PDB (YES) or not (NO).
-
recovery_status(optional):
string
Shows whether recovery is enabled or disabled for the PDB.
-
restricted(optional):
string
Indicates whether only users possessing RESTRICTED SESSION privilege can connect to the PDB.
-
snapshot_parent_con_id(optional):
string
This column shows the container ID of the master PDB that this PDB is a snapshot clone of. This column shows a nonzero value only if the PDB is a snapshot clone. For all other cases, it shows a value of 0.
-
tenant_id(optional):
string
Pluggable database tenant key.
-
total_size(optional):
integer
Shows the disk space (in bytes) used by the PBB, including both data and temp files.
-
undo_scn(optional):
integer
System change number (SCN) at which the PDB was last converted from shared to local undo, or from local to shared undo. This column is not relevant for CDB$ROOT.
-
undo_timestamp(optional):
string
Date and time at which the PDB was last converted from shared to local undo, or from local to shared undo. This column is not relevant for CDB$ROOT.