Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that need to be performed before and after applying a patch to an Oracle database or software environment. prepatch.sh is executed once each ORACLE_HOME, but there are two different scripts, one for the CRS_HOME and the … Read more
Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and their descriptions: 1. Administrative These waits occur due to DBA commands that cause users to wait, such as during an index rebuild. 2. Application Waits caused by user application code, like lock waits due to … Read more
Size of the Data: Determine the size of the database objects you intend to export. This includes tables, indexes, and other database structures. Compression: Decide whether you’ll use compression during the export process. Compressed exports require less disk space but may take longer to complete. Export Options: Consider any additional options you’ll use during the … Read more