In previous chapters, we set up a database and started using it. In this chapter, we will leverage diagnostic and trace files to learn more about the issues that may be plaguing our Oracle database. If the Oracle instance fails to start or it crashes, the diagnostic files are a great place to start digging into the problem.
Diagnostic Destination
Today’s Oracle database engine combines its diagnostic and trace files into a singular location called the Diagnostic Destination. Prior to Oracle Database 11g, the files were scattered over multiple locations, making it harder to find what you were looking for. ...
