1. | System trace files can be found in the directory identified by which initialization parameter? |
|
2. | What Oracle tool can the DBA use to monitor the size of a tablespace and notify the DBA when the tablespace is running out of space? |
|
3. | True or false: The alert log file records both successful and unsuccessful logins to the database. |
|
4. | The alert log file can be found in the directory identified by which initialization parameter? |
|
5. | What does the Oracle utility TKPROF do? |
|
Answers
1. | System trace files can be found in the directory identified by the BACKGROUND_DUMP_DEST parameter. |
2. | OEM’s Event Manager tool can be used to monitor space conditions in database tablespaces. |
3. | False, the alert log file records database startup and shutdown, but not user logins. |
4. | The alert log file can be found in the directory identified by the BACKGROUND_DUMP_DEST parameter. |
5. | The Oracle utility TKPROF formats a user trace file containing SQL statement statistics into a readable format. |