Check Startup, uptime and creation time of PDB database

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


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.