Index

Symbols  A  B  C  D  E  F  G  H  I  J  L  M  O  P  R  S  T  U  V  X  

---

Symbols

• @ abbreviation 1.1

---

A

• A_TERMCAP environment variable 6.4.1.2
• A_TERM environment variable 6.4.1.2
• ADA_PATH environment variable 1.2.2
• adapters utility 5.2
• administering command line SQL 4.1
• AIXTHREAD_SCOPE environment variable C.4
• AIX tools
  • Base Operation System tools 8.2.7.1
  • Performance Tool Box Agent 8.2.7.2
  • Performance Tool Box Manager 8.2.7.2
  • SMIT 8.2.7.3
  • System Management Interface tools 8.2.7.3
• archive buffers
  • tuning C.1.5
• ASM_DISKSTRING initialization parameter 1.3.1
• assistants
  • Oracle Database Configuration Assistant 3.1.3
  • Oracle Database Upgrade Assistant 3.1.2
  • Oracle Net Configuration Assistant 3.1.1
• asynchronous flag in SGA D.4.4
• asynchronous input/output D.4, D.4.2
  • verifying D.4.3
• Automatic Storage Management
  • restarting 2.1.1.2
  • stopping 2.1.1
• Automatic Storage Management, using 8.4.1
• automating
  • shutdown 2.2
  • startup 2.2

---

B

• bit-length support 6.2
• block size C.1.4
  • adjusting 8.3.3
• buffer cache
  • tuning size 8.7
• buffer manager 8.3
• BUFFER parameter C.1.6

---

C

• cache size 8.7
• catching routine 6.12
  • example 6.12
• CLASSPATH environment variable 1.2.2
• C library for 6.1.6
• client shared libraries 6.1.5
• client static libraries 6.1.5
• COBDIR environment variable 6.4.1.1
• commands
  • iostat 8.2.3
  • lsps 8.2.4
  • sar 8.2.2
  • SPOOL 4.2.4
  • swap 8.2.4
  • swapinfo 8.2.4
  • swapon 8.2.4
  • vmstat 8.2.1
• common environment
  • setting 1.2.3
• concurrent input/output C.2.2
• configuration files
  • ottcfg.cfg 6.1.1
  • pcbcfg.cfg 6.1.1
  • pccfor.cfg 6.1.1
  • pcscfg.cfg 6.1.1
  • pmscfg.cfg 6.1.1
  • precompiler 6.1.1
• CPU_COUNT initialization parameter D.6
• CPU scheduling C.3
• CREATE CONTROLFILE parameter F.1
• CREATE DATABASE parameter F.1

---

D

• database
  • block size C.1.4
• database block size
  • setting C.1.4
• database limits F.1
• DB_BLOCK_SIZE initialization parameter 8.6
• DB_CACHE_SIZE initialization parameter 8.6
• DB_FILE_MULTIBLOCK_READ_COUNT parameter C.2.5
• dbhome file 1.2.3
• debugger programs 6.1.3
• demo_procob.mk file 6.4.4
• demonstration programs
  • for Pro*COBOL 6.4.3
  • Oracle Call Interface 6.7.1
  • Oracle JDBC/OCI 6.8
  • Pro*C/C++ 6.3.1
  • Pro*FORTRAN 6.5.1
  • SQL*Module for Ada 6.6.1
• demonstrations
  • PL/SQL 7.2
  • precompiler 7.2
  • SQL*Loader 7.1
• direct input/output C.2.2
• disk input/output
  • file system type 8.4.2
  • input/output
    • slaves C.2.4
  • pacing C.2.6
  • tuning 8.4
• disks
  • monitoring performance 8.5
• DISPLAY environment variable 1.2.2
• dynamic linking
  • Oracle libraries and precompilers 6.1.4

---

E

• environment variables 6.4.1.1
  • A_TERM 6.4.1.2
  • A_TERMCAP 6.4.1.2
  • ADA_PATH 1.2.2
  • AIXTHREAD_SCOPE C.4
  • all 1.2.1
  • CLASSPATH 1.2.2
  • COBDIR 6.4.1.1
  • DISPLAY 1.2.2
  • for Pro*COBOL 6.4.1
  • HOME 1.2.2
  • LANG 1.2.2
  • LANGUAGE 1.2.2
  • LD_LIBRARY_PATH 1.2.2, 6.4.1.1, 6.4.1.2
  • LD_OPTIONS 1.2.2
  • LIBPATH 6.4.1.1
  • LPDEST 1.2.2
  • MicroFocus COBOL compiler 6.4.1.1
  • ORA_TZFILE 1.2.1
  • ORACLE_BASE 1.2.1
  • ORACLE_HOME 1.2.1
  • ORACLE_PATH 1.2.1
  • ORACLE_SID 1.1, 1.2.1
  • ORACLE_TRACE 1.2.1
  • ORAENV_ASK 1.2.1
  • PATH 1.2.2, 4.2.1, 6.4.1.1, 6.4.1.2
  • PRINTER 1.2.2
  • SHLIB_PATH 6.4.1.1
  • SQLPATH 1.2.1
  • TMPDIR 1.2.2
  • TNS_ADMIN 5.1
  • TWO_TASK 1.2.1
  • USER 1.2.2
