Index

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

Symbols

  • @ abbreviation 1

A

  • A_TERMCAP environment variable 1
  • A_TERM environment variable 1
  • ADA_PATH environment variable 1
  • adapters utility 1
  • administering command line SQL 1
  • AIXTHREAD_SCOPE environment variable 1
  • AIX tools
    • Base Operation System tools 1
    • Performance Tool Box Agent 1
    • Performance Tool Box Manager 1
    • SMIT 1
    • System Management Interface tools 1
  • archive buffers
    • tuning 1
  • ASM_DISKSTRING initialization parameter 1
  • assistants
    • Oracle Database Configuration Assistant 1
    • Oracle Database Upgrade Assistant 1
    • Oracle Net Configuration Assistant 1
  • asynchronous flag in SGA 1
  • asynchronous input/output
    • verifying 1
  • Automatic Storage Management
    • restarting 1
    • stopping 1
  • Automatic Storage Management, using 1
  • automating
    • shutdown 1
    • startup 1

B

  • bit-length support 1
  • block size
    • adjusting 1
  • buffer cache
    • tuning size 1
  • buffer manager 1
  • BUFFER parameter 1

C

  • cache size 1
  • catching routine
    • example 1
  • CLASSPATH environment variable 1
  • C library for 1
  • client shared libraries 1
  • client static libraries 1
  • COBDIR environment variable 1
  • commands
    • iostat 1
    • lsps 1
    • sar 1
    • SPOOL 1
    • swap 1
    • swapinfo 1
    • swapon 1
    • vmstat 1
  • common environment
    • setting 1
  • concurrent input/output 1
  • configuration files
    • ottcfg.cfg 1
    • pcbcfg.cfg 1
    • pccfor.cfg 1
    • pcscfg.cfg 1
    • pmscfg.cfg 1
    • precompiler 1
  • CPU_COUNT initialization parameter 1
  • CPU scheduling 1
  • CREATE CONTROLFILE parameter 1
  • CREATE DATABASE parameter 1

D

  • database
    • block size 1
  • database block size
    • setting 1
  • database limits 1
  • DB_BLOCK_SIZE initialization parameter 1
  • DB_CACHE_SIZE initialization parameter 1
  • DB_FILE_MULTIBLOCK_READ_COUNT parameter 1
  • dbhome file 1
  • debugger programs 1
  • demo_proc32.mk file 1
  • demo_procob.mk file 1
  • demonstration programs
    • for Pro*COBOL 1
    • Oracle Call Interface 1
    • Oracle JDBC/OCI 1
    • Pro*C/C++ 1
    • Pro*FORTRAN 1
    • SQL*Module for Ada 1
  • demonstrations
    • PL/SQL 1
    • precompiler 1
    • SQL*Loader 1
  • direct input/output 1
  • disk input/output
    • file system type 1
    • input/output
      • slaves 1
    • pacing 1
    • tuning 1
  • disks
    • monitoring performance 1
  • DISPLAY environment variable 1
  • dynamic linking
    • Oracle libraries and precompilers 1

E

  • environment variables
    • A_TERM 1
    • A_TERMCAP 1
    • ADA_PATH 1
    • AIXTHREAD_SCOPE 1
    • all 1
    • CLASSPATH 1
    • COBDIR 1
    • DISPLAY 1
    • for Pro*COBOL 1
    • HOME 1
    • LANG 1
    • LANGUAGE 1
    • LD_LIBRARY_PATH 1 , 2 , 3
    • LD_OPTIONS 1
    • LIBPATH 1
    • LPDEST 1
    • MicroFocus COBOL compiler 1
    • ORA_TZFILE 1
    • ORACLE_BASE 1
    • ORACLE_HOME 1
    • ORACLE_PATH 1
    • ORACLE_SID 1 , 2
    • ORACLE_TRACE 1
    • ORAENV_ASK 1
    • PATH 1 , 2 , 3 , 4
    • PRINTER 1
    • SHLIB_PATH 1
    • SQLPATH 1
    • TMPDIR 1
    • TNS_ADMIN 1
    • TWO_TASK 1
    • USER 1
  • executables
    • precompiler 1
    • precompilers 1
    • relinking 1
  • Extended file system 1

