Dear Readers, Recently one of BU person in my project requested us to send scheduled report for RMAN Backup completion for one of critical databases. As this requirement was from Business, I thought of having it simple & less techie. After exploring few options, I thought of using OEM reporting […]
Dear Readers, It happened many times, when I need to search a document MOS/Metalink Oracle support, which I referred in past but unable to find now. So thought of writing a Master Note which will have all MOS/Oracle Metalink documents you should have it handy when working on Exadata. Hope […]
Dear Readers, I thought of writing a post to include all ASM related scripts/commands. Its good to have everything you need in single place 🙂 1. Check file-type specific usage details all databases on the server. This is useful when we need to quickly check who occupied major space in […]
Dear Readers, Yeahh!! It gives me immense pleasure to announce that my blog has been listed in Top 100 Oracle Blogs And Websites For Oracle DBAs To Follow in 2020. Rank #70 🙂 Special thanks to Feedspot for getting this listed. See below. Top 100 Oracle Blogs And Websites For Oracle […]
Dear Readers, In my previous posts, I discussed about tablespace/FRA/RMAN backup/Patchset level monitoring using python. But none of these blog posts explained about connecting to multiple Oracle database using same program. Many of my blog followers requested me to write a code which connects to multiple databases & executes some […]
In my previous posts, I discussed about tablespace/FRA/RMAN backup monitoring using python. Here comes my new python code to display current DB patch set level for a Oracle DB. Note: This code is ready to use & only works on Oracle DB with versions 18+ Prerequisites: python binaries with version […]
Dear Readers, In my previous posts, I discussed about tablespace/FRA monitoring using python. Here comes my new python code to report RMAN backup job details from last 7 days in Oracle DB. Note: This code is ready to use. But you can definitely refer it & modify wherever as per […]
Dear Readers, In my previous post, I discussed about tablespace monitoring using python. Here comes my new python code to check FRA/Flash recovery area usage details in Oracle DB. Note: This code is ready to use. But you can definitely refer it & modify wherever as per your need. Prerequisites: […]
Dear Readers, I have published one more article on KT EXPERTS. This article explains how to export AUD$ & other AUDIT tables using DATAPUMP. Exporting the AUDIT tables/AUD$ Using Oracle Data Pump EXPDP Hope u will find this post very useful. 🙂 Cheers Regards, Adityanath
Dear Readers, I am planning to convert most of the scripts I currently use for Oracle DB monitoring, into python in near future. But why am I fascinated with Python?? Its very easy to understand. Its open source & most important its platform independent. So here comes python code to […]
Adityanath's Oracle Blog 