Oracle Parallel Server Support for the Oracle Enterprise Manager Console Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

Overview


This chapter describes some of the basic concepts of Oracle Parallel Servers and parallel server instances. You can control the activity of parallel servers and parallel server instances from Oracle Enterprise Manager's Navigator window. This chapter also describes the tasks you need to perform before you can start or shut down a parallel server.

The topics in this chapter are:

What Are Parallel Servers and Parallel Server Instances?

Specifying User Preferences for Parallel Server Nodes

What Are Parallel Servers and Parallel Server Instances?


An Oracle Parallel Server is a set of Oracle instances that access the same database. A parallel server can be run from a small cluster as well as from a large massively parallel processor (MPP) computer.

An Oracle Parallel Server Instance is comprised of background processes and shared memory (SGA) and allows you to access a database. You can connect to any instance to access any information that resides within a parallel server database.

You can access two types of activities within a parallel server: database-related activities and instance-related activities.

A database-related activity is any action or data stored in the database itself using tables. When you execute a parallel server job which involves a database-related activity, the job only needs to execute once. An example of a job containing database-related activity is the executing of SQL statements.

An instance-related activity is any action or data that pertains to a single instance. The data portion resides in the instance's SGA. When you execute a parallel server job which involves an instance-related activity, the job needs to be executed on every instance of the parallel server. An example of a job containing instance-related activity is starting or stopping an instance.

Specifying User Preferences for Parallel Server Nodes


Before you can start or shut down a parallel server, you must specify a username and password for every node belonging to the parallel server. Typically, the username and password you enter will be that of the oracle owner.

  1. From the Enterprise Manager menu bar, select File>Preferences. The User Preferences dialog box opens and displays all of the objects in the network.

  2. Scroll down to the line that displays the nodes of the parallel server you want to start or shut down.

  3. Click on this line and enter the username and password. Typically, you enter the username and password of the oracle owner. The Role field is greyed out and unavailable for nodes. Repeat this step for each node belonging to the parallel server.



Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index