Multiple TEMP tablespaces
SM_308Jan 13 2012 — edited Jan 13 2012RDBMS version:11.2, 10.2
We usually create only one temporary tablespace (TEMP) for a database. But, our application team is asking us to create two more dedicated Temporary tablespaces for 2 of its DB schemas which have high activity and assign it as the default temporary tablespaces for it.
Are there any advantages in creating separate TEMP tablespaces for highly active schemas ? Can't I just have one tablespace and increase the size of this TEMP tablespace instead ?