TKPROF of trace file - Parsing ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TKPROF of trace file - Parsing ??

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Arrow TKPROF of trace file - Parsing ??

    The following is a tkprof of an trace file. I see a lot of parse counts (1394) and misses in library cache is 0. Does this mean that all the parses are soft parses?



    SELECT ACTIVITY_NAME
    FROM
    D_ACTIVITIES WHERE LOWER(ACTIVITY_CODE) = :1


    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 1394 0.00 0.00 0 0 0 0
    Execute 1394 0.00 0.00 0 0 0 0
    Fetch 1394 0.00 0.00 0 1394 5576 1394
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 4182 0.00 0.00 0 1394 5576 1394

    Misses in library cache during parse: 0
    Optimizer goal: CHOOSE
    Parsing user id: 38 (U_TS)

    Rows Row Source Operation
    ------- ---------------------------------------------------
    1 TABLE ACCESS FULL D_ACTIVITIES


    Rows Execution Plan
    ------- ---------------------------------------------------
    0 SELECT STATEMENT GOAL: CHOOSE
    1 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'D_ACTIVITIES'

    ********************************************************************************

  2. #2
    Join Date
    Dec 2002
    Location
    India & Australia
    Posts
    68
    What is soft parses? do you think it was not even touching the Dictionary cache?


    VAST

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: TKPROF of trace file - Parsing ??

    Originally posted by ggnanaraj
    The following is a tkprof of an trace file. I see a lot of parse counts (1394) and misses in library cache is 0. Does this mean that all the parses are soft parses?
    Yes, all those are soft parses. For more info refer to http://asktom.oracle.com/pls/ask/f?p...D:920429344869

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width