Oracle Support – Useful Metalink References

Patch Set Updates for Oracle Products [ID 854428.1] Quick Guide to Avoid Issues in Creating DB Control Using EMCA [ID 750768.1] Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1] Oracle E-Business Suite Recommended Performance Patches [ID 244040.1] CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1] Cloning Oracle Applications Release 11i […]

Read the rest of this entry »

GPFS use with Oracle

When utilizing GPFS with Oracle, configuration and tuning considerations include: When setting up your LUNS it is important to: Create the logical volumes such that they map one to one with a volume group and a volume group be one to one with a LUN which is a single RAID device. Not stripe logical volumes […]

Read the rest of this entry »

Understand each sections of AWR

AWR report is broken into multiple parts. 1)Instance information:- This provides information the instance name , number,snapshot ids,total time the report was taken for and the database time during this elapsed time. Elapsed time= end snapshot time – start snapshot time Database time= Work done by database during this much elapsed time( CPU and I/o […]

Read the rest of this entry »

AWR and Performance Tuning

Oracle 10g provides a wealth of features, and my favorite among them is AWR. AWR has come to my rescue in critical situations where our  customers face performance issues. AWR collects database performance statistics and metrics for analysis and tuning, shows the exact time spent in the database, and even saves session information Performance can […]

Read the rest of this entry »

Oracle data buffer cache and v$db_cache_advice

Today let me brief one of the Oracle9i new features, which helped me in many projects to determine optimal size of the data buffers in large databases. The new view, v$db_cache_advice, that can predict the benefit of additional data buffers in the data buffer cache. This v$db_cache_advice view shows the estimated miss rates for twenty […]

Read the rest of this entry »