performance issue related to select min(bitmapped) from ts$ where dflmaxext =:1 and bitand(flags,102 — oracle-mosc

Database Tuning (MOSC)

MOSC Banner

performance issue related to select min(bitmapped) from ts$ where dflmaxext =:1 and bitand(flags,102

edited Jun 26, 2012 10:39PM in Database Tuning (MOSC) 4 commentsAnswered
Hi,
In my production database ADDM report below sql statement consuming maximum resource, i am not sure what exactly this SQL, please advice.

FINDING 2: 28% impact (130468 seconds)
--------------------------------------
SQL statements consuming significant database time were found.

   RECOMMENDATION 1: SQL Tuning, 7.3% benefit (34765 seconds)
      ACTION: Run SQL Tuning Advisor on the SQL statement with SQL_ID
         "8sph6b5p41afr".
         RELEVANT OBJECT: SQL statement with SQL_ID 8sph6b5p41afr and
         PLAN_HASH 1514356425
         select min(bitmapped) from ts$ where dflmaxext =:1 and
         bitand(flags,1024) =1024
      RATIONALE: SQL statement with SQL_ID "8sph6b5p41afr" was executed
         29828137 times and had an average elapsed time of 0.0011 seconds.

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