Monthly Archives: December 2014

2014 in review

2014 was a great year for me, though no of blogs posted were not as expected but last two month were exciting.Hope will share same Oracle enthusiasm through blog in 2015. Thanks for visiting my blog and wish you All Happy … Continue reading

Rate this:

Posted in Annual Report - Wordpress | Leave a comment

Analytical Function order of processing within SQL.

Personally Believe, Analytical functions in Oracle are Prime addition and provide great advantage in processing for required data projections. In current post will try to explain SQL order of processing for Analytical Functions. Most of us must be aware on … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , | 1 Comment

Aggregate Function Nesting in Oracle.

It’s been a while, I published blog on Oracle. Today we will discuss on, nested aggregation functions and level it can be nested. Lets first understand what is nesting functions. Nested function is concept, when the output of one function … Continue reading

Rate this:

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

Query Transformation playing with syntactically wrong SQL.

In Oracle whenever any SQL didn’t adhere syntax defined, it is bound to give some error. Any SQL is processed after syntax check is validated. In current blog will try to walk you through some SQL, that seems incorrect but … Continue reading

Rate this:

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

Oracle 12c TOP N Pagination performance considerations.

In my post on TOP N and Pagination in Oracle 12c highlighted features introduce. In current post will try to compare performance and cardinality estimations for a scenario between INLINE ORDER BY + OUTER ROWNUM and TOP N IN 12C. … Continue reading

Rate this:

Posted in Oracle 12c New Features, Oracle Internal | Tagged , , , , , | 1 Comment

On Rac dbms_xplan.display_cursor will give plan if cursor is present on node connected.

Most of us know, dbms_xplan.display_cursor utility is use to get plan, outline information for specific SQL from Cursor cache. During an performance issue analysis identified. For RAC Database(11g), dbms_xplan.display_cursor will give data if and only if necessary cursor(plan) is present … Continue reading

Rate this:

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