Oracle8i Parallel Server Concepts Release 2 (8.1.6) A76968-01 |
|
This manual prepares you to successfully implement parallel processing by presenting Oracle Parallel Server concepts. Information in this manual applies to Oracle Parallel Server as it runs on all operating systems.
You should read this manual before reading the Oracle8i Parallel Server Setup and Configuration Guide and Oracle8i Parallel Server Administration, Deployment, and Performance. For general information about Oracle and administering the Oracle Server, refer to Oracle8i Concepts. and the Oracle8i Administrator's Guide.
See Also:
You can also use the Oracle8i Parallel Server Documentation Online Roadmap to help you use the online Oracle Parallel Server Documentation set. |
This book has been re-written for Oracle8i. Oracle8i introduces Cache Fusion, a feature that reduces the overhead of resolving read/write conflicts caused by inter-instance contention. This greatly enhances performance as well as Oracle Parallel Server scalability.
See Also:
Appendix A, "Differences Between Releases" for information on feature changes from one release of Oracle Parallel Server to another. |
Release 8.1.5 introduced the first phase of Cache Fusion.
Release 8.1.6 introduces further enhancements to Cache Fusion as well as the Primary/Secondary Instance feature. There are also several new performance statistics.
This manual is written for database administrators and application developers who work with Oracle Parallel Server.
This book presents Oracle Parallel Server concepts in four parts. It begins by describing parallel processing fundamentals for Oracle Parallel Server. The book then covers synchronization processing among instances and explains the fundamentals of how Oracle Parallel Server is implemented. It ends with reference material that includes an appendix describing the differences between versions, and an appendix describing the implementation restrictions of Oracle Parallel Server.
This book has been reorganized for 8.1.6 into the following four parts:
This chapter provides a detailed discussion of the inter-instance coordination activities involved in a cluster. |
|
This chapter provides detail on Parallel Cache Management locking. |
Part III, "Implementing Oracle Parallel Server"
This appendix describes the differences between this release and previous releases of Oracle that pertain to Oracle Parallel Server. |
|
This appendix lists restrictions for Oracle Parallel Server. |
After reading this manual, read Oracle8i Parallel Server Setup and Configuration Guide and the Oracle8i Parallel Server Administration, Deployment, and Performance.
Read the following manuals for more information:
This section explains the conventions used in this manual including the following:
This section explains the conventions used within the text:
Uppercase text is used to call attention to command keywords, object names, parameters, filenames, and so on.
For example, "If you create a private rollback segment, the name must be included in the ROLLBACK_SEGMENTS parameter of the parameter file."
Italicized words within text are book titles or emphasized words.
The syntax diagrams and notation in this manual show the syntax for SQL commands, functions, hints, and other elements. This section tells you how to read syntax diagrams and examples and write SQL statements based on them.
Keywords are words that have special meanings in the SQL language. In the syntax diagrams in this manual, keywords appear in uppercase. You must use keywords in your SQL statements exactly as they appear in the syntax diagram, except that they can be either uppercase or lowercase. For example, you must use the CREATE keyword to begin your CREATE TABLE statements just as it appears in the CREATE TABLE syntax diagram.
Parameters act as place holders in syntax diagrams. They appear in lowercase. Parameters are usually names of database objects, Oracle datatype names, or expressions. When you see a parameter in a syntax diagram, substitute an object or expression of the appropriate type in your SQL statement. For example, to write a CREATE TABLE statement, use the name of the table you want to create, such as EMP, in place of the table parameter in the syntax diagram. (Note that parameter names appear in italics in the text.)
This list shows parameters that appear in the syntax diagrams in this manual and examples of the values you might substitute for them in your statements:
SQL and SQL*Plus commands and statements appear separated from the text of paragraphs in a monospaced font. For example:
INSERT INTO emp (empno, ename) VALUES (1000, 'SMITH'); ALTER TABLESPACE users ADD DATAFILE 'users2.ora' SIZE 50K;
Example statements may include punctuation, such as commas or quotation marks. All punctuation in example statements is required. All example statements terminate with a semicolon (;). Depending on the application, a semicolon or other terminator may or may not be required to end a statement.
Uppercase words in example statements indicate the keywords within Oracle SQL. When you issue statements, however, keywords are not case sensitive.
Lowercase words in example statements indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|