8-ASSIGNMENTS ON STORAGE STRUCTURE (2)

8-ASSIGNMENTS ON STORAGE STRUCTURE (2) - 4. List the free...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENTS ON STORAGE STRUCTURE 1. Identify the different types of segments in your database 2. Write a query to check which segment are within five extents short of the maximum extents. Ignore the bootstrap segment. This query is useful in identifying any segments that are likely to generate errors during future data loads 3. Which files have space allocated for the EMP table?
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4. List the free space available tablespace wise. The query should display the number of fragments, the total free space, and the largest free extent in each tablespace 5. List segments that will generate errors because of lack of space when they try to allocate an additional extent....
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online