RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Alert Log
«Prev
Next»
Performace Tuning Basics
Exam Preparation
Oracle Performance Tuning
Logical Database Design
Architecture Overview
DB Design Tuning
Logical Database Design
Implement Logical Design
Physical Performance
Oracle Expert Systems
Measure Oracle Performance
Performance Tuning Conclusion
Tuning Tequirements
Tuning Process Roles
Define Tuning Steps
Develop Performance Tuning
Identify Tuning Goals
Establish Performance Thresholds
Ongoing Performance Tuning
Business Requirements Tuning
Alert Files
Identify Log Location
Alert Log
Termination Messages
Recognize Severe Errors
Monitor Oracle Alert Log
Alert Files Conclusion
Trace Files
Trace File Desc
Trace File Location
Background User Process
Create Trace Files
Special Trace Events
Trace Files Conclusion
Alert log Concepts - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following messages would most likely be accompanied by a core dump?
Please select the best answer.
A.
ORA-00600 - Internal error code
B.
ORA-7445 - Exception encountered
C.
ORA-1650 - Cannot extend rollback segment
D.
ORA-1650 Failed to extend object
2.
Which of the following is a valid way to find the location of an alert log on a server?
Please select the best answer.
A.
Enter SQL*Plus and query the V$LOG_DEST view
B.
Find background_dump_dest in the init.ora file
C.
Go to $ORACLE_HOME/rdbms.log
3.
Which of the following alert log messages would you want to check for on a regular basis?
Please select all the correct answers.
A.
ORA-600 - Internal error code
B.
Database startup messages
C.
Database log switch messages
D.
ORA-7445 - Exception encountered
4.
Which of the following messages indicate that an update task should be fixed to perform more frequent COMMIT processing?
Please select the best answer.
A.
ORA-600 - Internal error code
B.
ORA-1650 - Failed to extend object
C.
ORA-1650 - Failed to extend rollback segment
D.
ORA-1578 - Oracle data block corrupted