Question
List the optional flexible architecture (ofa) of oracle database? or how can we organize the tablespaces in oracle database to have maximum performance ?
Answers
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.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Who is an assessing Officer?
  • Q What is the role of communication in implementing an effective disciplinary system?
  • Q As per the agreement made between India and Bangladesh, how many Indian enclaves have been merged with Bangladesh?
  • Q According to Union Budget 2014-15, how many IIMs to be opened?
  • Q Between the iterative routine sum-iter and recursive routine sum-rec, which is more efficient and why?
  • Q Can we connect two dataadapters to same data source using single connection at same time?
  • Q Who known as the Flying Sikh of India
  • Q Discuss the mechanisms by which antigenic change occurs in influenza viruses and detail the selection pressures that may facilitate emergence of new viral strains
  • Q What role does a Receptionist play in a customer's first impression of an organization?
  • Q In which European city is the Charles Bridge?
  • Q Can we override a static method?