F

  • files
    • dbhome 1
    • demo_procob.mk 1
    • glogin.sql 1
    • ins_precomp.mk 1
    • login.sql 1
    • Oracle Net Services configuration 1
    • ottcfg.cfg 1
    • pcbcfg.cfg 1
    • pccfor.cfg 1
    • pcscfg.cfg 1
    • pmscfg.cfg 1
    • privgroup 1 , 2
    • root.sh 1
  • file systems
    • ext2/ext3 1
    • GPFS 1
    • JFS 1
    • OCFS2 1
    • S5 1
    • UFS 1
    • VxFS 1
  • FORMAT precompiler
    • Pro*COBOL 1

G

  • getprivgrp command 1 , 2
  • glogin.sql file 1
  • GPFS
    • considerations for using 1

H

  • HOME environment variable 1
  • HP-UX dynamic processor reconfiguration 1
  • hugetlbfs
    • on SUSE 1

I

  • I/O buffers and SQL*Loader 1
  • I/O support
    • asynchronous 1
    • direct 1
  • implementing asynchronous input/output 1
  • Import utility 1
  • initialization parameters
    • ASM_DISKSTRING 1
    • CPU_COUNT 1
    • DB_BLOCK_SIZE 1
    • DB_CACHE_SIZE 1
    • JAVA_POOL_SIZE 1
    • LARGE_POOL_SIZE 1
    • LOG_BUFFERS 1
    • SHARED_POOL_SIZE 1
  • input/output
    • asynchronous 1 , 2
    • slaves 1
    • tuning 1
  • ins_precomp.mk file 1
  • installing
    • SQL*Plus command line Help 1
  • iostat command 1
  • IPC protocol 1
  • ireclen 1

J

  • JAVA_POOL_SIZE initialization parameters 1
  • JFS2 considerations 1
  • JFSconsiderations 1
  • Journaled file system 1 , 2

L

  • LANG environment variable 1
  • LANGUAGE environment variable 1
  • LARGE_POOL_SIZE initialization parameters 1
  • LD_LIBRARY_PATH environment variable 1 , 2 , 3
  • LD_OPTIONS environment variable 1
  • libclntst12.a 1
  • LIBPATH environment variable 1
  • libraries
    • client shared and static 1
  • lightweight timer implementation 1
  • Linux
    • resource management 1
  • Linux tools 1
  • listener
    • setting up for TCP/IP or TCP/IP with Secure Sockets Layer 1
  • LOG_BUFFERS initialization parameters 1
  • login.sql file 1
  • LPDEST environment variable 1
  • lsps command 1

M

  • make files
    • custom 1
    • demo_proc32.mk 1
    • demo_procob.mk 1
    • ins_precomp.mk 1
  • MAXDATAFILES parameter 1
  • MAXINSTANCES parameter 1
  • MAXLOGFILES parameter 1
  • MAXLOGHISTORY parameter 1
  • MAXLOGMEMBERS parameter 1
  • memory
    • contention 1
    • control paging 1
    • swap space 1
    • tuning 1
  • MicroFocus COBOL compiler 1
  • migrating 1
  • minor numbers of 8-bit 1
  • MLOCK privilege 1
  • Multi-CPU Binding (MCB) 1
  • multiple signal handlers 1
  • multithreaded applications 1

