Oracle clusters


Oracle clusters

What are the clusters? What are their advantages?

Oracle clusters - Dec 03, 2008 at 15:00 PM by Rajmeet Ghai

What are the clusters? What are their advantages?

A cluster contains data from one or more tables. All these tables have one or more columns in common. All the rows from all the tables that share the same cluster key.

Example: cluster named workers with the cluster key column department, a cluster size of 512 bytes, and storage parameter values

(department NUMBER(4))
SIZE 512
STORAGE (initial 100K next 50K);


  • Clusters can speed up join queries.
  • Storage is saved since storing the field or fields comprising the Cluster Key are stored once instead of multiple times.
  • Clustering does not does not affect the relational model (table schemas).
Oracle database objects

Oracle stores information in the form of tables. For eg you can have a table named as climate in which you can store information about the climate of a place in the form of columns...........

Difference between open_form and call_form

Open_form opens the indicated form. Call_form not just opens the indicated form, but also keeps the parent form alive...............

Oracle error handling

What is Exception in Oracle?, What are the predefined oracle exceptions?, Explain user defined exceptions in oracle, How PL/SQL Exceptions Are Raised?.............

Explain how to prevent tablespace fragmentation in oracle.

Tablespace fragmentation can be prevented by using PCTINCREASE command. PCTINCREASE is the percentage a new subsequent extent will grow...............

Oracle Modernization Solutions

A lot has been written on legacy modernization in the past few years. Most of the books, analyst reports, and white papers discuss at a high level why one should modernize and theorize, and the different approaches to, and possible outcomes of modernization............

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring