CHAPTER 5Oracle Storage

Exam Objectives

In this chapter you will learn to

• 052.6.1 Work with Tablespaces and Datafiles

• 052.6.2 Create and Manage Tablespaces

• 052.6.3 Handle Space Management in Tablespaces

The preceding 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 occurs in the database on disk. The database consists of three file types: the controlfile, the online redo log files, and the datafiles. Data is stored in the datafiles.

Users never see a physical datafile. All they see are logical segments. System administrators never see a logical segment. All ...

Get OCA/OCP Oracle Database 11g All-in-One Exam Guide 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.