Performance Tuning

Oracle Statspack has evolved into the Automatic Workload Repository (AWR). Oracle AWR Report AWR collects database statistics every 60 minutes (on the hour) out of… Read More »Oracle AWR Report Analysis

Oracle Wait Events and Solutions for Performance Tuning DB File Sequential Reads Possible Causes :· Use of an unselective index · Fragmented Indexes· High I/O on a particular disk… Read More »Oracle Wait Events and Solutions for Performance Tuning

Oracle Database In-Memory Advisor is designed to optimize analytical processing in the database. The In-Memory Advisor analyzes the analytical processing workload present in your database… Read More »Oracle Database In-Memory Advisor

Oracle 19c SQL Tuning Advisor. Analyze the SQL Tuning Set and generate recommendations A complete script is provided: sta_cc.sql.SQL Tuning Advisor (STA)The Script will: Generate a… Read More »Oracle 19c SQL Tuning Advisor

Oracle Real-Time ADDM Reports are generated using the “rtaddmrpt.sql” and “rtaddmrpti.sql” scripts in the “$ORACLE_HOME/rdbms/admin” directory. The “rtaddmrpt.sql” script assumes the report is for the… Read More »Oracle Real-Time ADDM Reports

The Automatic Workload Repository (AWR) stores performance related statics for an Oracle database. The Automatic Database Diagnostic Monitor (ADDM) is a diagnostic tool that analyzes… Read More »Automatic Database Diagnostic Monitor (ADDM)

Database statistics provide information about the type of database load and the resources being used by the database. To effectively Measuring Oracle Database Performance, statistics must… Read More »Measuring Oracle Database Performance

Oracle Performance Tuning Tips Oracle Performance Tuning is the process of administering a database to improve performance. Performance tuning in Oracle databases includes optimizing SQL statements and… Read More »Oracle Performance Tuning Tips