Monitoring and Detecting Lock Contention
Concepts of Locking
Overview of Locking issues
Types of DML locks
Levels of locks
Types of DDL lock modes
Detecting Blocking Locks
Monitoring locking activity
Deadlocks

Tuning Oracle Shared Server
Introducing Oracle Shared Server
When are Shared Servers required in Oracle9i
Monitoring dispatcher processes
Monitoring shared server processes
Increasing or decreasing the number of Dispatchers
Increasing or decreasing the number of Shared Servers
Monitoring Process Usage
Monitoring Memory Usage

Application Tuning
Role of the DBA
Oracle Data Structures
Selecting the physical structure
Data storage structures
Tuning for Different Types of Applications

Using Oracle Blocks Efficiently
Database Storage hierarchy
Allocating extents
Monitoring Space Usage in Data Segments
Recovering space from sparsely populated segments
Monitoring Space Usage in Index Segments

Previous page << pg1 pg2 pg3 pg4 pg5 pg6 pg7 pg8 pg9 pg10 pg11 PAGE12 pg13 Next page >>