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 : +
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/
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
It is not showing download option for me
please download DBA Sheet v7.0
where we need to download DBA Sheet v7.0
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
Hi Rajasekhar,
Great Script collection. Are you interested about new scripts (entries )
Regards,
Tom
Hi Rajasekhar,
Aweome sevice for DBA world. Keep it up.
Regards
Santosh
Thank You Rajasekhar
Thanks Rajasekhar for the knowledge share, your blog is awesome and request you to continue the same. It means a lot to people who are looking to enhance their skills.
Scripts are really good .
Thank you Rajasekhar for sharing your knowledge, your blog is awesome and request you to continue the same. It is helpful to lot people who are looking to enhance their skills.
appreciate the knowledge sharing and scripts provided.
Thank you, Bro.
Great Job..
we must appreciate your effort..
Thank you..
This is such a useful collection of scripts!
Really appreciate you guys putting in so much efforts!
A big thank you!
Hi Raj,
Like Oracle DBA, can you also please share all daily activities scripts of Mysql, Postgresql, Sql Server DBA. Then it will be very very useful for all DBA’s.
Thank you for this gift sir,
Really appreciate you guys putting in so much efforts!
Thanks a lot for the …..amazing script collection
The Download not work
please use DBA Sheet v7