Interested to Buy Any Domain ? << Click Here >> for more details...
List the Optional Flexible Architecture (OFA) of Oracle
database ?
- 1 Answers
- 4754 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 meant by Redo Log file mirrorring ? How it can be achieved?
How the log writer writes the data into database
What are Oracle Schema Objects?
List the factors that can affect the accuracy of the estimations ?
What is the function of ARCH?
How will you estimate the space required by a non-clustered tables?
How to find the current session sid
What are functions of PMON?
How to define Data Block size in Oracle?
Can a Tablespace hold objects from different Schemes in Oracle?
What is an Oracle Data Dictionary?
Which parameter in Storage clause will reduce no. of rows per block?
Oracle General 
