RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Business Requirements
«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
Overall Tuning Strategies - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following tuning measures is independent of hardware resources?
Please select
the best answer
.
A.
Data buffer hit ratio
B.
Disk sorts
C.
Redo log space requests
D.
Full-table scans
2.
Disk related slowdowns are most likely the result of what condition?
Please select
the best answer
.
A.
Contention within the Oracle data buffer (buffer busy waits)
B.
Disk I/O bottlenecks
C.
High disk sorts
D.
High buffer hit ratio
3.
Which of the following changes require bouncing your Oracle database? (Check all that apply)
Please select
all the correct answers
.
A.
Add blocks to db_block_buffer
B.
Add blocks to shared_pool_size
C.
Add a data file to a tablespace
D.
Increase the process parameter
4.
Which is not an option when capturing long-term Oracle performance data?
Please select
the best answer
.
A.
Use a third-party product to capture and display Oracle data
B.
Write a custom Oracle database to store long-term Oracle data
C.
Use the standard Oracle utilities to store long-term data