O

  • OCCI
    • user programs 1
  • OCI
    • user programs 1
  • operating system buffer cache, tuning 1
  • operating system commands
    • getprivgrp 1
    • running 1
    • setprivgrp 1
  • operating system tools
    • for AIX 1
    • iostat 1
    • lsps 1
    • sar 1
    • swap 1
    • swapinfo 1
    • swapon 1
    • vmstat 1
  • ORA_NLS10 environment variable 1
  • ORA_TZFILE environment variable 1
  • ORACLE_BASE environment variable 1
  • ORACLE_HOME environment variable 1
  • ORACLE_PATH environment variable 1
  • ORACLE_SID environment variable 1 , 2
  • ORACLE_TRACE environment variable 1
  • Oracle block size, adjusting 1
  • Oracle buffer manager 1
  • Oracle C++ Call Interface 1 , 2
  • Oracle Call Interface
    • demonstration programs 1
  • Oracle Cluster Services Synchronization Daemon
    • starting 1
    • stopping 1
  • Oracle Database
    • restarting 1
  • Oracle Database Client: 1
  • Oracle Database Configuration Assistant
    • configuring 1
  • Oracle Database environment variables
    • Oracle Database variables 1
  • Oracle Database process
    • stopping 1
  • Oracle Database tuning and large memory allocations 1
  • Oracle Database Upgrade Assistant 1
  • Oracle environment variables
    • ORA_NLS10 1
    • ORACLE_BASE 1
    • ORACLE_HOME 1
    • ORACLE_SID 1
  • Oracle JDBC/OCI
    • demonstration programs 1
  • Oracle Net Configuration Assistant
    • using 1
  • Oracle Net Services
    • configuration files 1
    • IPC protocol 1
    • protocols 1
    • protocol support 1
    • Secure Sockets Layer protocol 1
    • TCP/IP protocol 1
  • Oracle ODBC Driver 1
  • Oracle Protocol Support
    • IPC protocol 1
    • TCP/IP protocol 1
    • TCP/IP with Secure Sockets Layer protocol 1
  • Oracle Solaris
    • resource management 1 , 2
  • Oracle Solaris tools 1
  • ORAENV_ASK environment variable 1
  • oreclen 1
  • ottcfg.cfg file 1

P

  • page-out activity 1
  • paging
    • allocating sufficient 1
    • controlling 1
    • tuning 1
  • parameters
    • BUFFER 1
    • CREATE CONTROLFILE 1
    • CREATE DATABASE 1
    • DB_FILE_MULTIBLOCK_READ_COUNT 1
    • MAXDATAFILES 1
    • MAXLOGFILES 1
    • MAXLOGHISTORY 1
    • MAXLOGMEMBERS 1
    • SCHED_NOAGE 1
    • SGA_MAX_SIZE 1
    • shm_max 1
    • shm_seg 1
    • shmmax 1
    • shmseg 1
  • PATH environment variable 1 , 2 , 3 , 4
  • pcbcfg.cfg file 1
  • pccfor.cfg file 1
  • pcscfg.cfg file 1
  • Performance Tool Box Agent 1
  • PL/SQL demonstrations 1
  • PL/SQL kernel demonstrations 1
  • pmscfg.cfg file 1
  • postinstallation tasks
    • configuration assistants 1
  • precompiler executables
    • relinking 1
  • precompilers
    • executables 1
    • overview 1
    • Pro*C/C++ 1
    • Pro*COBOL 1
    • running demonstrations 1
    • signals 1
    • uppercase to lowercase conversion 1
    • value of ireclen and oreclen 1
    • vendor debugger programs 1
  • PRINTER environment variable 1
  • privgroup file 1 , 2
  • Pro*C/C++
    • demonstration programs 1
    • make files 1
    • signals 1
    • user programs 1
  • Pro*C/C++ precompiler 1
  • Pro*COBOL
    • demonstration programs 1
    • environment variables 1
    • FORMAT precompiler 1 , 2
    • naming differences 1
    • Oracle Runtime system 1
    • user programs 1
  • Pro*FORTRAN demonstration programs 1
  • PRODUCT_USER_PROFILE table 1
  • protocols 1

R

  • raw devices
    • buffer cache size 1
  • raw logical volumes 1
  • relinking executables 1
  • removing
    • SQL*Plus command line Help 1
  • resilvering, with Oracle Database 1
  • restarting
    • Automatic Storage Management 1
    • Oracle Database 1
  • restrictions, SQL*Plus
    • passwords 1
    • resizing windows 1
    • return codes 1
  • root.sh script 1

