My Oracle Support Banner

OCI: SQL Performance Analyzer Not Available In EM Express (Doc ID 2459869.1)

Last updated on NOVEMBER 08, 2019

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.