Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

What's New in Oracle Database 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

10 Managing Oracle Enterprise Manager Database Control

Part II Oracle Database Structure and Storage

11 Managing Control Files

12 Managing the Redo Log

13 Managing Archived Redo Logs

14 Managing Tablespaces

15 Managing Data Files and Temp Files

16 Managing Undo

17 Using Oracle Managed Files

Part III Schema Objects

18 Managing Schema Objects

19 Managing Space for Schema Objects

20 Managing Tables

21 Managing Indexes

22 Managing Clusters

23 Managing Hash Clusters

24 Managing Views, Sequences, and Synonyms

25 Repairing Corrupted Data

Part IV Database Resource Management and Task Scheduling

26 Managing Automated Database Maintenance Tasks

27 Managing Resources with Oracle Database Resource Manager

28 Oracle Scheduler Concepts

29 Scheduling Jobs with Oracle Scheduler

30 Administering Oracle Scheduler

Part V Distributed Database Management

31 Distributed Database Concepts

32 Managing a Distributed Database

33 Developing Applications for a Distributed Database System

34 Distributed Transactions Concepts

35 Managing Distributed Transactions

Part VI Appendixes

A Support for DBMS_JOB in Oracle Database 11g Release 2

Index