7 Managing Database Storage Structures

CERTIFICATION OBJECTIVES

7.01 Understand Tablespaces and Datafiles

7.02 Create and Manage Tablespaces

7.03 Manage Space in Tablespaces 3

image Two-Minute Drill

image Self Test

The previous two chapters dealt with the instance and the sessions against it: processes and memory structures. This chapter begins the investigation of the database itself. All data processing occurs in memory, in the instance, but data storage is in the database on disk. The database consists of three file types: the controlfile, the online ...

Get OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.