Tuning sql programs
Hi Friends,
I have selected an unknown program in V$SQLAREA which has high disk reads,
with the following info.
SQL_TEXT
========
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();
:mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
DISK_READS
==========
485,792
EXECUTIONS
==========
14,373
How do I know which user is running this program?
How do I tune this program to make it faster?(I usually create indexes on others programs i saw here but this one dont use tables)
Thanks a lot
Behind The Success And Failure Of A Man Is A Woman