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 Shared Pool?
What is the function of Redo Log in Oracle?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is Shared SQL Area?
What is an Oracle Rollback Segment?
What is the maximum number of Lock Processes used?
What is a Control file ?
What is the maximum size of a oracle9i database?
How does Space allocation table place within a block ?
What is meant by redo log buffer ?
What is hit ratio ?
Which parameter in Storage clause will reduce no. of rows per block?