Tuning the Package
Tuning the Package
Recently I tuned the peformance of a oracle pl/sql package. The description of the issue: This package is taking about 17 hours to complete. This packages is having approximately 3000+ lines of code...
How are the sqls performing today?
How are the sqls performing today?
How are the sqls performing today? Often, I face this question. First I will try to parse the question into simple terms. The sqls – what sqls? On any given day, the top 10 resource intensive sqls. ...
GLOGIN with Color Display
GLOGIN with Color Display
As a dba, I will be executing various scripts in multiple databases. Mostly in non-productions databases. In the event, if any of these scripts were executed inadvertently in the production database...
How “CARTESIAN JOINS” Impact SQL Queries
How “CARTESIAN JOINS” Impact SQL Queries
We all know what is a "CARTESIAN JOIN", for further reference, pls refer the url mentioned in the references section. I worked on a tuning task of a 11 page report. Two invisible cartesian joins are c...
Tablespace Capacity Planning Report
Tablespace Capacity Planning Report
I need to run capacity planning report in my project. Requirements: Predict db growth for 3 months, 6 months and one year. Display message, if the available free space in each tablespace is less tha...