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 ?

Report message to a moderator

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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 23 13:45:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.