Blog

...

...

In this post, I\'ll explain another simple script that kills long running sessions connecting from specific programs e.g. SQL Developer The script can be tuned to target any specific programs, but I\'m mainly defaulting the script to target SQL Developer, as it\'s widely used by the developers, moreover, it doesn\'t maintain disconnecting the running session properly when the user close the session\'s window, keeping the \"supposed to be closed\" session query running in the database! ...

It\'s crucial for any DBA to get to know about long running queries that can impact the performance of his/her database environment. Badly coded reports along with developers\' bad habit of using \"select *\" to navigate data on big tables enforce the DBA to have a kind of an early warning tool to get him aware of such performance threats before it exaggerates. ...

If your busy DBA career left you living under a rock for the last few days, let me remind you that the new bundle version 4.1 is now released with the following enhancements: Three new scripts: backup_ctrl_spf_AWR.sh kill_long_running_queries.sh check_standby_lag.sh ...

In this post I\'ll try to summarize all sorts of statistics in Oracle, I strongly recommend reading the full article, as it contains information you may find it valuable in understanding Oracle statistics. Database expert Mahmmoud ADEL ...

In this post, I\'ll share with you one of the most helpful tools I ever created, it will make database administration day to day activities more easier, faster and safer for you. I named it DBA Bundle, it\'s a tar file contains a group of shell scripts, you can DOWNLOAD the latest version from this link:  https://www.dropbox.com/s/ilq2ckntq4vrhgo/DBA_BUNDLE3.tar? dl=0 Created by Database expert Mahmmoud ADEL ...

A unidirectional replication from the source site to the target site. The pump process is bending with the following errors in the report file, but communication between the source site and target site is working as expected. ...

How to repair INVALID “Oracle Database Packages and Type” in dba_registry – ORA-01775 upgrade error The problem can happen if the database has been upgraded from Oracle 11gR2 to Oracle 12c ...

As a server restart of our database server was required due to server level activity, I had to shut down all the instances. I brought down the database first and then its respective ASM instances. After the server restart when I am trying to up the ASM instance it is giving me the below error: ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service ...

Oracle MAA (Maximum Availability Architecture is Oracle’s best practices blueprint based on proven Oracle high availability technologies, expert recommendations and customer experiences. The goal of MAA is to achieve optimal high availability for Oracle customers at the lowest cost and complexity. ...

...