RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Reduce Disk I/O | Process
«Prev
Next»
DBA Taks
Database Monitoring
Tuning Components
Tuning Roles
Network Performance
Disk I/O DB Performance
Memory Usage Performance
CPU Usage
OS Tuning Conclusion
Control File Parameters
iostat Utility
Define hot Disk
Disk Load Balancing
OS methods File Striping
OS File Striping Methods
PCTfree Striped Table
Disk IO Tuning
Managing Redo Log
Virtual Memory
Unix Memory Management
CPU Bottlenecks vmstat
Oracle Table Statistics
Reduce Memory Usage
Virtual Memory Conclusion
Redolog Files
Monitor CPU Usage
Monitor CPU via vmstat
CPU Dispatching
Changing Dispatch Priorities
Monitoring CPU Consumption
Manage Tablespace Files
Resequence Table Rows
ctas Resequence Table Rows
Remove Table Extents
Table Freelists
Oracle Table Reorganization - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following are common causes of chained rows?
Please select
all the correct answers
.
A.
Row length exceeds db_block_size
B.
Rows are expanded after an UPDATE
C.
PCUSED is set too high
D.
PCTFREE is set too high and rows are expanded with UPDATEs
2.
Under which conditions is it beneficial to physically re-sequence table rows?
Please select
all the correct answers
.
A.
In tables that access rows via ROW ID
B.
In tables that access rows via full-table scans with ORDER BY
C.
In tables that access rows via index range scans
D.
In tables where a single index is used by the majority of queries
3.
Which of the following are valid methods for reorganizing tables?
Please select
all the correct answers
.
A.
Export-import
B.
Spooled row data and SQL*Loader
C.
Parallel query
D.
CTAS