Introduction : A deadlock is a situation in which two or more sessions are waiting for each other to release locks, creating a circular dependency. Unlike simple blocking, where one …
Read More »
Implementing Class of Secure Transport (COST) in Oracle RAC 11.2 Introduction:Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances …
Read More »
ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Read More »
ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Read More »
How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle: …
Read More »
How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …
Read More »
ERROR ORA-01157: cannot identify/lock data file 206 – see DBWR trace file ORA-01110: data file 206: ‘+DATA’ SOLUTION If you are using XML in your database and you are trying …
Read More »
ERROR ORA-07445: exception encountered: core dump [kglic0()+756] [SIGSEGV] [ADDR:0x430000010B8AE910] [PC:0x107AB7474] [Address not mapped to object] [] SOLUTION SQL> ALTER SYSTEM SET “_cursor_stats_enabled”=false SCOPE=SPFILE; Caution : This recommendation can be applied …
Read More »
How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted block SELECT * FROM v$database_block_corruption — will show if any corruped block Step 2: Below query can give you …
Read More »
ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify UID not null; ORA-01442: column to be modified to NOT …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner