RE: Use of Multiple BLOCK Sizes ?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 19 Dec 2006 15:37:08 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF8B57A2@MSXVS04.trivadis.com>

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

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

Received on Tue Dec 19 2006 - 08:37:08 CST