
Oracle JSON
Being a Relational DB developer for years it took a while for me to adapt to JASON- (JavaScript Object Notation) when Oracle introduced

Bitmap Conversion From Rowid
Several times while checking the explain Plan, I find bitmap conversion to rowid which could slow down the performance of the query. The...

INDEX SKIP SCAN(INDEX_SS)
Prior to Oracle 9i version, if the leading column of an index wasn’t specified in a predicate, the index was effectively ignored by the...

PARALLEL_INDEX HINT
The PARALLEL_INDEX hint instructs the optimizer to use the specified number of concurrent servers to parallelize index range scans, full...

DBMS_UTILITY_FORMAT_ERROR_BACKTRACE
Oracle introduced this utility a while ago with 10g, but even now it's a hot topic in the interviews. I have witnessed this question...

FIRST_ROWS Hint in Oracle
I shared several post on performance recently. Whenever we talk bout performance first_rows can be of significant use. On many ...

Materialized View Refreshes
Interviewers seldom miss to discuss about mv or snapshot and the refresh mechanism associated with it. While in OLTP environment, i did...

Full Table Scan in Oracle
There is a common misbelief amongst us that FTS are evil, In one of my earlier blog i tried to give some insights on FTS and leverage a...

Few Complex SQL query- asked as routine Questions in PL/SQL interviews
Eight Years Back, i was naive developer, yearning to get a job into PL/SQL development, I faced multiple interviews. I still have some...

Create table for Exchange With clause on a Partitioned Table in Oracle Database 12c Release 2 (12.2)
With the advent of ORACLE 12.2 the create table statement has been enriched by the new “for exchange with” clause. This enables us to...

XmlTable, extract and xmlupdate, XQuery In a Nutshell
Early this week i was working on xml data in oracle, an Avenue still not much explored by me . I was trying to update an xml data from...

LISTAGG DEDUPLICATION - A better ListAgg Function: Enhancement in Oracle 19C
I was pondering since this weekend on what should I include in my blog until I found something exciting about the listagg, A built in...

Alternatives to Performance Weary PL/SQL Function- (Result_cache, Deterministic Function)
There are several real time problems where we come across Scanning of data records with PLSQL Functions, We prefer using functions for...

Sql_injection & Bind Variables
There are profound content scattered all over the internet which talks about proofing sql injection with bind variable as an option to...

Bind Variables: performance booster
One fine morning, I got a request from my manager to drop some staging tables. I Started working on it and ended up quickly writing a...

Revealing the unseen secrets of IF clause.
I hardly remember to have encountered with a subprograms without a conditional clause, are we not widely using the conditional structs...

Performance weary queries in oracle
I had been going pity busy in recent time with several interviews scheduled. Every interview i took, Otherwise different in their...

Pragma Inline
Inlining replaces a subprogram call (to a subprogram in the same program unit) with a copy of the called subprogram. Pragma inline could...

PRAGMA SERIALLY_REUSABLE IN ORACLE
The SERIALLY_REUSABLE Pragma specifies that the package state is needed for only one call to the server (for example, an OCI call to the...





















