O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting database initialization parameters

In Chapter 3, Creating the Oracle Database, we introduced the concept of database initialization parameters. We said that these parameters can be used to control nearly every aspect of database operations. In this section, we examine the concept of the parameter file and learn how to change initialization parameters.

Understanding the PFILE and SPFILE

During the process of creating our database in Chapter 3, Creating the Oracle Database, we were presented with the following screen:

Understanding the PFILE and SPFILE

As the title of this window, All Initialization Parameters, would suggest, we use this screen to define the initialization parameters ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required