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 - Managing Memory Parameters

Learn Oracle - Managing Memory Parameters

Some initialization parameters, referred to here as memory parameters, determine the total size of the system global area (SGA) and the program global area (PGA), and of the subcomponents of the SGA. The settings of memory parameters can affect the performance of your database. When Oracle DBA install your database, these parameters are tuned to meet the requirements of the environment that Oracle DBA specify.

If Oracle DBA enabled Automatic Shared Memory Configuration when Oracle DBA configured your database, Oracle automatically sizes the subcomponents of the SGA, which include the shared pool and buffer cache. Oracle recommends that Oracle DBA enable memory auto tuning.

If Automatic Shared Memory Management is disabled, Oracle DBA can enable it on the Memory Parameters page. You can navigate to this page from the Administration page by clicking Memory Parameters under the Instance heading. From this page Oracle DBA can enable or disable Automatic Shared Memory Management and view your SGA and PGA memory settings from their property pages.

Modifying Memory Parameters

To modify the size of an SGA subcomponent without bringing your instance down, Oracle DBA can disable Automatic Shared Memory Management on the Memory Parameters page.

If Oracle DBA choose to modify your memory settings manually, you can enter new sizes and apply changes dynamically while the instance is up. You can also do so from the Current property page on the Initialization Parameters page. However, there are some restrictions on dynamic modification of memory parameters.

To make changes to memory parameters persistent across instance startup and shutdown, Oracle DBA must alter your parameter file. Oracle DBA can do so by navigating to SPFile property page from the Memory Parameters page and making your changes there.
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 ParametersManage 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