This discussion is archived
3 Replies Latest reply: Dec 10, 2012 10:56 PM by robinsc RSS

Temporary Tablesapces - small file vs big file

user154136 Newbie
Currently Being Moderated
We are using bigfile tablespaces for our temporary tablespaces on Exadata. My preference is to change this to use small file tablespaces for temporary tablespaces and to define multiple tempfiles for each temporary tablespace. My thinking is that this will eliminate some temp file contention we are seeing and will help with some parallel operations. I was looking to get a feel of how Exadata sites are configuring temporary tablesapces. I know each site will have different needs and setup will vary but I was just trying to get a general feel.

Legend

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