Interested to Buy Any Domain ? << Click Here >> for more details...
List the Optional Flexible Architecture (OFA) of Oracle
database ?
- 1 Answers
- 4809 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
Can a View based on another View in Oracle?
How to find the SGA Size
How free extents are managed in Ver 6.0 and Ver 7.0 ?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
How to define Data Block size in Oracle?
What is SGA?
How the log writer writes the data into database
How can you find the size of a database?
What does LGWR do?
What is Shared SQL Area?
What is an Oracle SYSTEM tablespace and when is it Created?
Oracle General 
