Oracle EM Express Configuration Page provides the ability to administrate the initialization parameters of an instance or multiple instances in a RAC configuration; view the memory configuration and usage; usage of various features; and database properties. This article covers the general layout of EM Express Configuration Page and its functional usage.
- Logon the EM Express as an administrative user. In this case we will use the URL: https://10.30.15.63:5500/em. This indicates the EM Express is installed on server 10.30.15.63, listening on port 5500 (which is the default). NOTE: You may receive a certificate warning but select continue to site option. Enter your sysdba credentials at the sign in page and mark the check box as sysdba, normally this is the user name and password you used to create the database.
- From the top level drop down memory you have four options: Configuration, Storage, Security and Performance.
- Configuration drop down give the four options: Initialization Parameters, Memory, Database Feature Usage, and Current Database Properties.
- Initialization Parameters lists all current instance parameters and SPFILE parameters. From this page you can adjust most parameters.
- Memory option gives more details of memory usage that currently exists and allows the administrator a visual prospective of current environment.
- Database Feature Usage lists the features of database used by a user or application. This allows the administrator the ability to focus on features which may present a performance problem.
- Current Database Properties lists the value of all database property variables. However this view does not give the ability to update this values.
This article summarized the feature and use of the Configuration Page of Oracle 12c EM Express.
Larry Catt
OCP