OCI: SQL Performance Analyzer Not Available In EM Express
(Doc ID 2459869.1)
Last updated on FEBRUARY 03, 2020
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.
Symptoms
OCI DB system instance. Login to EM express console , navigate to Performance hub --> SQL Performance Analyzer (SPA) results following message:
SQL Performance Analyzer says:
Database Option Restriction
Oracle Real Application Testing (RAT) is required.
For SPA functionality , RAT component need to enabled at DB level
$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Oct 6 03:56:54 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from v$option where parameter like 'Real Application Testing';
PARAMETER VALUE CON_ID
---------------------------------------------------------------- ----------
Real Application Testing FALSE 0
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |