RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Data Dictionary
«Prev
Next»
Performance Tuning
Data Blocks
Database Block Size
Optimizing Space Usage
Segment Header Internals
Data Block Fundamentals
PCtfree Optimal Performance
PCtused Optimal Performance
PCT Used Optimal Performance
PCT Used Performance
Setting PCT Used Guidelines
Monitoring Tuning Indexes
Monitoring Tuning Indexes
Analyzing Oracle Index
Table High Water Marks
Water Mark Active
DB Engine Conclusion
Data Structures
Oracle Structures
Abstract Data Types
Using Oracle Objects
Oracle nested Tables
Oracle Data Constructs
Oracle Varrays
Performance Conclusion
Data Dictionary
Performance Views
DBA Performance
Building Alert Monitor
Oracle Data Dictionary
Partitioned Tuning
Partitioned Objects
Database Objects
Global Partitioned Indexes
Local Partitioned Indexes
Partitioned Index Maintenance
DB Partitioned Features
Index Techniques
Bitmap Indexes
Increase Query Speed
DW Star Schema
Star Transformation Queries
Star Transformation Process
Transformation Process
Using Concatenated Indexes
Function Based Indexes
Bitmapped Indexes
Oracle Database Tuning
Oracle Web Applications
Web Request Broker
Oracle Tuning - Glossary
DBA Performance Tools - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which V$ view contains global accumulated statistical information about the Oracle database?
Please select the best answer.
A.
V$SYSSTAT
B.
V$SGASTAT
C.
V$SESSION
D.
V$LIBRARYCACHE
2.
Which view can be interrogated to see if a table can take another extent?
Please select the best answer.
A.
V$SESSION
B.
DBA_TABLESPACES and DBA_TABLES
C.
DBA_VIEWS
D.
DBA_DATA_FILES and DBA_SEGMENTS
3.
What are listed as conditions that the DBA would want to be alerted to? (Choose all that apply)
Please select all the correct answers.
A.
Objects that cannot take another extent
B.
Object has high extents
C.
Too many connected sessions
D.
Tablespace is getting too full
4.
This question is based on the script we created in the "How to build an alert monitor" simulation shown below. What best describes the method for detecting objects with more than 600 extents?
Please select the best answer.
A.
Viewing the NEXT_EXTENT column of DBA_OBJECTS
B.
Viewing the NEXT_EXTENT column of DBA_TABLES
C.
Viewing the EXTENTS columns of DBA_SEGMENTS
D.
Viewing the MAX_EXTENTS columns of DBA_TABLES