Most Oracle users and developers aren’t actively aware of all the system and database management that goes 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 in a way that contributes to such an 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 into ...