Oracle Essentials, 3rd Edition

Chapter 5. Managing Oracle

Many Oracle users and developers are not actively aware of all the system and database management activities that go on around them. But effective management is vital to providing a reliable, available, and secure platform that delivers optimal performance. This chapter focuses on how you can manage Oracle to ensure these virtues for your environment. Much of the management responsibility usually falls upon the database administrator. However, users and developers of Oracle also need to be aware of some of the techniques described here.

The DBA is typically responsible for the following management tasks:

• Installing and upgrading the database and options

• Creating tables and indexes

• Creating and managing tablespaces

• Managing control files, online redo logs, archived redo logs, job queues, and server processes

• Creating, monitoring, and tuning data-loading procedures

• Adding users and groups and implementing security procedures

• Implementing backup and recovery plans

• Monitoring database performance and exceptions

• Reorganizing and tuning the database

• Troubleshooting database problems

• Coordinating with Oracle Worldwide Customer Support Services

Particularly in smaller companies, DBAs are also often called upon to take part in database schema design and security planning. DBAs in large enterprises may also help set up replication strategies, disaster and high-availability strategies, hierarchical storage management procedures, and the linking of database event monitoring (e.g., ...