Oracle World

Changing the NLS_CHARACTERSET to AL32UTF8 Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) - Help you to convert character set of database form WE8ISO8859P1 to AL32UTF8

ORA-02049: timeout: distributed transaction ORA-02049: timeout: distributed transaction waiting for lock Application team reported this error and the jobs are getting failed.

Lists all invalid objects in the database Lists all invalid objects in the database - This script share the details of all invalid objects in oracle database.

Displays information about PGA usage for each session Displays information about PGA usage for each session - This script help you to find the PGA usage in oracle database.

tblspc_free.sql tblspc_free.sql - find the information about tablespace usage in oracle database.

tblspc_files.sql tblspc_files.sql

tblspc_temp_free.sql tblspc_temp_free.sql

tblspc_temp_files.sql tblspc_temp_files.sql -This script help you to find the information about temp tablespace files in oracle database.

How to create a DBlink in oracle database How to create a DBlink in oracle database - check the details of existing DBlink and create the new DBlink in oracle database.

ORA-03113: end-of-file on communication channel ORA-03113: end-of-file on communication channel - To fix this error we need to first check the oracle database alert logfile.

Snapshot Physical Standby database Snapshot Physical Standby database was introduced from the 11g Version, which allows the use of a physical standby db in the read-write mode.