ERPstuff - Oracle EBS Community

Hi All,

I have created one procedure,this procedure contains 20 sql queries.
When i am trying to execute it will takes more time.So i want to findout which query will takes more time to execute?
How to resolve this problem?
How to findout which query will takes longer time to execute?

Please help me on this...

hi,

you can use
set timing on;
in sql
to check how much time one query is taking.

thanks,
venkat

[quote]Hi All,

I have created one procedure,this procedure contains 20 sql queries.
When i am trying to execute it will takes more time.So i want to findout which query will takes more time to execute?
How to resolve this problem?
How to findout which query will takes longer time to execute?

Please help me on this...



<i><div align="right">Originally posted by siva sankar

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

user oralce supplied package dbms_profiler