• executables
  • precompiler 6.1.2
  • precompilers 6.1.2
  • relinking 3.2
• Extended file system 8.4.2

---

F

• files
  • dbhome 1.2.3
  • demo_procob.mk 6.4.4
  • glogin.sql 4.1.1
  • ins_precomp.mk 6.1.2
  • login.sql 4.1.1
  • Oracle Net Services configuration 5.1
  • ottcfg.cfg 6.1.1
  • pcbcfg.cfg 6.1.1
  • pccfor.cfg 6.1.1
  • pcscfg.cfg 6.1.1
  • pmscfg.cfg 6.1.1
  • privgroup D.2.1, D.4.1
  • root.sh 1.2.3
• file systems
  • ext2/ext3 8.4.2
  • GPFS 8.4.2
  • JFS 8.4.2
  • OCFS2 8.4.2
  • S5 8.4.2
  • UFS 8.4.2
  • VxFS 8.4.2
• FORMAT precompiler 6.4.4
  • Pro*COBOL 6.4.5

---

G

• getprivgrp command D.2.1, D.4.1
• glogin.sql file 4.1.1
• GPFS
  • considerations for using C.2.2

---

H

• HOME environment variable 1.2.2
• HP-UX dynamic processor reconfiguration D.6
• hugetlbfs
  • on SUSE A.7.2

---

I

• I/O buffers and SQL*Loader C.1.6
• I/O support
  • asynchronous A.2
  • direct A.3
• implementing asynchronous input/output D.4.2
• Import utility C.1.6
• initialization parameters 1.3
  • ASM_DISKSTRING 1.3.1
  • CPU_COUNT D.6
  • DB_BLOCK_SIZE 8.6
  • DB_CACHE_SIZE 8.6
  • JAVA_POOL_SIZE 8.6
  • LARGE_POOL_SIZE 8.6
  • LOG_BUFFERS 8.6
  • SHARED_POOL_SIZE 8.6
• input/output
  • asynchronous C.2.3, D.4
  • slaves C.2.4
  • tuning 8.4
• ins_precomp.mk file 6.1.2
• installing
  • SQL*Plus command line Help 4.1.3.1
• iostat command 8.2.3
• IPC protocol 5.3.1
• ireclen 6.1.3

---

J

• JAVA_POOL_SIZE initialization parameters 8.6
• JFS2 considerations C.2.2
• JFSconsiderations C.2.2
• Journaled file system 8.4.2, C.2.2

---

L

• LANG environment variable 1.2.2
• LANGUAGE environment variable 1.2.2
• LARGE_POOL_SIZE initialization parameters 8.6
• LD_LIBRARY_PATH environment variable 1.2.2, 6.4.1.1, 6.4.1.2
• LD_OPTIONS environment variable 1.2.2
• libclntst12.a 6.1.6
• LIBPATH environment variable 6.4.1.1
• libraries
  • client shared and static 6.1.5
• lightweight timer implementation D.3
• Linux
  • resource management A.6
• Linux tools 8.2.6
• listener
  • setting up for TCP/IP or TCP/IP with Secure Sockets Layer 5.4
• LOG_BUFFERS initialization parameters 8.6
• login.sql file 4.1.1
• LPDEST environment variable 1.2.2
• lsps command 8.2.4

---

M

• make files
  • custom 6.9
  • demo_procob.mk 6.4.4
  • ins_precomp.mk 6.1.2
• MAXDATAFILES parameter F.1
• MAXINSTANCES parameter F.1
• MAXLOGFILES parameter F.1
• MAXLOGHISTORY parameter F.1
• MAXLOGMEMBERS parameter F.1
• memory
  • contention C.1
  • control paging 8.3.2
  • swap space 8.3.1
  • tuning 8.3
• MicroFocus COBOL compiler 6.4.1.1
• migrating 3.1.2
• minor numbers of 8-bit D.4.2
• MLOCK privilege D.4.1
• Multi-CPU Binding (MCB) B.3
• multiple signal handlers 6.12
• multithreaded applications 6.11

---

O

• OCCI 6.7
  • user programs 6.7.2
• OCI 6.7
  • user programs 6.7.2
• operating system buffer cache, tuning 8.7
• operating system commands
  • getprivgrp D.2.1
  • running 4.2.2
  • setprivgrp D.2.1
