As we all know Oracle generate a lot of temporary data by operations like bitmap merges, hash join, bitmap index creation, sort. This data only persists only for duration of a transaction or session and will not require media and instance recovery. Since Oracle RAC environment share tablespace between multiple instances, high concurrency of space management operations is very critical. Please use following guidelines for creating temporary tablespaces on Exadata machine.
- A BigFile Tablespace
- Located in DATA or RECO, whichever one is not HIGH redundancy
- Sized 32GB Initially
- Configured with AutoExtend on at 4GB
- Configured with a Max Size defined to limit out of control growth.