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.
0