How can we organise the tablespaces in Oracle database to have maximum performance ?
SYSTEM – Data dictionary tables DATA – Standard operational tables DATA2 – Static tables used for standard operations INDEXES – Indexes for Standard operational tables INDEXES1 – Indexes of static tables used for standard operations TOOLS – Tool table TOOLS1 – Indexes for tools table RBS – Standard Operations Rollback Segments RBS1,RBS2 – Additional/Special rollback segments TEMP – Temporary purpose tablespace TEMP_USER – Temporary tablespace for users USERS – User tablespaces.
