DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Regarding PLAN_TABLE OUTPUT

  1. 08-06-2003, 01:47 AM #1
    Vipassana
    Vipassana is offline Member
    Join Date
    Jul 2003
    Posts
    134

    Regarding PLAN_TABLE OUTPUT

    Guys,

    I ran the utlxpls.sql on the PLAN_TABLE and I got output with costs and partition scans etc. Can someone please explain me what is "Cost" column that is displayed and how it is calculated.


    Also, after the results are shown, at the end, there is a message:

    "Note: cpu costing is off". What does this mean and how to set it on?


    Hoping for some help here.

    Thanks,
    Vipassana
    Last edited by Vipassana; 08-06-2003 at 02:06 AM.
    Reply With Quote Reply With Quote
  2. 08-06-2003, 02:30 AM #2
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    http://otn.oracle.com/docs/products/...mops.htm#39473
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  3. 08-06-2003, 03:50 AM #3
    Vipassana
    Vipassana is offline Member
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by abhaysk
    http://otn.oracle.com/docs/products/...mops.htm#39473
    Hi, thanks for the link. It does not however explain why I am getting the message "Note: cpu costing is off" when I run utlxpls. Can someone help please.
    Reply With Quote Reply With Quote
  4. 08-06-2003, 03:57 AM #4
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Vipassana
    Hi, thanks for the link. It does not however explain why I am getting the message "Note: cpu costing is off" when I run utlxpls. Can someone help please.
    It was just for you to know what Optimizer means & how does it calculate Costs. STW, you will get ur ans
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  6. 08-06-2003, 04:48 AM #5
    Vipassana
    Vipassana is offline Member
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by abhaysk
    It was just for you to know what Optimizer means & how does it calculate Costs. STW, you will get ur ans

    What does STW mean
    Reply With Quote Reply With Quote
  7. 08-06-2003, 05:27 AM #6
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Vipassana
    What does STW mean
    http://www.catb.org/~esr/faqs/smart-questions.html

    Search for "STFW" word...
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  8. 08-06-2003, 05:43 AM #7
    Vipassana
    Vipassana is offline Member
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by abhaysk
    http://www.catb.org/~esr/faqs/smart-questions.html

    Search for "STFW" word...
    I've STFW'ed. No luck pal. In fact, that's what I did first. If can STFW better than me, please help me to find the answer.
    Reply With Quote Reply With Quote
  9. 08-06-2003, 05:49 AM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    abhaysk already pointed you to the correct link, read that chapter and chapter 9
    Reply With Quote Reply With Quote
  11. 08-06-2003, 06:06 AM #9
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    It means that you have not collected system level statistics or did not enable statistics in your init.ora.

    First of all, edit your init.ora file and add an entry:
    timed_statistics = true (do not forget to restart instance if you are using version earlier than 9i)

    Second, collect statistics on your table using ANALYZE TABLE ... COMPUTE/ESTIMATE STATISTICS or by using DBMS_STATS package (GATHER_TABLE_STATS/GATHER_INDEX_STATS) etc.

    explain the query plan again, and watch the results.

    Cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer
    Reply With Quote Reply With Quote
  12. 08-06-2003, 07:58 AM #10
    Vipassana
    Vipassana is offline Member
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by rotem_fo
    It means that you have not collected system level statistics or did not enable statistics in your init.ora.

    First of all, edit your init.ora file and add an entry:
    timed_statistics = true (do not forget to restart instance if you are using version earlier than 9i)

    Second, collect statistics on your table using ANALYZE TABLE ... COMPUTE/ESTIMATE STATISTICS or by using DBMS_STATS package (GATHER_TABLE_STATS/GATHER_INDEX_STATS) etc.

    explain the query plan again, and watch the results.

    Cheers.
    I did all this before; its still showing the same error. TIMED_STATISTICS=TRUE and table is analyzed for compute statistics. Still the same result
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width