BIG File Tablespaces
Date: Tue, 20 Feb 2024 13:11:25 -0500
Message-ID: <75cbf113-0638-4c70-9812-9c87408afec6_at_comcast.net>
Each Oracle datafile can contain maximum /4194303 (4 Million) data blocks/. So maximum file size is 4194303 multiplied by the database block size.
So, the maxsize of a bigfile tablepsace = 1*block_size*/4194303 and would be restricted by the max file size of the mount point and operating system./
/Now take into account the amount of time and other restrictions of the
backup solution your using and I think you've a very BAD idea./
/I've been through occurrences where a mount point gets hammered by IO,
corrupted by other happenings on the system and even dropped by an OS
admin. Having multiple datafiles across multiple mounts is the best
option. The smaller the pieces you have to recover the faster it gets
done. And yes, I've been criticized by many a "guru" who likes take
advantage of the latest and "best" practices over the years, but as my
managers always observed when those practices resulted in disaster I got
things back up quickly./
/KISS: Keep It Simple, Stupid.
/
/
/
/Richard Goulet, MSGT USAF(ret)
Previous Senior Oracle DBA and OCP
/
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 20 2024 - 19:11:25 CET