27/02/2022
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
Hi Friends. A survival guide for the ORACLE DBA and Weblogic.
27/02/2022
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
27/02/2022
ORA-02049: timeout: distributed transaction ORA-02049: timeout: distributed transaction waiting for lock Application team reported this error and the jobs are getting failed.
27/02/2022
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.
27/02/2022
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.
27/02/2022
tblspc_free.sql tblspc_free.sql - find the information about tablespace usage in oracle database.
27/02/2022
tblspc_files.sql tblspc_files.sql
27/02/2022
tblspc_temp_free.sql tblspc_temp_free.sql
27/02/2022
tblspc_temp_files.sql tblspc_temp_files.sql -This script help you to find the information about temp tablespace files in oracle database.
27/02/2022
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.
21/02/2022
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.
20/02/2022
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.