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 SQL Area?
What is Shared Pool?
What is an oracle database schema?
How will you monitor the space allocation ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
Can a Tablespace hold objects from different Schemes in Oracle?
What Does DBWR do?
What are Oracle Schema Objects?
What is the function of Dispatcher (Dnnn)?
What is the use of Oracle Control File?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is an Integrity Constrains in Oracle?