RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Sorting Operations
«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
Pinning Supplied Packages
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
Tuning Oracle Locks
Sorting Tuning Techniques - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
What was listed as the main drawback of the sort_area_size parameter?
Please select the best answer.
A.
The space in sort_area_size memory is allocated for all connected users, regardless of their sorting needs.
B.
The sort_area_size parameter cannot be used to reduce disk sorts.
C.
The sort_area_size parameter cannot be used with the sort_direct_writes parameter.
D.
The sort_area_size parameter cannot be used with SQL GROUP BY directives.
2.
Which are listed as techniques for reducing disk sorts? (Please select all that apply.)
Please select all the correct answers.
A.
Increasing sort_area_size
B.
Building new indices
C.
Using index hints
D.
Using direct sort writes
3.
Which of the following are true about an Oracle temporary tablespace? (Please select all that apply.)
Please select all the correct answers.
A.
The TEMP tablespace can be used for small sorts by adjusting sort_direct_writes.
B.
The TEMP tablespace is coalesced by the SMON process.
C.
The TEMP tablespace is only used for large sorts that do not fit into sort_area_size.
D.
The TEMP tablespace is never used when sort_direct_writes is set to TRUE.