Re: max file size for DB block 16k and 32K?
- From: William Muriithi <william.muriithi@xxxxxxxxxxxxxxxxxxx>
- To: "'niall.litchfield@xxxxxxxxx'" <niall.litchfield@xxxxxxxxx>, "'mccdba1@xxxxxxxxx'" <mccdba1@xxxxxxxxx>
- Date: Wed, 6 Jan 2010 07:50:54 -0600
To add to what Niall said, I think you can only change it during the database
creation. If you have a database already running, you would be well off letting
it go.
Someone here also said you may come across lot of bugs where running with
anything other than 8K. In another word, the performance gain is not worth it
as the change will trigger way too many problems
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
To: mccdba1@xxxxxxxxx <mccdba1@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
Sent: Wed Jan 06 06:29:10 2010
Subject: Re: max file size for DB block 16k and 32K?
2^22 * (block_size) so 64 and 128gb respectively. This obviously assumes that
a) you are using smallfile tablespaces and
b) the os doesn't impose a lower limit.
There's a section in the docs for your version called database limits that
contains this and other useful info.
Niall
On Wed, Jan 6, 2010 at 11:50 AM, dba1 mcc
<mccdba1@xxxxxxxxx<mailto:mccdba1@xxxxxxxxx>> wrote:
We have ORACLE 10.2.0.4 X86_64 on Redhat server. I knew for 8k DB block size
max file size is 32 GB.
Does anyone know for 16K and 32K what is max file size?
Does max file size different on X86 and X86_64 version?
Thanks.
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
