Total Time: 1 hour(s)

Summary: 
This course discusses the tools used to monitor and manage storage in an Oracle 10g Database, such as the Segment Advisor, the Undo Advisor, and the Redo Logfile Size Advisor. This course also covers index-organized tables, clustered tables, sorted hash clusters, and Resumable Space Allocation

Ojectives: 
After completing this course, students will be able to:
Describe the use of Redo and Archive logs.
Suspend transactions that hit space problems.
Size the tables appropriately using the Segment Advisor.
Rebuild indexes online.

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.