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.
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, recovery, information lifecycle management, and high
availability 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.
Pages:
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283