Chapter 4. Managing an Instance

Terms you'll need to understand:

• DB_NAME

• Startup

• Shutdown

• Initialization parameter file

• V$SESSION

• Alert log

• Background_dump_dest

• User_dump_dest

• Core_dump_dest

• MAX_DUMP_FILE_SIZE

• SQL_TRACE

Concepts you'll need to master:

• Create and manage initialization parameter files.

• Configure Oracle Managed File Systems.

• Start up the instance.

• Shut down the instance.

• Monitor and use diagnostic files.

In this chapter, you learn how, together, Oracle and you manage the instance and its processes. It is in this area that you will typically spend a considerable percentage of your time as a DBA, and a basic understanding is critical.