In the Oracle Audit logs, you may see INSERT statements such as the below:
Oracle audit logs for instances that are monitored by PA. For instance:
PRODK2 00:01 PERF_ANLYS_AGENT....SYSTEM....insert into APPL_SUPPORT_O.EXT_MARE_MTCH_AUD_RESULT (ACCESS DENIED)
PRODK2 00:01 PERF_ANLYS_AGENT....SYSTEM....insert into FACETS_DAILY_O.CER_WFDN_WRK_DONE (ACCESS DENIED)
PRODK2 00:01 PERF_ANLYS_AGENT....SYSTEM....insert into FACETS_DAILY_O.CMC_CDML_CL_LINE (ACCESS DENIED)
PRODK2 00:01 PERF_ANLYS_AGENT....SYSTEM....insert into FACETS_DAILY_O.CMC_MEAC_ACCUM (ACCESS DENIED)
PRODK2 00:01 PERF_ANLYS_AGENT....SYSTEM....update ODSSTAGE.DRVD_GRVP_GRP_VND_PRGM (ACCESS DENIED)
PRODK2 00:01 PERF_ANLYS_AGENT....SYSTEM....update ODSSTAGE_FACETS_O.CMC_CDML_CL_LINE (ACCESS DENIED)
See problem description.
Performance Analysis does not access any tables, what we do behind the scenes is a part of the Explain Plan we execute for some of the customer's SQL statements.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy