Beginning Oracle Database 12c Administration: From Novice to Professional, Second Edition

CHAPTER 9

Taking Control

Then felt I like some watcher of the skies

When a new planet swims into his ken;

Or like stout Cortez, when with eagle eyes

He stared at the Pacific—and all his men

Look’d at each other with a wild surmise—

Silent, upon a peak in Darien.

“On First Looking into Chapman’s Homer” by John Keats

If you are going to be responsible for a database, you need to know what it contains and how it is being used. Which are the biggest tables? How are the data files, control files, and log files laid out? How many people have database accounts? How many people use the database at a time? Your first action when you acquire responsibility ...