Arun Sankar's Blog

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT Some time we face this error when we run batch jobs with very ...

SQLT is a tool or scripts (SQLTXPLAIN.SQL) devolved by Carlos Sierra (Oracle Corporation).It is using to diagnose the performance of ...

Here we are discussing about checkpoint in Oracle database Checkpoint is the mechanism that defines the SCN in the redo thread of da...

Let us discuss new features of Oracle Database 12c Release 1.(12.1). Oracle says there are 500+ new features incorporated in 12c. We wi...

What are the basic checks for a junior DBA when slowness reports in the system? Taking user inputs: This is the very first step for...