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 12c has already ended, and Extended Support will expire in July 2022. After this date, Oracle is under no obligation to provide further updates for … Read more
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 ignore the errors during import and will continue the import. What are the differences between expdp and exp (Data Pump or normal exp/imp)? Data Pump … Read more
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 export of that table was started. This means that if you start exporting the table at 12:00 and someone makes changes to the data in … Read more
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’ to ‘1.4’ ORA-65011: Pluggable database F3094217277_21_4 does not exist. ORA-65169: error encountered while attempting to copy file /opt/app/oracle/prd/coddy/users.dbf ORA-19502: write error on file “/opt/app/oracle/prd/coddy/datafile/o1_mf_users_gc8xyz9o_.dbf”, block … Read more
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 recording changes made to data (such as inserts, updates, and deletes) in a sequential manner. These changes are logged in redo log files to ensure … Read more
Scenario 1: If the jobs are running too frequently, it is possible the queries are not releasing the lock and resulting in the error: “ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired”. DDL statements must obtain the library cache lock in order to perform DDL, so an explicit DDL lock timeout should … Read more
A full table scan reads all rows from a table, and then filters out those rows that do not meet the selection criteria. Just because during accessing large number of blocks with FTS Oracle can use multiblock I/O read call, FTS is sometimes better than index range scans. Reason Explanation No index exists. If no … Read more
There is no excerpt because this is a protected post.
Computer memory is managed in blocks of storage known as pages, which have a predetermined size that depends on the computer’s architecture. These pages are organized using a page table, which is a data structure that links virtual memory addresses to their physical location in memory. As companies store more and more information in their … Read more
On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle XML DB is not already installed in your database prior to an upgrade to Oracle Database 12c or later, then it is automatically installed in tablespace SYSAUX during the upgrade. If Oracle XML DB has … Read more