EM Express 12c Performance Page
Oracle EM Express Performance Page provides the ability to administrate the Users, Roles, and Profile requirements of an Oracle database. This article covers the general layout of EM Express Performance 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.
- The Performance option allows access to view performance of the database via the Performance Hub and perform performance optimization via the SQL Tuning Advisor.
- The Performance Hub option allows you to view the performance of your database based on multiple criteria and via a Summary, Activity, Workload, Monitored SQL, ADDM views. This can provide insight into the optimization of your instance and database configurations.
- The SQL Tuning Advisor option allows you to tune individual SQL statements and monitor executing SQL within the database. NOTE: This option requires additional Tuning Pack license.
This article summarized the feature and use of the Performance Page of Oracle 12c EM Express.
Larry Catt
OCP