3 Replies Latest reply: Dec 11, 2012 12:56 AM by robinsc RSS

    Temporary Tablesapces - small file vs big file

      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.