List the Optional Flexible Architecture (OFA) of Oracle
database ?
- 1 Answers
- 4343 Views
- I also Faced
- E-Mail Answers
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 role of archiever
What is the functionality of SYSTEM table space ?
What is the function of Lock (LCKn) Process?
What does LGWR do?
What are Oracle Schema Objects?
What is User Process?
• What is oracle Architecture?
When Does DBWR write to the database?
What is a Parallel Server option in ORACLE?
What is Cursor?
List the factors that can affect the accuracy of the estimations ?
How the space utilisation takes place within rollback segments?
Oracle General 
