Home » RDBMS Server » Performance Tuning » Dynamic_sampling and partitioning (10.2.0.4)
Dynamic_sampling and partitioning [message #407701] Thu, 11 June 2009 02:53 Go to next message
farenheiit
Messages: 31
Registered: June 2009
Location: Paris
Member
Hi,

When the optimizer_dynamic_sampling is activated and when we execute a query on a partionned table without precising the partitioning criterion. Are statisctics collected dynamicly on all the table ?

And if I precise the partitionning criterion, are statistics collected only on the partition?

Moreover, how to know if it's better to collect the statistics for each partition or globally for all the table ?
Re: Dynamic_sampling and partitioning [message #407791 is a reply to message #407701] Thu, 11 June 2009 11:16 Go to previous message
BlackSwan
Messages: 25043
Registered: January 2009
Location: SoCal
Senior Member
When all else fails Read The Fine Manual

http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10752/stats.htm#43007
Previous Topic: slow query with MERGE JOIN CARTESIAN and LATCH cache buffer chains
Next Topic: How to tune memory size in oracle 8i (merged)
Goto Forum:
  


Current Time: Wed Dec 07 08:27:49 CST 2016

Total time taken to generate the page: 0.08256 seconds