EBS Instacne working slow
i have not schedule any Gather schema for Instance but still running "SYS.DBMS_STATS.GATHER_TABLE_STATS".
ADDM report.-----
Finding 3: PL/SQL Execution
Impact is .18 active sessions, 36.82% of total activity.
--------------------------------------------------------
PL/SQL execution consumed significant database time.
Recommendation 1: SQL Tuning
Estimated benefit is .16 active sessions, 31.56% of total activity.
-------------------------------------------------------------------
Action
Tune the entry point PL/SQL "APPS.QLTTRAMB.WRAPPER" of type "PACKAGE"
and ID 147469. Refer to the PL/SQL documentation for addition
information.
Rationale
564 seconds spent in executing PL/SQL
"SYS.DBMS_STATS.GATHER_TABLE_STATS" of type "PACKAGE" and ID 3284.
Recommendation 2: SQL Tuning
Estimated benefit is .03 active sessions, 5.26% of total activity.
ADDM report.-----
Finding 3: PL/SQL Execution
Impact is .18 active sessions, 36.82% of total activity.
--------------------------------------------------------
PL/SQL execution consumed significant database time.
Recommendation 1: SQL Tuning
Estimated benefit is .16 active sessions, 31.56% of total activity.
-------------------------------------------------------------------
Action
Tune the entry point PL/SQL "APPS.QLTTRAMB.WRAPPER" of type "PACKAGE"
and ID 147469. Refer to the PL/SQL documentation for addition
information.
Rationale
564 seconds spent in executing PL/SQL
"SYS.DBMS_STATS.GATHER_TABLE_STATS" of type "PACKAGE" and ID 3284.
Recommendation 2: SQL Tuning
Estimated benefit is .03 active sessions, 5.26% of total activity.
0