List the Optional Flexible Architecture (OFA) of Oracle
database ?
- 1 Answers
- 4176 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 PCTFREE parameter is Storage clause ?
How can we plan storage for very large tables ?
Can a Tablespace hold objects from different Schemes in Oracle?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
How will you estimate the space required by a non-clustered tables?
• What is oracle Architecture?
What is the function of Redo Log in Oracle?
How the space utilisation takes place within rollback segments?
How to find the current session sid
What is the OPTIMAL parameter ?
What is Shared SQL Area?
What is Cursor?
Oracle General 
