Performance Tuning - Question 093

Which tablespace is used as the temporary tablespace if ‘TEMPORARY TABLESPACE’ is not specified for a user?

A. TEMP

B. DATA

C. SYSTEM

D. ROLLBACK

Answer: C

Explanation:

When a user’s Server Process writes a sort chunk to disk, it writes the data to the user’s temporary tablespace. This tablespace, although it is referred to as the user’s temporary tablespace, can have the tablespace attribute of being either permanent or temporary. If theer is no TEMPORARY TABLESPACE specified for the user, SYSTEM tablespace will be considered as temporary tablespace for the user.

Incorrect Answers

A: There is no TEMP tablespace in Oracle by default.

B: There is no DATA tablespace in Oracle by default.

D: ROLLBACK tablespace cannot be used as temporary tablespace.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 420-423

Chapter 8: Tuning Disk I/O