RE: Multiple Block Size
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Dec 2006 10:13:55 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Murtuja Khokhar
Sent: Wednesday, December 20, 2006 1:52 AM
To: VIVEK_SHARMA@xxxxxxxxxxx; Dabadge, Prashant
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx> 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@xxxxxxxxx]
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
Other related posts: