RE: Multiple Block Size

From: <Joel.Patterson_at_crowley.com>
Date: Wed, 20 Dec 2006 14:06:48 -0500
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B0269B591@jax-mbh-01.jax.crowley.com>

P.S. the link doesn't work because it is actually duplicated. Search and remove the second http://

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Wednesday, December 20, 2006 10:14 AM To: oracle-l_at_freelists.org
Subject: RE: Multiple Block Size

The Link did not work for me. Without the ability to support multiple block sizes it would not be possible to use the transportable tablespace feature to transport data from a database built with one block size (say 8k) to another database built using a different block size (say 4K).

Oracle did not intend the feature to be used for any other purpose. Doing so requires that you manage not just the main database buffer cache but start managing multiple caches. This is potentially a lot of work and any change in application behavior would throw all your pool tuning efforts right out the door and require rebalancing the available space between the pools. Most sites are better off to have just one database buffer pool and to let Oracle manage it.

Mark D Powell -- Phone (313) 592-5148

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Murtuja Khokhar

	Sent: Wednesday, December 20, 2006 1:52 AM
	To: VIVEK_SHARMA_at_infosys.com; Dabadge, Prashant
	Cc: oracle-l_at_freelists.org
	Subject: RE: Multiple Block Size

	Prashant,

http://www.dba-oracle.com/oracle_tips_multiple_blocksizes.htmhttp://www. dba-oracle.com/oracle_tips_multiple_blocksizes.htm <http://www.dba-oracle.com/oracle_tips_multiple_blocksizes.htmhttp:/www. dba-oracle.com/oracle_tips_multiple_blocksizes.htm>

VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:

Thanks Prashant for responding.

Could you give some DETAILS about HOW it is helpful when are transporting tablespaces across databases with different block sizes

Cheers

Vivek

From: Dabadge, Prashant
[mailto:Prashant.Dabadge_at_e-hps.com]

		Sent: Tuesday, December 19, 2006 10:34 PM
		To: VIVEK_SHARMA
		Subject: Multiple Block Size

		 

		Vivek,

		Multiple block size support in Database is very helpful

if you are transporting tablespaces across databases with different block sizes.I have done this many times .

I am not very sure if it helps in performance (maybe it might/might not help)

Folks

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

Any best practices, Links, Docs?

Thanks indeed

Merry X'mas

Prashant Dabadge

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***

	Do You Yahoo!?
	Tired of spam? Yahoo! Mail has the best spam protection around 
	http://mail.yahoo.com

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

Received on Wed Dec 20 2006 - 13:06:48 CST