Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to calculate the CPU Time for a procedure
Hi Gurus,
I have to calculate the CPU time taken or utilized for execution of various application packages/procedures during various phases - such as Parse, Execute and Fetch (where applicable).
I have the following information in the trace file :
BEGIN
SCH_ID.PKG_XYZ.XTZ_EP;
COMMIT;
END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 92.60 0 0 0 0 Execute 1 56200.00 53970.83 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 56200.00 54063.43 0 0 0 1
..and then similar set of statistics are present for each individual SQL statements which are contained in (or part of ) Procedure/Package and at the end the same set of statistics for Recursive and Non-Recursive SQLs.
The question I have is, how can I arrive at CPU Time statistics for the procedure as a whole for each phases of execution. For example:
Procedure/Package Name CPU Parse CPU EXECUTE CPU Fetch
PKG_XYZ.XTZ_EP : 102909 101937 99898
Any help or pointers to help would be highly appreciated.
Thanks for your time and help in advance!
Regards
Chandra
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 28 2004 - 06:38:50 CDT
![]() |
![]() |