• operating system tools
  • for AIX 8.2.7
  • iostat 8.2.3
  • lsps 8.2.4
  • sar 8.2.2
  • swap 8.2.4
  • swapinfo 8.2.4
  • swapon 8.2.4
  • vmstat 8.2.1
• ORA_NLS10 environment variable 1.2.1
• ORA_TZFILE environment variable 1.2.1
• ORACLE_BASE environment variable 1.2.1
• ORACLE_HOME environment variable 1.2.1
• ORACLE_PATH environment variable 1.2.1
• ORACLE_SID environment variable 1.1, 1.2.1
• ORACLE_TRACE environment variable 1.2.1
• Oracle block size, adjusting 8.3.3
• Oracle buffer manager 8.3
• Oracle C++ Call Interface 6.7, 6.7.1
• Oracle Call Interface 6.7
  • demonstration programs 6.7.1
• Oracle Cluster Services Synchronization Daemon
  • starting 2.1.2
  • stopping 2.1.2
• Oracle Database 3.1.3
  • restarting 2.1.1.2
• Oracle Database Client: 6.1.6
• Oracle Database Configuration Assistant
  • configuring 3.1.3
• Oracle Database environment variables
  • Oracle Database variables 1.2.1
• Oracle Database process
  • stopping 2.1.1
• Oracle Database tuning and large memory allocations D.5
• Oracle Database Upgrade Assistant 3.1.2
• Oracle environment variables
  • ORA_NLS10 1.2.1
  • ORACLE_BASE 1.2.1
  • ORACLE_HOME 1.2.1
  • ORACLE_SID 1.2.1
• Oracle JDBC/OCI
  • demonstration programs 6.8
• Oracle Net Configuration Assistant
  • using 3.1.1
• Oracle Net Services
  • configuration files 5.1
  • IPC protocol 5.3.1
  • protocols 5.3
  • protocol support 5.3
  • Secure Sockets Layer protocol 5.3.3
  • TCP/IP protocol 5.3.2
• Oracle ODBC Driver E
• Oracle Protocol Support
  • IPC protocol 5.3.1
  • TCP/IP protocol 5.3.2
  • TCP/IP with Secure Sockets Layer protocol 5.3.3
• Oracle Solaris
  • resource management B.2, B.3
• Oracle Solaris tools 8.2.5
• ORAENV_ASK environment variable 1.2.1
• oreclen 6.1.3
• ottcfg.cfg file 6.1.1

---

P

• page-out activity 8.3.2
• paging
  • allocating sufficient C.1.2
  • controlling C.1.3
  • tuning 8.3
• parameters
  • BUFFER C.1.6
  • CREATE CONTROLFILE F.1
  • CREATE DATABASE F.1
  • DB_FILE_MULTIBLOCK_READ_COUNT C.2.5
  • MAXDATAFILES F.1
  • MAXLOGFILES F.1
  • MAXLOGHISTORY F.1
  • MAXLOGMEMBERS F.1
  • SCHED_NOAGE D.2
  • SGA_MAX_SIZE B.1.6
  • shm_max 8.6
  • shm_seg 8.6
  • shmmax 8.6
  • shmseg 8.6
• PATH environment variable 1.2.2, 4.2.1, 6.4.1.1, 6.4.1.2
• pcbcfg.cfg file 6.1.1
• pccfor.cfg file 6.1.1
• pcscfg.cfg file 6.1.1
• Performance Tool Box Agent 8.2.7.2
• PL/SQL demonstrations 7.2
• PL/SQL kernel demonstrations 7.2
• pmscfg.cfg file 6.1.1
• postinstallation tasks
  • configuration assistants 3.1
• precompiler executables
  • relinking 6.1.2
• precompilers
  • executables 6.1.2
  • overview 6.1
  • Pro*C/C++ 6.3
  • Pro*COBOL 6.4
  • running demonstrations 7.2
  • signals 6.12
  • uppercase to lowercase conversion 6.1.3
  • value of ireclen and oreclen 6.1.3
  • vendor debugger programs 6.1.3
• PRINTER environment variable 1.2.2
• privgroup file D.2.1, D.4.1
• Pro*C/C++
  • demonstration programs 6.3.1
  • make files 6.3.1
  • signals 6.12
  • user programs 6.3.2
• Pro*C/C++ precompiler 6.3
• Pro*COBOL
  • demonstration programs 6.4.3
  • environment variables 6.4.1
  • FORMAT precompiler 6.4.4, 6.4.5
  • naming differences 6.4
  • Oracle Runtime system 6.4.2
  • user programs 6.4.4
• Pro*FORTRAN demonstration programs 6.5.1
• protocols 5.3

---

R

• raw devices
  • buffer cache size 8.7
• raw logical volumes C.2.2
• relinking executables 3.2
• removing
  • SQL*Plus command line Help 4.1.3.2
