This event signifies that the user process is reading a buffer into the SGA buffer cache and is waiting for a physical I/O call to return. A sequential read is a single-block read. DB file sequential reads wait event comes under the User I/O wait class. In any busy system this is one of the … Read more
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. There are two inventories : 1. The inventory in the ORACLE_HOME (Local Inventory) 2. The central inventory directory outside the ORACLE_HOME (Global Inventory) At startup, … Read more
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 minor code changes. Oracle Support cannot fix TX lock wait issues other than helping to identify the objects and commands causing the waits. This wait … Read more