List the Optional Flexible Architecture (OFA) of Oracle
database ?
Answer / orawhiz
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is Dedicated Server Configuration?
Why query fails sometimes ?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is PGA?
What constitute an ORACLE Instance?
How the log writer writes the data into database
What is the OPTIMAL parameter ?
What are disadvanteges of having raw devices ?
What do Redo Log Buffers contain?
what is the role of archiever
How to define Data Block size in Oracle?
What is the functionality of SYSTEM table space ?