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…