DBA Sheet v6.1

We have prepared DBA Sheet v6.1 which used to use on daily basis and we want to share with you all.

Special thanks to my friend "Sugivardhan Sundarrajan" who contributed lot of time to prepare this sheet

Please click here to download DBA Sheet v6.1

Please leave feedback in comment section below in case of any issues in this regard.

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

2 thoughts on “DBA Sheet v6.1

  1. Hi, Rajasekhar Amudala

    This sheet is very useful, great ideia, often I had verify commands about Oracle and tech information.
    Guy try to create book and sale, very good.

    Thanks
    Fernando

  2. Hi Rajasekhar,

    Thank you for this great tool !
    The following sql does not work on one of my 12c databases :

    select name CDB_NAME,(select name from v$pdbs) PDB_NAME,open_mode,database_role,(SELECT to_char(sysdate,’DD-MON-YYYY HH24:MI:SS’) FROM dual) “Current_time_db” ,(select INSTANCE_NAME from v$instance) INSTANCE_NAME,(select HOST_NAME from v$instance ) HOST_NAME from v$database;

    Because “select name from v$pdbs” returns more than one row.
    I needed to modify the request this way :

    … select name from v$pdbs where name not like ‘%SEED%’

    Still, in case of a multitenant database, it would not work I guess.

    Regards

    Jean-michel A.
    Nemours, France

Leave a Reply

Your email address will not be published. Required fields are marked *