Oracle7 Server Reference Manual

Library

Product

Contents

Index

Info

Audience
How Oracle7 Server Reference Is Organized
Conventions Used in This Manual
Your Comments Are Welcome

This manual provides reference information about Oracle7 Server release 7.3, including

initialization parameters

static data dictionary views

dynamic performance (V$) views

National Language Support (NLS)

database limits

Structured Query Language (SQL) scripts

Information in this manual applies to the Oracle7 Server release 7.3 running on all operating systems.

Audience

This manual is written for database administrators, system administrators, and database application developers.

Knowledge Assumed of the Reader

It is assumed that readers of this manual are familiar with relational database concepts, basic Oracle7 Server concepts, and with the operating system environment under which they are running Oracle.

Installation and Migration Information

This manual is not an installation or migration guide. Therefore, if your primary interest is installation, refer to your operating system-specific Oracle documentation, or if your primary interest is database and application migration, refer to Oracle7 Server Migration.

Database Administration Information

While this manual describes the architecture, processes, structures, and other concepts of the Oracle Server, it does not explain how to administer the Oracle Server. For that information, see the Oracle7 Server Administrator's Guide.

Application Design Information

In addition to administrators, experienced users of Oracle and advanced database application designers will find information in this manual useful. However, database application developers should also refer to the Oracle7 Server Application Developer's Guide and to the documentation for the tool or language product they are using to develop Oracle database applications.

**How Oracle7 Server Reference Is Organized**

This manual is organized as follows:

Chapter 1 Initialization Parameters

This chapter contains detailed descriptions of the database initialization parameters in the parameter file that are required to start an instance.

Chapter 2 Static Data Dictionary Views

This chapter contains descriptions of the Oracle7 data dictionary tables and views.

Chapter 3 Dynamic Performance (V$) Tables

This chapter contains descriptions of the dynamic performance views, also known as the V$ views.

Chapter 4 National Language Support

This chapter describes features that enable Oracle7 applications to operate with multiple languages using conventions specified by the application user.

Chapter 5 Database Limits

This chapter lists the limits of values associated with database functions and objects.

Chapter 6 SQL Scripts

This chapter describes the SQL scripts that are required for optimal operation of the Oracle7 Server.

Appendix A Operating System Dependencies

This appendix lists all references made in this manual to operating system-dependent behavior for the Oracle utilities.

Conventions Used in This Manual

The following sections explain the conventions used in this manual.

Text of the Manual

The following textual conventions are used:

UPPERCASE WORDS

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 of the rollback segment must be included in the ROLLBACK_SEGMENTS parameter of the parameter file."

Italicized Words

Italicized words within text indicate the definition of a term. For example:

"A database is a collection of data to be treated as a unit. The general purpose of a database is to store and retrieve related information, as needed."

Italics also call out specific book titles and empasized words.

Examples of Commands and Statements

SQL, Server Manager line mode, 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;

Punctuation , ' "

Example statements may include punctuation such as commas or quotation marks. All punctuation given in example statements is required. All example statements are terminated with a semicolon. Note that depending on the application being used, a semicolon or other terminator may or may not be required to end a statement.

Uppercase Words: INSERT, SIZE

Uppercase words in example statements are used to indicate the keywords within Oracle SQL. However, note that when issuing statements, keywords are not case sensitive.

Lowercase Words: emp, users2.ora

Lowercase words in example statements are used to indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file.

Special Icons

Two special icons are provided to alert you to particular information within the body of this manual:

Suggestion: The lightbulb highlights suggestions and practical tips that could save time, make procedures easier, and so on.

Warning: The warning symbol highlights text that warns you of actions that could be particularly damaging or fatal to your operations.

Additional Information: The OSDoc icon signifies the reader should refer to the Oracle operating system-specific documentation for additional information.

Your Comments Are Welcome

We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. At the back of this manual is a Reader's Comment Form which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals.

If the form is not available, please use the following address.

Oracle7 Server Documentation Manager Oracle Corporation 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A.

Prev Next

Library

Product

Contents

Index