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.