Module 12 - Routine Maintenance Tasks

Module Objectives

Database Maintenance

Maintenance Tools

Optimizer Statistics

Example - Updating Statistics

Demo - Optimizer Statistics

Data Fragmentation and Bloat

Routine Vacuuming

Vacuuming Commands

Vacuum and Vacuum Full

VACUUM Syntax

Example - Vacuuming

Example - Vacuuming (continued)

Demo - Vacuum Command

Preventing Transaction ID Wraparound Failures

Vacum Freeze

The Visibility Map

vacuumdb Utility

Demo - vacuumdb Utility

Autovacuuming

Autovacuuming Parameters

Per-Table Thresholds

Routine Reindexing

When to Reindex

Demo - Reindexing

CLUSTER

Example - CLUSTER

Module Summary

Lab Exercise - 1

Lab Exercise - 2