This chapter focuses on the tasks involved in managing your
instance. In this chapter, you will learn how to use the property pages in the
Instance region of the Administration page of Enterprise Manager.
Move your mouse over this icon to show all screenshots.
You can also move your mouse over each individual icon to see only the screenshot
associated with it.
The instance is idle until it is started. When the instance
is started, an initialization parameter file is read and the instance is configured
accordingly. After the instance is started and the database is opened, users
can access the database. In this section, you will examine the following tasks:
You can use Enterprise Manager to start the instance and open
the database by performing the following steps:
1.
Invoke Enterprise Manager from your browser. The Database
page is displayed indicating that the instance is down. Click Startup
to start the instance.
2.
The Startup/Shutdown:Specify Host and Target Database
Credentials page is displayed. Enter the host credentials and database
credentials. Click OK.
3.
The Startup/Shutdown:Confirmation page is displayed.
Click Yes to start the instance and open the database.
4.
The Startup/Shutdown:Activity page is displayed.
5.
After the instance is started and the database is open,
the Login page is displayed. Enter the username and password to
log in to Enterprise Manager Database Control. Click Login.
The initialization parameter file contains a list of configuration
parameters for the instance and database. The Oracle database server reads these
parameters at database startup and monitors them while the database is running.
The values of the parameters are stored in memory and many can be changed dynamically.
Follow the steps below to view the values of the initialization
parameters for your database:
1.
Click Administration on the Database Home
page to access the Administration property page.
2.
Click All Initialization Parameters in the Instance
section.
In this section you learn how to view the values of the memory
parameters in your database. Memory parameters are the initialization parameters
that determine the total size of the system global area (SGA) and its sub-components,
and the program global area (PGA). The values of the memory parameters can affect
the performance of your database.
If the Oracle server advises you of a performance problem
relating to the size of the SGA or PGA, you can use the memory advisor to help
you determine appropriate new settings. The memory advisor can model the effect
of parameter changes. Refer to Chapter 10 for information on using the memory
advisors.
Perform the steps listed below to view the values of the memory
parameters:
1.
Click Administration on the Database Home
page to access the Administration property page.
2.
Click Memory Parameters in the Instance
section.
3.
The Memory Parameters page appears.
Move your mouse over this icon to hide all screenshot
Bookmark
