You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for CLUSTER


1 to 20 of 873 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Performance Tuning Guide, 10g Release 1 (10.1)

14 The Query Optimizer

Cluster AccessA cluster scan is used to retrieve, from a table stored in an indexed cluster, all rows that have … the same cluster key value. In an indexed cluster, all rows with the same cluster key value are … stored in the same data block. To perform a cluster scan, Oracle first obtains the rowid

SQL Reference, 10g Release 1 (10.1)

DROP CLUSTER

DROP CLUSTERPurpose Use the DROP CLUSTER clause to remove a cluster from the database. Caution: When you drop a … cluster, any tables in the recycle bin that were once part of that cluster are purged from the … contents as the old one, but with no CLUSTER clause. Drop the old table. Use the RENAME statement to

Concepts Guide, 10g Release 1 (10.1)

5 Cluster Environment Installations

Cluster InstallationIn a typical cluster installation, when clusterware is present, Universal Installer installs the … node installation to the other nodes that are part of the installation. If the cluster is Cluster … . Note: For cluster installations, you must run oraInstRoot.sh on each node of the cluster to set up the

Concepts Guide, 10g Release 1 (10.1)

5 Cluster Environment Installations

Cluster DetectionWhen OUI detects that the destination you entered on the File Locations page is part of a cluster … Installation Mode page appears. Use this page to select between cluster and non-cluster installation … : Cluster installation: Select the nodes for your installation from the list of nodes on which clusterware

Concepts Guide, 10g Release 1 (10.1)

5 Cluster Environment Installations

Cluster Deinstallationare deinstalling, then removes software from the other cluster nodes associated with the Oracle home.

SQL Reference, 10g Release 1 (10.1)

ALTER CLUSTER

ALTER CLUSTERPurpose Use the ALTER CLUSTER statement to redefine storage and parallelism characteristics of a … cluster. Note: You cannot use this statement to change the number or the name of columns in the … cluster key, and you cannot change the tablespace in which the cluster is stored. See Also: CREATE CLUSTER

SQL Reference, 10g Release 1 (10.1)

CREATE CLUSTER

CREATE CLUSTERPurpose Use the CREATE CLUSTER statement to create a cluster. A cluster is a schema object that … stores together all the rows from all the tables that share the same cluster key. For information … information on the data dictionary views Prerequisites To create a cluster in your own schema, you

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKR—Cluster Registry MessagesPRKR— Cluster Registry Messages PRKR-1001 "cluster database {0} does not exist"

Concepts Guide, 10g Release 1 (10.1)

5 Cluster Environment Installations

5 Cluster Environment InstallationsA cluster installation uses Oracle Universal Installer to install software on the nodes of a … cluster that are network reachable and bound together by Oracle clusterware. You can use OUI to extend the … Oracle home of a product installation to include additional nodes on the cluster. This chapter … Software on a Cluster

Administrator's Guide, 10g Release 1 (10.1)

C Oracle Real Application Clusters Tools Messages

PRKC—Cluster Command Messagesusing 'srvctl add nodeapps' PRKC—Cluster Command Messages

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on Cluster TablesObject tables and tables containing LOB columns cannot be part of a cluster. You cannot specify … CLUSTER with either ROWDEPENDENCIES or NOROWDEPENDENCIES unless the cluster has been created with the

Administrator's Guide, 10g Release 1 (10.1)

17 Managing Clusters

Creating Cluster IndexesTo create a cluster index, one of the following conditions must be true: Your schema contains the … cluster. You have the CREATE ANY INDEX system privilege. In either case, you must also have either a … quota for the tablespace intended to contain the cluster index, or the UNLIMITED TABLESPACE system … privilege. A cluster

Administrator's Guide, 10g Release 1 (10.1)

8 Administrative Options

Cluster Database Home PageFrom the Cluster Database Home Page you can manage the cluster nodes and hosts as well as cluster … subcomponents such as instances and listeners. The Cluster Database Home Page is also a summary page … for cluster database management that provides an overview of cluster database activity.

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

duplicate cluster keyIt is possible for a race condition to occur when creating a new cluster key. If it is found that … another process has put the cluster key into the data/index block, then the session waits and retries … . The retry should then find a valid cluster key. Wait Time: 0.01 seconds Parameter Description dba … The dba of the block into

Administrator's Guide, 10g Release 1 (10.1)

17 Managing Clusters

Altering Cluster IndexesYou alter cluster indexes exactly as you do other indexes. See "Altering Indexes". Note: When … estimating the size of cluster indexes, remember that the index is on each cluster key, not the actual

Upgrade Guide, 10g Release 1 (10.1)

3 Upgrading a Database to the New Oracle Database 10 g Release

Upgrading a Cluster DatabaseIf you are upgrading a cluster database, then most of the actions described in this chapter should

SQL Reference, 10g Release 1 (10.1)

CREATE CLUSTER

Restrictions on Cluster DatatypesYou cannot specify a cluster key column of datatype LONG, LONG RAW, REF, nested table, varray, BLOB … information on datatypes SORT The SORT keyword is valid only if you are creating a hash cluster. This … clause instructs Oracle Database to sort the rows of the cluster on this column before applying the … . See "HASHKEYS Clause

Administrator's Guide, 10g Release 1 (10.1)

8 Administrative Options

Cluster Database Instances PagesInstances pages show instance-specific information similar to the information that you would see on a single-instance Oracle database.

Administrator's Guide, 10g Release 1 (10.1)

17 Managing Clusters

Dropping Cluster IndexesA cluster index can be dropped without affecting the cluster or its clustered tables. However … , clustered tables cannot be used if there is no cluster index; you must re-create the cluster index to … allow access to the cluster. Cluster indexes are sometimes dropped as part of the

Administrator's Guide, 10g Release 1 (10.1)

17 Managing Clusters

Specify the Location of Each Cluster and Cluster Index RowsIf you have the proper privileges and tablespace quota, you can create a new cluster and the … associated cluster index in any tablespace that is currently online. Always specify the TABLESPACE clause … in a CREATE CLUSTER / INDEX statement to identify the tablespace to store the new cluster or index … . The cluster