RE: Multiple Block Size

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 20 Dec 2006 10:13:55 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9483B3B@usahm208.amer.corp.eds.com>

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

        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 - 09:13:55 CST