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
Monitor Oracle alert log - Exercise
Monitor the alert log
Objective:
Write a script to monitor the alert log for two errors messages.
Exercise scoring
You will receive 5 points for successfully completing this exercise. To get full credit, you'll need to correctly write a script in the language of your choice that will monitor the alert log for two exceptional conditions. Once you have completed your answer, you'll submit your answer.
Instructions
In the previous lesson, you learned about a script that you could write and schedule to automatically check the most recent 400 lines of the alert log. The example used the UNIX "tail" command to do this. For this exercise, write your own script that checks for the following messages:
unable to extend rollback segment
unable to extend object
Hints
The example is written for the UNIX operating systems using the Korn shell language, but you can create these types of scripts in any language. If you choose, you can write your script for a different OS and in a different language. Just inform your tutor of this by adding a note in the text box.
Submitting your exercise
Once you've entered your response into the text box, Click the
Submit
button to submit the exercise.