Usage Of ASH Analytics In EM 13.3 PG & 13.4 Releases (Doc ID 2580773.1)

Hello

I made procedure like described in "Usage Of ASH Analytics In EM 13.3 PG & 13.4 Releases (Doc ID 2580773.1)":

For DB 12.1.0.2 and 12.2 Pluggable Databases (PDB):

Download the attached file,  'ash_analysis_package.sql'

For each PDB, follow the below procedure.

1. Log into the PDB with sqlplus as the DBSNMP user

2. Execute the downloaded script:

@ash_analysis_package.sql

3. Connect in the PDB as SYS

4. Execute the following command:

create public synonym omc_ash_viewer for dbsnmp.omc_ash_viewer;

---

Validation

Once the package is installed, we can validate if the necessary objects were created at database level.

For 12c DBs:

SQL> select owner, object_name, object_type, created from dba_objects where bject_name like '%ASH_VIEWER%';