PL/SQL (MOSC)

MOSC Banner

What is PL/SQL id -ADDM

edited Apr 28, 2017 1:15PM in PL/SQL (MOSC) 1 commentAnswered

Hello gurus,

How do i find what plsql object is the below ADDM referring to with PL/SQL ID 102296 .

Recommendation 1: SQL Tuning

   Estimated benefit is 1.76 active sessions, 46.41% of total activity.

   --------------------------------------------------------------------

   Action

      Tune the entry point PL/SQL ID 102296. Refer to the PL/SQL documentation

      for addition information.

   Rationale

      The SQL statement executed in container OP2XXXX with database ID

      1267752421.

   Rationale

      Subprogam ID 1 of PL/SQL ID 102296 spent 3148 seconds in execution.

Thanks in advance

Tagged:

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