Learn Oracle


I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and Oracle DBA friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

Step 5 - Viewing and Modifying Initialization Parameters

Learn Oracle - Viewing and Modifying Initialization Parameters

When Oracle DBA install one of the preconfigured databases provided by Oracle, the initialization parameters are optimized for normal use in the environment that Oracle DBA specified. It is not necessary for Oracle DBA to alter any initialization parameters at this time.

The steps described in this section will familiarize you with the initial parameter setting for your database and indicate how to modify parameters.

To view or modify the initialization parameters for your database:

1. From the Database Home page, click the Administration property page.

2. Click All Initialization Parameters under the Instance heading. Enterprise Manager displays the Initialization Parameters page comprised of a table listing the current value of each initialization parameter as seen by the database instance. Oracle DBA can also use this page to alter initialization parameter values, using the Show SQL, Revert, and Apply buttons.

There are two property pages shown on the Initialization Parameters page:

Current—The table on this property page displays all of the initialization parameter values currently seen by the database instance (in memory). Oracle DBA can use this page to make dynamic changes to parameters in the current running instance. Only parameters marked dynamic can be changed. To do so, enter a new value and click Apply.

This property page is present when Oracle DBA are using a server parameter file, whose location is displayed a the top of the table. This property page shows parameter settings in the server parameter file.

Changes to parameter settings in this file are persistent across instance startup and shutdown. To make persistent changes to an initialization parameter, enter the new value and click Apply. Oracle DBA can optionally apply changes to the current running instance by checking Apply changes in SPFile to the current running instance. If you do not check this box, your changes will not take effect until the database is shut down and restarted.

As the number of database users grows and workload increases, Oracle DBA might need to alter some initialization parameters. You can make these changes directly using the Initialization Parameter page as described, or indirectly using one of the advisors provided by Oracle.
Oracle Tutorial - BLOGS

STEP 5 - Next Topics
This step discusses starting and stopping the database instance, and managing initialization parameters.Learn Oracle DBA Step 5 by clicking links below:
Instance Memory StructureConfiguring Network
Oracle Background ProcessesBackground processes
Accessing the DatabaseAccessing the Database
Shuting down and Restarting the instance and DatabaseStarting and shutting the database
Viewing and Modifying InitializationViewing Parameters
Managing Memory Parameters
Oracle Database - PODCASTS
More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking
Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Source : Oracle Documentation | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info