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.
I have used bigfile temporary tablespaces for some intensively parallelized operations and never encountered any contention problems. If I were you, since we are talking about temporary stuff, I would make the change and run some tests.