RE: Use of Multiple BLOCK Sizes ?

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <VIVEK_SHARMA@xxxxxxxxxxx>
  • Date: Tue, 19 Dec 2006 15:37:08 +0100

Vivek

> Does use of Multiple BLOCK sizes (for different Tablespaces) help in
> Performance of a Hybrid Application?

Every decision you take about the physical storage of a table has an
impact on performance. Every. However, how significant the impact is and
if it is good or bad depends on the utilization of the blocks.
Therefore, IMHO, to find the best storage options you have to carefully
understand your data and how Oracle and your application use it.


HTH
Chris

--
//www.freelists.org/webpage/oracle-l


Other related posts: