Re: Max File Size?
- From: Don Seiler <don@xxxxxxxxx>
- To: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- Date: Mon, 25 Aug 2014 14:02:42 -0500
True it's based on db_block_size. Likewise that also determines the
eventual astronomical maxsize of a bigfile datafile.
On Mon, Aug 25, 2014 at 1:51 PM, Uzzell, Stephan <SUzzell@xxxxxxxxxx> wrote:
> 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 | 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> 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]
> 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
> 403 399 2442
> --
> //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
>
--
Don Seiler
http://www.seiler.us
Other related posts:
