This discussion is archived
1 Reply Latest reply: Dec 4, 2012 7:42 AM by Marcus Rangel RSS

Bigfile Temporary Tablespaces

user154136 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points