How to check the performance?

[siva sankar]

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...

[venkat_mel]

hi,

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

thanks,
venkat

[2jliu]

[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

[santanasan]

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

[Awais.Riaz]

user oralce supplied package dbms_profiler