Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

What's New in Oracle Database Administrator's Guide?

Oracle Database 11g Release 2 (11.2) New Features in the Administrator's Guide

Part I Basic Database Administration

1 Getting Started with Database Administration

2 Creating and Configuring an Oracle Database

3 Starting Up and Shutting Down

4 Configuring Automatic Restart of an Oracle Database

5 Managing Processes

6 Managing Memory

7 Managing Users and Securing the Database

8 Monitoring Database Operations

9 Managing Diagnostic Data

Part II Oracle Database Structure and Storage

10 Managing Control Files

11 Managing the Redo Log

12 Managing Archived Redo Logs

13 Managing Tablespaces

14 Managing Datafiles and Tempfiles

15 Managing Undo

16 Using Oracle-Managed Files

Part III Schema Objects

17 Managing Schema Objects

18 Managing Space for Schema Objects

19 Managing Tables

20 Managing Indexes

21 Managing Clusters

22 Managing Hash Clusters

23 Managing Views, Sequences, and Synonyms

24 Repairing Corrupted Data

Part IV Database Resource Management and Task Scheduling

25 Managing Automated Database Maintenance Tasks

26 Managing Resource Allocation with Oracle Database Resource Manager

27 Oracle Scheduler Concepts

28 Scheduling Jobs with Oracle Scheduler

29 Administering Oracle Scheduler

Part V Distributed Database Management

30 Distributed Database Concepts

31 Managing a Distributed Database

32 Developing Applications for a Distributed Database System

33 Distributed Transactions Concepts

34 Managing Distributed Transactions

Part VI Appendices

A Support for DBMS_JOB in Release 11gR2

Index