Library Cache Lock Waits

Library Cache Lock Waits

Oracle 12c Optimizing Performance

Optimizing Performance Chpt 14 This is part of the Oracle documentation This section deals with the SDU and why it is important to resize this to maximize performance in a situation where network performance is critical

Performance Tuning Functions

V$SQL_MONITOR displays SQL statements whose execution have been (or are being) monitored by Oracle. An entry is created in V$SQL_MONITOR every time the execution of a SQL statement is being monitored. SQL monitoring is automatically started when a SQL statement runs parallel or when it has consumed at least 5 seconds of CPU or I/O […]