ERPstuff - Oracle EBS Community

unfortunately, there's no quickfix solution to that.
Setting up statspack and scheduling snapshot during your peak workloads and interpreting report requires knowledge and exp.

sorry.. you gotta get a DBA
regards,
santosh

all sql's ( during runtime ) taking >6 s are logged into v$session_longops
run statspack.snapshots are desired intervals using dbms_job or crond
you will get top sqls ( exec time / parse time ) in any given timeframe.

Statspack is your answer , I guess.
rgds
Santosh

COST = time
set autotrace on or get trace working in a session .
zap the shared pool to get correct timings / cost of each statement.
rgds,
santosh