ADM506 Database Administration Oracle II

Download from Rapidshare
Download from Mediafire

Course Overview

Course Goals …………………………………………………..vii
Course Objectives ……………………………………………..vii
Unit 1: Introduction to Oracle cache management …………….1
Oracle System Global Area……………………………………..2
Oracle Program Global Area …………………………………. 20
Unit 2: Monitoring of the database instance………………….. 37
The New Oracle Database Monitor provided by SAP………… 38
Oracle Wait Interface …………………………………………. 54
Unit 3: Analyzing application design………………………….. 79
Consequences of Expensive SQL Statements ………………. 81
Using SM50/SM66 to Find Expensive SQL Statements ……… 85
Using ST03N/STAD to Find Expensive SQL Statements…….. 88
Using ST04N to Find Expensive SQL Statements …………… 92
Using the SQL Trace to Find Expensive SQL Statements …..106
Exclusive Lockwaits ………………………………………….113
Unit 4: Index management and optimization …………………127
Index utilization……………………………………………….128
Creating an index …………………………………………….142
Unit 5: Cost Based Optimizer ………………………………….163
Update statistics………………………………………………164
Cost evaluation……………………………………………….178
Unit 6: Analyzing memory configuration……………………..199
Data Buffer Utilization ………………………………………..200
Efficiency of the Shared Pool…………………………………214
Monitoring the Automatic Program Global Area ……………..222
Unit 7: Analyzing physical and logical layout………………..235
Fragmented indexes………………………………………….236
I/O contention…………………………………………………252
Index ……………………………………………………………..261