1 Reply Latest reply on Dec 4, 2012 3:42 PM by Marcus Rangel

    Bigfile Temporary Tablespaces

      In most RAC environments, you use multiple tempfiles in a temp tablespace to avoid contention yet in the Exadata OLTP best practices guide it stats that you should start out by using a bigfile tablespace for temporarty tablespaces. This seemed odd to me since bigfile tablespaces can only have one tempfile. Understanding that OLTP may not have much parallelism, so multiple tempfiles may not be needed but it still seemed odd to use bigfile instead of smallfile tablespaces for something like temp. Does anyone have any experience with using bigfile tablespaces on RAC for temporary tablespaces.