Oracle World

Oracle World Hi Friends. A survival guide for the ORACLE DBA and Weblogic.

27/02/2022

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 waiting for lock Application team reported this error and the jobs are getting failed.

27/02/2022

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 - This script help you to find the PGA usage in oracle database.

27/02/2022

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

27/02/2022

tblspc_files.sql

27/02/2022

tblspc_temp_free.sql

27/02/2022

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 - 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 - To fix this error we need to first check the oracle database alert logfile.

20/02/2022

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

Address

767, Sector 115 Divine World Society
Mohali
140301

Telephone

+919501077946

Website

Alerts

Be the first to know and let us send you an email when Oracle World posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Oracle World:

Shortcuts

Share

Category