0 Replies Latest reply: Jun 27, 2014 5:19 PM by user6433292 RSS

    How to interpret tkprof_table.ticks?

    user6433292

      Hi,

      I googled on web trying to search the meaning of tkprof_table.ticks but I could not find anything.

      Can someone help me understand what ticks column means?

      The following ticks show a large value. It is certainly not the sum of all other columns. far far from close.

       

      SELECT parse_cnt,parse_elap,exe_count, exe_cpu, exe_elap,fetch_elap,ticks, sql_statement

        FROM tkprof_table

      WHERE Lower(sql_statement) LIKE '%set transaction isolation level%'

      ORDER BY ticks desc

       

      PARSE_CNT PARSE_ELAP EXE_COUNT EXE_CPU EXE_ELAP FETCH_ELAP      TICKS SQL_STATEMENT                              

             10       1619        11   31250   164191          0 4294192015 set transaction isolation level serializable

             10       1619        11   31250   164191          0 4294192015 set transaction isolation level serializable

              1        102         1       0       59        696     355707 set transaction isolation level serializable

              1        125         2       0    31984          0      87975 set transaction isolation level serializable

              1        125         2       0    31984          0      87975 set transaction isolation level serializable

       

      Thanks,