Tuning sql programs

[yxez]

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

[malay_biswal]

Looking at the diskreads per execution i do not think this package is doing high disk reads. Any way find the SQL_ID and map it with v$session.