Oracle Archives - Page 8 of 30

What is Global and Local Inventory in Oracle?

Overview of Inventory: The inventory is a very important part of the Oracle Universal Installer. This is where OUI keeps all information regarding the products installed on a specific machine.…

asrblogger October 17, 2023No Comments

Oracle

Oracle Wait Events : ” enq: TX – Row Lock Contention “

TX lock contention is an application coding, design and usage problem and can ONLY be fixed by changing application code with more frequent and explicit COMMIT statements and any other…

asrblogger October 17, 2023No Comments

Oracle Scripts SQL

How to Identify and Remove the duplicate rows in a Table?

In case if we want to identify duplicates rows of a table and want to remove them from a table. Below are the command which will identify and remove the…

asrblogger October 15, 2023No Comments

Interview Questions Oracle

Basic Concepts of Index

Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key indexes and text indexes are all just variations on the…

asrblogger October 15, 2023No Comments

Oracle

Oracle Database Block Corruption

Block-Corruption-RecoveryDownload What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. Data Block corruptions are one of the common source of database…

asrblogger October 15, 2023No Comments

Oracle

Things to know before Upgrading Oracle 12c DB !!

Why there is a need to upgrade Oracle 12c Database? The most important reason to upgrade 12c is to enjoy continued access to Oracle support. Premier Support for Oracle Database…

asrblogger October 15, 2023No Comments

Interview Questions Oracle

Export/Import Interview Questions-II

What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified file. What is use of IGNORE option in imp? Will…

asrblogger October 15, 2023No Comments

Interview Questions Oracle

Export/Import Interview questions-I

What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of that table will be consistent with the time that the…

asrblogger October 15, 2023No Comments

Core DBA Oracle

ORA-65011: Pluggable database does not exist.

Below is the error while I was upgrading my test environment. SQL> alter pluggable database application CODDY begin upgrade '1.3' to '1.4'; alter pluggable database application CODDY begin upgrade '1.3'…

asrblogger October 14, 2023No Comments

Interview Questions Oracle

What is redo log thread?

In Oracle Database, a redo log thread refers to a specific instance of redo log processing within the database. Redo logs are crucial components of a database system, responsible for…