Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Monitor sql statement on toad or sql plus

90680Apr 10 2006 — edited Apr 10 2006

Hi folks......

I am not an expert on DB tunning or monitoring, but I have a specific issue related with it.

I have 2 reports, both of them, get the same information, both they have a small difference. If I run the TKProf to see the execution values, one of the is faster then the other but it has more CPU usage.

Can I know, by typing a script or pl/sql code, how many CPU are they using by time. Or which process is comsuming the more CPU.

Sometimes I run the report (one of them) and I get executing time between 1' 30" minutes and 4' 00", but some day I get tiem between 19' 00" and 27' 00".

Can I get in desc order which process is getting more CPU time in execution process.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2006

Added on Apr 10 2006

#general-database-discussions

5 comments

2,584 views