RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
CPU Usage | 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
Interpreting vmstat output - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
You have been asked to monitor your database server for possible CPU bottlenecks. You are running a 4-way symmetric multiprocessor. You have run vmstat and observed the following output:
vmstatquiz
What is the status of the memory on this database processor?
Please select
the best answer
.
A.
Significant memory paging
B.
Moderate memory paging
C.
No memory paging
2.
What is the status of the CPU on this database processor?
Please select
the best answer
.
A.
CPU busy at greater than 95%
B.
CPU between 50% and 95% busy
C.
CPU busy between 0% and 49% busy
3.
What is the status of the waiting tasks on this database processor if it has a 6-way SMP?
Please select
the best answer
.
A.
Run queue is less than 6, so there are no CPU waits
B.
Run queue is less than 6, so there are 50% CPU waits
C.
Run queue is less than 6, so there are about 3 tasks waiting on CPU
4.
Which statement best describes the situation reflected in this output
Please select
the best answer
.
A.
The server is busy and there is a CPU bottleneck.
B.
The server is busy and at the verge of a CPU bottleneck, but no bottleneck exists.
C.
There is significant memory paging.
D.
There are significant CPU wait events.