My Oracle Support Banner

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.


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 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 - 64bit Production

SQL> select * from v$option where parameter like 'Real Application Testing';
PARAMETER    VALUE                      CON_ID
---------------------------------------------------------------- ----------
Real Application Testing   FALSE                  0







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

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