ADDMrpt finding
Just wondering if anyone could tell me what to do with this?
FINDING 1: 66% impact (17657 seconds)
-------------------------------------
PL/SQL execution consumed significant database time.
RECOMMENDATION 1: SQL Tuning, 66% benefit (17657 seconds)
ACTION: Tune the PL/SQL block with SQL_ID "8gub7zxznbthv". Refer to the
"Tuning PL/SQL Applications" chapter of Oracle's "PL/SQL User's Guide
and Reference"
RELEVANT OBJECT: SQL statement with SQL_ID 8gub7zxznbthv
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN CEK_HARIAN_RUN8; :mydate := next_date;
IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
RATIONALE: SQL statement with SQL_ID "8gub7zxznbthv" was executed 2