• resilvering, with Oracle Database C.2.7
• restarting
  • Automatic Storage Management 2.1.1.2
  • Oracle Database 2.1.1.2
• restrictions, SQL*Plus 4.3
  • passwords 4.3.3
  • resizing windows 4.3.1
  • return codes 4.3.2
• root.sh script 1.2.3

---

S

• sar command 8.2.2, 8.3.2
• SCHED_NOAGE
  • enabling D.2.1
  • scheduling policy D.2
• scripts
  • root.sh 1.2.3
• setprivgrp command D.2.1, D.4.1
• SGA 8.6
  • determining the size of 8.6.1
• SGA_MAX_SIZE parameter B.1.6
• SHARED_POOL_SIZE initialization parameters 8.6
• shared memory segments D.1
• SHLIB_PATH environment variable 6.4.1.1
• shm_max parameter 8.6
• shm_seg parameter 8.6
• shmmax parameter 8.6
• shmseg parameter 8.6
• shutdown
  • automating 2.2
• SIGCLD signal 6.12
• SIGCONT signal 6.12
• SIGINT signal 6.12
• SIGIO signal 6.12
• signal handlers 6.12
• signal routine 6.12
  • example 6.12
• signals
  • SIGCLD 6.12
  • SIGCONT 6.12
  • SIGINT 6.12
  • SIGIO 6.12
  • SIGPIPE 6.12
  • SIGTERM 6.12
  • SIGURG 6.12
• SIGPIPE signal 6.12
• SIGTERM signal 6.12
• SIGURG signal 6.12
• SPOOL command
  • SQL*Plus 4.2.4
• SQL*Loader C.1.6
• SQL*Loader demonstrations 7.1
• SQL*Module for Ada 6.6
  • demonstration programs 6.6.1
  • user programs 6.6.2
• SQL*Plus
  • command line Help 4.1.3
  • default editor 4.2.1
  • editor 4.2.1
  • interrupting 4.2.3
  • restrictions 4.3
  • running operating system commands 4.2.2
  • site profile 4.1.1
  • SPOOL command 4.2.4
  • system editor 4.2.1
  • user profile 4.1.1
  • using command-line SQL*Plus 4.2
• SQL*Plus, interrupting 4.2.3
• SQL*Plus command line Help
  • installing 4.1.3.1
  • removing 4.1.3.2
• SQLPATH environment variable 1.2.1
• starting
  • Oracle Cluster Services Synchronization Daemon 2.1.2
• startup
  • automating 2.2
• static linking
  • Oracle libraries and precompilers 6.1.4
• stopping
  • Oracle Cluster Services Synchronization Daemon 2.1.2
• swap command 8.2.4
• swapinfo command 8.2.4
• swapon command 8.2.4
• swap space 8.3
  • tuning 8.3
• swap space allocation 8.3.1
• symfind utility 6.10
• SYSDATE 1.2.4
• system editor
  • SQL*Plus 4.2.1
• system time 1.2.4

---

T

• TCP/IP protocol 5.3.2
• TCP/IP with Secure Sockets Layer protocol 5.3.3
• thread support 6.11
• TMPDIR environment variable 1.2.2
• Transparent Hugepages
  • disable for Oracle Database servers A.7.6
• troubleshooting
  • I/O lags A.7.6
  • ocssd.log threads blocked A.7.6
• tuning 8.3
  • disk input/output 8.4
  • input/output bottlenecks 8.4
  • large memory allocations D.5
  • memory management 8.3
  • recommendations D.5.2
• tuning tools
  • iostat command 8.2.3
  • lsps command 8.2.4
  • Performance Tool Box Agent 8.2.7.2
  • Performance Tool Box Manager 8.2.7.2
  • sar command 8.2.2
  • swap command 8.2.4
  • swapinfo command 8.2.4
  • swapon command 8.2.4
  • vmstat command 8.2.1
• TWO_TASK environment variable 1.2.1

---

U

• undefined symbols 6.10
• Unix file systems 8.4.2
• UNIX System V file system 8.4.2
• upgraded databases
  • upgrading 3.1.2
• USER environment variable 1.2.2
• user interrupt handler 6.12
• user profile
  • SQL*Plus 4.1.1
• user programs
  • for Pro*C/C++ 6.3.2
  • OCCI 6.7.2
  • OCI 6.7.2
  • Pro*C/C++ 6.3.2
  • Pro*COBOL 6.4.4
  • SQL*Module for Ada 6.6.2
• using command-line SQL*Plus 4.2
• utilities
  • adapters 5.2
  • Import C.1.6
  • symfind 6.10

---

V

• Veritas file system 8.4.2
• virtual memory data pages
  • tuning Oracle Database D.5
• virtual memory page size, default D.5.1
• vmstat command 8.2.1

---

X

• X/Open Distributed Transaction Processing XA interface 6.13
• XA functionality 6.13