RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Memory Processes
«Prev
Next»
Backup Recovery
Backup Considerations
DBA Responsibilities
DBA Role Considerations
Operational Considerations
Technical Considerations
Disaster Recovery Plan
Plans Testing
Backup Recovery Strategy
Oracle Memory Processes
Oracle Instance Structure
DBWR Arch Process
Oracle Recovery Data Structures
DB Configuration File
Database Control File
Control File Maintenance
RedoLog Files
Writing Redo Log Files
Multiplexing Redo Log
Archive Log Files
Checkpoint Process
Physical File Placement
State Structure Database
File Components Conclusion
Archivelog Noarchivelog
Physical Logical Backups
Archivelog Mode
Archiving Options
Archive Process Options
Normal Arch Processing
Manual Archiving
Auto ArchiveLog Options
Retrieve ArchiveLog
Standby Database
VM Conclusion
Oracle Memory Structures - Exercise
Instance Memory Structures
Objective:
Match terms and definitions
Exercise scoring
This exercise is unscored. It is designed to allow you to check your understanding of instance memory structures. When you are done, click the
Submit
button.
Instructions
In the left column below are several terms, with their corresponding definitions in the right column. Click a term in the left column, and then click the definition in the right column to make a match.
When you have all of the terms and their definitions matched, click the Done button to see whether or not you've matched the terms correctly. Green lines mean the match is correct, red lines mean the match is incorrect. If you didn't get the matches right the first time, click Clear to erase your matches and try again.
When you complete the exercise, click the
Submit
button to see the correct answers.
Term Matching Exercise
Match items in the left column with the items in the right column.
Instructions
In the left column below are three terms and their corresponding definitions in the right column.
Identify a term in the left column and match the definition on the right column to make a match. When you think you have all of the terms and their definitions matched correctly, click the Submit button and you will see whether or not you have matched the terms correctly. When you have completed the exercise, click the
Submit
button to see the correct answers.
V$VGA
INIT.ORA
Shared Pool
log buffer
data buffer cache
ARCH_IO_SLAVES
Used to provide information about the instance
Contains blocks read from datafiles
Contains information to be writing to the redo logs
Used to configure instance parameters
A parameter related to the Large Pool
Contains data dictionary information