79834

Common Oracle DBA Tasks

As an Oracle DBA. you can expeci to be involved in the fol łowi ng tasks: ■Installing Oracle software ■Creating Oracle dalabases

■Performing upgradcs of the databasc and software to ncw rclcasc lcvels ■Slarting and shutting down the database instance ■Managing the storage structures of the database ■Managing u sers and security

■Managing databasc objeets. such as tables. indexcs. and vicws

■Backing up the database and performing recovcry operations w hen ncccssary

■Monitoring the siatę of the database and taking preventive or corrective aclion as

required

■Monitoring and tuning databasc performance

■Diagnosing and reporting critical errors to Oracle Support Services

In a smali to medium-si/^d database environment, you might be the sole person

performing these tasks. In large, enterprise environments. the job is often divided

among scvcral DBAs. cach of whom has a specialty. such as databasc security or

database tuning.