S

  • sar command 1 , 2
  • SCHED_NOAGE
    • enabling 1
    • scheduling policy 1
  • scripts
    • root.sh 1
  • setprivgrp command 1 , 2
  • SGA
    • determining the size of 1
  • SGA_MAX_SIZE parameter 1
  • SHARED_POOL_SIZE initialization parameters 1
  • shared memory segments 1
  • SHLIB_PATH environment variable 1
  • shm_max parameter 1
  • shm_seg parameter 1
  • shmmax parameter 1
  • shmseg parameter 1
  • shutdown
    • automating 1
  • SIGCLD signal 1
  • SIGCONT signal 1
  • SIGINT signal 1
  • SIGIO signal 1
  • signal handlers 1
  • signal routine
    • example 1
  • signals
    • SIGCLD 1
    • SIGCONT 1
    • SIGINT 1
    • SIGIO 1
    • SIGPIPE 1
    • SIGTERM 1
    • SIGURG 1
  • SIGPIPE signal 1
  • SIGTERM signal 1
  • SIGURG signal 1
  • SPOOL command
    • SQL*Plus 1
  • SQL*Loader 1
  • SQL*Loader demonstrations 1
  • SQL*Module for Ada
    • demonstration programs 1
    • user programs 1
  • SQL*Plus
    • command line Help 1
    • default editor 1
    • editor 1
    • interrupting 1
    • PRODUCT_USER_PROFILE table 1
    • restrictions 1
    • running operating system commands 1
    • site profile 1
    • SPOOL command 1
    • system editor 1
    • user profile 1
    • using command-line SQL*Plus 1
  • SQL*Plus, interrupting 1
  • SQL*Plus command line Help
    • installing 1
    • removing 1
  • SQLPATH environment variable 1
  • starting
    • Oracle Cluster Services Synchronization Daemon 1
  • startup
    • automating 1
  • static linking
    • Oracle libraries and precompilers 1
  • stopping
    • Oracle Cluster Services Synchronization Daemon 1
  • swap command 1
  • swapinfo command 1
  • swapon command 1
  • swap space
    • tuning 1
  • swap space allocation 1
  • symfind utility 1
  • SYSDATE 1
  • system editor
    • SQL*Plus 1
  • system time 1

T

  • tables
    • PRODUCT_USER_PROFILE 1
  • TCP/IP protocol 1
  • TCP/IP with Secure Sockets Layer protocol 1
  • thread support 1
  • TMPDIR environment variable 1
  • Transparent Hugepages
    • disable for Oracle Database servers 1
  • troubleshooting
    • I/O lags 1
    • ocssd.log threads blocked 1
  • tuning
    • disk input/output 1
    • input/output bottlenecks 1
    • large memory allocations 1
    • memory management 1
    • recommendations 1
  • tuning tools
    • iostat command 1
    • lsps command 1
    • Performance Tool Box Agent 1
    • Performance Tool Box Manager 1
    • sar command 1
    • swap command 1
    • swapinfo command 1
    • swapon command 1
    • vmstat command 1
  • TWO_TASK environment variable 1

U

  • undefined symbols 1
  • Unix file systems 1
  • UNIX System V file system 1
  • upgraded databases
    • upgrading 1
  • USER environment variable 1
  • user interrupt handler 1
  • user profile
    • SQL*Plus 1
  • user programs
    • for Pro*C/C++ 1
    • OCCI 1
    • OCI 1
    • Pro*C/C++ 1
    • Pro*COBOL 1
    • SQL*Module for Ada 1
  • using command-line SQL*Plus 1
  • utilities
    • adapters 1
    • Import 1
    • symfind 1

V

  • Veritas file system 1
  • virtual memory data pages
    • tuning Oracle Database 1
  • virtual memory page size, default 1
  • vmstat command 1

X

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