All posts under PL/SQL

Oracle subquery caching

fcb7dis

On Oracle there’s a kind of cache that works with scalar subqueries (look below for a simple example of a scalar subquery) which prevents the database engine to repeat unnecessary work to get the same result again and again. But while this seems to be less than useful with pure Oracle[…]

Read More »

Where does Oracle process SQL statements ?

brain-017

Programming,programming,programming…a way a of life.(kind of!)  But how many times do we actually stop to think about what we are doing ? I decided to blog on this, because it is important to always keep in mind some basic concepts Whenever we need to execute a SQL statement, Oracle allocates[…]

Read More »