Printable View
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
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.Quote:
It was just for you to know what Optimizer means & how does it calculate Costs. STW, you will get ur ansQuote:
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.
Quote:
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 :rolleyes:
http://www.catb.org/~esr/faqs/smart-questions.htmlQuote:
Originally posted by Vipassana
What does STW mean :rolleyes:
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.Quote:
Originally posted by abhaysk
http://www.catb.org/~esr/faqs/smart-questions.html
Search for "STFW" word...
abhaysk already pointed you to the correct link, read that chapter and chapter 9
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 :rolleyes:Quote:
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.