1.

List The Optional Flexible Architecture (ofa) Of Oracle Database? Or How Can We Organize The Tablespaces In Oracle Database To Have Maximum Performance ?

Answer»
  • 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 - Tools 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 tablespace.


Discussion

No Comment Found

Related InterviewSolutions