Home » RDBMS Server » Performance Tuning » TKPROF STATISTICS-To Mr.Daljit Singh
TKPROF STATISTICS-To Mr.Daljit Singh [message #65106] Fri, 30 April 2004 03:11
Monu
Messages: 5
Registered: April 2004
Junior Member
Mr Daljit

            Thanks for replying!

I have collected the following statistics using TKPROF,So can i assume that the second data collected is better since i have added optimizer hints in my procedures

                                  Before adding optimizer hints

call     count  cpu   elapsed  disk   query  current  rows
--------------------------------------------------------------
Parse      1    0.00   0.00       0       0         0          0
Execute   1    0.15   0.23       6       8        2          0
Fetch      0    0.00   0.00       0       0        0          0
------------- -------- ---------- ---------- -----------------
total      2     0.15   0.23       6        8         2           0

                                 After adding optimizer hints

call     count   cpu   elapsed     disk    query     current      rows
------- ------  -------- ---------- ---------- ---------- ------
Parse     1      0.00     0.00          0          0          0           0
Execute  1      0.09     0.07          0          0          2           0
Fetch     0      0.00     0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ------
total        2      0.09    0.07         0          0          2           0

Which data are better?

Thankx

Gaurav

 
Previous Topic: TKPROF HELP
Next Topic: Optimize performance for Update Opertaion
Goto Forum:
  


Current Time: Wed Jan 27 14:46:08 CST 2021