In the previous installment of this series we looked at four reasons from gv$sql_shared_cursor view and explained the situations and criteria for which Oracle is forced to compile a new execution plan...
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...
Open source databases are becoming more and more popular. MySQL and PostgreSQL databases are the top two open source relational databases and their use is on the increase. Migrating to these database...