ITS 33477 ORACLE PERFORMANCE AND TUNING

Introduction to tools and techniques to improve performance of currently accepted Oracle server platforms; Files and events supporting tuning process; Application tuning issues impacting database performance; Tuning components and functions of shared pool and buffer cache. Monitor contents and usage of Redo Log buffer. Identify: Database configuration and I/O issues; SQL operations requiring sorts. Use: Direct writes for large sorts and allocate temporary space appropriately; Oracle tools to diagnose and resolve contention. Create tuning session; Gather, view and edit input data. Prerequisite: ITS 33476 Oracle Architecture and Administration.