Re: BIG File Tablespaces

Hi RIchard,

Each Oracle datafile can contain maximum *4194303 (4 Million) data blocks*.

I'm not a fan of BIGFILE tablespaces too, but this part is not relevant for them.
According to
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/physical-database-limits.html

A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion ( 232 ) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks. So they have the same limit of the number of datablocks: 232 for BIGFILE TS vs 222 * 1023 (max number of datafiles for TS = 210) for Small size TS.

On Tue, Feb 20, 2024 at 6:12 PM richard goulet <rjgoulet_at_comcast.net> wrote:

> 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 *
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l