RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Data Buffer Cache
«Prev
Next»
Tuning Oracle Instance
Instance Tuning
Main Components SGA
Shared Pool Tuning
Oracle Library Cache
Query Dictionary Cache
Global Area Session
Data Buffer Cache
Redo Log Buffer
Instance Tuning Conclusion
Shared Pool Tuning
Shared Pool Optimal Tuning
Pin Packages Shared Pool
Reserved Size
Identifying High Use Packages
Pinned Packages Output
IIdentify Swapped out Items
Statistics gathered from Startup
Detecting Library Cache Contention
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
Oracle Redo Logs
Tuning Techniques
View RedoLog Activity
Redo Log Parameters
RedoLog Wait Statistics
RedoLogs Online Size Determination
size Archived RedoLog FileSystem
Tune redo Log Operations
log_checkpoint_interval
RedoLog Tuning Conclusion
Sorting Operations
Oracle Sorting Basics
Sorting Parameters
SQL Join Operations
Monitor for Disk Sorts
Sorting Direct Writes
Temporary Sorting Space
Monitoring Temp Tablespace
Remove SQL Sorts
Sorting Operations Conclusion
Intro Tuning Oracle Locks
Oracle Locking Scheme
Shared Exclusive Locks
Oracle Lock Modes
Database Deadlocks
Preventing Database Deadlocks
Dictionary Lock Views
Lock Utility Scripts
DBMS Lock Package
Tuning Oracle Locks Conclusion
Oracle Buffer Concepts - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
What is the best way to improve the buffer hit ratio for a small, frequently read table? (Choose all that apply)
Please select all the correct answers.
A.
Use the ALTER TABLE table1 CACHE; command.
B.
Use the RECYCLE pool for the table.
C.
Use the KEEP pool for the table.
D.
Use the DEFAULT pool for the table.
2.
Which data buffer pool would be most appropriate for a table that is always accessed with a full-table scan?
Please select the best answer.
A.
KEEP pool
B.
RECYCLE pool
C.
DEFAULT pool
3.
What is a possible remedy for a poor data buffer hit ratio? (Choose all that apply)
Please select the best answer.
A.
Increase db_block_buffer
B.
Tune queries to remove full-table scans
C.
Move large tables into the KEEP pool
D.
Increase db_file_multiblock_read_count
4.
Which tuning technique would be the most beneficial for tuning a full-table scan against a very large Oracle table?
Please select the best answer.
A.
Re-setting db_file_multiblock_read_count to a higher value
B.
Segregating the table into the RECYCLE pool
C.
Segregating the table into the KEEP pool
D.
Increasing the value of db_block_buffer