RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Oracle Instance
«Prev
Next»
Tuning Oracle Instance
Instance Tuning
Main Components SGA
Oracle Library Cache
Query Dictionary Cache
Shared Pool Tuning
Shared Pool Optimal Tuning
Pin Packages Shared Pool
Pinning Memory Objects
Reserved Size
Shared Pool Reserved Size
Tuning Parameters
Identifying High Use Packages
Identify Swapped out Items
Detecting Library Cache Contention
Reduce Fragmentation
Library Cache Statistics
Reuse SQL Library Cache
Tuning Shared Pool
Data Buffer Cache
Tuning Data Buffer
Calculate buffer Hit Ratio
Non- Full table Scan
Full table Scan
Impact Adding Data Buffers
Predict Amount Spare Memory
Create multiple Buffer Pools
Configure Multiple Buffer Pools
Size Buffer Pools
Monitor Buffer Cache
Use Table Caching
Databuffer Cache Conclusion
Redo Log Tuning
log_checkpoint_interval
RedoLog Wait Statistics
size Archived RedoLog FileSystem
RedoLogs Online Size Determination
Sorting Operations
Oracle Sorting Basics
Monitoring Temp Tablespace
sort_direct_writes
Tuning Oracle Locks
Oracle Instance Tuning - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following is a symptom of a shared_pool_size problem?
Please select the best answer.
A.
A low data buffer hit ratio
B.
A poor library cache hit ratio
C.
A high amount of redo log space requests
D.
A high amount of disk sorts
2.
When you suspect an instance tuning problem, what is the best source of Oracle tuning information?
Please select the best answer.
A.
The Oracle data dictionary tables
B.
The v$ views
C.
The Oracle utilities (bstat-estat)
D.
The OS performance statistics
3.
Which sequence correctly shows types of tuning in the following order: from most important to least important?
Please select the best answer.
A.
SGA tuning, disk I/O tuning, database design tuning, SQL statement tuning
B.
SGA tuning, database design tuning, SQL statement tuning, disk I/O tuning
C.
Database design tuning, disk I/O tuning, SQL statement tuning, SGA tuning
D.
SQL statement tuning, SGA tuning, database design tuning, disk I/O tuning
4.
Which of the following situations cause performance problems for redo log processing? (Please select all that apply.)
Please select all the correct answers.
A.
Redo logs switch 10 per hour
B.
Redo log switch 2 per hour
C.
The database experiences a high value for redo log space requests.
D.
The archived redo log file system becomes full.