Oracle8i Administrator's Reference
Release 3 (8.1.7) 64 Bit for Fujitsu Siemens ReliantUNIX

Part Number A89874-01
Go To Documentation Library
Library
Go To Product List
Product
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Purpose of this Guide
Audience
Oracle8i and Oracle8i Enterprise Edition
Typographic Conventions
Command Syntax
Accessing Installed Documentation
Related Documentation
Oracle Services and Support

1 Administering Oracle8i

Overview
Environment Variables
Oracle8i Environment Variables
UNIX Environment Variables
Setting a Common Environment
Setting and Exporting the Value of a Variable in a Current Session
Setting the System Time
Product Executables
System Global Area
Calculating the Size of the SGA
Oracle8i Memory Requirements and Usage
Server Resource Limits
Database Limits
Special Accounts and Groups
Security
Groups and Security
Security for Server Manager Commands
Security for Database Files
Remote Passwords
Customizing the initsid.ora File
Embedded PL/SQL Gateway
Overview
Installing the Embedded PL/SQL Gateway
SQL*Loader Demonstrations Files
SQL*Loader Demonstrations
Administering SQL*Loader
PL/SQL Demonstrations
Database Examples

2 Tuning Oracle8i

The Importance of Tuning
Fujitsu Siemens ReliantUNIX Tools
vmstat
sar
dkstat
mpstat
swap
SQL Scripts
Tuning Memory Management
Allocate Sufficient Swap Space
Control Paging
Hold the SGA in a Single Shared Memory Segment
Tuning Disk I/O
Tune the Database Writer to Increase Write Bandwidth
Choose the Appropriate File System Type
Monitoring Disk Performance
Disk Performance Issues
Tuning CPU Usage
Keep All Oracle Users and Processes at the Same Priority
Use Processor Affinity and Binding on Multi-Processor Systems
Use a Client/Server Configuration
Use Single-Task Linking for Large Exports/Imports and SQL*Loader Jobs
Tuning Oracle Resource Contention and UNIX Kernel Parameters
Tuning and Specifying Block Size and File Size
Tuning the Fujitsu Siemens ReliantUNIX Buffer Cache Size
Using Trace and Alert Files
Trace File Names
Alert Files
Using Raw Devices/Volumes
Disadvantages of Raw Devices/Volumes
Guidelines for Using Raw Devices/Volumes
Raw Device Setup

3 Administering SQL*Plus

Administering SQL*Plus
Using Setup Files
Using the PRODUCT_USER_PROFILE Table
Using Demonstration Tables
Installing and Removing the Help Facility
Using SQL*Plus
Using a System Editor from SQL*Plus
Running Operating System Commands from SQL*Plus
Interrupting SQL*Plus
Using the SPOOL Command
Restrictions of SQL*Plus
Resizing Windows
Return Codes

4 Using Oracle Precompilers and the Oracle Call Interface

Overview of Oracle Precompilers
Precompiler Configuration Files
Issues Common to All Precompilers
Static and Dynamic Linking
Client Shared Library
Pro*C/C++ Precompiler
Pro*C/C++ Demonstration Programs
Pro*C/C++ User Programs
Pro*COBOL Precompiler
Pro*COBOL Environment Variables
MicroFocus COBOL Compiler
Pro*COBOL Demonstration Programs
Pro*COBOL User Programs
FORMAT Precompiler Option
Pro*FORTRAN Precompiler
Pro*FORTRAN Demonstration Programs
Pro*FORTRAN User Programs
Oracle Call Interface
OCI Demonstration Programs
OCI User Programs
Custom Make Files
Correcting Undefined Symbols
Multi- threaded Applications
Using Signal Handlers
XA Functionality

5 Configuring Net8

Core Net8 Products and Features
Net8 Files and Utilities
Oracle Connection Manager
Server Models
Oracle Names
Net8 Protocol Support
ADDRESS Specification
BEQ Protocol
IPC Protocol
RAW Protocol
TCP/IP Protocol Adapter
Specifying a TCP/IP ADDRESS
Configuring Oracle Intelligent Agent for Oracle SNMP
Oracle Advanced Security

6 Running Oracle Data Option Demonstrations

Oracle8i interMedia
Text
Audio, Video, and Image
Locator
Web Agent and Clipboard
Oracle8i Time Series Demonstrations
Oracle8i Visual Information Retrieval
Oracle8i Spatial

A Optimal Flexible Architecture

Optimal Flexible Architecture
Characteristics of an OFA-Compliant Database
Optimal Flexible Architecture Implemented on UNIX
Mount Points
Naming Directories
Naming Database Files
Separate Segments with Different Requirements
Naming Tablespaces
Exploiting the OFA Structure for Oracle Files
OFA File Mapping
Raw Device Sizes
File Mapping for Multiple-Instance OFA Database
Directory Structure

Index


Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Library
Go To Product List
Product
Go To Index
Index