Performance Tuning

 Hard Parses If session execute the SQL statement that not present in the shared pool then Oracle need following steps to placed in memory:1. Allocate memory for the statement from …

  Soft Parses wait in Oracle Soft ParseSession executes a statement that exists in shared pool is refered to Soft Parse. Note: General high “parse call” (> 10/sec.) indicates that …

  Read of datafile ‘E:ORADATAORCLTEMP01.DBF’ (fno 201) header failed with ORA-01202 During the running the datapatch -verbose command for applying patch on DB, We got the following error:Queryable inventory could …

  SQL*Net more data to client event wait In Oracle We generally got the wait “SQL*Net more data to client” in our performance reports. Wait event:SQL*Net data to clientSQL*Net more …

  Memory Paging cause Oracle database performance issue ErrorOn checking the operating system, heavy paging is notice which degrade the performance of the Oracle Database. On unix base systemvmstat and …

  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 …