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

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 C...

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

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 quie...

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

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

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 p...

Eight Years Back, i was naive developer, yearning to get a job into PL/SQL development, I faced multiple interviews. I still have some f...

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 cr...

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 o...

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 ...

There are several real time problems where we come across Scanning of data records with PLSQL Functions, We prefer using functions for bu...

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

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 dy...

I hardly remember to have encountered with a subprograms without a conditional clause, are we not widely using the conditional structs i...

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

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

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 ...