Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8 Administration: Managing Storage |
| Course Status: | Released | Course Features |
| Course Language: | English | |
| Course Duration: | 4 Hours | |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Database administrators |
| Prerequisites |
| Completion of the Oracle Introduction curriculum |
| Course Aim |
| To explain tablespace creation and maintenance, and to discuss extent allocation and block-space utilization |
| Learning Objectives |
| Create tablespaces. Explain tablespace sizing issues. Describe segment types. Explain how to control extent allocation. Coalesce free space. Monitor space utilization. |
| Topics Covered |
| Creating tablespaces - Logical database structure - Tablespace creation - Hands-on: Creating a tablespace - Hands-on: Creating a tablespace in OEM Tablespace administration - Resizing - Hands-on: Increasing tablespace space - Hands-on: Increasing tablespace space in OEM - Status - Obtaining information Segments and extents - Segment types - Controlling extent allocation - Hands-on: Coalescing free space Monitoring storage structures - Block space utilization - Useful data dictionary views - Hands-on: Monitoring segments |