Shared pool tuning due to performance issues In Shared pool area of SGA memory, Oracle keeps the DDL of SQL queries, PL/SQL packages, object information and etc. For understanding …

  Tuning Buffer Cache and DBWR process for performance Understand the terminology involved in Buffer CacheBuffer CacheOracle having copies of database blocks for frequent access instead of fetching from disks …

Buffer busy wait in Statspack report Oracle ERROROn fetching the statspack report from Oracle Database, We are getting the Buffer busy wait on top: Avg Total Wait wait Waits Event …

  Buffer Busy Waits in Oracle Buffer busy waits is directly related to I/O in statspack report its also directly relate to “db file sequential read” and “db file scattered …