-
Audit User DDL
- January 20, 2020
- Posted by: admin
- Category: Scripts
No Comments
Audit_User_DDL -
SQL DEVELOPER INSTALLATION ON WINDOWS AND LINUX
- January 19, 2020
- Posted by: admin
- Category: Scripts
sql-developer-installation-on-windows-amp-linux -
Kill Long Running Sessions Connecting From Specific Program
- April 22, 2018
- Posted by: admin
- Category: Scripts
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! -
Report Long Running Queries | Long Active Sessions Script | Oracle On Linux
- April 22, 2018
- Posted by: admin
- Category: Scripts
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. -
Oracle Database Administration Scripts | DBA Bundle V4.1
- February 24, 2018
- Posted by: admin
- Category: Scripts
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 -
All About Statistics In Oracle
- January 5, 2018
- Posted by: admin
- Category: Performance Tuning
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 -
Oracle Database Administration Scripts | DBA Bundle
- January 1, 2018
- Posted by: admin
- Category: Scripts
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: [V. 3.12 16-Nov-2017]
https://www.dropbox.com/s/ilq2ckntq4vrhgo/DBA_BUNDLE3.tar? dl=0
Created by Database expert Mahmmoud ADEL -
ERROR OGG-01224 (1:Connection refused)
- December 28, 2017
- Posted by: admin
- Category: High Availability
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.
-
ORACLE PACKAGES AND TYPES IN DBA_REGISTRY ORA-01775
- December 26, 2017
- Posted by: admin
- Category: UPGRADE
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
-
Cluster Synchronization Service “ORA-29701”
- December 26, 2017
- Posted by: admin
- Category: ASM
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
- 1
- 2