ITS 44000 ORACLE DBASE 10g: ADMIN I-A

Introduction to Oracle relational database concepts. Use of SQL for storing, retrieving, and manipulating data in relational databases; Access data from more than one table using joins; Aggregate data using group functions, write sub-queries, and create and populate Oracle database tables; Define, maintain, and modify other database objects; Use SQL's Data Manipulation Language and transaction controls; Control both user and object level security in an Oracle database; Use basic PL/SQL. 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.