Check Startup, uptime and creation time of PDB database
Check startup time of PDB database
col name for a8
col open_time for a33
select con_id,name,dbid,open_mode,open_time from v$containers;
CON_ID NAME DBID OPEN_MODE OPEN_TIME
------ -------- ---------- ---------- --------------------------------
1 CDB$ROOT 2882898177 READ WRITE 05-MAR-19 04.17.12.279 PM +05:30
2 PDB$SEED 2312485862 READ ONLY 05-MAR-19 04.17.12.638 PM +05:30
3 XEPDB1 3053402371 READ WRITE 05-MAR-19 04.17.25.287 PM +05:30
4 PDB2 3201890097 READ WRITE 05-MAR-19 09.47.41.236 PM +05:30
Check uptime of PDB database
col name for a8
col "database uptime" for a30
select name,floor(sysdate-cast(open_time as date))||'Days '||floor(((sysdate-cast(open_time as date))-floor(sysdate-cast(open_time as date)))*24)||'hours '||round(((sysdate-cast(open_time as date)-floor(sysdate-cast(open_time as date) )*24)-floor((sysdate-cast(open_time as date)-floor(sysdate-cast(open_time as date))*24)))*60)||'minutes' "Database Uptime" from v$containers;
NAME Database Uptime
-------- -------------------------
CDB$ROOT 0Days 22hours 57minutes
PDB$SEED 0Days 22hours 57minutes
XEPDB1 0Days 22hours 57minutes
PDB2 0Days 17hours 43minutes
Check creation time and status of PDBS
select pdb_name,creation_time,status from dba_pdbs;
PDB_NAME CREATION_ STATUS
-------------------- --------- ----------
XEPDB1 01-MAR-19 NORMAL
PDB$SEED 01-MAR-19 NORMAL
PDB2 05-MAR-19 NORMAL
Check size of PDBS
select name,open_mode,restricted,creation_time,total_size from v$PDBS;
NAME OPEN_MODE RESTRICTED CREATION_ TOTAL_SIZE
-------- ---------- ---------- --------- ----------
PDB$SEED READ ONLY NO 01-MAR-19 809500672
XEPDB1 READ WRITE NO 01-MAR-19 947912704
PDB2 READ WRITE NO 05-MAR-19 932184064