RE: Use of Multiple BLOCK Sizes ?

Folks, Rich

Thanks indeed Rich for the pointer.

• How should BLOCKSIZE for LOB Tablespace be Calculated?
• Is it based on the Average Row Size of the Rows in the LOB Table?
• Is performance benefit observed in ALL Operations on LOB Tables i.e. SELECT, INSERT, UPDATE, DELETE?

Cheers

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich Sent: Tuesday, December 19, 2006 8:33 PM Cc: oracle-l_at_freelists.org
Subject: RE: Use of Multiple BLOCK Sizes ?

My knee jerk to investigating the use of multiple block sizes is to see if it would benefit LOB storage for third party app. In other words, would the LOBs benefit from having a 16k or 32k blocksize? Unfortunately, I have zero documentation about what the LOBs are and why in the world is the vendor putting certain non-LOB tables and indexes in the LOB tablespace.

Of course I haven't gotten that far yet, but when I do, I'll let you know. Unless someone else here would like to chime in... :)

GL!

Rich

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of LS Cheng Sent: Tuesday, December 19, 2006 8:23 AM To: VIVEK_SHARMA_at_infosys.com
Cc: oracle-l_at_freelists.org
Subject: Re: Use of Multiple BLOCK Sizes ?

I think the best practice is multi block size tablespaces are invented so you can transport them and not for performance reasons

On 12/19/06, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:

Folks

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

Any best practices, Links, Docs?

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- http://www.freelists.org/webpage/oracle-l