Oracle

I will explain Alter table drop partition in Oracle in this post.

I will explain V$SESSION_LONGOPS | Find long running queries (long ops) in Oracle in this post.

I will explain v$sqltext and v$sqlstats in Oracle in this post.

I will explain Expdp – Impdp ( Export – Import ) Parallel in Oracle in this post.

I will explain Gc current block busy and Gc cr block busy wait event in Oracle in this post.

I will explain Log File Sync Wait event in Oracle in this post.

I will explain Direct path read Wait event in Oracle in this post.

I will explain DB File Scattered Read Wait event in Oracle in this post.

I will explain DB File Sequential Read Wait event in Oracle in this post.

I will explain Enq: TX – Row lock contention Wait Event in Oracle Database in this post.