Oracle8 Administrator's Reference for Sun SPARC Solaris 2.x
Release 8.0.4







Title and Copyright Information

Send Us Your Comments


Oracle8 and Oracle8 Enterprise Edition
Typographic Conventions
Command Syntax

1 Optimal Flexible Architecture on Oracle8

Optimal Flexible Architecture (OFA)
Characteristics of OFA-Compliant Database
OFA Implemented on Oracle8 for UNIX
Naming Mount Points
Naming Directories
Naming Files
Naming Tablespaces
Exploiting OFA Structure for Oracle Files
OFA File Mapping
Raw Device Sizes
File Mapping for Multiple-Instance OFA Database
Directory Structure
Default OFA Database

2 Administering Oracle8 on Solaris 2.x

Customizing the initsid.ora File
Sample initsid.ora File
Setting the Environment
Displaying and Setting Environment Variables
Setting a Common Environment
Database Examples
Environment Variables for Oracle8
Oracle Environment Variables on UNIX
UNIX Environment Variables Used with Oracle8
Setting the System Time
Estimating Oracle8 Server Memory Usage
Calculating Cluster Size and Index Size
Calculating Cluster Size
Calculating Index Size
Server Resource Limits
Initialization Parameters
Default Initialization Parameter Values
Controlling the System Global Area
Size limits of the SGA
Calculating the Size of the SGA
Relocating the SGA
Managing Special Accounts and Groups
Special Accounts
Special Groups
Managing Security
Groups and Security
Security for Oracle Server Utilities
Oracle Server Roles and UNIX Groups
Security for Server Manager Commands
Security for Database Files
Network Security
Enabling Automatic Logins for Oracle Net8
Checking Order
Security and Remote Passwords
Administering Login Home Directories
Building and Running Demonstrations
Loading PL/SQL Demonstrations
Running PL/SQL Demonstrations
SQL*Loader Demonstrations
Administering SQL*Loader
Oracle Security Server
Oracle8 Server SQL Reference

3 Tuning Oracle8 on Solaris 2.x

The Importance of Tuning
Before Tuning the System
Solaris 2.x Tools
SQL Scripts
utlbstat and utlestat 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
Look for Large Disk Request Queues Using IOSTAT
Choose the Appropriate File System Type
Monitoring Disk Performance
Disk Performance Issues
Tuning CPU Usage
Keep All Oracle Users/Processes at the Same Priority
Use Processor Affinity/Binding on Multi-Processor Systems
Use Single-Task Linking for Large Exports/Imports and SQL*Loader Jobs
Tuning Oracle Resource Contention
Tune UNIX Kernel Parameters
Tuning Block Size and File Size
Specifying Oracle Block Size
Tuning the Solaris 2.x Buffer Cache Size
Using Trace and Alert Files
Trace File Names
Alert Files
Raw Devices
Disadvantages of Raw Devices
Guidelines for Using Raw Devices
Setting Up Raw Devices

4 Administering SQL*Plus on Solaris 2.x

Administering SQL*Plus
Setup Files
The Site Profile
The User Profile
Demonstration Tables
Help Facility
Using SQL*Plus
Using a System Editor from SQL*Plus
Setting the Order of the Editor
Setting the _editor option
Setting Environment Variables
Default Settings
Running Operating System Commands from SQL*Plus
Interrupting SQL*Plus
Using the SPOOL Command
COPY Command
Resizing Windows
Return Codes

5 Using Oracle Precompilers and the Oracle Call Interface on Solaris 2.x

Overview of Oracle Precompilers
Relinking Precompiler Executables
Precompiler Configuration Files
Issues Common to All Precompilers
Supplemental Documentation
Administering Pro*C/C++
Using Pro*C/C++
Administering Pro*COBOL
Environment Variables
Using Pro*COBOL
Administering Pro*FORTRAN
SQL*Module for Ada
Administering SQL*Module for Ada
Using SQL*Module for Ada
Oracle Call Interface
Using the Oracle Call Interface
Oracle Precompiler and Oracle Call Interface Linking and Makefiles
Custom Makefiles
Undefined Symbols
Thread Support
Static and Dynamic Linking with Oracle Libraries
Using Signal Handlers
XA Functionality

6 Configuring Oracle Net8

Supplemental Documentation
Supplementary Information in README Files
Core Net8 Products and Features
Net8 Files and Utilities
Oracle Connection Manager
Multi-Threaded Server
Oracle Names
Net8 Assistant
Oracle Net8 Protocol Adapters
The BEQ Protocol Adapter
Overview of the BEQ Protocol Adapter
Specifying a BEQ ADDRESS
The IPC Protocol Adapter
Overview of the IPC Protocol Adapter
Specifying an IPC ADDRESS
The RAW Protocol Adapter
The TCP/IP Protocol Adapter
Overview of the TCP/IP Protocol Adapter
Specifying a TCP/IP ADDRESS
The SPX/IPX Protocol Adapter
The ntisbsdm Broadcast Daemon
The ntspxctl Utility
SPX/IPX Protocol Adapter Command Summary
The getname Command
Specifying the SPX/IPX ADDRESS
The APPC/LU6.2 Protocol Adapter
Solaris 2.x-Specific Listener
Specifying an APPC/LU6.2 ADDRESS
Net8 Naming Adapters
Oracle Enterprise Manager (OEM) Intelligent Agent
Oracle Advanced Networking Option

7 Running Oracle Data Cartridge Demos on Solaris 2.x

Issues Common to Data Cartridges
Oracle8 Time Series Cartridge
Installing Time Series Cartridge Demos
Oracle8 Visual Information Retrieval Cartridge
Creating the Demo
Oracle8 Image Cartridge
Creating the Demo


Copyright © 1997 Oracle Corporation.

All Rights Reserved.