Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024

M. Malcher, D. KuhnPro Oracle Database 23c Administrationhttps://doi.org/10.1007/978-1-4842-9899-2_16

16. Automation and Troubleshooting

Michelle Malcher¹   and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

In almost any type of database environment from development to testing to production, DBAs rely heavily on SQL statements, blocks of code, and scripts to perform tasks. Typical jobs that DBAs automate include the following:

• Shutdown and startup of databases and listeners

• Backups

• Validating the integrity of backups

• Checking for errors

• Removing old trace or log files

• Checking for errant processes

• Checking for abnormal conditions

• Performance tuning

Now with 23c, ...