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 […]
Dear Readers, Yesterday one of my friend pinged with the requirement of generating muliple AWR reports for every 1 hour using single command. This particular database has SNAP_INTERVAL set to every 15 minutes. He had already referred one of my old post given below, which helps us generating muliple AWR […]
Dear Readers, I recently completed Python programming course which was authorized by “University of Michigan” offered through Coursera. It was really good course & worth the time I invested in. So here comes my first python program, which can be useful for Oracle DBA’s like me to get consolidated report […]
Dear Readers, My first YouTube Video on “OEM Metrics Extension || What || Why || How” Hope u will find this post very useful. Cheers Regards, Adityanath
Today while applying “Patch 30501910: GI RELEASE UPDATE 19.6.0.0.0” on recently upgrade GRID home from 12.2 to 19.6, I received error related ACFS ==> CLSRSC-196: ACFS driver install actions failed. Command used for patching ==> opatchauto apply -oh /u01/app/19.6.0.0/grid /u05/ADI/patch/30501910 Detailed error is as given below: Execution of [SIHAStartupAction] patch […]
Dear Readers, I have published two more articles on KT EXPERTS. This articles focuses on new DB features that have been introduced in Oracle 18C along with its significance. Oracle 18C new feature: Cancel SQL instead of killing session Oracle 18C new feature: Schema Only Account Hope u will find […]
Dear Readers, I am very happy to announce that I posted my first ever article on KT EXPERTS. This article focuses on new DB parameters that have been introduced in Oracle 18C along with its significance. Oracle 18C New Initialization Parameters Hope u will find this post very useful. 🙂 Stay […]
We need sleep function many a times in our code, may be for application logic or even sometimes for monitoring purpose. We always had this available with sleep() function that resides within DBMS_LOCK ==> DBMS_LOCK.SLEEP This was always a big security risk as granting access to DBMS_LOCK will make a […]
Adityanath's Oracle Blog 