In this chapter, we've begun to dig deeper into the day-to-day activities of an Oracle DBA. We've examined the processes of database startup and shutdown, and learned to control those processes. We've managed Oracle database parameters using the PFILE and SPFILE. We've explored the data dictionary and learned to query it in order to retrieve valuable database information. We've learned about the process of gathering database diagnostics, and used the alert log and trace files to do so. We've also looked at the new ADR and ADRCI diagnostic command tools. Finally, we've examined the Oracle Support model, including the My Or...
- from OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
- Publisher: Packt Publishing
- Released: February 2013
Share this highlighthttp://www.safaribooksonline.com/a/oca-oracle-database/1311189/