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.
Objectives:
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
Topics:
Monitoring and Managing Storage
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
