Performance Tuning - Question 084

The database includes tables with static data, which are used for queries only. To which size should you set PCTFREE for this type of table?

A. 0

B. 50

C. 20

D. 10

Answer: A

Explanation:

The parameter PCTFREE tells Oracle how much space to set aside in each block to store row updates.

Since we have a database with static data, PCTFREE can be set to 0 to use the disk space more effectively.

Incorrect Answers

B: By setting this parameter to 50 you will preserve 50% of data block for the future inserts. It will be just space wasting because of static nature of data inside the tables.

C: This size still cannot be considered as appropriate for the database with static data.

D: You can use this size for the database with minimal level of update activity.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 401

Chapter 8: Tuning Disk I/O