Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

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 :)

Jagadish said...

Excellent...

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.
-Venu Teepireddy

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

Tim... said...

Hi.

I've corrected the typo. Thanks for pointing it out. :)

Cheers

Tim...

Chi said...

Nice and excellent piece of work on gathering statistics.
Regards,

Chi

vyms said...

Tim,

The Setting Preferences proc is not available in Oracle 10g, is this right ?

Please confirm about this.


Thanks.

Tim... said...

Hi.

You can set preferences using SET_PARAM, but it's a little different. I've rewritten the section to make it clearer.

Cheers

Tim...

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. :)

Cheers

Tim...

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)