MK's Oracle DBA and performance tuning blog

O racle Database Wait Events I will describe some of the wait events that cause performance problems in Oracle Databases. You can find the top 5 wait events in the AWR reports. In this article, I will tell you about the most frequently encountered Wait events in AWR reports.   racle Wait Events and Their Solutions b file sequential read Db file sequential read:  This event occurs when a user tries to perform a Physical I/O while waiting for sequential reads from the Buffer cache. This type of situation usually occurs when the data on the table is accessed by using index, not full table scan, as a result of single block reading.   If this event occurs,  possible reasons are wrong index usage, index fragmentation, excessive I/O traffic on specific disks. To Solve this problem, Query should use Right index and fragmented indexes should be defragmented with Rebuild Index operation. When you encounter this wait event, which appears very frequently in AWR and ADDM reports,...

  SQL Tune Query 1) To tune particular sql_id. DECLARE   l_sql_tune_task_id  VARCHAR2(100); BEGIN   l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (                           sql_id      => '&&1',                           scope       => DBMS_SQLTUNE.scope_comprehensive,                           time_limit  => 4000,                           task_name   => '&&1'||'_manual_...

  Original:  SQL Tune Report–sqltrpt.sql ORACLE 10g provides a script sqltrpt.sql to query the most resource-intensive SQL. ln addition, according to the input SQL_ID, generate corresponding execution plan and tuning recommendations, which is a good tuning optimization script. In fact, sqltrpt is an abbreviation of SQL Tune Report. This script is located at $ORACLE_HOME/rdbms/admin/sqltrpt.sql. The specific script is as follows Rem Rem $Header: sqltrpt. sql 11-apr-2005.11:01:39 pbelknap Exp $ Rem Rem sqltrpt. sql Rem Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  Rem Rem    NAME Rem      sqltrpt. sql - SQL Tune RePorT Rem Rem    DESCRIPTION Rem      Script that gets a single statement   as   input   from the user (via SQLID), Rem      tunes that statement , and   then displays the text report. Rem Rem    ...