RE: Max File Size?
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: "'don@xxxxxxxxx'" <don@xxxxxxxxx>, "JSweetser@xxxxxxxx" <JSweetser@xxxxxxxx>
- Date: Mon, 25 Aug 2014 18:51:28 +0000
Actually, that’s only the case for a 8kb blocksize… 16kb blocksize gets you
almost to 64GB.
Stephan Uzzell | Senior Database Administrator | Managed Services |MICROS
Systems, Inc.
Mobile: 443.864.1725 | suzzell@xxxxxxxxxx<mailto:suzzell@xxxxxxxxxx> |
www.micros.com<blocked::http://www.micros.com>
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Don Seiler
Sent: Monday, 25 August, 2014 14:47
To: JSweetser@xxxxxxxx
Cc: oracle@xxxxxxxxxxx; Oracle-L
Subject: Re: Max File Size?
Joe, 32767 MB (or 1MB short of 32GB) is the max size (in MB, anyway) for a
datafile that isn't defined as a bigfile.
Don.
On Mon, Aug 25, 2014 at 1:44 PM, Sweetser, Joe
<JSweetser@xxxxxxxx<mailto:JSweetser@xxxxxxxx>> wrote:
I am running 11.2.0.2 on RH 5 without any special settings/configs. Oracle
seems to be pretty unhappy when an individual file gets over 32gb.
alter database datafile '/u02/oradata/joedb/being_silly_01.dbf' resize 33056m
ORA-1144 signalled during: alter database datafile '/u02/oradata/
joedb/being_silly_01.dbf' resize 33056m...
-joe
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of Dave Morgan
Sent: Monday, August 25, 2014 12:30 PM
To: Oracle-L
Subject: Max File Size?
Hello All,
In this age of arrays, SSD and virtual everything what are people using
for a maximum data file size on their production systems?
Since the 2GB physical disk limit is no longer with us :)
TIA
Dave
--
Dave Morgan
Senior Consultant, 1001111 Alberta Limited
dave.morgan@xxxxxxxxxxx<mailto:dave.morgan@xxxxxxxxxxx>
403 399 2442<tel:403%20399%202442>
--
//www.freelists.org/webpage/oracle-l
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT, Underwriters
at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does
not guarantee that either are virus-free and accepts no liability for any
damage sustained as a result of viruses. Thank you.
--
//www.freelists.org/webpage/oracle-l
--
Don Seiler
http://www.seiler.us
Other related posts:
