RelationalDBDesign RelationalDBDesign 


Data Blocks  «Prev  Next»

Settings for PCTFREE, PCTUSED, and FREELIST parameters - Exercise

Set table parameters

Objective: Determine the best settings for the PCTFREE, PCTUSED, and FREELIST parameters.

Scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview

You have been asked to allocate an Oracle table according to the following specifications.
Your database has a lot of free disk space, and you want performance over space re-use. The table will be frequently updated and deleted from, and the rows are initially stored without all of their data columns. Rows may double their sizes after they are fully expanded. There may be up to four concurrent transactions updating this table at any time. The block size is 8K.

Instructions

Given the following table definition, add the appropriate storage parameters for PCTFREE, PCTUSED, and FREELISTS.

Create table
Customer(
cust_name  varchar2(40) null,
cust_street        varchar2(40) null
)
storage (initial 10m next 2m pctfree ?? pctused ?? freelists ??);

Based upon this scenario, how many rows will reside on each data block? Determine the best settings for PCTFREE, PCTUSED, and FREELISTS. Please justify your answer.