Oracle8i Administrator's Reference
Release 3 (8.1.7) 64 Bit for SGI IRIX

Part Number A87435_01
Go To Documentation Library
Go To Product List
Go To Index

Go to next page


Title and Copyright Information

Send Us Your Comments


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

1 Administering Oracle8i

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
Groups and Security
Security for Server Manager Commands
Security for Database Files
Remote Passwords
Customizing the initsid.ora File
Embedded PL/SQL Gateway
Installing the Embedded PL/SQL Gateway
Demonstrations Files
SQL*Loader Demonstrations
Administering SQL*Loader
PL/SQL Demonstrations
Database Examples

2 Tuning Oracle8i

The Importance of Tuning
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 the Post-Wait Driver
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 SGI IRIX Buffer Cache Size
Tuning Oracle8i on IRIX Systems
Lock the SGA in Physical Memory
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 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*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
Audio, Video, and Image
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
Directory Structure


Go to next page
Copyright © 2001 Oracle Corporation.

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