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 the maximum size of a oracle9i database?
What is an Integrity Constrains in Oracle?
What constitute an ORACLE Instance?
What is meant by free extent ?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is hit ratio ?
what is the role of archiever
What is the maximum number of Lock Processes used?
What is an Oracle Rollback Segment?
How will you swap objects into a different table space for an existing database?
How will you monitor the space allocation ?
How the log writer writes the data into database