Database Tuning (MOSC)

MOSC Banner

EBS Instacne working slow

edited Feb 27, 2013 10:49PM in Database Tuning (MOSC) 18 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center