List the Optional Flexible Architecture (OFA) of Oracle
database ?
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 are Oracle Schema Objects?
What are functions of PMON?
What is Shared Pool?
What are the consideration at tehe migration of Oracle 9i to 10G.
How will you estimate the space required by a non-clustered tables?
What is meant by redo log buffer ?
How will you swap objects into a different table space for an existing database?
How to find the SGA Size
When will be a segment released?
How the space utilisation takes place within rollback segments?
What is the function of checkpoint(CKPT)?
Diference between Oracle 9i and 10G.