Interested to Buy Any Domain ? << Click Here >> for more details...
List the Optional Flexible Architecture (OFA) of Oracle
database ?
- 1 Answers
- 4667 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 |
Can a Tablespace hold objects from different Schemes in Oracle?
What are the components of SGA?
How will you force database to use particular rollback segment?
What is hit ratio ?
How will you swap objects into a different table space for an existing database?
When Does DBWR write to the database?
How many Dispatcher Processes are created?
what is the role of archiever
How will you create multiple rollback segments in a database ?
What is advantage of having disk shadowing/ Mirroring ?
What are Oracle Schema Objects?
What is the function of Redo Log in Oracle?
Oracle General 
