1.

List The Optional Flexible Architecture (ofa) Of Oracle Database? 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.

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