|Cost-Based Optimizer (CBO) And Database Statistics - Lists the available mechanisms for gathering database statistics that are used by the cost-based optimizer.|
Donny said...Just to say hellow!
shweta gupta said...really helped a lot in writing script for analysing the database
Kash said...ORACLE-Base is always best. The most compact help on WEB for ORacle
Prat said...This is excellent stuff.
Chandra said...Excellent document for lerners
SDE said...Really helpful for newbies :)
Hussain said...Really, it should be appreciated
PRATIK said...A VERY BRIEF AND INFORMATIVE GUIDE TO GATHERING OPTIMIZER STATISTICS
Laxman said...Really Excellent
Shariq said...Very well compiled! It really helps. Thanx.
sridhar kola said...its the best,
gatorman said...Great artical
rphani.. said...Its really helpfull...
Aashar said...Outstanding knowlegde sharing..
Gman said...Many thanks - this is really helpful
Venu Teepireddy said...Very helpful content. Thanks for your work.
John MacAulay said...Very well thought out and excellently presented. Saved me an awful lot of grubbing around in manuals. Much appreciated - thank you!
sedin said...very good content. ps: dba_jobs instead of d_jobs
I've corrected the typo. Thanks for pointing it out. :)
Chi said...Nice and excellent piece of work on gathering statistics.
The Setting Preferences proc is not available in Oracle 10g, is this right ?
Please confirm about this.
You can set preferences using SET_PARAM, but it's a little different. I've rewritten the section to make it clearer.
TommyP said...It is really about the statistics, not the CBO.
Tim... said...Yep. I guess you are correct. I was an Oracle 8i article that I've continued to add stuff too. :)
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!