Monthly Archives: November 2015

Basic Understanding of Autonomous Transaction in Oracle

Most of us are aware of Use of Autonomous transactions in oracle and what benefit it exhibit. just to elaborate on same, It help to Perform SQL operations(Especially committed DML) independent of primary transaction. In precise, Its shares no lock … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | Leave a comment

Outer Join tables with Filter predicates in Oracle.

Most of us must be aware of Oracle Outer joins behaviour and its significance. Using outer join, We can fetch all rows from one of table and only matched rows from other table with null for all non matched rows. … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment

Statistics history for Database objects in oracle.

Oracle enthusiast, knows importance of underlying stats on db objects and its prime role to decide execution plan. Most of time during case analysis, for thorough plan change analysis we need past snapshot of table\index\column\partition stats, as many a times … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , | Leave a comment