Parameter Configuration 

Definition

This submonitor in the SAP/Oracle Database Monitor lets you view the active Oracle database parameters and the contents of the init<SID>.ora file. You can also see the history of changes to the parameters. You can use this submonitor to view parameters on different instances of an Oracle Real Application Cluster (RAC).

Data is retrieved at run time from the database through a query to the views V$PARAMETER and V$SPPARAMETER. The view V$SPPARAMETER shows the current values of the parameters in the Oracle spfile but not the current values used by the instance. This view returns NULL values if a server parameter file (spfile) is not being used by the instance. You can also check this by looking at the value of the parameter SPFILE in the view V$PARAMETER.

The view V$PARAMETER shows the current values for the parameters used (not the spfile values). If a parameter in the database is changed, it is logged in the alert file. This lets us retrieve the history of changes to each parameter.

Use

·        For each instance, you need to create a table called sap_alert_<Inst_ID>  in order to access the corresponding alert log file data. For this you need to perform the following commands to create this table to access the external alert log file

...

                            a.      Create the path of the alert log file :

[ create directory DIR_1 as 'ALERT_LOG_PATH' ; ]

ALERT_LOG_PATH contains the path of the alert log file of the required instance.

                            b.      Create the database table corresponding to the above alert log file by issuing the following SQL command:

[ CREATE TABLE sap_alert_<INST_ID>

(entry   VARCHAR2(2000) ) ORGANIZATION EXTERNAL

(TYPE oracle_loader  DEFAULT DIRECTORY DIR_1 ACCESS PARAMETERS

(RECORDS DELIMITED BY NEWLINE

NOBADFILE

NOLOGFILE

NODISCARDFILE

FIELDS TERMINATED by '   '

MISSING FIELD VALUES ARE NULL

(entry )

) location('ALERT_LOG_FILE_NAME') );  ]

Notice the directory DIR_1 near the top of the above command. Make sure that you provide the file name in the ALERT_LOG_FILE_NAME.

Make sure that the tables match the alert log file path whenever its directory or its name changed.

·        To start the submonitor, you choose Detailed Analyses ®  Additional Functions ® Display V$/GV$ Views and Values. You cannot view history information in this monitor.

Structure

·        Active Parameters

This tab page displays the parameters that are currently active in the database. It displays the following information:

Column	Description
Instance ID	Instance ID
SID	Name of the RAC instance
Parameter	Name of the active parameter
Parameter value	Value of the parameter
Value in SPFILE	Value in SPFILE (if present)

 

·        Init<SID> file

This tab page displays the contents of the init<SID>.ora file. It displays the following information:

 

Column	Description
Parameter	Name of the parameter
Value	Value of the parameter

 

·        Compare Parameter Config.

This tab page only appears for RAC.

 

·        Parameters History

This tab page uses the alert log file to display all changes in database parameters.

Choose Show parameters history to display the following information:

Column	Description
Instance ID	Instance ID
SID	Name of the RAC instance
Parameter	Name of the parameter
Value	Value of the parameter
Timestamp	Timestamp for this value of the parameter
Scope	Indicates whether the parameter change is only temporary, or persistent and in memory
Target instance	RAC instance for which the change applies