Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013

    Unanswered: Max bigfile tbsp sizeon ASM

    Hi all,

    I am using oracle 11.2 enterprise edition on exadata server RHEL 5 64 bit

    I have 32 TB of usable ASM space. I want to create a a bigfile tablespace in ASM:

    please help me in identifying max size of bigfile tablespace applicable to my environment
    os block size = 1024B
    DB block size = 8K
    ASM diskgroup blocksize = 4096B

    thanks in advance

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    From Oracle DB Admin documentation:
    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.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts