S

S locks

LOCK TABLE command, ADG 7-13

S number format element, SQL 2-41

S variable in SQLDA

how value is set, PC_ 15-10

purpose of, PC_ 15-10

SALES sample table, SQL 4-3

same-row writers block writers, SCN 221

Sample Application, ADQ 8-3, ADQ 12-4

Sample Application Using AQ, ADQ 8-1

SAMPLE BLOCK clause, STU 4-21

access path, STU 4-21

hints cannot override, STU 4-25

SAMPLE clause, STU 4-21

access path, STU 4-21

hints cannot override, STU 4-25

cost-based optimization, SCN 139, STU 4-19

of SELECT, SQL 7-574

of SELECT and subqueries, SQL 7-570

sample database table

DEPT table, PCO 2-28

EMP table, PCO 2-28

sample database tables

DEPT table, PC_ 2-17, PLS xiii

EMP table, PC_ 2-17, PLS xiii

SAMPLE function, GTK 3-24

Sample JMS Applications, ADQ 12-1

sample object type code, PC_ 17-24

sample programs, ADL 1-5, OCI B-1, PLS A-1

ansidyn1.pc, PC_ 14-29

ansidyn2.pc, PC_ 14-37

calldemo.sql, with sample9.pc, PC_ 7-23

calling a stored procedure, PCO 6-25

coldemo1.pc, PC_ 18-24

cppdemo1.pc, PC_ 12-6

cppdemo2.pc, PC_ 12-9

cppdemo3.pc, PC_ 12-13

cursor operations, PCO 5-19

cursor variable demos, PC_ 4-32

cursor variable use, PCO 6-36

cursor variables

PL/SQL source, PCO 6-36

cv_demo.pc, PC_ 4-33

cv_demo.sql, PC_ 4-32

datatype equivalencing, PCO 4-49

dynamic SQL Method 1, PCO 9-10

dynamic SQL method 2, PCO 9-15

dynamic SQL Method 3, PCO 9-21

dynamic SQL method 4, PCO 11-44

EXEC ORACLE scope, PCO 14-7

extp1.pc, PC_ 7-31

fetching in batches, PCO 7-10, PCO 7-22

how to precompile, PC_ 2-19

in demo directory, PCO cxxvi

LOB DESCRIBE example, PCO 13-27

lobdemo1.pc, PC_ 16-35

LOBDEMO1.PCO, PCO 13-29

navdemo1.pc, PC_ 17-24

oraca.pc, PC_ 9-42

PL/SQL examples, PCO 6-8

sample10.pc, PC_ 15-40

SAMPLE10.PCO, PCO 11-44

sample11.pc, PC_ 4-33

SAMPLE11.PCO, PCO 6-36

sample12.pc, PC_ 15-40

SAMPLE12.PCO, PCO 10-28

SAMPLE13.PCO, PCO 2-25

SAMPLE14.PCO, PCO 7-22

sample1.pc, PC_ 2-18

SAMPLE1.PCO, PCO 2-29

sample2.pc, PC_ 4-43

SAMPLE2.PCO, PCO 5-19

sample3.pc, PC_ 8-8

SAMPLE3.PCO, PCO 7-10

sample4.pc, PC_ 5-15

SAMPLE4.PCO, PCO 4-49

sample5.pc, PC_ 20-10

sample6.pc, PC_ 13-9

SAMPLE6.PCO, PCO 9-10

sample7.pc, PC_ 13-15

SAMPLE7.PCO, PCO 9-15

sample8.pc, PC_ 13-21

SAMPLE8.PCO, PCO 9-21

sample9.pc, PC_ 7-23

SAMPLE9.PCO, PCO 6-25

simple query, PCO 2-30

sqlvcp.pc, PC_ 4-22

tables of group items, PCO 7-22

WHENEVER...DO CALL example, PCO 8-18

sample scripts

RMAN, RMN 2-22

sample table scans, STU 4-21

hints cannot override, STU 4-25

SAP R/3 integration with LSM, LEG 1-7

sar UNIX command, DWG 18-75, STU 18-5

SASL. See Simple Authentication and Security Layer (SASL).

save set

changing the status, LEG 3-20

recover, LEG A-1

retention policy, LEG 2-9

status value

aborted, LEG 2-8

browsable, LEG 2-8

client index, LEG 2-9

in progress, LEG 2-8

recoverable, LEG 2-8

recyclable, LEG 2-8

scanned-in, LEG 2-8

suspect, LEG 2-8

viewing details of save sets on volume, LEG 3-21

SAVE_CONFIG command, NET A-9

SAVE_CONFIG_ON_STOP_listener_name parameter, NET C-56

savepoint, PCO 3-17

SAVEPOINT command, ADG 7-6

SAVEPOINT keyword

behavior in Oracle7 and Oracle8i, MIG 9-23

savepoint names

reusing, PLS 5-45

SAVEPOINT SQL statement, PC_ F-102

SAVEPOINT statement, PC_ F-102, PCO 3-17, PCO F-79, PLS 5-45, SCN 13, SQL 7-567

example, PCO 3-17

example of, PC_ 3-19

examples, PC_ F-102, PCO F-80

purpose of, PC_ 3-19

syntax, PLS 11-153

savepoints, SCN 1-54, SCN 37

creating, PC_ F-102, PCO F-79

definition of, PC_ 3-19

described, SCN 37

erasing, SQL 7-230

implicit, SCN 34

in-doubt transactions, DDS 5-13, DDS 5-15

maximum number of, ADG 7-6

overview of, SCN 1-54

rolling back to, ADG 7-6, SCN 38, SQL 7-565

specifying, SQL 7-567

uses for, PC_ 3-19

when erased, PC_ 3-20, PCO 3-19

SAXAttrList - oracle.xml.parser.v2.SAXAttrList, JPR 4-44

SAXParser() - oracle.xml.parser.v2.SAXParser.SAXParser(), JPR 4-51

sb1

definition, OCI 3-27

sb2

definition, OCI 3-27

sb4

definition, OCI 3-27

sbtio.log

and RMAN, RMN 9-3

sbttest program, RMN 1-23, RMN 2-22, RMN 9-10

scalability, PSC 1-3, STU 18-11

and partitioning, PSA 5-16

application, PSC 8-12

applications, PSC 8-10

batch jobs, SCN 195

client/server architecture, SCN 6-4

database, PSC 8-12

definition, PSC 8-3

enhancement for release 7.3, PSC A-13

four levels of, PSC 8-10

hardware, PSC 8-11

network, PSC 8-13

operating system, PSC 8-11

parallel DML, SCN 194

parallel SQL execution, SCN 158

potential, PSC 8-2

relative, PSC 8-7

serially reusable packages, ADG 9-70

shared memory system, PSC 8-11

with Cache Fusion, PSA 12-4

scalability, of Oracle Internet Directory, OID 1-4

Scalability, Queue Operation, ADQ 5-3

scalable operations, DWG 18-53

scalar datatypes, PLS 2-11

scalar types, PCO 11-18

Scale

using SQLPRC to extract, PC_ F-117, PCO 4-44

scale

definition of, PC_ 15-16, PC_ F-117, PCO 4-44

greater than precision, SQL 2-18

negative, SQL 2-18

of NUMBER datatype, SQL 2-17

partitions, PSC 1-2

specifying, PLS 2-14

using sqlprc() to extract, PC_ 15-16

when negative, PC_ 15-16, PC_ F-117, PCO 4-44

scanned-in save set, LEG 2-8

scanner command, LEG 5-6, LEG 5-12

scanner program, LEG A-1

Command Line Utilities Help, LEG 2-7

man page, LEG 2-7

using to recover save sets, LEG 2-7, LEG 2-9

using to recover volumes, LEG 2-7

scans, STU 4-21

cluster, STU 4-36, STU 4-38

indexed, STU 4-39

fast full index scan, STU 4-23

full table, STU 4-21, STU 4-46

LRU algorithm, SCN 7-4

multiblock reads, STU 4-26

parallel query, SCN 161

rule-based optimizer, STU 4-46

hash cluster, STU 4-36, STU 4-38

index, STU 4-22

bitmap, STU 4-24

bounded range, STU 4-41

cluster key, STU 4-39

composite, STU 4-39

MAX or MIN, STU 4-44

ORDER BY, STU 4-45

restrictions, STU 4-46

selectivity and, STU 4-25

single-column, STU 4-40

unbounded range, STU 4-42

index joins, STU 4-24

range, STU 4-23, STU 4-39, STU 4-40

bounded, STU 4-41

MAX or MIN, STU 4-44

ORDER BY, STU 4-45

unbounded, STU 4-42

sample table, STU 4-21

hints cannot override, STU 4-25

table scan and CACHE clause, SCN 7-4

unique, STU 4-22, STU 4-37, STU 4-39

SCC date format element, SQL 2-46

scenarios, Recovery Manager

backing up archived redo logs, RMN 5-20

cataloging operating system copies, RMN 5-27

deleting obsolete backups and copies, RMN 4-11

duplexing backup sets, RMN 5-23

handling backup errors, RMN 5-28

incremental backups, RMN 5-22

incremental cumulative backups, RMN 5-23

listing backups and copies, RMN 4-10

listing obsolete backups and copies, RMN 4-10

maintaining backups and copies, RMN 5-27

NOARCHIVELOG backups, RMN 5-25

OPS backups, RMN 5-26

parallelization of backups, RMN 5-24

recovering pre-resetlogs backup, RMN 6-42, RMN 6-43

recovery after total media failure, RMN 6-39

reporting database schema, RMN 4-13

reporting datafiles needing backups, RMN 4-10, RMN 5-16

reporting obsolete backups, RMN 4-11

reporting unrecoverable datafiles, RMN 4-11

restoring when databases share name, RMN 6-35

setting size of backup sets, RMN 5-18

Schedule a Queue Propagation, ADQ 9-65

scheduled links

continuous pushes, REP 7-11, REP 7-12

creating, RAR 2-13

guidelines, REP 7-10

parallel propagation, REP 7-12

periodic pushes, REP 7-10

serial propagation, REP 7-12

scheduled purges

guidelines, REP 7-11

periodic purges, REP 7-12

schedulePropagation(Session, String, Date, Double, String, Double) - oracle.jms.AQjmsDestination.schedulePropagation(javax.jms.Session, java.lang.String, java.util.Date, java.lang.Double, java.lang.String, java.lang.Double), JPR 2-70

Scheduling Propafation, ADQ 8-104

Scheduling Propagation, ADQ 12-96

Scheduling, Propagation, ADQ 1-15

schema, OID 2-10

adding and changing object classes (online), OID 6-2

administration, OID 6-1

using Oracle Directory Manager, OID 4-13

definition location, OID 5-17

definitions in subSchemaSubentry, OID 2-10

distributed among several tablespaces, OID 13-9

elements, OID F-1

add/replace event, OID 5-27

delete event, OID 5-27

for specific Oracle products, OID F-3

naming conventions, DCI 2-5

SCHEMA clause

of CREATE JAVA, SQL 7-313

schema extension, in NDS, NET 6-83

Schema Management pane, in Oracle Directory Manager, OID 6-10

schema names

qualifying column names, ADO 2-7

schema object privileges, SCN 305

DML and DDL operations, SCN 307

granting and revoking, SCN 306

overview of, SCN 1-40

views, SCN 308

schema objects, SCN 10-1, SQL 2-68

auditing, SCN 1-43, SCN 336

by access, SQL 7-222

by session, SQL 7-222

options, SQL 7-223

successful
SQL statements on, SQL 7-222

cascading effects on revoking, SAD 23-16

compatibility, MIG 9-10

creating

tablespace quota required, SCN 293

creating multiple objects, SAD 19-2

default audit options, SAD 24-10

default tablespace for, SAD 22-16, SCN 292

defining default buffer pool for, SQL 7-609

dependencies between, SAD 19-23

dependencies of, SCN 108

and distributed databases, SCN 118

and views, SCN 10-16

on non-existence of other objects, SCN 115

triggers manage, SCN 102

dependent on lost privileges, SCN 112

dimensions, SCN 10-20

disabling audit options, SAD 24-12

distributed database naming conventions for, DDS 1-22, SCN 392

domain index, SCN 10-47

dropping, SQL 7-509

enabling audit options on, SAD 24-10

global names, DDS 1-22, SCN 392

granting privileges, SAD 23-11

in a revoked tablespace, SAD 22-17, SCN 293

in other schemas, SQL 2-79

indextype, SCN 10-46

information in data dictionary, SCN 2-2

INVALID status, SCN 109

list of, SQL 2-68

listing by type, SAD 19-30

listing information, SAD 19-29

materialized views, SCN 10-18

name resolution, SQL 2-78

namespaces, SQL 2-73

naming

examples, SQL 2-75

guidelines, SQL 2-76

rules, SQL 2-72

object types, SQL 2-30

on remote databases, SQL 2-79

overview of, SCN 1-6, SCN 1-22, SCN 10-2

owned by dropped users, SAD 22-20

partitioned indexes, SQL 2-70

partitioned tables, SQL 2-70

parts of, SQL 2-70

privileges on, SCN 305

privileges to access, SAD 23-4

privileges to rename, SAD 19-3

privileges with, SAD 23-4

reauthorizing, SQL 6-2

recompiling, SQL 6-2

referring to, SQL 2-76, SQL 7-87

relationship to datafiles, SCN 3-17, SCN 10-2

remote, accessing, SQL 7-273

renaming, SAD 19-3

revoking privileges, SAD 23-14

stopping auditing of, SQL 7-552

trigger dependencies on, SCN 106

user-defined operator, SCN 10-48

user-defined types, SCN 13-3

SCHEMA_NAMES OTT parameter, OCI 14-28, PC_ 19-31

usage, OCI 14-33, PC_ 19-36

schema-independent users, ADG 11-19, ADG 11-20, SAD 22-12

schemaless users

SSL, OAS 17-13

schemas, DWG 16-2, SCN 280

associated with users, SCN 1-37, SCN 10-2

attributes, OCI 6-19

changes

updating recovery catalog, RMN 3-32

changing for a session, SQL 7-87

contents of, SCN 10-2

contrasted with tablespaces, SCN 10-2

creating, SQL 7-369

creating for snapshots, REP 3-32

default, ADG 11-44

defined, SCN 280

definition of, SQL 2-68

describing, OCI 6-2

design guidelines for materialized views, DWG 8-8

export privileges, SUT 1-4

objects in, SCN 10-2

OUTLN, SCN 129

snowflake, DWG 2-3

specifying for Export, SUT 1-25

star, DWG 2-3

star schemas, DWG 16-2, STU 4-62

third-normal form, DWG 16-2

unique, ADG 11-19

user-defined datatypes, ADO 3-2, SCN 13-14

user-defined types, ADO 1-2

schemes, iteration, PLS 3-10

scientific notation, PLS 2-8, SQL 2-42

scientific notation for FLOAT EXTERNAL, SUT 5-67

SCN, PSC 6-6

System Change Number, PSA 7-18

SCN (system change number), SBR 1-7

definition, SBR 1-10

use in control files, SBR 1-8

use in distributed recovery, SBR 6-18

SCN. See system change number.

SCN. See system change numbers

SCN, see system change number

scope, PLS 2-38

collection, PLS 4-8

cursor, PLS 5-7

cursor parameter, PLS 5-7

cursor variables, PCO 6-31

definition, PLS 2-38

exception, PLS 6-7

identifier, PLS 2-38

loop counter, PLS 3-13

of a cursor variable, PC_ 4-26

of DECLARE STATEMENT directive, PC_ F-40, PCO F-28

of precompiler options, PC_ 10-7, PCO 14-9

of the EXEC ORACLE statement, PC_ 10-10, PCO 14-7

of WHENEVER statement, PC_ 9-28

package, PLS 8-6

WHENEVER directive, PCO 8-20

SCOPE clause

of column ref constraints, SQL 7-242

scope constraints, SQL 7-242

SCOPE FOR constraint, ADO 9-30, ADO 9-32

scope, autonomous, ADG 7-32

scoped REFs, ADO 1-7, ADO 7-2, SCN 13-9

script files

running before Export, SUT 1-9, SUT 1-63

scripting, ADG 12-2

scripts

data dictionary, SRF 5-3

downgrading, MIG 13-54

errors while running, MIG 1-11

Java, SRF 5-7

migration, SRF 5-6, SRF 5-7

rerunning, MIG 4-33, MIG 5-21, MIG 7-22, MIG 13-55

SQL scripts, SRF 5-2

upgrading, MIG 7-20

scripts, batched line-mode commands, OID 6-17

scripts, Recovery Manager

CATRMAN.SQL, RMN 3-10

SCSI

as used in Oracle Parallel Server, PSC 2-6

SDFs. See secondary data files

.sdns.ora file, NET 4-24

sdns.ora file, NET 4-24

SDO, SMS 52-1

SDO_ADMIN package, SPR 1-15

SDO_GEOM package, SPR 1-15

SDO_MIGRATE package, SPR 1-15

SDO_TUNE package, SPR 1-15

SDU

see session data unit

SDU parameter, NET 8-9, NET C-40

search and compare operations, OID 2-6

search condition, PCO 5-11

definition of, PC_ 6-10

in the WHERE clause, PC_ 6-10

using in the WHERE clause, PCO 5-11

search criteria bar, in Oracle Directory Manager, OID 7-6

search depth, specifying, OID 7-6

search filters

IETF-compliant, OID A-4

ldapsearch, OID A-6

search results, specifying maximum number of entries, OID 7-5

SEARCH_COLUMNS column

PLAN_TABLE table, STU 5-5

searching

audit log entries, OID 5-26

duration, OID 7-6

entries, OID 7-2

base level, OID 7-6

one-level, OID 7-6

root of search, OID 7-4

search depth, OID 7-6

subtree level, OID 7-6

using ldapsearch, OID A-4

for attributes

using Oracle Directory Manager, OID 6-19

for audit log entries, OID 5-24

for entries

using command line tools, OID 7-25

for object classes, OID 6-5

for objects

using Oracle Directory Manager, OID 4-12

for objects, using Oracle Directory Manager, OID 4-12

making attributes available for, OID 6-30

specifying maximum number of entries, OID 7-5

using filters, OID 6-8

secondary data files (SDFs)

SQL*Loader DDL support, SUT 3-20

secondary indexes

dropping from index-organized tables, MIG 13-15

secondary memory

of object, OCI 13-16

secret key, OAS 8-5

location in RADIUS, OAS 4-17

secure

mode

running directory servers in, OID F-5

running server instances in, OID 8-2

port 636, OID 8-2

Secure Socket Layer. See SSL

Secure Sockets Layer, SAD 21-2, SAD 22-7, SAD 22-12

configuring, OID 4-4

enabling Oracle Directory Manager, OID 4-5

industry standard protocol, OAS 10-2

See SSL

Secure Sockets Layer (SSL) protocol, ADG 11-68

SecurID, OAS 4-6

authentication parameters, OAS B-5

creating users for authentication, OAS 7-8

enabling authentication, OAS 7-2

sample for sqlnet.ora file, OAS A-4

system requirements, OAS 1-13

token cards, OAS 4-5, OAS 4-6

troubleshooting, OAS 7-15

types of cards, OAS 7-10

using with Oracle client tools, OAS 7-10

SecurID authentication method

see Oracle Advanced Security

Security, ADQ 4-4

security, DDS 8-15, NET A-3, NET A-26, OID 2-20, REP A-8, SCN 1-40, SCN 280

accessing a database, SAD 21-2

administrator of, SAD 21-2

administrator privileges, SCN 5-3

application context, ADG 11-40

application developers and, SAD 21-9

application enforcement of, SCN 1-41

attribute level, OID 1-5

auditing, SCN 330, SCN 334

auditing policies, SAD 21-19

auditing user actions, SCN 1-43

authentication of users, SAD 21-2

between Oracle and non-Oracle clients and servers, OAS 10-6

BFILEs, ADL 11-8, ADL 11-9

BFILEs using SQL DDL, ADL 11-10

BFILEs using SQL DML, ADL 11-10

data, SAD 21-3, SCN 1-38

database security, SAD 21-2

database users and, SAD 21-2

definer rights, SCN 49, SCN 62

deleting audit data, SCN 2-5

described, SCN 1-37

discretionary access control, SCN 1-38, SCN 280

distributed databases, DDS 1-25

centralized user management, DDS 1-27

domains, SCN 1-39, SCN 280

dynamic predicates, SCN 326

enforcement in application, ADG 11-7

enforcement in database, ADG 11-7

enforcement mechanisms, SCN 1-38

entry level, OID 1-5

establishing policies, SAD 21-1

features of Oracle8i, ADG 11-4

fine-grained access control, ADG 11-35, SCN 325

for different clients, OID 8-3

for multimaster replication, RAR A-2

trusted vs. untrusted, RAR A-2

for snapshot replication, RAR A-7

trusted vs. untrusted, RAR A-8

general users, SAD 21-4

in LDAP Version 3, OID 1-3

invoker rights, SCN 49, SCN 62

level of, SAD 21-3

LSNRCTL utility, NET A-3

message queues, SCN 73

multi-byte characters

in role names, SAD 23-7

in role passwords, SAD 23-8

NAMESCTL utility, NET A-26

OLESQL driver, DDS 8-14

operating-system security and the database, SAD 21-3

passwords, SCN 285

policies

implementing, SCN 327

policies for database administrators, SAD 21-8

policy for applications, ADG 11-5, ADG 11-12

policy for biometrically identified users, OAS 8-3

privilege management policies, SAD 21-6

privileges, SAD 21-2

procedures enhance, SCN 310

program interface enforcement of, SCN 8-27

protecting the audit trail, SAD 24-16

protocol adapter includes, OAS 12-3

Recovery Manager, RMN 2-13

remote objects, DDS 2-28

REMOTE_OS_ROLES parameter, SAD 23-22

replication, RAR A-1

roles to force security, SAD 21-6

roles, advantages, ADG 11-8

security officer, SAD 1-3

security policies, SCN 325

SSL parameters for different clients, OID 8-3

system, SCN 1-38, SCN 2-3

table- or view-based, ADG 11-35

test databases, SAD 21-10

threats and countermeasures, ADG 11-2

trusted vs. untrusted, RAR A-2, RAR A-8

using synonyms, DDS 2-30

views and, SCN 10-14

views enhance, SCN 308

within Oracle Internet Directory environment, OID 2-20

security domains, SCN 1-39, SCN 280

enabled roles and, SCN 321

tablespace quotas, SCN 292

security enhancements, GTK 3-68 to GTK 3-77

application development, GTK 3-69

fine-grained access control, GTK 3-69

integrated security and directory services, GTK 3-72

multi-tier authentication and authorization, GTK 3-78

native authentication on Windows NT, GTK 3-77

security login, PSG 6-13

security policies

administering, ADG 11-38

applied within database, ADG 11-15

centrally managed, ADG 11-14

downgrading, MIG 13-45

establishing, ADG 11-1, ADG 11-5

example, ADG 11-39

fine-grained access control, MIG 13-45

implementing, ADG 11-47

multiple policies per table, ADG 11-37

on tables or views, ADG 11-36

technical issues, ADG 11-3

threats and countermeasures, ADG 11-2

Security with Queues, ADQ 4-4

segment attributes clause

of CREATE TABLE, SQL 7-383, SQL 7-393

segment header

processing during inserts, PSA 6-4

segments, SCN 1-7, SCN 4-18, STU 20-26

data, SCN 4-18

data dictionary, SAD 19-27

deallocating extents from, SCN 4-15

deallocating unused space, SAD 12-14

defined, SCN 4-3

displaying information on, SAD 19-32

header, PSA 9-14

header block, PSA 3-6, SCN 4-12

header contention, PSC 7-14

header, contention, PSC 7-14

ID number, PSA 3-4, PSA 3-6

index, SCN 4-19

monitoring rollback, SAD 11-14

name, PSA 3-6

overview of, SCN 1-7, SCN 4-18

rollback, SCN 4-21

rollback. See rollback segments.

rollback segment, PSC 7-6

size, PSA 3-6

table

high water mark, SCN 147

temporary, SCN 1-8, SCN 4-19, SCN 10-11

allocating, SCN 4-19

cleaned up by SMON, SCN 8-11

dropping, SCN 4-17

FILE keyword in SQL*Loader, SUT 8-28

ignore quotas, SCN 293

operations that require, SCN 4-19

parallel INSERT, SCN 153

storage parameters, SAD 12-13

tablespace containing, SCN 4-17, SCN 4-20

SELDFCLP variable (SQLDA), PCO 11-14

SELDFCRCP variable (SQLDA), PCO 11-14

SELDFMT variable (SQLDA), PCO 11-9

SELDH-CUR-VNAMEL variable (SQLDA), PCO 11-13

SELDH-MAX-VNAMEL variable (SQLDA), PCO 11-12

SELDH-VNAME variable (SQLDA), PCO 11-12

SELDI variable (SQLDA), PCO 11-11

SELDI-CUR-VNAMEL variable (SQLDA), PCO 11-13

SELDI-MAX-VNAMEL variable (SQLDA), PCO 11-13

SELDI-VNAME variable (SQLDA), PCO 11-13

SELDV variable (SQLDA), PCO 11-8

SELDVLN variable (SQLDA), PCO 11-9

SELDVTYP variable (SQLDA), PCO 11-11

SELECT

block access during, PSA 6-9

object privilege, SQL 7-535

statement, SQL 7-569

Select All Propagation Schedules, ADQ 10-12

Select All Queue Tables in Database, ADQ 10-4

Select All Queues in Database, ADQ 10-10

SELECT ANY SEQUENCE system privilege, SQL 7-525

SELECT ANY TABLE system privilege, SQL 7-527

SELECT command

read consistency, ADG 7-11

SELECT ... FOR UPDATE, ADG 7-18

select descriptor, PC_ 13-26, PC_ 15-4, PCO 11-4

definition of, PC_ 13-26

information in, PC_ 13-26

select descriptors

information in, PCO 9-26

Select Instances to Start dialog box, PSG 7-8

Select Instances to Stop dialog box, PSG 7-11

SELECT INTO statement

syntax, PLS 11-154

select list, PCO 5-8

definition of, PC_ 6-8

number of items in, PC_ 6-8

using the free() function for, PC_ 15-37

using the malloc() function for, PC_ 15-32

select lists, SQL 5-19

ordering, SQL 5-21

Select Messages in Queue Table, ADQ 10-21

SELECT privilege, ADG 11-22

SELECT privilege for object tables, ADO 2-12, ADO 2-13

Select Propagation Schedules in User Schema, ADQ 10-30

Select Queue Subscribers, ADQ 10-35

Select Queue Subscribers and Their Rules, ADQ 10-37

Select Queue Tables in User Schema, ADQ 10-25

Select Queues for Which User Has Any Privilege, ADQ 10-17

Select Queues for Which User Has Queue Privilege, ADQ 10-19

Select Queues In User Schema, ADQ 10-28

SELECT SQL statement, PC_ F-103

select SQLDA

purpose of, PC_ 15-3, PCO 11-3

SELECT statement, PC_ 6-7, PCO F-80, SCN 12, SQL 5-19

accessing non-Oracle system, DDS C-2

available clauses, PCO 5-9

clauses available for, PC_ 6-8

composite indexes, SCN 10-24

embedded SQL examples, PC_ F-106, PCO F-83

example, PCO 5-8

example of, PC_ 6-7

FOR UPDATE, ADL 2-7

FOR UPDATE clause, DDS 2-33

INTO clause, PCO 5-8

INTO clause in, PC_ 6-8

purpose of, PC_ 6-7

read consistency, ADL 5-2

SAMPLE clause, STU 4-21

access path, STU 4-21, STU 4-25

cost-based optimization, SCN 139, STU 4-19

subqueries, SCN 21

testing, PC_ 6-8

using host arrays in, PC_ 8-5

using host tables, PCO 7-6

WHERE clause in, PC_ 6-8

See also queries

Select the Number of Messages in Different States for Specific Instances, ADQ 10-41

Select the Number of Messages in Different States for the Whole Database, ADQ 10-39

Select User Queue Tables, ADQ 10-7

SELECT_CATALOG_ROLE role, SQL 7-530

SELECT_CATALOG_ROLE roll, SAD 23-3

SELECT_ERROR

precompiler option, PC_ 6-8, PC_ 10-38

SELECT_ERROR option, PCO 5-9

SELECT_ERROR precompiler option, PCO 14-37

selected audit log events, OID 5-28

selecting

an entry's superclass, OID 7-14

attribute syntax type, OID 6-32

selecting a permanent LOB INTO a temporary LOB locator, ADL 10-9

selecting root of search, OID 7-5

selectivity of predicates, SCN 131, STU 8-2

histograms, SCN 131, SCN 133, STU 8-17

user-defined selectivity, SCN 141, STU 4-33

selectivity of queries, STU 4-25

selectivity, index, STU 12-4

select-list

describing, OCI 4-11

select-list items

naming, PCO 11-4

selectNodes(String, NSResolver) - oracle.xml.parser.v2.XMLNode.selectNodes(java.lang.String, oracle.xml.parser.v2.NSResolver), JPR 4-114

selector, PLS 5-21

select-project-join views, STU 4-76

selectSingleNode(String, NSResolver) - oracle.xml.parser.v2.XMLNode.selectSingleNode(java.lang.String, oracle.xml.parser.v2.NSResolver), JPR 4-114

self joins, SQL 5-23

SELF parameter, DCI 5-4, DCI 5-5, PLS 9-9

selfish style of method invocation, ADO 1-4, SCN 13-6

semantic checking, PCO E-2

controlling with the SQLCHECK option, PC_ D-2

definition of, PC_ D-2

enabling, PC_ D-4, PCO E-3

using the SQLCHECK option, PCO E-2

with the SQLCHECK option, PC_ D-2

semantics

assignment, PLS B-2

blank-padding, PLS B-3

CHAR versus VARCHAR2, PLS B-1

copy-based for internal LOBs, ADL 9-27

non-blank-padding, PLS B-3

pseudo-reference, ADL 10-10

reference based for BFILEs, ADL 11-7

string comparison, PLS B-2

value, ADL 10-10

semi-joins, STU 4-61

send command (RMAN), RMN 2-22, RMN 10-136

send(Message) - oracle.jms.AQjmsProducer.send(javax.jms.Message), JPR 2-141

send(Message, int, int, long) - oracle.jms.AQjmsProducer.send(javax.jms.Message, int, int, long), JPR 2-141

send(Queue, Message) - oracle.jms.AQjmsProducer.send(javax.jms.Queue, javax.jms.Message), JPR 2-142

send(Queue, Message, int, int, long) - oracle.jms.AQjmsProducer.send(javax.jms.Queue, javax.jms.Message, int, int, long), JPR 2-142

separate precompilation

guidelines, PCO 2-26

guidelines for, PC_ 2-16

referencing cursors for, PC_ 2-16

restrictions, PCO 2-27

restrictions on, PC_ 2-16

specifying MAXOPENCURSORS for, PC_ 2-16

using a single SQLCA with, PC_ 2-17

separators, PLS 2-3

SEQ synonym for USER_SEQUENCES, SRF 2-162

sequence, PLS 5-3

data dictionary cache, PSC 8-13, PSC 8-14

not cached, PSC 8-15, PSC B-3

timestamp, PSC 8-14

sequence cache, STU 2-12

sequence generators

external, PSA 6-14

SEQUENCE keyword

SQL*Loader, SUT 5-56

sequence number cache size, PSA 6-13

sequence number generator

and block contention, PSA 5-5

application scalability, PSC 8-12

distributed locks, PSC 8-13

LM locks, PSC 8-13

on parallel server, PSC 8-13

restriction, PSC 8-15, PSC B-3

skipping sequence numbers, PSC 8-14

sequence numbers

cached, SUT 1-57

exporting, SUT 1-57

for multiple tables and SQL*Loader, SUT 5-57

generated by SEQUENCE clause, SUT 4-11

generated by SQL*Loader SEQUENCE clause, SUT 5-56

generated, not read and SQL*Loader, SUT 5-47

setting column to a unique number with SQL*Loader, SUT 5-56

using, PSA 6-13

SEQUENCE_CACHE_ENTRIES initialization parameter: obsolete

SEQUENCE_CACHE_ENTRIES parameter, ADG 2-33

obsolete for 8.1, PSC A-6

SEQUENCE_CACHE_HASH_BUCKETS initialization parameter: obsolete

sequence_deviation, ADQ 2-6

sequences, SCN 1-24, SCN 10-21, SQL 2-56, SQL 7-372, SUT 2-46

accessing, ADG 2-30

accessing values of, SQL 7-372

altering, ADG 2-30, SAD 18-13

attributes, OCI 6-14

auditing, SCN 336

caching numbers, ADG 2-29

caching sequence numbers, ADG 2-33

changing

the increment value, SQL 7-81

the number of cached values, SQL 7-81

CHECK constraints prohibit, SCN 271

creating, ADG 2-29, ADG 2-34, SAD 18-12, SQL 7-371

creating without limit, SQL 7-373

CURRVAL, ADG 2-30, ADG 2-32

describing, OCI 6-2

dropping, ADG 2-34, SAD 18-13

exporting, SUT 1-57

global conflict detection for, PSA 6-14

granting

system privileges on, SQL 7-525

how to use, SQL 2-57

incrementing, SQL 7-371, SQL 7-373

independence from tables, SCN 10-21

initialization parameters, ADG 2-29

length of numbers, SCN 10-21

log sequence number, PSA 13-6, PSA 13-7

managing, SAD 18-12

maximum value

setting or changing, SQL 7-81

minimum value

setting or changing, SQL 7-81

NEXTVAL, ADG 2-31

number generation, SCN 10-21

ordering values, SQL 7-81

parallel server, ADG 2-30

Parallel Server and, SAD 18-13

privileges for altering, SAD 18-12

privileges for creating, SAD 18-12

privileges for dropping, SAD 18-13

privileges needed, ADG 2-30 to ADG 2-35

recycling values, SQL 7-81

reducing serialization, ADG 2-31

removing from the database, SQL 7-497

renaming, SQL 7-554

replication, REP 2-18

restarting, SQL 7-497

at a different number, SQL 7-82

at a predefined limit, SQL 7-373

reusing, SQL 7-372

stopping at a predefined limit, SQL 7-373

synonyms for, SQL 7-377

where to use, SQL 2-57

sequential control, PLS 3-15

sequential reads, STU 20-5

sequential writes, STU 20-5

SERIAL_REUSE initialization parameter, SRF 1-107

SERIALIZABLE option

for ISOLATION LEVEL, ADG 7-25

SERIALIZABLE parameter, ADG 7-11, PSA 1-8

serializable transactions, ADG 7-22, STU 17-6

SERIALIZABLE=TRUE, GTK 7-2

serialization

of transactions, REP 6-3

serially reusable packages, PLS 5-65

serially reusable PL/SQL packages, ADG 9-70

SERIALLY_REUSABLE pragma, ADG 9-71, PLS 5-65

syntax, PLS 11-159

server

integration with PL/SQL, PC_ 7-2

server backup

automatic bootstrap backup, LEG 4-8

bootstrap backup, LEG 4-7

maintaining bootstrap information, LEG 4-11

manual bootstrap backup, LEG 4-11

server configuration

allocating resources with multi-threaded server, NET 9-9

connection concentration, NET 8-29

discovering Oracle Names servers, NET 6-60

external procedures, NET 8-48

local naming, NET 6-6

log files, NET 12-20

multi-threaded server, NET 9-4

prespawned dedicated server, NET 7-16

region database for Oracle Names, NET 6-50

trace files, NET 12-35

server connections

methods of, NET 11-11

syntax, NET 11-10

server destroyed, LEG 5-3

server handle

attributes, OCI A-9

description, OCI 2-9

setting in service context, OCI 2-10

server index directory

contents, UNIX, LEG 5-12

contents, Windows NT, LEG 5-20

server indexes and configuration files

damaged, LEG 5-3

recovering for UNIX, LEG 5-11

server instances

running, OID 4-2

running in secure mode, OID 8-2

Server Manager, GTK 7-7

differences with SQL*Plus

ampersands, MIG 11-15

blank lines, MIG 11-12

commands, MIG 11-3

comments, MIG 11-9

COMMIT command, MIG 11-17

CREATE LIBRARY command, MIG 11-16

CREATE TYPE command, MIG 11-16

hyphen continuation character, MIG 11-13

startup, MIG 11-2

syntax, MIG 11-9

migrating scripts to SQL*Plus, MIG 11-1

PL/SQL, SCN 26, SCN 27

SQL statements, SCN 10

server operation time limit, OID 5-17

Server Pages, PL/SQL, PLS 7-45

SERVER parameter, NET 2-9, NET B-3, NET C-46

net service name, DDS 2-16

server processes, SCN 1-16, SCN 8-5

archiver (ARCn), SAD 4-12

background, SAD 4-11 to SAD 4-13

checkpoint (CKPT), SAD 4-12

database writer (DBWn), SAD 4-11, SAD 10-13

dedicated, SAD 4-2

dispatcher (Dnnn), SAD 4-13

dispatchers, SAD 4-6 to SAD 4-10

job queue processes (SNPn), SAD 8-2

job queue processes, SAD 4-13

listener process and, SCN 6-6

lock process (LCK0), SAD 4-13

log writer (LGWR), SAD 4-11

monitoring, SAD 4-14

monitoring locks, SAD 4-15

multi-threaded, SAD 4-3 to SAD 4-10

number, SRF 1-48, SRF 1-49, SRF 1-72, SRF 1-73, SRF 1-99

number of, OID F-5

parallel query, SAD 4-17

process monitor (PMON), SAD 4-12

queue monitor (QMNn), SAD 4-13

recoverer (RECO), SAD 4-12

shared, SAD 4-2

SHUTDOWN, MIG 9-23

system monitor (SMON), SAD 4-12

too many, OID 13-5

trace files for, SAD 4-15

server resource

administrator, LEG 2-27

name, LEG 2-26

parallelism, LEG 2-26

server resource type, LEG 2-5

server roundtrips

cache functions, OCI C-4

datatype mapping and manipulation functions, OCI C-6

describe operation, OCI C-6

LOB functions, OCI C-3

object functions, OCI C-4

relational functions, OCI C-2, OCI C-7

server testing, NET 11-15

server troubleshooting, NET 12-3

server_error event attribute, ADG 14-4

SERVER_PRINCIPALparameter

DCE parameter, OAS 14-17

SERVERERROR event

triggers on, SQL 7-431

servers, SCN 1-32

client/server architecture, SCN 6-2

communicating with clients on Windows NT, LEG B-7

configuring, using input files, OID 7-25

connecting to, OID 4-4

dedicated, SCN 1-16, SCN 8-23

multi-threaded contrasted with, NET 9-2, SCN 8-16

dedicated server architecture, SCN 8-3

defined, SCN 1-33

directory, OID 1-4

connecting to, OID 4-3

disconnections, NET 2-6

in stack communications, NET 3-9

loopback tests, NET 12-4

multi-threaded, SCN 1-16

architecture, SCN 8-3, SCN 8-16

dedicated contrasted with, NET 9-2, SCN 8-16

processes of, SCN 8-14, SCN 8-15, SCN 8-16, SCN 8-20

parameters, configuring, OID 4-17

processes, OID 2-32

multiple, OID 2-32

processes of, SCN 1-16

replication, OID 1-4

role in two-phase commit, DDS 4-6

server-to-server interaction, described, NET 3-9

shared, SCN 1-16

starting databases, NET 11-8

suppliers, OID 2-15

server-side failover, PSC 9-12

server-side scripts, SCN 29

SERVICE (SER or SERV) attribute, NET 9-6

service context handle

attributes, OCI A-7

description, OCI 2-9

elements of, OCI 2-9

service discovery

db_name.conf file, PSG C-3

errors, PSG C-2

listener.ora file, PSG C-4

nmiconf.log file, PSG C-7

nmiconf.lst file, PSG C-7

on UNIX, PSG C-3

on Windows NT, PSG 3-11, PSG 3-34, PSG C-3

performing, PSG 6-15

PM\db_name registry key, PSG 3-11, PSG 3-34, PSG C-3

See auto-discovery

services.ora file, PSG C-6

SID_LIST_listener_name parameter, PSG C-4

tnsnames.ora file, PSG C-5

troubleshooting, PSG C-7

understanding, PSG C-2

service interfaces, DCI 1-14

service name

and address storage, in NDS, NET 6-84

character set keyword values, NET C-5

described, NET 6-2

of remote database, SQL 7-275

service names, SCN 6-6

database links and, DDS 2-13

specifying in database links, DDS 7-4

service naming

Net8, MIG 9-47

service naming, Net8, GTK 3-75

SERVICE option

LOG_ARCHIVE_DEST_n initialization parameter, SBY 5-8

SERVICE parameter, OAS B-2, NET B-4

service registration, NET xviii

benefits, NET 2-23

configuration, NET 2-23

connection load balancing, NET 2-24, NET 2-26

connect-time failover, NET 2-23

described, NET 2-22

events in listener.log, NET 12-26

SERVICE_DIED event, NET 12-26

SERVICE_REGISTER event, NET 12-26

SERVICE_UPDATE event, NET 12-26

service routine, ADG 10-35, DCI 4-12

examples, ADG 10-35, DCI 4-12

service time, STU 1-2, STU 1-3

SERVICE_DIED event, NET 12-26

SERVICE_NAME parameter, MIG F-6, NET 6-3, NET C-47, NET C-88

SERVICE_NAME parameter in tnsnames.ora file, PSG 3-18

SERVICE_NAMES initialization parameter, MIG F-12, MIG F-15, SRF 1-107

SERVICE_NAMES parameter, NET 2-32, NET 6-3, NET 9-6, PSA 1-8, SCN 6-6

SERVICE_NAMES parameter in initdb_name.ora file, PSG 4-9

SERVICE_REGISTER event, NET 12-26

SERVICE_UPDATE event, NET 12-26

services, LEG B-10, NET 1-5

connecting, NET 1-5

described, NET 1-5

extensibility, DCI 1-6

OracleHOME_NAMEAgent, PSG 6-10

OracleHOME_NAMEDataGatherer, PSG 6-27

OracleHOME_NAMEManagementServer, PSG 6-11

OraclePGMSService, PSG 3-21

service names, NET 6-2

SERVICES command, NET 2-9, NET 2-14, NET A-9

services.ora file, PSG C-6, PSG C-7

session, PCO 3-12, PLS 5-41

definition of, PC_ 3-15

migration, OCI 8-12, OCI 15-106

session control statements, SCN 1-52, SCN 14, SQL 6-5

PL/SQL support of, SQL 6-5

session data unit

adjusting to improve network performance, NET 5-8

configuring, NET 8-9

Session Data Unit (SDU), STU 22-16

Session Data Unit (SDU) Size field in Net8 Assistant, NET 8-9

Session is closed - error, ADQ D-6

session layer

described, NET 3-4

session limits, license

setting initially, SAD 2-23

session locks

releasing, SQL 7-107

session management, OCI 8-12, OCI 8-14

session memory statistic, STU 19-24

Session object is invalid - error, ADQ D-14

session primitives, ADG 11-42

session trees

distributed transactions, DDS 4-4, DDS 4-5

clients, DDS 4-6

commit point site, DDS 4-7, DDS 4-9

database servers, DDS 4-6

global coordinators, DDS 4-7

local coordinators, DDS 4-6

tracing, DDS 5-9

SESSION_CACHED_CURSORS initialization parameter, SRF 1-108

SESSION_CACHED_CURSORS parameter, STU 19-20

of ALTER SESSION, SQL 7-94

SESSION_CONTEXT view, SRF 2-162

SESSION_MAX_OPEN_FILES initialization parameter, SRF 1-108

SESSION_MAX_OPEN_FILES parameter, ADL 4-2, ADL 11-56, ADL 11-70

SESSION_PRIVS view, SRF 2-162

SESSION_ROLES view, SQL 7-600, SRF 2-162

queried from PL/SQL block, SCN 323

SESSION_USER attribute, USERENV, ADG 11-43

SESSIONS, OID 13-11

sessions

auditing by, SCN 338

auditing connections and disconnections, SAD 24-8

beginning, PC_ F-26, PCO F-17

calculating resource cost limits, SQL 7-73

changing resource cost limits, SQL 7-73

connections contrasted with, SCN 8-4

defined, SCN 8-4, SCN 338

disconnecting, SQL 7-106

enabling PARALLEL DML, SCN 195

global name resolution for, SQL 7-88

granting

system privileges on, SQL 7-525

lightweight, SCN 287

limit on concurrent, SCN 1-42

by license, SCN 299

limiting resource costs, SQL 7-73

limits per instance, SAD 22-3

limits per user, SCN 297

listing privilege domain of, SAD 23-24

memory allocation in the large pool, SCN 7-12

modifying characteristics of, SQL 7-86

multiple, PSA 4-5, PSA 4-6

number of concurrent, SQL 7-111

number of concurrent sessions, SAD 2-23

object cache, SQL 7-91

package state and, ADG 9-17, SCN 112

Parallel Server session limits, SAD 2-24

resource limits and, SCN 295

restricted, SQL 7-106

setting advice for transactions, DDS 5-13

setting maximum for instance, SAD 22-4

setting warning limit for instance, SAD 22-4

stack space in PGA, SCN 7-15

terminating, SAD 4-20 to SAD 4-23, SQL 7-107

time limits on, SCN 297

transaction isolation level, SCN 242

viewing current number and high water mark, SAD 22-6

viewing memory use, SAD 22-29

waiting for PCM lock conversion, PSA 9-12

when auditing options take effect, SCN 333

where information is stored, SCN 7-15

SESSIONS (SES or SESS) attribute, NET 9-7

SESSIONS initialization parameter, SRF 1-109

SESSIONS parameter

ensuring LM lock capacity, PSA 10-3

sessions parameter, OID 13-10

sessions, user

active, SAD 4-22

inactive, SAD 4-22

marked to be terminated, SAD 4-22

terminating, SAD 4-20

viewing terminated sessions, SAD 4-22

SESSIONS_PER_USER parameter

of ALTER PROFILE, SQL 7-69

of CREATE PROFILE, SQL 7-361

session-specific user identity, OID 2-21

session-specific variables, PLS 8-11

set archivelog destination command (RMAN), RMN 6-14

SET AUTHENTICATION_LEVEL command, NET A-84

SET CACHE_CHECKPOINT_INTERVAL command, NET A-50

SET clause, PCO 5-11

in UPDATE statements, PC_ 6-10

of ALTER SESSION, SQL 7-86

of ALTER SYSTEM, SQL 7-108

of UPDATE, SQL 7-619

purpose of, PC_ 6-10

use of subqueries in, PC_ 6-10

using a subquery, PCO 5-11

SET command

of CMCTL, NET A-83

of LSNRCTL, NET A-11

of NAMESCTL, NET A-49

set command (RMAN), RMN 10-138

autolocate option

using in OPS configuration, RMN 6-17

duplex parameter, RMN 5-24

executed within run, RMN 10-142

maxcorrupt for datafile option, RMN 5-28

newname parameter, RMN 1-65, RMN 6-10

SET COMPATIBILITY command

SQL*Plus scripts, MIG 10-11

SET CONNECT_TIMEOUT command, NET A-12

SET CONSTRAINT(S) statement, SQL 7-598

SET CONSTRAINTS statement

DEFERRABLE or IMMEDIATE, SCN 275

SET CURRENT_LISTENER command, NET A-12

SET DATABASE clause

of CREATE CONTROLFILE, SQL 7-264

SET DEFAULT_DOMAIN command, NET A-51

SET DESCRIPTOR statement, PC_ 14-18, PC_ F-106, PCO F-83

SET DISPLAYMODE command

of CMCTL, NET A-85

of LSNRCTL, NET A-13

SET FORWARDING_AVAILABLE command, NET A-51

SET INSTANCE command, PSA 1-5, PSA 4-4

example of, PSA 1-5

instance startup, PSA 1-5, PSA 4-4

SET LOG_DIRECTORY command, NET A-13

SET LOG_FILE command, NET A-14

SET LOG_FILE_NAME command, NET A-52

SET LOG_LEVEL command, NET A-85

SET LOG_STATS_INTERVAL command, NET A-53

SET LOG_STATUS command, NET A-14

SET NAMESCTL_TRACE_LEVEL command, NET A-54

set newname command (RMAN)

during database restore, RMN 6-3

set operators, PLS 5-6, SQL 3-12, SQL 7-579

SET PASSWORD command

of LSNRCTL, NET 11-7, NET A-15

of NAMESCTL, NET A-55

SET RELAY_STATISTICS command, NET A-86

SET REQUESTS_ENABLED command, NET A-56

SET RESET_STATS_INTERVAL command, NET A-56

SET ROLE statement, SCN 14, SQL 7-600

ALL EXCEPT option, ADG 11-26

ALL option, ADG 11-26

associating privileges with role, ADG 11-9

at startup, ADG 11-16

disabling, ADG 11-17

enabling roles, ADG 11-25

equivalent to SET_ROLE, ADG 11-10

how password is set, SAD 23-8

operating system roles, ADG 11-27

protecting role use, ADG 11-23

role passwords, ADG 11-18

used to enable/disable roles, SAD 23-17

when using operating-system roles, SAD 23-21

SET SAVE_CONFIG_INTERVAL command, NET A-57

SET SAVE_CONFIG_ON_STOP command, NET A-15

of LSNRCTL, NET A-15

of NAMESCTL, NET A-58

SET SERVER command, NET A-59

SET STARTUP_WAITTIME command, NET A-16

SET statement

AUTORECOVERY option, SBR 5-11

LOGSOURCE variable, SBR 5-6, SBR 5-10

SET STATEMENT_ID clause

of EXPLAIN PLAN, SQL 7-513

Create a Queue Table, ADQ 9-13

SET TRACE_FILE_NAME command, NET A-60

SET TRACE_LEVEL command, NET A-60

SET TRANSACTION command, ADG 7-8

ISOLATION LEVEL clause, ADG 7-25

SERIALIZABLE, ADG 7-25

SET TRANSACTION statement, PLS 5-47, SCN 13, SQL 7-602, STU 20-30

example, PCO 3-20

example of, PC_ 3-23

ISOLATION LEVEL, SCN 218, SCN 242

purpose of, PC_ 3-23

READ ONLY clause, SCN 4-22

READ ONLY parameter, PCO 3-20

READ ONLY parameter in, PC_ 3-23

requirements for, PC_ 3-23

restrictions, PCO 3-20

restrictions on, PC_ 3-23

syntax, PLS 11-161

USE ROLLBACK SEGMENT option, SAD 11-12

SET TRC_DIRECTORY command, NET A-17

SET TRC_FILE command, NET A-17

SET TRC_LEVEL command, NET A-18

SET UNTIL command, PSA 14-10

SET UNUSED clause

of ALTER TABLE, SQL 7-147

SET UNUSED clause for columns, SCN 10-7

Set Up Server dialog box, LEG B-8

SET USE_PLUGANDPLAY command, NET A-18

SET_CONTEXT procedure, ADG 11-52

set_disabled, SPR 11-21, RAR 8-36

SET_ROLE procedure, ADG 11-10

SET_SESSION_LONGOPS procedure

syntax change, MIG 9-33

setAddress(String) - oracle.jms.AQjmsAgent.setAddress(java.lang.String), JPR 2-26

setAdtPayload(CustomDatum) - oracle.jms.AdtMessage.setAdtPayload(oracle.sql.CustomDatum), JPR 2-6

setAdtPayload(CustomDatum) - oracle.jms.AQjmsAdtMessage.setAdtPayload(oracle.sql.CustomDatum), JPR 2-17

setAncops(ODCIObjectList) - oracle.ODCI.ODCIQueryInfo.setAncops(oracle.ODCI.ODCIObjectList), JPR 3-53

setArgtype(BigDecimal) - oracle.ODCI.ODCIArgDesc.setArgtype(java.math.BigDecimal), JPR 3-5

setArray(ODCIArgDesc[]) - oracle.ODCI.ODCIArgDescList.setArray(oracle.ODCI.ODCIArgDesc[]), JPR 3-8

setArray(ODCIArgDesc[], long) - oracle.ODCI.ODCIArgDescList.setArray(oracle.ODCI.ODCIArgDesc[], long), JPR 3-8

setArray(ODCIColInfo[]) - oracle.ODCI.ODCIColInfoList.setArray(oracle.ODCI.ODCIColInfo[]), JPR 3-16

setArray(ODCIColInfo[], long) - oracle.ODCI.ODCIColInfoList.setArray(oracle.ODCI.ODCIColInfo[], long), JPR 3-16

setArray(ODCIObject[]) - oracle.ODCI.ODCIObjectList.setArray(oracle.ODCI.ODCIObject[]), JPR 3-44

setArray(ODCIObject[], long) - oracle.ODCI.ODCIObjectList.setArray(oracle.ODCI.ODCIObject[], long), JPR 3-44

setArray(String[]) - oracle.ODCI.ODCIRidList.setArray(java.lang.String[]), JPR 3-59

setArray(String[], long) - oracle.ODCI.ODCIRidList.setArray(java.lang.String[], long), JPR 3-59

setAttribute(String, String) - oracle.xml.parser.v2.XMLElement.setAttribute(java.lang.String, java.lang.String), JPR 4-100

setAttributeNode(Attr) - oracle.xml.parser.v2.XMLElement.setAttributeNode(org.w3c.dom.Attr), JPR 4-100

setBaseURL(URL) - oracle.xml.parser.v2.XMLParser.setBaseURL(java.net.URL), JPR 4-125

setBoolean(String, boolean) - oracle.jms.AQjmsMapMessage.setBoolean(java.lang.String, boolean), JPR 2-93

setBooleanProperty(String, boolean) - oracle.jms.AQjmsAdtMessage.setBooleanProperty(java.lang.String, boolean), JPR 2-17

setBooleanProperty(String, boolean) - oracle.jms.AQjmsMessage.setBooleanProperty(java.lang.String, boolean), JPR 2-113

setByte(String, byte) - oracle.jms.AQjmsMapMessage.setByte(java.lang.String, byte), JPR 2-94

setByteProperty(String, byte) - oracle.jms.AQjmsAdtMessage.setByteProperty(java.lang.String, byte), JPR 2-18

setByteProperty(String, byte) - oracle.jms.AQjmsMessage.setByteProperty(java.lang.String, byte), JPR 2-114

setBytes(String, byte[]) - oracle.jms.AQjmsMapMessage.setBytes(java.lang.String, byte[]), JPR 2-94

setBytes(String, byte[], int, int) - oracle.jms.AQjmsMapMessage.setBytes(java.lang.String, byte[], int, int), JPR 2-95

setChar(String, char) - oracle.jms.AQjmsMapMessage.setChar(java.lang.String, char), JPR 2-95

setClientID(String) - oracle.jms.AQjmsConnection.setClientID(java.lang.String), JPR 2-46

setColname(String) - oracle.ODCI.ODCIArgDesc.setColname(java.lang.String), JPR 3-5

setColname(String) - oracle.ODCI.ODCIColInfo.setColname(java.lang.String), JPR 3-13

setColtypename(String) - oracle.ODCI.ODCIColInfo.setColtypename(java.lang.String), JPR 3-13

setColtypeschema(String) - oracle.ODCI.ODCIColInfo.setColtypeschema(java.lang.String), JPR 3-13

setCpucost(BigDecimal) - oracle.ODCI.ODCICost.setCpucost(java.math.BigDecimal), JPR 3-21

setData

setting to EMPTY_BLOB() using JPublisher, ADL 6-9

setDebug(boolean) - oracle.jms.AQjmsOracleDebug.setDebug(boolean), JPR 2-131

setDeliveryMode(int) - oracle.jms.AQjmsProducer.setDeliveryMode(int), JPR 2-143

setDisableMessageID(boolean) - oracle.jms.AQjmsProducer.setDisableMessageID(boolean), JPR 2-143

setDisableMessageTimestamp(boolean) - oracle.jms.AQjmsProducer.setDisableMessageTimestamp(boolean), JPR 2-144

setDoctype(DTD) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.setDoctype(oracle.xml.parser.v2.DTD), JPR 4-13

setDoctype(DTD) - oracle.xml.parser.v2.XMLDocumentHandler.setDoctype(oracle.xml.parser.v2.DTD), JPR 4-87

setDoctype(DTD) - oracle.xml.parser.v2.XMLParser.setDoctype(oracle.xml.parser.v2.DTD), JPR 4-125

setDocumentHandler(DocumentHandler) - oracle.xml.parser.v2.SAXParser.setDocumentHandler(org.xml.sax.DocumentHandler), JPR 4-51

setDouble(String, double) - oracle.jms.AQjmsMapMessage.setDouble(java.lang.String, double), JPR 2-96

setDoubleProperty(String, double) - oracle.jms.AQjmsAdtMessage.setDoubleProperty(java.lang.String, double), JPR 2-18

setDoubleProperty(String, double) - oracle.jms.AQjmsMessage.setDoubleProperty(java.lang.String, double), JPR 2-114

setDTDHandler(DTDHandler) - oracle.xml.parser.v2.SAXParser.setDTDHandler(org.xml.sax.DTDHandler), JPR 4-52

setElement(ODCIArgDesc, long) - oracle.ODCI.ODCIArgDescList.setElement(oracle.ODCI.ODCIArgDesc, long), JPR 3-8

setElement(ODCIColInfo, long) - oracle.ODCI.ODCIColInfoList.setElement(oracle.ODCI.ODCIColInfo, long), JPR 3-16

setElement(ODCIObject, long) - oracle.ODCI.ODCIObjectList.setElement(oracle.ODCI.ODCIObject, long), JPR 3-44

setElement(String, long) - oracle.ODCI.ODCIRidList.setElement(java.lang.String, long), JPR 3-59

setEncoding(String) - oracle.xml.parser.v2.XMLDocument.setEncoding(java.lang.String), JPR 4-80

setEntityResolver(EntityResolver) - oracle.xml.parser.v2.SAXParser.setEntityResolver(org.xml.sax.EntityResolver), JPR 4-52

setErrorHandler(ErrorHandler) - oracle.xml.parser.v2.SAXParser.setErrorHandler(org.xml.sax.ErrorHandler), JPR 4-53

setErrorHandler(ErrorHandler) - oracle.xml.parser.v2.XMLTokenizer.setErrorHandler(org.xml.sax.ErrorHandler), JPR 4-142

setErrorStream(OutputStream) - oracle.xml.parser.v2.DOMParser.setErrorStream(java.io.OutputStream), JPR 4-19

setErrorStream(OutputStream) - oracle.xml.parser.v2.XMLTokenizer.setErrorStream(java.io.OutputStream), JPR 4-143

setErrorStream(OutputStream) - oracle.xml.parser.v2.XSLProcessor.setErrorStream(java.io.OutputStream), JPR 4-152

setErrorStream(OutputStream, String) - oracle.xml.parser.v2.DOMParser.setErrorStream(java.io.OutputStream, java.lang.String), JPR 4-20

setErrorStream(PrintWriter) - oracle.xml.parser.v2.DOMParser.setErrorStream(java.io.PrintWriter), JPR 4-20

setExceptionListener(ExceptionListener) - oracle.jms.AQjmsConnection.setExceptionListener(javax.jms.ExceptionListener), JPR 2-47

setFlags(BigDecimal) - oracle.ODCI.ODCIFuncInfo.setFlags(java.math.BigDecimal), JPR 3-26

setFlags(BigDecimal) - oracle.ODCI.ODCIPredInfo.setFlags(java.math.BigDecimal), JPR 3-49

setFlags(BigDecimal) - oracle.ODCI.ODCIQueryInfo.setFlags(java.math.BigDecimal), JPR 3-54

setFlags(BigDecimal) - oracle.ODCI.ODCIStatsOptions.setFlags(java.math.BigDecimal), JPR 3-62

setFloat(String, float) - oracle.jms.AQjmsMapMessage.setFloat(java.lang.String, float), JPR 2-96

setFloatProperty(String, float) - oracle.jms.AQjmsAdtMessage.setFloatProperty(java.lang.String, float), JPR 2-19

setFloatProperty(String, float) - oracle.jms.AQjmsMessage.setFloatProperty(java.lang.String, float), JPR 2-115

setIndexcols(ODCIColInfoList) - oracle.ODCI.ODCIIndexInfo.setIndexcols(oracle.ODCI.ODCIColInfoList), JPR 3-36

setIndexinfo(ODCIIndexInfo) - oracle.ODCI.ODCIIndexCtx.setIndexinfo(oracle.ODCI.ODCIIndexInfo), JPR 3-30

setIndexname(String) - oracle.ODCI.ODCIIndexInfo.setIndexname(java.lang.String), JPR 3-36

setIndexschema(String) - oracle.ODCI.ODCIIndexInfo.setIndexschema(java.lang.String), JPR 3-36

setInt(String, int) - oracle.jms.AQjmsMapMessage.setInt(java.lang.String, int), JPR 2-97

setIntProperty(String, int) - oracle.jms.AQjmsAdtMessage.setIntProperty(java.lang.String, int), JPR 2-19

setIntProperty(String, int) - oracle.jms.AQjmsMessage.setIntProperty(java.lang.String, int), JPR 2-115

setIocost(BigDecimal) - oracle.ODCI.ODCICost.setIocost(java.math.BigDecimal), JPR 3-21

setJMSCorrelationID(String) - oracle.jms.AQjmsMessage.setJMSCorrelationID(java.lang.String), JPR 2-115

setJMSCorrelationIDAsBytes(byte[]) - oracle.jms.AQjmsMessage.setJMSCorrelationIDAsBytes(byte[]), JPR 2-116

setJMSDeliveryMode(int) - oracle.jms.AQjmsMessage.setJMSDeliveryMode(int), JPR 2-116

setJMSDestination(Destination) - oracle.jms.AQjmsMessage.setJMSDestination(javax.jms.Destination), JPR 2-116

setJMSExpiration(long) - oracle.jms.AQjmsMessage.setJMSExpiration(long), JPR 2-117

setJMSMessageID(String) - oracle.jms.AQjmsMessage.setJMSMessageID(java.lang.String), JPR 2-117

setJMSPriority(int) - oracle.jms.AQjmsMessage.setJMSPriority(int), JPR 2-117

setJMSRedelivered(boolean) - oracle.jms.AQjmsMessage.setJMSRedelivered(boolean), JPR 2-118

setJMSReplyTo(Destination) - oracle.jms.AQjmsAdtMessage.setJMSReplyTo(javax.jms.Destination), JPR 2-20

setJMSReplyTo(Destination) - oracle.jms.AQjmsMessage.setJMSReplyTo(javax.jms.Destination), JPR 2-118

setJMSTimestamp(long) - oracle.jms.AQjmsMessage.setJMSTimestamp(long), JPR 2-119

setJMSType(String) - oracle.jms.AQjmsAdtMessage.setJMSType(java.lang.String), JPR 2-20

setJMSType(String) - oracle.jms.AQjmsMessage.setJMSType(java.lang.String), JPR 2-119

setLocale(Locale) - oracle.xml.parser.v2.XMLDocument.setLocale(java.util.Locale), JPR 4-80

setLocale(Locale) - oracle.xml.parser.v2.XMLParser.setLocale(java.util.Locale), JPR 4-125

setLocale(Locale) - oracle.xml.parser.v2.XSLProcessor.setLocale(java.util.Locale), JPR 4-152

setLogStream(OutputStream) - oracle.jms.AQjmsOracleDebug.setLogStream(java.io.OutputStream), JPR 2-131

setLong(String, long) - oracle.jms.AQjmsMapMessage.setLong(java.lang.String, long), JPR 2-97

setLongProperty(String, long) - oracle.jms.AQjmsAdtMessage.setLongProperty(java.lang.String, long), JPR 2-21

setLongProperty(String, long) - oracle.jms.AQjmsMessage.setLongProperty(java.lang.String, long), JPR 2-119

setMessageListener(MessageListener) - oracle.jms.AQjmsConsumer.setMessageListener(javax.jms.MessageListener), JPR 2-62

setMessageListener(MessageListener) - oracle.jms.AQjmsSession.setMessageListener(javax.jms.MessageListener), JPR 2-182

setMethodname(String) - oracle.ODCI.ODCIFuncInfo.setMethodname(java.lang.String), JPR 3-26

setMethodname(String) - oracle.ODCI.ODCIPredInfo.setMethodname(java.lang.String), JPR 3-49

setName(String) - oracle.jms.AQjmsAgent.setName(java.lang.String), JPR 2-27

setNavigationMode(int) - oracle.jms.AQjmsConsumer.setNavigationMode(int), JPR 2-63

setNavigationMode(int) - oracle.jms.AQjmsQueueReceiver.setNavigationMode(int), JPR 2-154

setNavigationMode(int) - oracle.jms.AQjmsTopicReceiver.setNavigationMode(int), JPR 2-208

setNavigationMode(int) - oracle.jms.AQjmsTopicSubscriber.setNavigationMode(int), JPR 2-212

setNetworkcost(BigDecimal) - oracle.ODCI.ODCICost.setNetworkcost(java.math.BigDecimal), JPR 3-21

setNodeFactory(NodeFactory) - oracle.xml.parser.v2.DOMParser.setNodeFactory(oracle.xml.parser.v2.NodeFactory), JPR 4-20

setNodeValue(String) - oracle.xml.parser.v2.XMLAttr.setNodeValue(java.lang.String), JPR 4-60

setNodeValue(String) - oracle.xml.parser.v2.XMLNode.setNodeValue(java.lang.String), JPR 4-115

setObject(Serializable) - oracle.jms.AQjmsObjectMessage.setObject(java.io.Serializable), JPR 2-128

setObject(String, Object) - oracle.jms.AQjmsMapMessage.setObject(java.lang.String, java.lang.Object), JPR 2-97

setObjectname(String) - oracle.ODCI.ODCIFuncInfo.setObjectname(java.lang.String), JPR 3-26

setObjectname(String) - oracle.ODCI.ODCIObject.setObjectname(java.lang.String), JPR 3-40

setObjectname(String) - oracle.ODCI.ODCIPredInfo.setObjectname(java.lang.String), JPR 3-49

setObjectProperty(String, Object) - oracle.jms.AQjmsAdtMessage.setObjectProperty(java.lang.String, java.lang.Object), JPR 2-21

setObjectProperty(String, Object) - oracle.jms.AQjmsMessage.setObjectProperty(java.lang.String, java.lang.Object), JPR 2-120

setObjectschema(String) - oracle.ODCI.ODCIFuncInfo.setObjectschema(java.lang.String), JPR 3-26

setObjectschema(String) - oracle.ODCI.ODCIObject.setObjectschema(java.lang.String), JPR 3-41

setObjectschema(String) - oracle.ODCI.ODCIPredInfo.setObjectschema(java.lang.String), JPR 3-49

setOptions(BigDecimal) - oracle.ODCI.ODCIStatsOptions.setOptions(java.math.BigDecimal), JPR 3-62

setParam(String, String) - oracle.xml.parser.v2.XSLStylesheet.setParam(java.lang.String, java.lang.String), JPR 4-155

setPreserveWhitespace(boolean) - oracle.xml.parser.v2.XMLParser.setPreserveWhitespace(boolean), JPR 4-125

setPriority(int) - oracle.jms.AQjmsProducer.setPriority(int), JPR 2-144

setPrivateKey(byte[], String) - oracle.security.ssl.OracleSSLCredential.setPrivateKey(byte[], java.lang.String), OAS F-22

setPrivateKey(String, String) - oracle.security.ssl.OracleSSLCredential.setPrivateKey(java.lang.String, java.lang.String), OAS F-22

setProtocol(int) - oracle.jms.AQjmsAgent.setProtocol(int), JPR 2-27

setRid(String) - oracle.ODCI.ODCIIndexCtx.setRid(java.lang.String), JPR 3-31

setSample(BigDecimal) - oracle.ODCI.ODCIStatsOptions.setSample(java.math.BigDecimal), JPR 3-62

setSenderID(AQjmsAgent) - oracle.jms.AQjmsMessage.setSenderID(oracle.jms.AQjmsAgent), JPR 2-120

setShort(String, short) - oracle.jms.AQjmsMapMessage.setShort(java.lang.String, short), JPR 2-98

setShortProperty(String, short) - oracle.jms.AQjmsAdtMessage.setShortProperty(java.lang.String, short), JPR 2-22

setShortProperty(String, short) - oracle.jms.AQjmsMessage.setShortProperty(java.lang.String, short), JPR 2-121

setsize parameter

backup command (RMAN), RMN 1-40, RMN 10-29

setSSLCredentials(OracleSSLCredential) - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.setSSLCredentials(oracle.security.ssl.OracleSSLCredential), OAS F-33

setSSLCredentials(OracleSSLCredential) - oracle.security.ssl.OracleSSLServerSocketFactory.setSSLCredentials(oracle.security.ssl.OracleSSLCredential), OAS F-29

setSSLCredentials(OracleSSLCredential) - oracle.security.ssl.OracleSSLSocketFactoryImpl.setSSLCredentials(oracle.security.ssl.OracleSSLCredential), OAS F-47

setSSLCredentials(OracleSSLCredential) - oracle.security.ssl.OracleSSLSocketFactory.setSSLCredentials(oracle.security.ssl.OracleSSLCredential), OAS F-42

setSSLProtocolVersion(int) - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.setSSLProtocolVersion(int), OAS F-34

setSSLProtocolVersion(int) - oracle.security.ssl.OracleSSLServerSocketFactory.setSSLProtocolVersion(int), OAS F-29

setSSLProtocolVersion(int) - oracle.security.ssl.OracleSSLServerSocket.setSSLProtocolVersion(int), OAS F-27

setSSLProtocolVersion(int) - oracle.security.ssl.OracleSSLSocketFactoryImpl.setSSLProtocolVersion(int), OAS F-48

setSSLProtocolVersion(int) - oracle.security.ssl.OracleSSLSocketFactory.setSSLProtocolVersion(int), OAS F-42

setSSLSessionContext(byte[]) - oracle.security.ssl.OracleSSLSession.setSSLSessionContext(byte[]), OAS F-40

setStandalone(String) - oracle.xml.parser.v2.XMLDocument.setStandalone(java.lang.String), JPR 4-81

setString(String, String) - oracle.jms.AQjmsMapMessage.setString(java.lang.String, java.lang.String), JPR 2-98

setStringProperty(String, String) - oracle.jms.AQjmsAdtMessage.setStringProperty(java.lang.String, java.lang.String), JPR 2-22

setStringProperty(String, String) - oracle.jms.AQjmsMessage.setStringProperty(java.lang.String, java.lang.String), JPR 2-121

setTablename(String) - oracle.ODCI.ODCIArgDesc.setTablename(java.lang.String), JPR 3-5

setTablename(String) - oracle.ODCI.ODCIColInfo.setTablename(java.lang.String), JPR 3-13

setTableschema(String) - oracle.ODCI.ODCIArgDesc.setTableschema(java.lang.String), JPR 3-5

setTableschema(String) - oracle.ODCI.ODCIColInfo.setTableschema(java.lang.String), JPR 3-13

setText(String) - oracle.jms.AQjmsTextMessage.setText(java.lang.String), JPR 2-200

setTextDecl(String, String) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.setTextDecl(java.lang.String, java.lang.String), JPR 4-13

setTextDecl(String, String) - oracle.xml.parser.v2.XMLDocumentHandler.setTextDecl(java.lang.String, java.lang.String), JPR 4-88

setTimeToLive(int) - oracle.jms.AQjmsProducer.setTimeToLive(int), JPR 2-145

setting

debug logging levels, OID 5-23

using the OID Control Utility, OID 5-23

internal LOBs to empty, ADL 2-9

LOBs to NULL, ADL 2-8

maximum number of subentries, using Oracle Directory Manager, OID 4-11

maximum search time, using Oracle Directory Manager, OID 4-11

overides for NLS_LANG variable

system operational attributes, OID 5-15

setting archive buffer parameters, SAD 7-21

setting instances, PSA 4-3

setting wallet location, OID 4-6

setToken(int, boolean) - oracle.xml.parser.v2.XMLTokenizer.setToken(int, boolean), JPR 4-143

setTokenHandler(XMLToken) - oracle.xml.parser.v2.XMLTokenizer.setTokenHandler(oracle.xml.parser.v2.XMLToken), JPR 4-143

setTraceLevel(int) - oracle.jms.AQjmsOracleDebug.setTraceLevel(int), JPR 2-131

Setup Wizard, REP 8-18

setValidationMode(boolean) - oracle.xml.parser.v2.XMLParser.setValidationMode(boolean), JPR 4-126

setValue(ODCIArgDesc) - oracle.ODCI.ODCIArgDescRef.setValue(oracle.ODCI.ODCIArgDesc), JPR 3-10

setValue(ODCIColInfo) - oracle.ODCI.ODCIColInfoRef.setValue(oracle.ODCI.ODCIColInfo), JPR 3-18

setValue(ODCICost) - oracle.ODCI.ODCICostRef.setValue(oracle.ODCI.ODCICost), JPR 3-23

setValue(ODCIFuncInfo) - oracle.ODCI.ODCIFuncInfoRef.setValue(oracle.ODCI.ODCIFuncInfo), JPR 3-28

setValue(ODCIIndexCtx) - oracle.ODCI.ODCIIndexCtxRef.setValue(oracle.ODCI.ODCIIndexCtx), JPR 3-33

setValue(ODCIIndexInfo) - oracle.ODCI.ODCIIndexInfoRef.setValue(oracle.ODCI.ODCIIndexInfo), JPR 3-38

setValue(ODCIObject) - oracle.ODCI.ODCIObjectRef.setValue(oracle.ODCI.ODCIObject), JPR 3-46

setValue(ODCIPredInfo) - oracle.ODCI.ODCIPredInfoRef.setValue(oracle.ODCI.ODCIPredInfo), JPR 3-51

setValue(ODCIQueryInfo) - oracle.ODCI.ODCIQueryInfoRef.setValue(oracle.ODCI.ODCIQueryInfo), JPR 3-56

setValue(ODCIStatsOptions) - oracle.ODCI.ODCIStatsOptionsRef.setValue(oracle.ODCI.ODCIStatsOptions), JPR 3-64

setValue(String) - oracle.xml.parser.v2.XMLAttr.setValue(java.lang.String), JPR 4-61

setVersion(String) - oracle.xml.parser.v2.XMLDocument.setVersion(java.lang.String), JPR 4-81

setWallet(String, String) - oracle.security.ssl.OracleSSLCredential.setWallet(java.lang.String, java.lang.String), OAS F-22

setXMLDecl(String, String, String) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.setXMLDecl(java.lang.String, java.lang.String, java.lang.String), JPR 4-13

setXMLDecl(String, String, String) - oracle.xml.parser.v2.XMLDocumentHandler.setXMLDecl(java.lang.String, java.lang.String, java.lang.String), JPR 4-88

SGA

See Also system global area

SGA. See System Global Area., SAD 2-22

SGA. See system global area

SGA. See System Global Area (SGA).

SGA size, DWG 18-18, STU 19-7

SGA statistics, STU 15-2

SGA, defined, PSG 1-2

SGADEF file, GTK 7-7

shadow column groups, REP 5-11

shadow processes, SCN 8-23

open cursors and, MIG 3-18

SHADOW_CORE_DUMP initialization parameter, SRF 1-110

share locks

share table locks (S), SCN 235

share locks (S)

LOCK TABLE command, ADG 7-13

SHARE ROW EXCLUSIVE lock mode, SQL 7-548

share row exclusive locks (SRX)

LOCK TABLE command, ADG 7-15

SHARE UPDATE lock mode, SQL 7-548

SHARED clause

of CREATE DATABASE LINK, SQL 7-274

shared data structures mode, OCI 2-20

shared database links

configuring, DDS 2-16

creating links, DDS 2-14, DDS 2-15

to dedicated servers, DDS 2-16

to multi-threaded (MTS) servers, DDS 2-17

determining whether to use, DDS 2-14

example, DDS 1-20

shared disk storage subsystem, PSG 2-5

shared disk system

advantages, PSC 2-6

shared exclusive mode, PSC 5-9

shared global area (SGA), SCN 7-2

shared high availability node configuration, PSC 9-24

SHARED keyword

CREATE DATABASE LINK statement, DDS 2-15

shared library, DCI 4-2

naming conventions, DCI 2-7

shared memory access

advantages, disadvantages of, PSC 2-4

shared memory system

scalability, PSC 8-11

shared mode, OCI 2-20

data files, PSC 7-2

file operation restrictions, PSC A-20

instance number, PSA 1-6

instance recovery, PSA 14-2

OCIInitialize(), OCI 2-21

OCIStmtPrepare(), OCI 2-21

recovery restrictions, PSA 14-7

rollback segments, SCN 4-28

using environmental variables, OCI 2-21

shared nothing systems, PSC 2-7

shared Oracle home, PSG B-11

shared pool, SCN 7-7, STU 2-12

allocation of, SCN 7-11

ANALYZE statement, SCN 7-11

ANALYZE statement and, SAD 19-8

contention, STU 2-13

dependency management and, SCN 7-11

described, SCN 7-7

flushing, SCN 7-12

keeping objects pinned in, STU 13-4

object dependencies and, SCN 116

overview of, SCN 1-14

procedures and packages, SCN 60

row cache and, SCN 7-10

size of, SCN 7-7

tuning, STU 19-13, STU 19-25

shared pool size, OID 13-8

parameter, OID 13-10

shared resource system, PSA 8-11

shared server processes, SAD 4-2

creating additional, SQL 7-114

maximum number, SRF 1-72

terminating, SQL 7-114

trace files for, SAD 4-15

shared server processes (Snnn), SCN 8-15, SCN 8-20

described, SCN 8-20

shared servers, SCN 1-16

advantages and disadvantages, NET 5-5

recommended for, NET 5-5

see also multi-threaded servers

shared SQL

for remote and distributed statements, DDS 1-34

shared SQL area, PSA 5-8

shared SQL areas, SCN 7-8, SCN 15

ANALYZE statement, SCN 7-11

ANALYZE statement and, SAD 19-8

dependency management and, SCN 7-11

described, SCN 7-8

keeping in the shared pool, STU 13-4

loading SQL into, SCN 20

memory allocation, STU 19-16

overview of, SCN 1-14, SCN 15

parse locks and, SCN 240

procedures, packages, triggers and, SCN 7-10

similar SQL statements, STU 13-2

size of, SCN 7-8

statements considered, STU 13-1

shared SQL for remote and distributed statements, SCN 405

shared structures

interoperability, MIG 9-18

SHARED_MEMORY_ADDRESS initialization parameter, SRF 1-110

SHARED_MEMORY_ADDRESS parameter, SCN 7-14

SHARED_POOL_RESERVED_MIN_ALLOC initialization parameter: obsolete

SHARED_POOL_RESERVED_SIZE initialization parameter, SRF 1-111

SHARED_POOL_RESERVED_SIZE parameter, STU 19-27

V$SHARED_POOL_RESERVED, SRF 3-103

SHARED_POOL_SIZE

setting, PSA 10-3

SHARED_POOL_SIZE initialization parameter, REP 7-7, SRF 1-111

changes in release 8.1, MIG 8-5

parallel execution allocation, MIG B-10

SHARED_POOL_SIZE parameter, DWG 18-10, DWG 18-16, SCN 7-7, STU 19-22, STU 19-27

allocating library cache, STU 19-16

system global area size and, SCN 7-13

tuning the shared pool, STU 19-24

short records with missing data

SQL*Loader, SUT 5-43

short waits

definition of, STU 20-57

short-circuit evaluation, PLS 2-45

SHORTINT

C Language datatype, SUT 5-59

SHOW

Import parameter, SUT 1-3, SUT 2-26

SHOW ADDRESS command, NET A-87

SHOW ALL command, NET A-88

SHOW CACHE_CHECKPOINT INTERVAL command, NET A-62

SHOW command

of CMCTL, NET A-86

of LSNRCTL, NET A-19

of NAMESCTL, NET A-61

SHOW CONNECT_TIMEOUT command, NET A-19

SHOW CURRENT_LISTENER command, NET A-19

SHOW DEFAULT_DOMAIN command, NET A-63

SHOW DISPLAYMODE command

of CMCTL, NET A-89

of LSNRCTL, NET A-19

SHOW FORWARDING_AVAILABLE command, NET A-64

SHOW INSTANCE command, PSA 4-4, PSA 4-6

SHOW LOG_DIRECTORY command, NET A-19

SHOW LOG_FILE command, NET A-19

SHOW LOG_FILE_NAME command, NET A-65

SHOW LOG_STATS_INTERVAL command, NET A-65

SHOW LOG_STATUS command, NET A-19

SHOW NAMESCTL_TRACE_LEVEL command, NET A-66

SHOW PARAMETER command

example of, PSA 1-6

SHOW PARAMETERS command, PSA 4-6

instance number, PSA 1-6

SHOW PARAMETERS statement, SRF 1-9

SHOW PASSWORD command, NET A-19

SHOW PROFILE command, NET A-89

SHOW RAW_MODE command, NET A-19

SHOW RELAY command, NET A-90

SHOW REQUESTS_ENABLED command, NET A-67

SHOW RESETS_STATS_INTERVAL command, NET A-67

SHOW RULES command, NET A-91

SHOW SAVE_CONFIG_INTERVAL command, NET A-68

SHOW SAVE_CONFIG_ON_STOP command, NET A-19, NET A-68

SHOW SERVER command, NET A-69

SHOW SGA command, PSA 4-6

SHOW SGA statement, STU 19-5

SHOW STARTUP_WAITTIME command, NET A-19

SHOW STATUS command, NET A-69

SHOW SYSTEM_QUERIES command, NET A-70

SHOW TRACE_FILE_NAME command, NET A-70

SHOW TRACE_LEVEL command, NET A-71

SHOW TRC_DIRECTORY command, NET A-19

SHOW TRC_FILE command, NET A-19

SHOW TRC_LEVEL command, NET A-19

SHOW USE_PLUGANDPLAY command, NET A-19

SHOW VERSION command, NET A-72

SHOW_TNS_INFO parameter, NET C-74

showWarnings(boolean) - oracle.xml.parser.v2.DOMParser.showWarnings(boolean), JPR 4-21

showWarnings(boolean) - oracle.xml.parser.v2.XSLProcessor.showWarnings(boolean), JPR 4-152

SHRINK clause

of ALTER ROLLBACK SEGMENT, SQL 7-79

shutdown, SCN 5-10, SCN 5-11

abnormal, SCN 5-6, SCN 5-11

audit record, SCN 333

deallocation of the SGA, SCN 7-2

prohibited by dispatcher processes, SCN 8-21

steps, SCN 5-10

SHUTDOWN ABORT command, PSA 4-5

SHUTDOWN ABORT statement, SCN 5-11

crash recovery required, SCN 344

SHUTDOWN command

ABORT option, PSA 4-5, PSA 4-6

IMMEDIATE option, PSA 4-6

of CMCTL, NET A-92

of NAMESCTL, NET A-72

specifying an instance, PSA 4-4

shutdown command (RMAN), RMN 10-147

SHUTDOWN event

triggers on, SQL 7-431

SHUTDOWN statement

ABORT option, SAD 3-13, SBR 4-7, SBR 5-15, SBR 5-16, SBR 5-25, SBR 6-13

consistent whole database backups, SBR 1-17

IMMEDIATE option, SAD 3-12

NORMAL option, SAD 3-11

shutdown types, PSG 7-10

abort, PSG 7-10

immediate, PSG 7-10

normal, PSG 7-10

shutdown database and other services, PSG 7-11

shutdown database only, PSG 7-11

shutting down an instance, PSA 4-5

abnormal shutdown, PSA 4-5

aborting the instance, SAD 3-13

archiving redo log files, PSA 13-15

changing startup order, PSA 1-6

connecting and, SAD 3-10

connecting as INTERNAL, SAD 3-10

example of, SAD 3-12

forcing a log switch, PSA 13-15

immediately, SAD 3-12

lost sequence numbers, PSC 8-14

normally, SAD 3-11

unarchived log files, PSA 13-4

shutting down an Oracle Parallel Server database, PSG 7-12

setting parameters, PSG 7-25

viewing results, PSG 7-12

with SYSDBA privilege, PSG 6-26

with SYSOPER privilege, PSG 6-26

SID

described, PSG 1-15

SID field in Net8 Assistant, NET 7-13, NET 8-47, NET 8-49

SID parameter, MIG F-6, NET C-48

SID Prefix, PSG 3-4, PSG 3-27

SID, configuring on the listener, NET 7-13

SID, defined, PSG 1-15

SID_DESC parameter, NET C-52, PSG C-4

SID_LIST_listener_name parameter, NET C-52, PSG 3-40, PSG 6-6, PSG C-4

external procedures, NET 8-47

Heterogeneous Services, NET 8-49

Oracle Enterprise Manager

listener.ora requirements, NET 7-13, NET C-50

SID_NAME parameter, MIG F-15, NET 7-13, NET 8-47, NET 8-49, NET C-52

SID_startup net service name, PSG C-5

sidalrt.log file, PSG C-10

sidbsp0.trc file, PSG C-9

siddbwr.trc file, PSG C-9

side effect, DCI 5-6

side effects, ADG 9-6, ADG 9-61, PLS 7-14

controlling, PLS 7-9

sidlckn.trc file, PSG C-9, PSG C-11

sidlmdn.trc file, PSG C-9

sidlmon.trc file, PSG C-9

sidp00n.trc file, PSG C-9

SIDs in LISTENER.ORA file, SCN 6-6

sidsmon.trc file, PSG C-9

SIGN function, SQL 4-83

signal handling

requirements for Oracle's operating system dependent call, NET 10-11

UNIX considerations, NET 10-10

using in conjunction with Net8, NET 10-11

signature checking, SCN 117

signature mismatch, DCI 5-9

signatures

PL/SQL library unit dependencies, ADG 9-28

to manage remote dependencies, ADG 9-30

significant characters, PLS 2-5

SIGNTYPE subtype, PLS 2-13

SILENT

SQL*Loader command-line parameter, SUT 6-8

simple authentication, OID 1-5, OID 2-21

for access control subjects, OID 9-24, OID 9-30

Simple Authentication and Security Layer (SASL), in LDAP Version 3, OID 1-3

simple authentication for directory naming, NET 2-51

simple comparison conditions, SQL 5-16

simple expressions, SQL 5-3

Simple Network Management Protocol (SNMP), STU 11-5

Simple Network Management Protocol (SNMP) support

database management, DDS 1-32, SCN 403

simple subquery snapshots

many-to-many references, REP 3-15

many-to-one references, REP 3-15

simple symbols, PLS 2-3

SIN function, SQL 4-83

single domain naming model, NET 4-16

single points-of-failure

avoiding with high availability, PSC 9-2

single shared mode, PSA 7-19, PSC 4-8

single sign-on, OAS 12-3, OAS 15-3, GTK 4-9

Single Sign-On, described, NET 4-26

single table aggregate requirements, DWG 8-13

SINGLE TABLE clause

of CREATE CLUSTER, SQL 7-257

SINGLE TABLE HASHKEYS, SCN 10-61

single tier, STU 18-14

single-byte character sets

Import, SUT 2-53

single-instance database

migrating to multi-instance, PSG 9-3

single-line comments, PLS 2-10

single-process systems

enabling distributed recovery, DDS 5-28

single-row functions, SQL 4-4

miscellaneous, SQL 4-6

SINGLEROW index keyword, SUT 5-44, SUT 8-20

single-table hash clusters, SAD 17-5, SCN 10-61

compatibility, MIG 9-10

dropping, MIG 13-16

single-table load

discontinued, SUT 5-34

single-table-only hash clusters, GTK 3-26

single-task linking, GTK 7-5

support, OCI 1-27

single-valued attributes, OID 2-4

converting to multi-valued, OID 6-19

SINH function, SQL 4-84

site autonomy, SCN 1-34, SCN 394

distributed databases, DDS 1-24

site ownership

dynamic, REP 5-7

primary, REP 5-7

site priority

altering, SPR 37-22, RAR 8-88

as a backup method during timestamp conflict resolution, REP 5-12, REP 5-18

site priority conflict resolution method, REP 5-22

site priority groups

adding members to, SPR 37-10, RAR 8-76

creating

syntax, SPR 37-47, RAR 8-113

dropping, SPR 37-57, RAR 8-123

removing members from, SPR 37-58, RAR 8-124

SIZE clause

of ALTER CLUSTER, SQL 7-4

of CREATE CLUSTER, SQL 7-256

of filespec clause, SQL 7-517

size limit, varray, PLS 4-5

Size of an Integer and ROWID, PC_ E-2

size of attribute values, OID F-8

size of backup sets, setting, RMN 1-41

SIZE option

allocating extents, PSA 8-12

sizes

estimating for tables, SAD 13-4

sizing

I/O subsystem, OID 12-6

sizing tablespaces, OID 12-9

skewing parallel DML workload, SCN 175

SKIP

effect on SQL*Loader RECNUM specification, SUT 5-55

SQL*Loader, SUT 5-35

SQL*Loader command-line parameter, SUT 6-9

SQL*Loader control file keyword, SUT 5-76

skip offline option (RMAN)

backup command, RMN 5-16

skip parameters

for arrays of structures, OCI 5-23

for standard arrays, OCI 5-24

skip readonly option (RMAN)

backup command, RMN 5-16

SKIP_CORRUPT_BLOCKS procedure, SAD 20-3, SAD 20-7

example, SAD 20-14

SKIP_INDEX_MAINTENANCE parameter, SUT 6-9, SUT 8-20

SKIP_UNUSABLE_INDEXES parameter, SCN 114, SUT 2-26, SUT 6-10, SUT 8-20

of ALTER SESSION, SQL 7-94

sleep time, OID Monitor, OID 3-2, OID 3-3

slow-down, PSC 8-5

SMALLINT datatype, SUT 5-59

ANSI, SQL 2-28

DB2, SQL 2-29

SQL/DS, SQL 2-29

SMALLINT subtype, PLS 2-14

smartcards, OAS 1-9, OAS 4-5

and RADIUS, OAS 1-8, OAS 4-5, OAS 4-8, OAS 4-18, OAS C-2

smit utility

restarting cdsadv service, OAS 14-16

SMON background process, SCN 8-11

See also system monitor process

SMON process, PSC 6-3

instance recovery, PSA 14-2, PSA 14-3

recovery after SHUTDOWN ABORT, PSA 4-5

transaction recovery, PSC A-15

SMP

scaling limitations of, PSC 2-3

SMP architecture

disk affinity, SCN 206

sn attribute, OID 2-5

SNA, NET 4-4

snaphsots, SCN 427

snapshot, PC_ 3-16, PCO 3-12

snapshot control files, RMN 1-15

specifying location, RMN 2-3

snapshot descriptor, OCI 2-15

Snapshot Group Wizard, REP 8-20

snapshot groups, REP 1-5, REP 3-23, SCN 425

adding objects to, RAR 5-6

creating, SPR 37-41, RAR 5-4, RAR 5-5, RAR 8-107

deployment templates, REP 4-21

dropping, RAR 7-10

group owner, RAR 7-5, REP 3-24

snapshot log

Import, SUT 2-48

snapshot logs, REP 1-10, REP 3-20, SCN 430

altering, RAR 7-17

privileges required, RAR 7-17

creating, RAR 4-1, RAR 5-4, REP 3-37

deleting, RAR 7-24

deployment templates, REP 4-13

filter columns

adding, RAR 7-17

import, REP 3-20

managing, RAR 7-17

space, RAR 7-18

master table

purging, SPR 48-4, SPR 48-5, SPR 48-6, RAR 8-235, RAR 8-236, RAR 8-237

primary key, REP 3-20

privileges required to create, REP 3-37

purging

manual, RAR 7-19

privileges required, RAR 7-19

purging rows from, RAR 7-18

reducing space allocated to, RAR 7-19

reorganizing master tables with, RAR 7-20

ROWID, REP 3-20

troubleshooting, REP B-9

truncating, RAR 7-19

privileges required, RAR 7-20

truncating master table with, RAR 7-21

underlying table for, REP 3-20

snapshot logs. See materialized view logs

snapshot sites

adding using offline instantiation, RAR 7-34

administrator

creating, RAR 2-16

advantages of, REP 7-9

changing masters, SPR 37-83, RAR 7-9, RAR 8-149

compared with master sites, REP 7-8

database links, REP 7-15

creating, RAR 2-17, RAR 5-4

database links for, REP 3-32

database version, REP 7-14

deferred transaction queue

scheduled push, REP 3-34

dropping, SPR 37-59, RAR 7-10, RAR 8-125

dropping objects from, RAR 7-13

flowchart for setting up, RAR 2-15

group owner

using, RAR 7-5

local creation, REP 4-29

managing, RAR 7-5

migration, MIG G-6

network connectivity, REP 7-14

preparing for deployment templates, REP 7-13

propagating changes to master, SPR 11-19, RAR 8-34

refresher

creating, RAR 2-16

refreshing, SPR 37-71, RAR 8-137

rollback segments, REP 7-16

schedule purge, RAR 2-18

schedule push, RAR 2-19

scheduled links for

guidelines, REP 7-10

scheduled purge for

guidelines, REP 7-11

schemas, REP 7-15

setup, REP 7-14

users

creating, RAR 2-16

snapshot too old message, SCN 215

SNAPSHOT_REFRESH_KEEP_CONNECTIONS initialization parameter: obsolete

SNAPSHOT_REFRESH_PROCESSES initialization parameter: obsolete

snapshots, PLS 5-42, REP 1-7, REP 3-1, SUT 2-48

architecture, REP 3-17

assignment tables, REP 3-11

base table, REP 3-21

column level subsetting, REP A-3

compatibility, MIG 9-44

complex, REP 3-6

value for PCTFREE, REP 3-28

value for PCTUSED, REP 3-28

concepts, REP 3-2

creating, REP 3-38

creating schemas for, REP 3-32

data dictionary views, RAR 9-53

data subsetting, REP 3-4, REP 3-8

datatypes supported, REP 3-22

deployment templates, REP 1-11, REP 4-1, SCN 431

disabling replication for, REP 6-19

disconnected computing, REP 3-4

distributed database recovery, SBR 6-18

dropping, RAR 7-14

enabling replication for, REP 6-19

executing against, OCI 4-7

generating support for, SPR 37-66, RAR 8-132

horizontal partitioning, REP 3-8

import, REP 3-20

importing, SUT 2-48

index, REP 3-23

large refresh group optimization, REP A-2

mass deployment, REP 3-4

master sites, REP 3-19

master table

Import, SUT 2-48

master tables, REP 3-19

media recovery and, SBR 6-18

network loads, REP 3-3

null refresh, REP A-2

offline instantiation of, SPR 25-3, SPR 25-5, RAR 8-48, RAR 8-50

Oracle8i Lite support, REP C-1

preparing for, REP 3-31

primary key, REP 3-5, REP A-7

privileges, REP 3-33

read-only, REP 1-7, REP 3-8, SCN 427

registration, REP 3-17

simple with subqueries, REP A-6

unregistering, REP 3-17

refresh, RAR 4-18, REP 1-10, REP 3-28, SCN 8-13, SCN 430

complete, REP 3-28

failures, REP B-8

fast, REP 3-28

force, REP 3-29

initiating, REP 3-30

interval, REP 3-30

job queue processes, SCN 1-19, SCN 8-13

on-demand, REP 3-30

physical ROWIDs, MIG 12-6

querying for last refresh time, REP 3-16

retries, REP B-8

troubleshooting, REP B-7, REP B-8

refresh groups, REP 3-25

creating, RAR 5-6

data dictionary views, RAR 9-53

size, REP 3-27

refreshing, SPR 48-8, SPR 48-11, SPR 48-12, RAR 7-40, RAR 8-239, RAR 8-242, RAR 8-243

registration at master site, REP 3-16

restoring dropped

Import, SUT 2-49

ROWID, REP 3-5

same as materialized view, SCN 1-24

security

trusted vs. untrusted, RAR A-8

security for, RAR A-7

simple subquery

AND expression and, REP 3-15

EXISTS clause and, REP 3-15

filter columns requirement, REP 3-15

joins and, REP 3-15

number of columns in master tables, REP 3-15

snapshot groups, REP 3-23

snapshot logs, REP 1-10, REP 3-20, SCN 430

creating, RAR 4-1, RAR 5-4

subqueries, REP 3-9

restrictions, REP 3-14

too old

OPTIMAL storage parameter and, SAD 11-6

trace file, REP B-8

troubleshooting, REP B-7

types, REP 3-4

updatable

deferred constraints, REP A-8

updateable, REP 1-8, SCN 428

upgrading, MIG 7-30

upgrading to primary key, MIG G-11

use of, REP 3-3

vertical partitioning, REP 3-8

views, REP 3-22

snapshots. See materialized views

SNMP, STU 11-5

SNMPAGENT role, SQL 7-530

Snnn background processes, SCN 8-15

snowflake schemas, DWG 16-3

complex queries, DWG 16-3

SNP background processes, RAR 1-4, REP 3-34, SRF 1-50

about, SAD 8-2

managing job queues, SAD 8-3 to SAD 8-14

starting, SAD 8-3

viewing job queue information, SAD 8-14

SNPn background processes, SCN 1-19, SCN 8-13

message propagation, SCN 76

.so files

naming conventions, DCI 2-7

software code areas, SCN 7-18

shared by programs and utilities, SCN 7-19

Software Packager, Oracle, GTK 3-58

software requirements, PSG 2-2, PSG 2-3

software-based connection redirection, OID 14-7

SOME, STU 4-67

SOME comparison operator, PLS 5-5

SOME operator, SQL 3-6

sort area parameter, OID 13-11

sort areas, SCN 7-17

memory allocation, STU 20-35

process local area, STU 2-12

sort enhancements, PSC A-12

sort improvements, GTK 3-26

sort operations, SCN 3-12

sort segments, SCN 3-13

sort space, PSC A-12

SORT_AREA_RETAINED_SIZE initialization parameter, SRF 1-112

SORT_AREA_RETAINED_SIZE parameter, SCN 7-17, STU 19-42, STU 20-37

of ALTER SESSION, SQL 7-95

of ALTER SYSTEM, SQL 7-118

SORT_AREA_SIZE initialization parameter, SRF 1-112

compatibility, MIG B-8

index creation and, SAD 14-3

SORT_AREA_SIZE parameter, DWG 14-28, DWG 18-19, SCN 4-20, SCN 7-17, STU 4-29, STU 12-16, STU 19-41

and parallel execution, DWG 18-19

cost-based optimization and, STU 4-59

index creation and, ADG 5-2

of ALTER SESSION, SQL 7-95

of ALTER SYSTEM, SQL 7-118

tuning sorts, STU 20-36

SORT_DIRECT_WRITES initialization parameter

compatibility, MIG B-8

SORT_DIRECT_WRITES initialization parameter: obsolete

SORT_DIRECT_WRITES parameter, PSC A-15

SORT_MULTIBLOCK_READ_COUNT initialization parameter, SRF 1-113

SORT_MULTIBLOCK_READ_COUNT parameter, DWG 18-26, STU 20-38

of ALTER SESSION, SQL 7-95

of ALTER SYSTEM, SQL 7-118

SORT_READ_FAC initialization parameter: obsolete

SORT_SPACEMAP_SIZE initialization parameter: obsolete

SORT_WRITE_BUFFER_SIZE initialization parameter: obsolete

SORT_WRITE_BUFFERS initialization parameter: obsolete

SORTED INDEXES clause

direct path loads, SUT 5-44

example, SUT 4-25

SQL*Loader, SUT 8-17

sorting

binary, NLS 2-28

character data, NLS 2-28

double characters, NLS 2-31

following language conventions, NLS 2-28

maximum memory, SRF 1-112

multiple-column indexes

SQL*Loader, SUT 8-17

optimum sort order

SQL*Loader, SUT 8-18

order, NLS 2-28

ORDER BY queries, SRF 1-78

presorting in direct path load, SUT 8-16

SORTED INDEXES clause

SQL*Loader, SUT 8-17

specifying non-default, NLS 2-32, NLS 2-33

with function-based indexes, ADG 5-6

sort-merge joins, STU 4-51

access path, STU 4-43

cost-based optimization, STU 4-59

example, STU 4-43

sorts

(disk) statistic, STU 20-35

(memory) statistic, STU 20-35

avoiding on index creation, STU 20-38

tuning, STU 20-35

Sorts in Memory data view, STU 14-12

Sorts on Disk data view, STU 14-12

SOUNDEX function, SQL 4-84

source data for tuning, STU 11-2

source database

definition, MIG 1-3

source systems, DWG 11-2

SOURCE_ROUTE parameter, MIG F-11, NET 8-4, NET 8-7, NET 8-31, NET 8-34, NET 8-38, NET C-41

SOURCE_SIZE view, SRF 2-162

SP date format element suffix, SQL 2-51

space

allocating extents, PSA 8-11

deallocating unused, PSA 8-14

determining unused, PSA 8-14

free blocks, PSC 7-10, PSC 7-25

free list, PSC 7-10

not allocated to instance, PSA 8-10

reducing snapshot log, RAR 7-19

unavailable in exclusive mode, PSA 8-9

space management, DWG 18-51

compression of free space in blocks, SCN 4-10

data blocks, SAD 12-2 to SAD 12-6, SCN 4-5

datatypes, space requirements, SAD 12-18

deallocating unused space, SAD 12-14

direct-load INSERT, SCN 153

extents, SCN 4-12

MINIMUM EXTENT parameter, SCN 190

parallel DDL, SCN 190

parallel execution, DWG 18-43

PCTFREE, SCN 4-6

PCTUSED, SCN 4-7

reducing transactions, DWG 18-44

row chaining, SCN 4-10

segments, SCN 4-18

setting storage parameters, SAD 12-8 to SAD 12-13

space requirements

copying data, MIG 3-15

migration, MIG 3-15, MIG 4-6, MIG 5-4

spaces

where allowed, PLS 2-2

spaghetti code, PLS 3-15

sparse collections, PLS 4-3

Spatial

compatibility, MIG 9-14

use in power demand example, DCI 11-81

spatial applications

index-organized tables, SCN 10-45

spatial data, GTK 3-10

SPAWN command, NET A-20

special characters, SUT A-2

specification

call, PLS 8-3

cursor, PLS 5-12

function, PLS 7-7

method, PLS 9-8

object, PLS 9-5

package, PLS 8-6

procedure, PLS 7-4

SPECIFICATION clause

of ALTER PACKAGE, SQL 7-65

Enqueue a Message, ADQ 11-10, ADQ 11-13, ADQ 11-7

specifying attributes, as mandatory or optional, OID 6-2

specifying destinations

for archived redo logs, SAD 7-10, SBR 2-21

specifying multiple ARCH processes, SAD 7-20

SPECint_rate95 baseline, OID 12-15

speedup

definition, PSC 8-4

spelled numbers

specifying, SQL 2-51

spin count, STU 18-12

SPINCOUNT parameter, STU 21-2

split mirrors

using as backups, RMN 5-12

SPLIT PARTITION clause, SAD 15-14, SAD 15-29

of ALTER INDEX, SQL 7-34, SQL 7-41

of ALTER TABLE, SQL 7-161

SPLIT PARTITION statement

no-logging mode, SCN 11-58, SCN 151

rules of parallelism, SCN 181

splitText(int) - oracle.xml.parser.v2.XMLText.splitText(int), JPR 4-132

splitting mirrors

suspend/resume mode, SBR 4-9

sponsor node, OID 10-20

cold backup procedures, OID B-3

SPOOL

Migration utility option, MIG 4-17

SPTH date format element suffix, SQL 2-51

SPX protocol

described, NET 4-3

parameters for addresses, NET B-4

SERVICE parameter, NET B-4

SQL, GTK 2-14, SCN 10, SMS 46-1, ADQ 1-7

analytic functions, GTK 2-10

benefits of, PC_ 1-3

comparison operators, PLS 5-5

compatibility, MIG 9-13

cursors used in, SCN 15

Data Definition Language (DDL), SCN 12

Data Manipulation Language (DML), SCN 12

data manipulation statements, PLS 5-2

description of, SQL 1-2

dynamic, PLS 10-2

dynamic SQL, SCN 28

embedded, SCN 1-52, SCN 14, SQL 1-4

user-defined datatypes, SCN 13-14

Embedded SQL, PC_ 1-3

extension

partition or subpartition name, SCN 11-63

functions, SCN 10, SQL 4-2

column default values, SCN 10-9

COUNT, SCN 10-38

in CHECK constraints, SCN 271

new in Oracle8i, MIG E-3

NVL, SCN 10-9

optimizing view queries, STU 4-84

keywords, SQL A-1, SUT A-2

memory allocation for, SCN 7-11

nature of, PC_ 1-3

need for, PC_ 1-3

Oracle Tools support of, SQL 1-5

overview of, SCN 1-51, SCN 10

parallel execution, SCN 158

parameters, SQL A-1

parsing of, SCN 16

PL/SQL and, SCN 1-55, SCN 24

pseudocolumns, PLS 5-3

recursive, SCN 15

cursors and, SCN 15

removing incompatibilities for downgrading, MIG 13-33

reserved words, SCN 11, SUT A-2

row operators, PLS 5-6

session control statements, SCN 14

set operators, PLS 5-6

shared SQL, SCN 15

special characters, SUT A-2

standards, SQL 1-2, SQL B - 1

statement-level rollback, SCN 34

statements

auditing, SQL 7-215

determining the cost of, SQL 7-512

summary of statements, PCO F-4

support in PL/SQL, PLS 1-20

syntax, SQL 7-1, SQL A-1

system control statements, SCN 14

transaction control statements, SCN 13

transactions and, SCN 1-52, SCN 32, SCN 35

types of statements in, SCN 1-51, SCN 11

optimizing, STU 4-47

user-defined datatypes, ADO 3-1, SCN 13-13

embedded SQL, ADO 3-6, SCN 13-14

OCI, ADO 3-2, SCN 13-15

SQL area

shared, PSA 5-8

SQL area tuning, STU 19-8

SQL areas

private, SCN 7-8

persistent, SCN 7-8

runtime, SCN 7-9

shared, SCN 1-14, SCN 7-8, SCN 15

SQL capabilities

data dictionary tables, DDS 7-14

SQL codes

returned by SQLGLS routine, PCO 8-22

sql command (RMAN), RMN 10-150

SQL Communications Area, PC_ 9-2, PCO 2-10

SQLCA, PC_ 9-16

SQL cursor

syntax, PLS 11-163

SQL DDL

BFILE security, ADL 11-10

SQL Descriptor Area, PCO 9-25, PCO 11-4

SQLDA, PC_ 13-26, PC_ 15-4

SQL dialect

understood by non-Oracle system, DDS 6-4

SQL directives

CONTEXT USE, PC_ 11-8, PC_ F-33, PCO 12-8

DECLARE CURSOR, PCO F-24

DECLARE DATABASE, PC_ F-37, PCO F-26

DECLARE STATEMENT, PC_ F-39, PCO F-27

DECLARE TABLE, PC_ F-40, PCO F-29

DECLARE TYPE, PC_ F-42

TYPE, PC_ F-110

VAR, PC_ F-115, PCO F-90

WHENEVER, PC_ F-118, PCO F-92

SQL directives CONTEXT USE, PCO F-21

SQL DML

BFILE security, ADL 11-10

SQL errors

ORA-00900, DDS 3-12

ORA-02015, DDS 3-12

SQL Exception (string) - error, ADQ D-9

SQL function

ACOS, SQL 4-13

SQL functions

ABS, SQL 4-12

ADD_MONTHS, SQL 4-13

aggregate, SQL 4-6

analytic, SQL 4-7

ASCII, SQL 4-14

ASIN, SQL 4-15

ATAN, SQL 4-15

ATAN2, SQL 4-16

AVG, SQL 4-16

BFILENAME, SQL 4-17

CEIL, SQL 4-18

character

returning character values, SQL 4-4

returning number values, SQL 4-5

CHARTOROWID, SQL 4-19

CHR, SQL 4-19

CONCAT, SQL 4-20

conversion, SQL 4-5

CONVERT, SQL 4-21

CORR, SQL 4-22

COS, SQL 4-23

COSH, SQL 4-24

COUNT, DWG 6-5, SQL 4-24

CUME_DIST, SQL 4-28

date, SQL 4-5

DENSE_RANK, SQL 4-29

DEREF, SQL 4-30

DUMP, SQL 4-31

EMPTY_BLOB, SQL 4-33

EMPTY_CLOB, SQL 4-33

EXP, SQL 4-33

FIRST_VALUE, SQL 4-34

FLOOR, SQL 4-35

GREATEST, SQL 4-36

GROUPING, SQL 4-36

HEXTORAW, SQL 4-37

INITCAP, SQL 4-38

INSTR, SQL 4-38

INSTRB, SQL 4-39

LAG, SQL 4-40

LAST_DAY, SQL 4-41

LAST_VALUE, SQL 4-42

LEAD, SQL 4-44

LEAST, SQL 4-45

LENGTH, SQL 4-45

LENGTHB, SQL 4-46

linear regression, SQL 4-71

LN, SQL 4-46

LOG, SQL 4-47

LOWER, SQL 4-47

LPAD, SQL 4-48

LTRIM, SQL 4-48

MAKE_REF, SQL 4-49

MAX, SQL 4-50

MIN, SQL 4-52

MOD, SQL 4-53

MONTHS_BETWEEN, SQL 4-54

NEW_TIME, SQL 4-55

NEXT_DAY, SQL 4-55

NLS_CHARSET_DECL_LEN, SQL 4-56

NLS_CHARSET_ID, SQL 4-56

NLS_CHARSET_NAME, SQL 4-57

NLS_INITCAP, SQL 4-58

NLS_LOWER, SQL 4-59

NLS_UPPER, SQL 4-60

NLSSORT, SQL 4-59

NLV2, SQL 4-65

NTILE, SQL 4-61

number, SQL 4-4

NUMTODSINTERVAL, SQL 4-62

NUMTOYMINTERVAL, SQL 4-63

NVL, SQL 4-64

object reference, SQL 4-12

PERCENT_RANK, SQL 4-66

POWER, SQL 4-67

RANK, SQL 4-67

RATIO_TO_REPORT, SQL 4-68

RAWTOHEX, SQL 4-69

REF, SQL 4-70

REFTOHEX, SQL 4-70

REGR_AVGX, SQL 4-71

REGR_AVGY, SQL 4-71

REGR_COUNT, SQL 4-71

REGR_INTERCEPT, SQL 4-71

REGR_R2, SQL 4-71

REGR_SLOPE, SQL 4-71

REGR_SXX, SQL 4-71

REGR_SXY, SQL 4-71

REGR_SYY, SQL 4-71

REPLACE, SQL 4-78

ROUND (date), SQL 4-79

ROUND (number), SQL 4-79

ROW_NUMBER, SQL 4-80

ROWIDTOCHAR, SQL 4-81

RPAD, SQL 4-82

RTRIM, SQL 4-82

SIGN, SQL 4-83

SIN, SQL 4-83

single-row, SQL 4-4

miscellaneous, SQL 4-6

SINH, SQL 4-84

SOUNDEX, SQL 4-84

SQRT, SQL 4-85

STDDEV, SQL 4-86

STDDEVP, SQL 4-87

STDDEVS, SQL 4-88

SUBSTR, SQL 4-90

SUBSTRB, SQL 4-91

SUM, SQL 4-91

SYS_CONTEXT, SQL 4-93

SYS_GUID, SQL 4-97

SYSDATE, SQL 4-98

TAN, SQL 4-98

TANH, SQL 4-99

TO_CHAR (date), SQL 4-99

TO_CHAR (number), SQL 4-100

TO_DATE, SQL 4-101

TO_LOB, SQL 4-102

TO_MULTI_BYTE, SQL 4-103

TO_NUMBER, SQL 4-103

TO_SINGLE_BYTE, SQL 4-104

TRANSLATE, SQL 4-105

TRANSLATE...USING, SQL 4-106

TRIM, SQL 4-107

TRUNC (date), SQL 4-109

TRUNC (number), SQL 4-108

UID, SQL 4-109

UPPER, SQL 4-110

USER, SQL 4-110

USERENV, SQL 4-111

VALUE, SQL 4-112

VARIANCE, SQL 4-115

VARP, SQL 4-113

VARS, SQL 4-114

VSIZE, SQL 4-116

SQL Loader, DWG 14-10

loading InLine LOB data, ADL 4-7

performance for internal LOBs, ADL 4-6

SQL operators

applying to fields, SUT 5-88

SQL Parse event, STU 14-5

SQL query

binding placeholders. See bind operation

defining output variables, OCI 4-14, OCI 5-18, OCI 12-4

defining output variables. See define operation

fetching results, OCI 4-15

statement type, OCI 1-9

SQL scripts

CATQUEUE.SQL, SRF 5-4

creating the data dictionary, SRF 5-2

optional, SRF 5-3

required, SRF 5-2

SQL service

capabilities, DDS 6-4

data dictionary views, DDS 6-8, DDS 7-10

Heterogeneous Services, DDS 6-4

views

Heterogeneous Services, DDS 7-13

SQL statement

restrictions, PSC B-3

SQL statement property sheet in Oracle Trace, STU 14-15

SQL statements, OCI 1-7, SCN 1-51, SCN 11, SCN 17

ALLOCATE, PC_ F-12, PCO F-10

ALLOCATE DESCRIPTOR, PCO F-12

ALLOCATE DESCRIPTOR TYPE, PC_ F-14

ALTER DATABASE, SBY 1-28, SBY 4-12, SBY 4-16

ALTER SYSTEM, SBY 4-11

applying log files, SBR 5-12

array processing, SCN 23

auditing, SCN 335, SCN 337

by access, SQL 7-215

by proxy, SQL 7-214

by session, SQL 7-214

by user, SQL 7-214

overview, SCN 1-43

stopping, SQL 7-550

successful, SQL 7-215

when records generated, SCN 332

avoiding the use of indexes, STU 12-7

binding placeholders in, OCI 4-5, OCI 5-2, OCI 12-2

CACHE FREE ALL, PC_ F-15

CALL, PC_ 7-27, PC_ F-16, PCO F-13

CLOSE, PC_ F-18, PCO F-14

COMMIT, PC_ F-24, PCO F-15

complex, STU 4-48, STU 4-74

optimizing, STU 4-74

concerns when executing, PC_ 6-6

CONNECT, PC_ F-26, PCO F-17

CONTEXT ALLOCATE, PC_ F-28, PCO F-19

CONTEXT FREE, PC_ F-29, PCO F-20

CONTEXT OBJECT OPTION GET, PC_ F-30

CONTEXT OBJECT OPTION SET, PC_ F-32

controlling transactions, PCO 3-13

converting

examples of, STU 4-71

CREATE CONTROLFILE, SBY 4-12

creating cursors, SCN 20

DEALLOCATE DESCRIPTOR, PC_ F-34, PCO F-23

decomposition, STU 9-32

DELETE, PC_ F-43, PCO F-31

DESCRIBE, PC_ F-47, PCO F-34

DESCRIBE DESCRIPTOR, PC_ F-49, PCO F-36

determining the execution plan for, SQL 7-512

determining type prepared, OCI 4-4

dictionary cache locks and, SCN 241

disabling audit options, SAD 24-12

distributed

defined, STU 4-48

optimization of, STU 4-94

routing to nodes, SCN 20

distributed databases and, DDS 1-33, SCN 404

dynamic, ADG 11-50

embedded, SCN 14

ENABLE THREADS, PC_ F-50, PCO F-38

enabling audit options on, SAD 24-10

ensuring the use of indexes, STU 12-6

executable versus directive, PC_ 2-3

EXECUTE, PC_ F-53, PCO F-41

EXECUTE ... END-EXEC, PC_ F-51

EXECUTE DESCRIPTOR, PCO F-43

EXECUTE IMMEDIATE, PC_ F-57, PCO F-44

EXECUTE...END-EXEC, PCO F-39

executing, OCI 4-6

execution, ADG 7-2, SCN 17, SCN 22

execution plans of, SCN 124, STU 4-5

failure in, SCN 343

FETCH, PC_ F-58, PCO F-46, PCO F-49

FETCH DESCRIPTOR, PC_ F-61, PCO F-49

for defining and controlling transactions, PC_ 3-16

for manipulating a cursor, PC_ 6-7, PC_ 6-11

for manipulating ORACLE data, PC_ 6-7

for querying Oracle data, PC_ 6-7

for recovering tablespace, SBR 5-12

FREE, PC_ F-63, PCO F-51

GET DESCRIPTOR, PCO F-52

handles, SCN 1-15

in trigger bodies, ADG 13-15, ADG 13-20

INSERT, PC_ F-67, PCO F-55

instance-specific, PSA 4-7

larger than 32 KB, SPR 51-12

LOB APPEND, PC_ F-71, PCO F-58

LOB ASSIGN, PC_ F-72, PCO F-59

LOB CLOSE, PC_ F-72, PCO F-59

LOB COPY, PC_ F-73, PCO F-60

LOB CREATE, PC_ F-73, PCO F-60

LOB DESCRIBE, PC_ F-74, PCO F-61

LOB DISABLE BUFFERING, PC_ F-75, PCO F-62

LOB ENABLE BUFFERING, PC_ F-76, PCO F-63

LOB ERASE, PC_ F-76, PCO F-63

LOB FILE CLOSE, PC_ F-77, PCO F-64

LOB FILE SET, PC_ F-78, PCO F-65

LOB FLUSH BUFFER, PC_ F-78, PCO F-65

LOB FREE TEMPORARY, PC_ F-79, PCO F-66

LOB LOAD, PC_ F-79, PCO F-66

LOB OPEN, PC_ F-80, PCO F-67

LOB READ, PC_ F-81, PCO F-68

LOB TRIM, PC_ F-81, PCO F-68

LOB WRITE, PC_ F-82, PCO F-69

mapping to non-Oracle datastores, DDS 9-2

matching with outlines, STU 10-3

modifying indexed data, STU 12-5

not allowed in triggers, ADG 13-20

number of triggers fired by single, SCN 102

OBJECT CREATE, PC_ F-83

OBJECT DELETE, PC_ F-84

OBJECT DEREF, PC_ F-85

OBJECT FLUSH, PC_ F-86

OBJECT GET, PC_ F-87

OBJECT RELEASE, PC_ F-88

OBJECT SET, PC_ F-89

OBJECT UPDATE, PC_ F-90

OPEN, PC_ F-91, PCO F-70, PCO F-71, PCO F-72

OPEN DESCRIPTOR, PC_ F-93, PCO F-72

optimization

complex statements, STU 4-74

types of statements, STU 4-47

optimizing to improve performance, PC_ C-5, PCO D-4

overview, SCN 1-51

parallel execution, SCN 158

parallelizing, SCN 158, SCN 166

parse locks, SCN 240

parsing, SCN 20

PREPARE, PC_ F-95, PCO F-74

preparing for execution, OCI 4-4

privileges required for, ADG 11-22, SCN 305

processing, OCI 4-2

recursive, STU 13-1

OPTIMIZER_GOAL does not affect, STU 4-11

referencing dependent objects, SCN 110

REGISTER CONNECT, PC_ F-97

relating to standby database, SBY 1-28

remote

defined, STU 4-48

resource limits and, SCN 296

restricting ad hoc use, ADG 11-12, ADG 11-13

ROLLBACK, PC_ F-98, PCO F-76

rolling back, SQL 7-564

rules for executing, PC_ C-5

SAVEPOINT, PC_ F-102, PCO F-79

SELECT, PC_ F-103, PCO F-80

SET DESCRIPTOR, PC_ F-106, PCO F-83

simple, STU 4-47

static versus dynamic, PCO 2-6

successful execution, SCN 33

summary of, PC_ F-5, PCO F-4

tracking the occurrence in a session, SQL 7-213

transactions, SCN 23

triggers on, SCN 82, SCN 89

triggering events, SCN 87

tuning, STU 2-10

types

control statements, OCI 1-8

data definition language, OCI 1-7

data manipulation language, OCI 1-8

embedded SQL, OCI 1-11

PL/SQL, OCI 1-9

queries, OCI 1-9

types of, PC_ 2-3, SCN 1-51, SCN 11, STU 4-47

undoing, SQL 7-564

UPDATE, PC_ F-111, PCO F-86

using to control a cursor, PCO 5-8, PCO 5-12

using to manipulate data, PCO 5-7

SQL strings

applying SQL operators to fields, SUT 5-88

example, SUT 4-28

new behavior in 8.1.5, SUT 3-18

quotation marks, SUT 5-19

SQL syntax used in this manual, PCO cxxvi

SQL text match, DWG 19-8

with query rewrite, DWG 19-30

SQL trace facility, STU 6-2, STU 6-6, STU 11-6, STU 19-9, STU 19-40

example of output, STU 6-15

output, STU 6-12

parse calls, STU 19-9

statement truncation, STU 6-14

steps to follow, STU 6-3

trace files, STU 6-4, STU 11-3

SQL*Forms

display error screen in, PC_ 20-8

IAP constants in, PC_ 20-8

returning values to, PC_ 20-8

reverse return code switch in, PC_ 20-8

SQL*Loader, GTK 3-36, GTK 3-47, GTK 3-56, SCN 1-11, SMS 24-1

about, SAD 1-17

appending rows to tables, SUT 5-33

bad file, SUT 3-11

BADDN keyword, SUT 5-25

BADFILE keyword, SUT 5-25

basics, SUT 3-2

bind arrays and performance, SUT 5-75

BINDSIZE command-line parameter, SUT 5-76, SUT 6-4

case studies, SUT 4-1

associated files, SUT 4-3

direct path load, SUT 4-25

extracting data from a formatted report, SUT 4-28

loading combined physical records, SUT 4-15

loading data into multiple tables, SUT 4-19

loading delimited, free-format files, SUT 4-11

loading fixed-length data, SUT 4-8

loading variable-length data, SUT 4-5

choosing which rows to load, SUT 5-41

command-line parameters, SUT 6-2

CONCATENATE keyword, SUT 5-36

concepts, SUT 3-1

CONTINUE_LOAD keyword, SUT 5-35

CONTINUEIF keyword, SUT 5-36

CONTROL command-line parameter, SUT 6-4

controlling memory use, SUT 5-24

conventional path loads, SUT 8-2

DATA command-line parameter, SUT 6-4

data conversion, SUT 3-8

data definition language

expanded syntax diagrams, SUT 5-15

high-level syntax diagrams, SUT 5-4

data definition language syntax, SUT 5-3

datatype specifications, SUT 3-8

DB2 load utility, SUT B-1

DIRECT command-line parameter, SUT 6-5, SUT 8-10

direct load

NOLOGGING mode, SCN 11-58, SCN 151

parallel direct load, SCN 147

similar to direct-load INSERT, SCN 146

direct path method, SUT 3-14

discard file, SUT 3-13

discarded records, SUT 3-11

DISCARDFILE command-line parameter, SUT 6-5

DISCARDFILE keyword, SUT 5-28

DISCARDMAX command-line parameter, SUT 6-5

DISCARDMAX keyword, SUT 5-29

DISCARDS keyword, SUT 5-29

errors caused by tabs, SUT 5-49

ERRORS command-line parameter, SUT 6-5

example sessions, SUT 4-1

exclusive access, SUT 8-25

FILE command-line parameter, SUT 6-6

filenames, SUT 5-18

index options, SUT 5-43

indexes and, ADG 5-2, SAD 14-4

inserting rows into tables, SUT 5-32

INTO TABLE statement, SUT 5-39

LOAD command-line parameter, SUT 6-6

load methods, SUT 8-2

loading data contained in the control file, SUT 5-54

loading LONG data, SUT 5-64

LOG command-line parameter, SUT 6-6

log file datafile information, SUT 7-3

log file entries, SUT 7-1

log file header information, SUT 7-2

log file summary statistics, SUT 7-4

log file table information, SUT 7-3

log file table load information, SUT 7-4

log files, SUT 3-13

methods of loading data, SUT 3-14, SUT 5-32

multiple INTO TABLE statements, SUT 5-51

National Language Support, SUT 5-30

object names, SUT 5-18

PARALLEL command-line parameter, SUT 6-6

parallel data loading, SUT 8-25, SUT 8-26, SUT 8-30

PARFILE command-line parameter, SUT 6-6

partition operations, SCN 11-47, SCN 11-49

preparing tables for case studies, SUT 4-4

READBUFFERS keyword, SUT 5-24

READSIZE command-line parameter, SUT 6-7

rejected records, SUT 3-11

replacing rows in tables, SUT 5-33

required privileges, SUT 3-14

reserved words, SUT A-2

ROWS command-line parameter, SUT 6-7

SILENT command-line parameter, SUT 6-8

SINGLEROW index keyword, SUT 5-44

SKIP command-line parameter, SUT 6-9

SKIP keyword, SUT 5-35

SORTED INDEXES during direct path loads, SUT 5-44

specifying columns, SUT 5-47

specifying datafiles, SUT 5-22

specifying field conditions, SUT 5-44

specifying fields, SUT 5-47

specifying more than one data file, SUT 5-23

suppressing messages, SUT 6-8

updating rows, SUT 5-33

SQL*Loader log file

global information, SUT 7-2

SQL*Loader restrictions on records, SUT 3-17

SQL*Menu

PL/SQL, SCN 25

SQL*Module

applications, ADG 9-4

FIPS flagger, SCN 14

for Ada, MIG 9-20

stored procedures, SCN 27

SQL*Net, MIG F-9

coexistence issues, MIG F-5 to MIG F-11

third-party Oracle7 applications, MIG F-8

using SERVICE_NAME, MIG F-7

using SID, MIG F-7

compared with Net8, MIG F-2

compatibility issues

Oracle7 client connection to release 8.1 database, MIG F-6

connecting using Version 2, PC_ 3-4

migrating, MIG F-12 to MIG F-15

configuration files, MIG F-13

listener.ora file, MIG F-15

Oracle Names release 8.1, MIG F-17

software on client, MIG F-13

software on server, MIG F-13

sqlnet.ora file, MIG F-14

tnsnames.ora file, MIG F-14

verifying service name and instance name, MIG F-12

migrating to Net8, MIG 8-13, MIG 9-46

relinking, MIG 10-2

requirement for migration

Windows platforms, MIG 4-12, MIG 5-12

SID parameter, MIG F-6

upgrading from V1 to V2, MIG 9-46

use with Oracle8i, MIG 10-2

See Net8

SQL*Net Easy Configuration, described, MIG F-2

SQL*Net. See Net8

SQL*Net, level required by Biometric Athentication Service, OAS 8-5

SQL*Plus, PC_ 1-3, PCO 1-4

ALERT file, SCN 8-15

anonymous blocks, ADG 9-4, SCN 26

applying log files, SBR 5-11

compile-time errors, ADG 9-41

connecting with, SCN 282

creating a sequence, SPR 1-5

differences with Server Manager

ampersands, MIG 11-15

blank lines, MIG 11-12

commands, MIG 11-3

comments, MIG 11-9

COMMIT command, MIG 11-17

CREATE LIBRARY command, MIG 11-16

CREATE TYPE command, MIG 11-16

hyphen continuation character, MIG 11-13

startup, MIG 11-2

syntax, MIG 11-9

executing a package, SCN 48

executing a procedure, SCN 46

invoking stored procedures, ADG 9-49

loading a procedure, ADG 9-10

lock and latch monitors, SCN 240

migrating scripts from Server Manager, MIG 11-1

parallel recovery, SCN 351

restricting ad hoc use, ADG 11-12, ADG 11-13

scripts

upgrading, MIG 10-11

session variables, SCN 26

SET SERVEROUTPUT ON command, ADG 9-3

SHOW ERRORS command, ADG 9-41

showing size of SGA, SCN 7-13

SQL statements, SCN 10

starting, SAD 3-2

starting a database, SAD 3-3

starting an instance, SAD 3-3

statistics monitor, SCN 298

stored procedures, SCN 27

using to test SELECT statements, PC_ 6-8

versus embedded SQL, PC_ 1-3

SQL*Plus script, STU 11-7

SQL*Plus sessions

multiple, PSA 4-6

SQL, dynamic, PC_ 2-5

SQL_CURSOR, PC_ F-12, PCO F-10

sql_data_cl must be a class that implements SQLData interface - error, ADQ D-14

Sql_data_class cannot be null - error, ADQ D-11

SQL_SINGLE_RCTX

defined constant, PC_ 5-52

definition of, PC_ 5-47

SQL_STATEMENT column

TKPROF_TABLE, STU 6-18

SQL_TRACE initialization parameter, SRF 1-114

trace files and, SAD 4-15

SQL_TRACE parameter, SCN 8-15, STU 6-5

of ALTER SESSION, SQL 7-95

SQL92, PC_ xvi, SCN 212, SQL 1-2

conformance, PCO cxxvii

minimum requirement, PCO cxxvii

Oracle compliance with, SQL B - 2

SQL92 standards conformance, PCO cxxvii

SQL92_SECURITY initialization parameter, GTK 7-2, SRF 1-114

SQLADR subroutine

example, PCO 11-26

parameters, PCO 11-14

storing buffer addresses, PCO 11-3

syntax, PCO 11-14

sqlald() function

example of using, PC_ 15-21

purpose of, PC_ 15-5

syntax for, PC_ 15-5

sqlaldt() function

see SQLSQLDAAlloc, PC_ 5-52

SQL.BSQ file, STU 20-33

SQLCA, PC_ 9-2, PC_ 9-14, PCO 8-2

components in, PC_ 9-19

components set for a PL/SQL block, PC_ 9-22, PCO 8-13

declaring, PC_ 9-16

description of, PC_ 9-16

explicit versus implicit checking of, PC_ 9-3

fields, PCO 8-10

including multiple times, PC_ 5-34

interaction with Oracle, PCO 2-10

overview, PCO 2-9

overview of, PC_ 2-8

SQLCABC component in, PC_ 9-19

SQLCABC field, PCO 8-10

SQLCAID component in, PC_ 9-19

SQLCAID field, PCO 8-10

sqlcode component in, PC_ 9-19

SQLCODE field, PCO 8-10

sqlerrd, PC_ 9-21

SQLERRD(3) field, PCO 8-11

SQLERRD(5) field, PCO 8-12

sqlerrd[2] component in, PC_ 9-21

sqlerrmc component in, PC_ 9-20

SQLERRMC field, PCO 8-11

sqlerrml component in, PC_ 9-20

SQLERRML field, PCO 8-11

sqlwarn, PC_ 9-22

SQLWARN(4) flag, PCO 8-12

use in separate precompilations, PC_ 2-17

using more than one, PC_ 9-16

using with Net8, PCO 8-7

using with SQL*Net, PC_ 9-16

SQLCA status variable

data structure, PCO 8-7

declaring, PCO 8-8

effect of MODE option, PCO 8-3

explicit versus implicit checking, PCO 8-3

purpose, PCO 8-7

SQLCABC field, PCO 8-10

sqlca.h

listing of, PC_ 9-17

use of SQLCA_STORAGE_CLASS with, PC_ 2-16

SQLCAID component, PC_ 9-19

SQLCAID field, PCO 8-10

SQLCDAFromResultSetCursor(), PC_ 5-52

SQLCDAGetCurrent, PC_ 5-53

sqlcdat()

see SQLCDAFromResultSetCursor(), PC_ 5-52

SQLCHECK option

restrictions, PCO E-2

restrictions on, PC_ D-2

usage notes for, PC_ 10-39

using the DECLARE TABLE statement, PCO E-4

using to check syntax/semantics, PCO E-1

what it affects, PC_ D-3

SQLCHECK precompiler option, PC_ 10-38, PC_ 17-21, PC_ D-4, PC_ D-5, PCO 14-37

SQLCHECK support for objects, PC_ 17-21

sqlclu() function

example of using, PC_ 15-37

purpose of, PC_ 15-37

syntax for, PC_ 15-37

sqlclut() function

see SQLSQLDAFree(), PC_ 5-52

SQLCODE

with MODE=ANSI, PC_ 10-31

sqlcode

component in SQLCA, PC_ 9-3, PC_ 9-14

interpreting values of, PC_ 9-19

SQLCODE field, PCO 8-10

interpreting its value, PCO 8-10

SQLCODE function, PLS 6-18

syntax, PLS 11-166

SQLCODE status variable

declaring, PC_ 9-13

effect of MODE option, PCO 8-3

usage, PCO 8-3

when declared with the SQLCA, PC_ 9-14

when used, PC_ 9-14

SQL-CONTEXT, PCO 12-7

host tables not allowed, PCO 12-8

variable declaration, PCO 4-15

sqlcpr.h, PC_ 9-23

sqlcurt() function

see SQLDAToResultSetCursor(), PC_ 5-52

SQLDA, PCO 9-25, PCO 9-26

bind versus select, PC_ 13-26, PCO 9-26

BNDDFCLP variable, PCO 11-14

BNDDFCRCP variable, PCO 11-14

BNDDFMT variable, PCO 11-9

BNDDH-CUR-VNAMEL variable, PCO 11-13

BNDDH-MAX-VNAMEL variable, PCO 11-12

BNDDH-VNAME variable, PCO 11-12

BNDDI variable, PCO 11-11

BNDDI-CUR-VNAMEL variable, PCO 11-13

BNDDI-MAX-VNAMEL variable, PCO 11-13

BNDDI-VNAME variable, PCO 11-13

BNDDV variable, PCO 11-8

BNDDVLN variable, PCO 11-9

BNDDVTYP variable, PCO 11-11

C variable in, PC_ 15-11

declaring, PCO 11-7

definition of, PC_ 13-26

example, PCO 11-7

F variable in, PC_ 15-10

I variable in, PC_ 15-10

information stored in, PC_ 13-26, PCO 9-26

L variable in, PC_ 15-8

M variable in, PC_ 15-11

N variable in, PC_ 15-7

purpose, PCO 11-4

purpose of, PC_ 13-26

S variable in, PC_ 15-10

SELDFCLP variable, PCO 11-14

SELDFCRCP variable, PCO 11-14

SELDFMT variable, PCO 11-9

SELDH-CUR-VNAMEL variable, PCO 11-13

SELDH-MAX-VNAMEL variable, PCO 11-12

SELDH-VNAME variable, PCO 11-12

SELDI variable, PCO 11-11

SELDI-CUR-VNAMEL variable, PCO 11-13

SELDI-MAX-VNAMEL variable, PCO 11-13

SELDI-VNAME variable, PCO 11-13

SELDV variable, PCO 11-8

SELDVLN variable, PCO 11-9

SELDVTYP variable, PCO 11-11

SQLADR subroutine, PCO 11-14

SQLDFND variable, PCO 11-8

SQLDNUM variable, PCO 11-8

struct, contents of, PC_ 15-5

structure, PCO 11-8

structure of, PC_ 15-7

T variable in, PC_ 15-9

use in dynamic SQL method 4, PC_ 15-4

V variable in, PC_ 15-8

X variable in, PC_ 15-11

Y variable in, PC_ 15-11

Z variable in, PC_ 15-12

sqlda.h, PC_ 15-3

SQLDAToResultSetCursor(), PC_ 5-52

SQLDFND variable (SQLDA), PCO 11-8

SQLDNUM variable (SQLDA), PCO 11-8

SQL/DS datatypes, SQL 2-28

conversion to Oracle datatypes, SQL 2-29

restrictions on, SQL 2-30

SQL/DS option (DB2 file format)

not supported by SQL*Loader, SUT B-4

SQLEnvGet function in SQLLIB, PC_ 5-47

SQLEnvGet(), PC_ 5-53

sqlerrd

component, PC_ 9-15, PC_ 9-21

SQLERRD(3) field, PCO 8-11

using with batch fetch, PCO 7-8

SQLERRD(3) variable, PCO 8-9

SQLERRD(5) field, PCO 8-12

sqlerrd[2] component, PC_ 9-15, PC_ 9-21

returns N or rows fetched, PC_ 8-7

use with data manipulation statements, PC_ 8-6

sqlerrm

component in the SQLCA, PC_ 9-3

SQLERRM function, PLS 6-18

syntax, PLS 11-168

sqlerrmc component, PC_ 9-20

SQLERRMC field, PCO 8-11

SQLERRMC variable, PCO 8-9

sqlerrml component, PC_ 9-20

SQLERRML field, PCO 8-11

SQLERROR

WHENEVER directive condition, PC_ F-119

SQLERROR condition, PCO 8-16

in the WHENEVER statement, PC_ 9-24

meaning of, PC_ 9-24

of WHENEVER directive, PCO 8-16

WHENEVER directive, PCO F-93

SQLErrorGetText(), PC_ 5-52

SQLExtProcError(), PC_ 5-53, PC_ 7-31

SQLFC parameter, PCO 8-22

SQLGLM subroutine

example, PCO 8-14

parameters, PCO 8-13

provides DSNTIAR support for DB2 conversions, PCO 8-14

purpose, PCO 8-13

restrictions, PCO 8-14

syntax, PCO 8-13

sqlglm(), PC_ 9-23

sqlglm() function, PC_ 9-22

example of using, PC_ 9-23

parameters of, PC_ 9-22

sqlglmt()

see SQLErrorGetText, PC_ 5-52

SQLGLS routine, PCO 8-21, PCO 8-22

parameters, PCO 8-22

SQL codes returned by, PCO 8-22

syntax, PCO 8-22

using to obtain SQL text, PCO 8-21

sqlgls() function, PC_ 9-31

example of use, PC_ 4-22

sample program for, PC_ 9-34

see SQLLIB

function SQLStmGetText, PC_ 4-22

sqlglst() function

see SQLStmtGetText, PC_ 5-53

SQLIEM function

in user exits, PC_ 20-8

purpose of, PC_ 20-8

syntax for, PC_ 20-8

SQLIEM subroutine

restrictions, PCO 8-14

SQLJ

client, NLS 6-30

See Oracle SQLJ

SQLJ translators, NLS 6-2

sqlld2() function, PC_ 5-56

sqlld2t() function

see SQLLDAGetName, PC_ 5-53

SQLLDAGetName, PC_ 5-53

sqlldat() function

see SQLCDAGetCurrent, PC_ 5-53

SQLLIB

and embedded SQL, PC_ 2-4

extensions for OCI interoperability, PC_ 5-45

function

SQLCDAFromResultSetCursor, PC_ 5-52

function SQLCDAGetCurrent, PC_ 5-53

function SQLColumnNullCheck, PC_ 5-53

function SQLDAFree, PC_ 5-52

function SQLDAToResultSetCursor, PC_ 5-52

function SQLEnvGet, PC_ 5-47, PC_ 5-53

function SQLErrorGetText, PC_ 5-52

function SQLExtProcError, PC_ 5-53, PC_ 7-31

function SQLLDAGetName, PC_ 5-53

function SQLNumberPrecV6, PC_ 5-53

function SQLNumberPrecV7, PC_ 5-53

function SQLRowidGet, PC_ 5-53

function SQLStmtGetText(), PC_ 5-53

function SQLSvcCtxGet, PC_ 5-48, PC_ 5-53

function SQLVarcharGetLength, PC_ 4-22

new names for functions, PC_ A-3

new names for public functions, PC_ 5-51

SQLLIB function

SQLSQLDAAlloc, PC_ 5-52

SQLVarcharGetLength, PC_ 5-53

SQLNET_CRYPTO_CHECKSUM_TYPE_CLIENT parameter, NET C-15

SQLNET_CRYPTO_CHECKSUM_TYPE_SERVER parameter, NET C-15

SQLNET.ALTERNATE_PORT parameter, NET C-21

SQLNET.AUTHENTICATION_GSSAPI_ parameter, OAS B-2

SQLNET.AUTHENTICATION_GSSAPI_ SERVICE parameter, NET C-14

SQLNET.AUTHENTICATION_GSSAPI_SERVICE parameter, OAS 5-7, OAS 9-3

SQLNET.AUTHENTICATION_KERBEROS5_ SERVICE parameter, NET C-14

SQLNET.AUTHENTICATION_KERBEROS5_SERVICE parameter, OAS 6-8

SQLNET.AUTHENTICATION_SERVICES parameter, OAS 4-11, OAS 5-7, OAS 6-8, OAS 7-8, OAS 8-10, OAS 9-3, OAS 10-18, OAS 10-19, OAS 10-30, OAS 11-3, OAS 11-5, OAS B-2, NET C-13

SQLNET.CLIENT_AUTHENTICATION parameter, NET C-23, NET C-56

SQLNET.CLIENT_REGISTRATION parameter, NET 8-23, NET C-14

SQLNET.CRYPTO_CHECKSUM_CLIENT parameter, OAS 2-14, OAS A-8, NET C-14

SQLNET.CRYPTO_CHECKSUM_SERVER parameter, OAS 2-14, OAS A-8, NET C-15

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT parameter, OAS 2-14, OAS A-9

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER parameter, OAS 2-14, OAS A-9

SQLNET.CRYPTO_SEED parameter, OAS 2-13, OAS A-10, NET C-16

SQLNET.ENCRYPTION_CLIENT parameter, OAS 2-13, OAS A-5, NET C-16

SQLNET.ENCRYPTION_SERVER parameter, OAS 2-12, OAS A-5, NET C-17

SQLNET.ENCRYPTION_TYPES_CLIENT parameter, OAS 2-13, OAS A-7, NET C-17

SQLNET.ENCRYPTION_TYPES_SERVER parameter, OAS 2-12, OAS A-6, NET C-18

SQLNET.EXPIRE_TIME parameter, NET 8-23, NET C-18

SQLNET.FIPS_140 parameter, OAS D-3

SQLNET.IDENTIX_FINGERPRINT_DATABASE parameter, OAS 8-10, NET C-18

SQLNET.IDENTIX_FINGERPRINT_DATABASE_ PASSWORD parameter, NET C-19

SQLNET.IDENTIX_FINGERPRINT_DATABASE_ USER parameter, NET C-19

SQLNET.IDENTIX_FINGERPRINT_METHOD parameter, NET C-19

SQLNET.IDENTIX_USE_MD5HASH parameter, OAS B-2

SQLNET.KERBEROS5_CC_NAME parameter, OAS 6-9, NET C-19

SQLNET.KERBEROS5_CLOCKSKEW parameter, OAS 6-9, NET C-20

SQLNET.KERBEROS5_CONF parameter, OAS 6-9, NET C-20

SQLNET.KERBEROS5_CONF_MIT parameter, OAS 6-10

SQLNET.KERBEROS5_KEYTAB parameter, OAS 6-10, NET C-20

SQLNET.KERBEROS5_REALMS parameter, OAS 6-10, NET C-20

sqlnet.log file, NET 12-19

sample client-side error stack, NET 12-18

sqlnet.ora file, PSG 3-21, PSG 3-40

AUTOMATIC_IPC, MIG F-14

Common sample, OAS A-3

configuration parameter reference, NET C-5 to NET C-30

CyberSafe sample, OAS A-3

default configuration, PSG 3-21

Identix sample, OAS A-3

Kerberos sample, OAS A-3

migrating, MIG F-14

modifying so CDS can resolve names, OAS 14-19

NAMES.DIRECTORY_PATH parameter, OAS 14-19

Oracle Advanced Security checksum sample, OAS A-2

Oracle Advanced Security encryption sample, OAS A-2

OSS.SOURCE.MY_WALLET parameter, OAS 10-12, OAS 10-21

parameters

AUTOMATIC_IPC, NET C-80

BEQUEATH_DETACH, NET 10-12, NET C-5

DAEMON.TRACE_DIRECTORY, NET C-5

DAEMON.TRACE_LEVEL, NET C-6

DAEMON.TRACE_MASK, NET C-6

DISABLE_OOB, NET C-6

LOG_DIRECTORY_CLEINT, NET C-7

LOG_DIRECTORY_SERVER, NET C-7

LOG_FILE_CLIENT, NET C-7

LOG_FILE_SERVER, NET C-7

NAMES_DIRECTORY_PATH, NET C-8

NAMESCTL_INTERNAL_ENCRYPT_PASSWORD, NET C-10

NAMESCTL.INTERNAL_USE, NET C-11

NAMESCTL.NO_INITIAL_SERVER, NET C-11

NAMESCTL.NOCONFIRM, NET C-11

NAMESCTL.SERVER_PASSWORD, NET C-11

NAMESCTL.TRACE_DIRECTORY, NET C-12

NAMESCTL.TRACE_FILE, NET C-12

NAMESCTL.TRACE_LEVEL, NET C-12

NAMESCTL.TRACE_UNIQUE, NET C-12

NAMES.DCE_PREFIX, NET C-7

NAMES.DEFAULT_DOMAIN, NET 8-17, NET C-8

NAMES.DIRECTORY_PATH, NET 8-19

NAMES.INITIAL_RETRY_TIMEOUT, NET C-8

NAMES.MAX_OPEN_CONNECTIONS, NET C-9

NAMES.MESSAGE_POOL_START_SIZE, NET C-9

NAMES.NDS.NAME.CONTEXT, NET C-9

NAMES.NIS.META_MAP, NET C-9

NAMES.PREFERRED_SERVERS, NET 8-26, NET C-10

NAMES.REQUEST_RETRIES, NET C-10

OSS.MY.WALLET, NET C-13

SQLNET_CRYPTO_CHECKSUM_TYPE_CLIENT, NET C-15

SQLNET_CRYPTO_CHECKSUM_TYPE_SERVER, NET C-15

SQLNET.ALTERNATE_PORT, NET C-21

SQLNET.AUTHENTICATION_GSSAPI_ SERVICE, NET C-14

SQLNET.AUTHENTICATION_KERBEROS5_ SERVICE, NET C-14

SQLNET.AUTHENTICATION_SERVICES, NET C-13

SQLNET.CLIENT_AUTHENTICATION, NET C-23

SQLNET.CLIENT_REGISTRATION, NET C-14

SQLNET.CRYPTO_CHECKSUM_CLIENT, NET C-14

SQLNET.CRYPTO_CHECKSUM_SERVER, NET C-15

SQLNET.CRYPTO_SEED, NET C-16

SQLNET.ENCRYPTION_SERVER, NET C-17

SQLNET.ENCRYPTION_TYPES_CLIENT, NET C-17

SQLNET.ENCRYPTION_TYPES_SERVER, NET C-18

SQLNET.ENCYRPTION_CLIENT, NET C-16

SQLNET.EXPIRE_TIME, NET C-18

SQLNET.IDENTIX_FINGERPRINT_DATABASE, NET C-18

SQLNET.IDENTIX_FINGERPRINT_DATABASE_PASSWORD, NET C-19

SQLNET.IDENTIX_FINGERPRINT_DATABASE_USER, NET C-19

SQLNET.IDENTIX_FINGERPRINT_METHOD, NET C-19

SQLNET.KERBEROS5_CC_NAME, NET C-19

SQLNET.KERBEROS5_CLOCKSKEW, NET C-20

SQLNET.KERBEROS5_CONF, NET C-20

SQLNET.KERBEROS5_KEYTAB, NET C-20

SQLNET.KERBEROS5_REALMS, NET C-20

SQLNET.RADIUS_ALTERNATE, NET C-21

SQLNET.RADIUS_ALTERNATE_RETRIES, NET C-21

SQLNET.RADIUS_AUTHENTICATION, NET C-21

SQLNET.RADIUS_AUTHENTICATION_INTERFACE, NET C-22

SQLNET.RADIUS_AUTHENTICATION_PORT, NET C-22

SQLNET.RADIUS_AUTHENTICATION_RETRIES, NET C-22

SQLNET.RADIUS_AUTHENTICATION_TIMEOUT, NET C-22

SQLNET.RADIUS_CHALLENGE_RESPONSE, NET C-23

SQLNET.RADIUS_SECRET, NET C-23

SQLNET.RADIUS_SEND_ACCOUNTING, NET C-23

SSL_CIPHER_SUITES, NET C-24

SSL_VERSION, NET C-24

TNSPING.TRACE_DIRECTORY, NET C-24

TNSPING.TRACE_LEVEL, NET C-25

TRACE_DIRECTORY_CLIENT, NET C-25

TRACE_DIRECTORY_SERVER, NET C-25

TRACE_FILE_CLIENT, NET C-25

TRACE_FILE_SERVER, NET C-25

TRACE_FILEN_CLIENT, NET C-26

TRACE_FILEN_SERVER, NET C-26

TRACE_FILENO_CLIENT, NET C-26

TRACE_FILENO_SERVER, NET C-27

TRACE_LEVEL_CLIENT, NET C-27

TRACE_LEVEL_SERVER, NET C-27

TRACE_TIMESTAMP_CLIENT, NET C-28

TRACE_TIMESTAMP_SERVER, NET C-28

TRACE_UNIQUE_CLIENT, NET C-28

USE_CMAN, NET 8-21, NET C-29

USE_DEDICATED_SERVER, NET 8-21, NET C-30

parameters for clients and servers using CyberSafe, OAS B-2

parameters for clients and servers using Identix, OAS B-2

parameters for clients and servers using Kerberos, OAS B-5

parameters for clients and servers using RADIUS, OAS B-6

parameters for clients and servers using SecurID, OAS B-5

parameters for clients and servers using SSL, OAS B-11

parameters for FIPS 140-1, OAS D-2

Radius sample, OAS A-3

sample, OAS A-2

SecurID sample, OAS A-4

SERVICE parameter, OAS B-2

SQLNET.AUTHENTICATION_GSSAPI_ parameter, OAS B-2

SQLNET.AUTHENTICATION_GSSAPI_SERVICE parameter, OAS 5-7, OAS 9-3

SQLNET.AUTHENTICATION_KERBEROS5_SERVICE parameter, OAS 6-8

SQLNET.AUTHENTICATION_SERVICES parameter, OAS 5-7, OAS 6-8, OAS 7-8, OAS 8-10, OAS 9-3, OAS 10-18, OAS 10-19, OAS 10-30, OAS 11-3, OAS 11-5, OAS B-2

SQLNET.CRYPTO_CHECKSUM_CLIENT parameter, OAS 2-14, OAS A-8

SQLNET.CRYPTO_CHECKSUM_SERVER parameter, OAS 2-14, OAS A-8

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT parameter, OAS 2-14, OAS A-9

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER parameter, OAS 2-14, OAS A-9

SQLNET.CRYPTO_SEED parameter, OAS 2-13, OAS A-10

SQLNET.ENCRYPTION_CLIENT parameter, OAS A-5

SQLNET.ENCRYPTION_SERVER parameter, OAS 2-12, OAS A-5

SQLNET.ENCRYPTION_TYPES_CLIENT parameter, OAS 2-13, OAS A-7

SQLNET.ENCRYPTION_TYPES_SERVER parameter, OAS 2-12, OAS A-6

SQLNET.FIPS_140 parameter, OAS D-3

SQLNET.IDENTIX_FINGERPRINT_DATABASE parameter, OAS 8-10

SQLNET.IDENTIX_USE_MD5HASH parameter, OAS B-2

SQLNET.KERBEROS5_CC_NAME parameter, OAS 6-9

SQLNET.KERBEROS5_CLOCKSKEW parameter, OAS 6-9

SQLNET.KERBEROS5_CONF parameter, OAS 6-9

SQLNET.KERBEROS5_CONF_MIT parameter, OAS 6-10

SQLNET.KERBEROS5_KEYTAB parameter, OAS 6-10

SQLNET.KERBEROS5_REALMS parameter, OAS 6-10

SSL sample, OAS A-2

SSL_CIPHER_SUITES parameter, OAS 10-27

SSL_CLIENT_AUTHENTICATION parameter, OAS 10-29

SSL_CLIENT_AUTHETNICATION parameter, OAS 10-12

SSL_VERSION parameter, OAS 10-18, OAS 10-28

Trace File Set Up sample, OAS A-2

upgrading, MIG F-14

sqlnet.ora, configuring for replication, OID 10-4

sqlnetpid.trc file, NET C-28

SQLNET.RADIUS_ALTERNATE parameter, OAS 4-20, NET C-21

SQLNET.RADIUS_ALTERNATE_PORT parameter, OAS 4-20

SQLNET.RADIUS_ALTERNATE_RETRIES parameter, OAS 4-20, NET C-21

SQLNET.RADIUS_ALTERNATE_TIMEOUT parameter, OAS 4-20

SQLNET.RADIUS_AUTHENTICATION parameter, NET C-21

SQLNET.RADIUS_AUTHENTICATION_INTERFACE parameter, NET C-22

SQLNET.RADIUS_AUTHENTICATION_PORT parameter, NET C-22

SQLNET.RADIUS_AUTHENTICATION_RETRIES parameter, NET C-22

SQLNET.RADIUS_AUTHENTICATION_TIMEOUT parameter, NET C-22

SQLNET.RADIUS_CHALLENGE_RESPONSE parameter, NET C-23

SQLNET.RADIUS_CLASSPATH parameter, OAS 4-18

SQLNET.RADIUS_SECRET parameter, NET C-23

SQLNET.RADIUS_SEND_ACCOUNTING parameter, OAS 4-23, NET C-23

sqlnet.trc file, NET 12-34, NET C-25

SQLNUL subroutine

example, PCO 11-22

parameters, PCO 11-21

purpose, PCO 11-21

syntax, PCO 11-21

sqlnul() function

example of using, PC_ 15-18

purpose of, PC_ 15-18

syntax for, PC_ 15-18

use of with T variable, PC_ 15-9

sqlnult() function

see SQLColumnNullCheck(), PC_ 5-53

SQLNumberPrecV6, PC_ 5-53

SQLNumberPrecV7, PC_ 5-53

SQLPR2 subroutine, PCO 11-21

sqlpr2() function, PC_ 15-17

sqlpr2t() function

see SQLNumberPrecV7, PC_ 5-53

SQLPRC subroutine

example, PCO 11-20

parameters, PCO 11-20

purpose, PCO 11-20

syntax, PCO 11-20

sqlprc() function, PC_ 15-16

sqlprct() function

see SQLNumberPrecV6, PC_ 5-53

SQLROWIDGET

retrieving ROWID of last row inserted, PCO 4-33

SQLRowidGet(), PC_ 5-53

SQLSQLDAAlloc, PC_ 5-52

SQLSQLDAFree(), PC_ 5-52

SQLSTATE

class codes, PC_ 9-4

declaring, PC_ 9-4, PCO 8-4

mapping to Oracle errors, PC_ 9-6

predefined classes, PC_ 9-5

status codes, PC_ 9-6

status variable, PC_ 9-2, PC_ 9-3

using, PC_ 9-13

values, PC_ 9-4

with MODE=ANSI, PC_ 10-31

SQLSTATE status variable

class code, PCO 8-4

coding scheme, PCO 8-4

effect of MODE option, PCO 8-3

interpreting values, PCO 8-4

predefined classes, PCO 8-5

predefined status codes and conditions, PCO 8-31

subclass code, PCO 8-4

usage, PCO 8-3

SQLSTM parameter, PCO 8-22

SQLSTM routine, PCO 8-22

SQLStmt object, ADG 1-16

SQLStmtGetText, PC_ 5-53

SQLSvcCtxGet function in SQLLIB, PC_ 5-48

SQLSvcCtxGet(), PC_ 5-53

SQLT typecodes, OCI 3-25

SQLT_NTY

bind example, OCI 12-13

define example, OCI 12-14

description, OCI 3-18

pre-allocating object memory, OCI 12-5

SQLT_REF

definition, OCI 3-18

description, OCI 3-18

SQLVarcharGetLength, PC_ 5-53

sqlvcp() function, see SQLLIB

function SQLVarcharGetLength, PC_ 4-22

sqlvcpt() function

see SQLVarcharGetLength, PC_ 5-53

sqlwarn

flag, PC_ 9-22

SQLWARN(4) flag, PCO 8-12

SQLWARNING

conditionWHENEVER directive, PCO F-93

WHENEVER directive condition, PC_ F-119

SQLWARNING condition, PCO 8-15

in the WHENEVER statement, PC_ 9-24

meaning of, PC_ 9-24

of WHENEVER directive, PCO 8-15

SQRT function, SQL 4-85

square brackets, defined, NET xx, PSG xxiii

SRC parameter, NET 8-36, NET C-76

SRV parameter, NET 8-36, NET C-76

SRX locks

LOCK Table command, ADG 7-15

SS date format element, SQL 2-46

SSL, OAS 1-8, OID 4-5, GTK 2-8, GTK 3-70

application level firewalls, OAS 10-10

attribute values, OID F-4

authenticated access, OID 1-5

authentication, OID 9-8

client and server, OID 4-6

for Oracle Directory Manager, OID 4-6

one-way, OID 4-6

server only, OID 4-6

two-way, OID 4-6

authentication modes, OAS 10-2

authentication parameters, OAS B-11

authentication process in an Oracle environment, OAS 10-6

authentication, for Oracle Directory Manager, OID 4-6

authorization, OAS 10-10

certificate, OAS 10-4

certificate authority, OAS 10-4

cipher suites, OAS B-12, OID 8-2

configuring, OAS 10-22

SSL_RSA_EXPORT_WITH_DES40_CBC_SHA, OID 8-2

SSL_RSA_EXPORT_WITH_RC4_40_MD5, OID 8-2

SSL_RSA_WITH_NULL_MD5, OID 8-2

SSL_RSA_WITH_NULL_SHA, OID 8-2

supported in Oracle Internet Directory, OID 8-2

client authentication parameter, OAS B-13

client scenarios, OID 8-2

components, OID 2-22

components in an Oracle environment, OAS 10-4

configuration parameters, OID 8-2

modifying, OID 8-3

configuration set entry, OID 5-3

configuring, OID 4-4

configuring cipher suites, OAS 10-22

configuring on the client, OAS 10-11

configuring on the server, OAS 10-19

data privacy, OID 1-5

default port, OID 2-24, OID F-5

disabling, OID F-5

enable, OID 5-3

enabling, OAS 10-10, OID 8-2, OID A-7, OID A-8, OID A-10, OID A-11, OID A-15, OID F-5

handshake, OAS 10-6, OID 2-23, OID 8-2

how it works, OID 2-23

limitations, OAS 10-10

modifying orclsslwalleturl parameter, OID 5-10, OID F-6

no authentication, OID 2-22, OID 4-6, OID F-5

for access control subject, OID 9-24, OID 9-30

one-way authentication, OID 2-22

for access control subjects, OID 9-24, OID 9-30

parameters, OID 8-2

password, OID 4-6

performance, OAS 10-10

port 636, OID 8-2

privileges, OAS 10-10

Public Key Infrastructure, GTK 3-73

requiring client authentication, OAS 10-28

roles, OAS 10-10

sample for sqlnet.ora file, OAS A-2

schemaless users, OAS 17-13

Secure Sockets Layer, OAS 10-2

strong authentication, OID 2-21

system requirements, OAS 1-14

toggling on and off, OID F-5

two-way authentication, OID 2-22, OID F-5

for access control subjects, OID 9-24, OID 9-30

Version 2, OID 8-2

Version 3, OID 8-2

version parameter, OAS B-13

wallet, OAS 10-4

wallet location, parameter, OAS B-14

wallets, OID 2-23, OID F-5, OID F-6

changing location of, OID 5-10, OID F-6

changing passwords, OID 5-10, OID F-6

with other authentication methods, OAS 10-7

X.509v3 certificates, GTK 3-71

SSL authentication for directory naming, NET 2-51

SSL authentication method

see Oracle Advanced Security

SSL. See Secure Sockets Layer.

SSL_CIPHER_SUITES parameter, OAS 10-27, NET C-24

SSL_CLIENT_AUTHENTICATION parameter, OAS 10-12, OAS 10-22, OAS 10-29

SSL_VERSION parameter, OAS 10-18, OAS 10-28, NET C-24

SSL_Version_2_0 - oracle.security.ssl.OracleSSLProtocolVersion.SSL_Version_2_0, OAS F-23

SSL_Version_3_0 - oracle.security.ssl.OracleSSLProtocolVersion.SSL_Version_3_0, OAS F-24

SSL_Version_3_0_Only - oracle.security.ssl.OracleSSLProtocolVersion.SSL_Version_3_0_Only, OAS F-24

SSL_Version_3_0_With_2_0_Hello - oracle.security.ssl.OracleSSLProtocolVersion.SSL_Version_3_0_With_2_0_Hello, OAS F-24

SSL_Version_Undetermined - oracle.security.ssl.OracleSSLProtocolVersion.SSL_Version_Undetermined, OAS F-24

SSLenable, configuration set entry, OID 5-3

SSLSocketSession - oracle.security.ssl.SSLSocketSession, OAS F-49

SSLSocketSession() - oracle.security.ssl.SSLSocketSession.SSLSocketSession(), OAS F-50

SSLSocketTest - oracle.security.ssl.SSLSocketTest, OAS F-52

SSSSS date format element, SQL 2-46

stack, PLS 9-13

stack communications

client application, NET 3-6

described, NET 3-2

Network Interface, NET 3-8

Network Session, NET 3-8

NI, NET 3-8

NS, NET 3-8

OCI, NET 3-7

Oracle Call Interface, NET 3-7

Oracle protocols, NET 3-9

server side interaction, NET 3-9

TTC, NET 3-7

stack space, SCN 7-15

stack, technology, OID 14-3

STag - oracle.xml.parser.v2.XMLToken.STag, JPR 4-138

staging

databases, DWG 8-2

file systems, DWG 4-9

files, DWG 8-2

staging databases, DWG 8-2

STagName - oracle.xml.parser.v2.XMLToken.STagName, JPR 4-138

STALE status

of redo log members, SAD 6-15

STALE_TOLERATED mode, DWG 19-26

standalone procedures

dropping, SQL 7-493

stand-alone Recovery Manager commands, RMN 1-8

standalone subprograms, PLS 1-18

standard cards

using SecurID, OAS 7-11

Standard Header Files, PC_ E-2

STANDARD package, STU 13-4

standard SQL, SQL B - 1

Oracle extensions to, SQL B - 5

standards, SCN 1-3

ANSI, ADG 7-17

ANSI/ISO, SCN 1-3, SCN 255, SCN 266

isolation levels, SCN 212, SCN 221

FIPS, SCN 14

integrity constraints, SCN 255, SCN 266

Oracle adherence, SCN 1-3

standby control file

creating, SQL 7-20

standby database

activating, SQL 7-11

compatibility, MIG 9-41

designing media recovery, SQL 7-12

migrating, MIG 8-6

migrating to Oracle8i, MIG 8-6

mounting, SCN 5-7, SQL 7-11

recovering, SQL 7-13, SQL 7-14

survivability, SCN 367

upgrading, MIG 8-6

standby databases, PSA 14-17

activating, SBY 1-12, SBY 1-19, SBY 3-20

advantages, SBY 1-2

altering control files, SBY 4-12, SBY 5-26

archived redo logs

transmitting, SBY 3-13

backing up, SBY 4-16

commands, SBY 1-28

configuration of environment, SBY 1-19, SBY 2-2

configuration options, SBY 1-2

control files

altering, SBY 5-26

creating, SBY 2-8, SBY 5-15

refreshing, SBY 4-15, SBY 5-26

creating

on remote host, SBY 5-14

on same host, SBY 5-2

procedures, SBY 2-8, SBY 2-12, SBY 2-13, SBY 2-14, SBY 2-32

datafiles

creating, SBY 4-10

renaming, SBY 4-11

taking offline, SBY 4-13

description, SBY 1-2

direct path operations, SBY 4-13

effect of altering primary database, SBY 1-27

failover to, SBY 1-12, SBY 3-20

initialization parameters, SBY 2-19, SBY 5-9

invalidating, SBY 3-7

managed recovery mode, SBY 1-9, SBY 3-13

manual recovery mode, SBY 1-8

procedures, SBY 2-31, SBY 3-4

monitoring, SBY 4-2

new features in 8.1.5, SBY xxvii

new features in 8.1.6, SBY xxvii

preparation for creating, SBY 2-2

read-only mode, SBY 1-10, SBY 3-17

re-creating, SBY 5-44

redo log files

altering, SBY 4-12

responding to changes that affect, SBY 4-9

sustained recovery mode, SBY 1-9

testing, SBY 1-15

transmitting archived redo logs, SBY 3-13

with a time lag

bypassing, SBY 5-56

creating, SBY 5-52

managing, SBY 5-54

rolling back database, SBY 5-55

with no ongoing recovery, SBY 5-46

standby transmission mode

definition of, SAD 7-14

Net8 and, SAD 7-15

RFS processes and, SAD 7-15

STANDBY_ARCHIVE_DEST initialization parameter, SBY 2-21, SBY 5-9, SRF 1-115

STANDBY_ARCHIVE_DEST parameter

of ALTER SYSTEM, SQL 7-118

STAR hint, SQL 2-66, STU 7-19

star joins, DWG 16-3, STU 4-62

star queries, DWG 16-2

star transformation, DWG 16-5

star query, STU 4-62

star schemas

advantages, DWG 2-4

defining fact tables, DWG 2-5

dimensional model, DWG 2-3, DWG 16-2

redundancy, DWG 2-4

star transformation, DWG 16-2, STU 7-34

star transformations, DWG 16-5

restrictions, DWG 16-9

STAR_TRANSFORMATION hint, SQL 2-67, STU 7-34

STAR_TRANSFORMATION_ENABLED initialization parameter, SRF 1-116

STAR_TRANSFORMATION_ENABLED parameter, DWG 16-4, STU 7-35

of ALTER SESSION, SQL 7-95

star-query optimization, GTK 4-3

Start a Queue, ADQ 9-36

START CMAN command, NET 11-9

start columns

in partitioning and EXPLAIN PLAN statement, STU 5-15

START command

of CMCTL, NET A-92

of LSNRCTL, NET 7-5, NET 11-7, NET A-20

of NAMESCTL, NET 6-54, NET 6-59, NET 11-5, NET A-73

START statement in Oracle Trace, STU 14-21

START WITH clause, PLS 5-4

of ALTER MATERIALIZED VIEW...REFRESH, SQL 7-53

of CREATE SEQUENCE, SQL 7-373

of SELECT, SQL 7-577

of SELECT and subqueries, SQL 7-571

start() - oracle.jms.AQjmsConnection.start(), JPR 2-47

start(Session, boolean, boolean) - oracle.jms.AQjmsDestination.start(javax.jms.Session, boolean, boolean), JPR 2-71

START_CLIENT_CACHE command, NET 11-6, NET A-75

startElement(NSName, SAXAttrList) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.startElement(oracle.xml.parser.v2.NSName, oracle.xml.parser.v2.SAXAttrList), JPR 4-14

startElement(NSName, SAXAttrList) - oracle.xml.parser.v2.XMLDocumentHandler.startElement(oracle.xml.parser.v2.NSName, oracle.xml.parser.v2.SAXAttrList), JPR 4-88

starter database

overview, SAD 2-6

starting

an instance

with dispatchers, NET 9-7

with multi-threaded servers, NET 9-4

Console, PSG 6-12

databases, NET 11-8

directory servers, OID 3-3, OID 4-17, OID 4-18

using default configuration, OID 3-10

LDAP server instance, OID 3-3

listener, PSG 3-41

listeners, NET 11-7

Management Server, PSG 6-11

Net8 Assistant, NET 4-28

Net8 components, NET 11-4

Net8 Configuration Assistant, NET 4-27

OID Monitor, OID 3-2, OID 3-3

Oracle Connection Manager, NET 11-9

Oracle Data Gatherer, PSG 6-27

Oracle Directory Manager, OID 4-2

on Sun Solaris, OID 4-2

on UNIX, OID 4-2

on Windows 95, OID 4-2

on Windows NT, OID 4-2

Oracle Directory Replication Server, OID 3-6

Oracle Directory Server instances, OID 10-9

Oracle Enterprise Manager, PSG 6-10

Oracle Intelligent Agents, PSG 6-10

Oracle Names client cache, NET 11-6

Oracle Names servers, NET 6-54, NET 11-5

Oracle Parallel Server database, PSG 3-41, PSG 7-7

Oracle Performance Manager, PSG 8-5

from Console, PSG 6-28

standalone, PSG 6-28

replication server instances, OID 3-6

replication servers, OID 10-17

starting a database

exclusive mode, SAD 3-7

forcing, SAD 3-6

Oracle Enterprise Manager, SAD 3-4

parallel mode, SAD 3-7

PFILE option, SAD 3-3

recovery and, SAD 3-6

Recovery Manage, SAD 3-3

restricted mode, SAD 3-5

SQL*Plus, SAD 3-3

when control files unavailable, SAD 3-4

when redo logs unavailable, SAD 3-4

starting an instance

automatically at system startup, SAD 3-7

database closed and mounted, SAD 3-5

database name conflicts and, SAD 2-20

enabling automatic archiving, SAD 7-8

examples of, SAD 3-7

exclusive mode, SAD 3-7

forcing, SAD 3-6

mounting and opening the database, SAD 3-5

normally, SAD 3-5

Oracle Enterprise Manager, SAD 3-4

parallel mode, SAD 3-7

recovery and, SAD 3-6

Recovery Manager, SAD 3-3

remote instance startup, SAD 3-7

restricted mode, SAD 3-5

SQL*Plus, SAD 3-3

when control files unavailable, SAD 3-4

when redo logs unavailable, SAD 3-4

without mounting a database, SAD 3-4

starting an instance using SQL*Plus, PSA 4-2

starting up

after file operations, PSA 9-2, PSC A-20

database name, SRF 1-32

during instance recovery, PSA 3-3

exclusive mode, PSA 8-11

global constant parameters, PSA 1-9, PSC 7-7

instance number, SRF 1-47

remote instance, PSA 1-4, PSA 1-5, PSA 4-4

rollback segments, PSA 3-5, PSC 7-6

shared mode, PSC A-20

startup order, PSA 1-6, SRF 1-47

verifying access to files, PSC 7-2

start-server commands, OID 2-30, OID 3-2, OID 5-2

startup, SCN 5-2, SCN 5-5

allocation of the SGA, SCN 7-2

starting address, SCN 7-14

audit record, SCN 333

forcing, SCN 5-6

prohibited by dispatcher processes, SCN 8-21

recovery during, SCN 344

restricted mode, SCN 5-6

results, PSG 7-12

setting Parallel Server parameters for, PSG 7-24

steps, SCN 5-5

SYSDBA privilege, PSG 6-26

SYSOPER privilege, PSG 6-26

STARTUP command, PSA 1-5

MOUNT option, PSA 14-13

of NAMESCTL, NET A-75

PFILE option, PSA 1-4, PSA 1-5

specifying an instance, PSA 4-4

startup command (RMAN), RMN 10-152

STARTUP event

triggers on, SQL 7-431

STARTUP FORCE statement

crash recovery required, SCN 344

STARTUP statement

database name, SRF 1-32

MOUNT option, SAD 3-5, SBR 5-27, SBR 5-29

NOMOUNT option, SAD 2-10, SAD 3-4

RECOVER option, SAD 3-6

RESTRICT option, SAD 3-6

specifying database name, SAD 3-3

starting a database, SAD 3-3

startup types, PSG 7-8

force, PSG 7-8

mount, PSG 7-8

no mount, PSG 7-8

open, PSG 7-8

restrict, PSG 7-8

STARTUP_WAITTIME_listener_name parameter, NET C-56

state, ADQ 2-6

session, of package objects, ADG 9-17

STATE_EXPIRED - oracle.jms.AQjmsConstants.STATE_EXPIRED, JPR 2-55

STATE_PROCESSED - oracle.jms.AQjmsConstants.STATE_PROCESSED, JPR 2-55

STATE_READY - oracle.jms.AQjmsConstants.STATE_READY, JPR 2-55

STATE_WAITING - oracle.jms.AQjmsConstants.STATE_WAITING, JPR 2-55

statement failures, SBR 1-12

definition, SBR 1-12

statement handle

attributes, OCI A-15

description, OCI 2-10

statement terminator, PLS 11-15

statement triggers, SCN 89

conditional code for statements, ADG 13-17

described, SCN 89

row evaluation order, ADG 13-21

specifying SQL statement, ADG 13-5

timing, ADG 13-7

trigger evaluation order, ADG 13-21

UPDATE statements and, ADG 13-6, ADG 13-18

valid SQL statements, ADG 13-20

when fired, SCN 102

See also triggers

STATEMENT_ID column

PLAN_TABLE table, STU 5-4

statement-level read consistency, SCN 216

statement-level rollback, PCO 3-17

breaking deadlocks, PCO 3-17

description of, PC_ 3-22

to break deadlocks, PC_ 3-22

statement-level rollbacks, PLS 5-44

statements

See SQL statements

statements, PL/SQL

assignment, PLS 11-3

CLOSE, PLS 5-11, PLS 5-24, PLS 11-17

COMMIT, PLS 11-31

DELETE, PLS 11-52

dynamic SQL, PLS 10-2

EXECUTE IMMEDIATE, PLS 10-3

EXIT, PLS 11-65

FETCH, PLS 5-9, PLS 5-23, PLS 11-77

FORALL, PLS 4-32

GOTO, PLS 11-89

IF, PLS 11-91

INSERT, PLS 11-94

LOCK TABLE, PLS 11-100

LOOP, PLS 11-102

NULL, PLS 11-109

OPEN, PLS 5-8, PLS 11-119

OPEN-FOR, PLS 5-19, PLS 11-121

OPEN-FOR-USING, PLS 10-7

RAISE, PLS 11-138

RETURN, PLS 11-147

ROLLBACK, PLS 11-149

SAVEPOINT, PLS 11-153

SELECT INTO, PLS 11-154

SET TRANSACTION, PLS 11-161

UPDATE, PLS 11-172

static allocation, PSA 6-6

static arrays

binding, OCI 5-10

defining, OCI 5-22

STATIC clause

of ALTER TYPE, SQL 7-188

of CREATE TYPE, SQL 7-442

of CREATE TYPE BODY, SQL 7-448

static data dictionary views

added in Oracle8i, MIG C-2

changed in Oracle8i

added columns, MIG C-7

columns that may return NULLs, MIG C-15

dropped columns, MIG C-12

renamed columns, MIG C-14

obsolete in Oracle8i, MIG 9-25, MIG C-17

static hashing

lock mastering scheme, PSC 3-5

STATISTICS

Export parameter, SUT 1-24

statistics, DWG 19-31, STU 15-2, SUT 2-61

auditing conflict resolution, RAR 6-29

background checkpoints completed, SRF C-2

background checkpoints started, SRF C-2

background timeouts, SRF C-2

branch node splits, SRF C-2

buffer is not pinned count, SRF C-2

buffer is pinned count, SRF C-2

bytes received via SQL*Net from client, SRF C-3

bytes received via SQL*Net from dblink, SRF C-3

bytes sent via SQL*Net to client, SRF C-3

bytes sent via SQL*Net to dblink, SRF C-3

Cached Commit SCN referenced, SRF C-3

calls to get snapshot scn

kcmgss, SRF C-3

calls to kcmgas, SRF C-3

calls to kcmgcs, SRF C-3

calls to kcmgrs, SRF C-3

change write time, SRF C-3

checkpoint, SCN 8-11

cleanouts and rollbacks - consistent read gets, SRF C-3

cleanouts only - consistent read gets, SRF C-3

cluster key scan block gets, SRF C-3

cluster key scans, SRF C-3

cold recycle reads, SRF C-3

collecting, SPR 37-74, RAR 8-140

commit cleanout failures

block lost, SRF C-3

buffer being written, SRF C-4

callback failure, SRF C-4

cannot pin, SRF C-4

hot backup in progress, SRF C-4

write disabled, SRF C-4

commit cleanouts, SRF C-4

commit cleanouts successfully completed, SRF C-4

Commit SCN cached, SRF C-4

computing exactly, SQL 7-204

consistent changes, SRF C-4

consistent gets, SRF C-4, STU 19-28, STU 21-4, STU 21-21

CPU used by this session, SRF C-5

CPU used when call started, SRF C-5

CR blocks created, SRF C-5

cross instance CR read, SRF C-5

current blocks converted for CR, SRF C-5

current value, STU 15-4

cursor authentication, SRF C-5

data blocks consistent reads - undo records applied, SRF C-5

db block changes, SRF C-5

db block gets, SRF C-5, STU 19-28, STU 21-4

DBWR buffers scanned, SRF C-5

DBWR checkpoint buffers written, SRF C-5

DBWR checkpoints, SRF 1-63, SRF C-6

DBWR cross instance writes, SRF C-6

DBWR free buffers found, SRF C-6

DBWR lru scans, SRF C-6

DBWR make free requests, SRF C-6

DBWR revisited being-written buffer, SRF C-6

DBWR summed scan depth, SRF C-6

DBWR transaction table writes, SRF C-6

DBWR undo block writes, SRF C-6

DDL statements parallelized, SRF C-6

deferred (CURRENT) block cleanout applications, SRF C-7

deleting, RAR 6-30, SAD 19-4

deleting from the data dictionary, SQL 7-206

DFO trees parallelized, SRF C-7

dirty buffers inspected, SRF C-7

DLM, for monitoring contention, PSA 11-18

DML statements parallelized, SRF C-7

enqueue conversions, SRF C-7

enqueue deadlocks, SRF C-7

enqueue releases, SRF C-7

enqueue requests, SRF C-7

enqueue timeouts, SRF C-7

enqueue waits, SRF C-7

estimated, SCN 137

block sampling, SCN 138, STU 8-3

row sampling, SCN 138, STU 8-3

estimating, DWG 18-67, SQL 7-204

exchange deadlocks, SRF C-7

execute count, SRF C-7

exporting and importing, SCN 131, STU 8-2

extensible optimization, SCN 140, STU 4-32

forcing disassociation, SQL 7-471

free buffer inspected, SRF C-7

free buffer requested, SRF C-7

from ANALYZE, SCN 137, STU 8-4

from B*-tree or bitmap index, SCN 136, STU 8-6

functions, DWG 17-46

gathering with DBMS_STATS package, STU 8-6

generating, STU 8-3

generating and managing with DBMS_STATS, SCN 135, STU 8-5

generating for cost-based optimization, STU 8-3

global cache cr block log flush time, SRF C-8, SRF C-9

global cache cr block send time, SRF C-8

global cache cr timeouts, SRF C-8

global cache defers, SRF C-8

global cache freelist waits, SRF C-8

global cache get time, SRF C-8

global cache gets, SRF C-8

global cache prepare failures, SRF C-9

global cache, analyzing, PSA 12-11

global lock async converts, SRF C-9

global lock async gets, SRF C-9

global lock convert time, SRF C-9

global lock get time, SRF C-9

global lock release time, SRF C-9

global lock releases, SRF C-9

global lock sync converts, SRF C-9

global lock sync gets, SRF C-9

HIGH_VALUE and LOW_VALUE, STU 4-26

hot buffers moved to head of LRU, SRF C-9

immediate (CR) block cleanout applications, SRF C-9

immediate (CURRENT) block cleanout applications, SRF C-9

index fast full scans (direct read), SRF C-9

index fast full scans (full), SRF C-9

index fast full scans (rowid ranges), SRF C-9

instance recovery database freeze count, SRF C-9

kcmccs called get current scn, SRF C-10

kcmccs read scn without going to DLM, SRF C-10

kcmggs waited for batching, SRF C-10

leaf node splits, SRF C-10

logons cumulative, SRF C-10

logons current, SRF C-10

max session memory, STU 19-24

messages received, SRF C-10

messages sent, SRF C-10

native hash arithmetic execute, SRF C-10

native hash arithmetic fail, SRF C-10

next scns gotten without going to DLM, SRF C-10

no buffer to keep pinned count, SRF C-10

no work - consistent read gets, SRF C-10

on indexes, SQL 7-301

opened cursors cumulative, SRF C-10

opened cursors current, SRF C-10

opens of replaced files, SRF C-11

opens requiring cache replacement, SRF C-11

operating system, DWG 18-75

OS All other sleep time, SRF C-11

OS Chars read and written, SRF C-11

OS Data page fault sleep time, SRF C-11

OS Input blocks, SRF C-11

OS Involuntary context switches, SRF C-11

OS Kernel page fault sleep time, SRF C-11

OS Major page faults, SRF C-11

OS Messages received, SRF C-11

OS Messages sent, SRF C-11

OS Minor page faults, SRF C-11

OS Other system trap CPU time, SRF C-11

OS Output blocks, SRF C-11

OS Process heap time, SRF C-11

OS Signals received, SRF C-11

OS Swaps, SRF C-11

OS System call CPU time, SRF C-11

OS System calls, SRF C-12

OS Text page fault sleep time, SRF C-12

OS User level CPU time, SRF C-12

OS User lock wait sleep time, SRF C-12

OS Voluntary context switches, SRF C-12

OS Wait-cpu (latency) time, SRF C-12

Process stack size, SRF C-11

optimizer goal, STU 4-11

optimizer mode, STU 4-10

optimizer use of, SCN 130, SCN 131, STU 4-10, STU 4-12, STU 8-2

OS Input blocks, SRF C-11

Parallel operations downgraded 1 to 25 pct, SRF C-12

Parallel operations downgraded 25 to 50 pct, SRF C-12

Parallel operations downgraded 50 to 75 pct, SRF C-12

Parallel operations downgraded 75 to 99 pct, SRF C-12

Parallel operations downgraded to serial, SRF C-12

Parallel operations not downgraded, SRF C-12

parse count (hard), SRF C-12

parse count (total), SRF C-12

parse time cpu, SRF C-12

parse time elapsed, SRF C-13

partitioned tables and indexes, SCN 11-13

partitions and subpartitions, SCN 134, STU 8-4

physical reads, SRF C-13, STU 19-28

physical reads direct, SRF C-13

physical writes, SRF C-13

physical writes direct, SRF C-13

physical writes non checkpoint, SRF C-13

pinned buffers inspected, SRF C-13

prefetched blocks, SRF C-13

prefetched blocks aged out before use, SRF C-13

process last non-idle time, SRF C-13

purging, SPR 37-70, RAR 8-136

PX local messages recv'd, SRF C-14

PX local messages sent, SRF C-14

PX remote messages recv'd, SRF C-14

PX remote messages sent, SRF C-14

queries parallelized, SRF C-14

query servers, STU 21-15

queuing, SCN 77

rate of change, STU 15-4

recording for tuning, PSA 11-5

recovery array read time, SRF C-14

recovery array reads, SRF C-14

recovery blocks read, SRF C-14

recursive calls, SRF C-14

recursive cpu usage, SRF C-14

redo blocks written, SRF C-14

redo buffer allocation retries, SRF C-14

redo entries, SRF C-14

redo log space requests, SRF C-15

redo log space wait time, SRF C-15

redo log switch interrupts, SRF C-15

redo ordering marks, SRF C-15

redo size, SRF C-15

redo sync writes, SRF C-15

redo synch time, SRF C-15

redo wastage, SRF C-15

redo write time, SRF C-16

redo writer latching time, SRF C-16

redo writes, SRF C-16

remote instance undo block writes, SRF C-16

remote instance undo header writes, SRF C-16

rollback changes - undo records applied, SRF C-16

rollbacks only - consistent read gets, SRF C-16

rows fetched via callback, SRF C-16

selectivity of predicates, SCN 131, STU 8-2

histograms, SCN 131, SCN 133, STU 8-17

user-defined, SCN 141, STU 4-33

serializable aborts, SRF C-16

session connect time, SRF C-16

session cursor cache count, SRF C-16

session cursor cache hits, SRF C-16

session logical reads, SRF C-17

session memory, STU 19-24

session pga memory, SRF C-17

session pga memory max, SRF C-17

session stored procedure space, SRF C-17

session uga memory, SRF C-17

session uga memory max, SRF C-17

shared server processes, STU 19-7, STU 21-9

sorts (disk), SRF C-17, STU 20-35

sorts (memory), SRF C-17, STU 20-35

sorts (rows), SRF C-17

specifying for Export, SUT 1-24, SUT 2-25

SQL*Net roundtrips to/from client, SRF C-17

SQL*Net roundtrips to/from dblink, SRF C-17

summed dirty queue length, SRF C-17

switch current to new buffer, SRF C-18

table fetch by rowid, SRF C-18

table fetch continued row, SRF C-18

table scan blocks gotten, SRF C-18

table scan rows gotten, SRF C-18

table scans (cache partitions), SRF C-18

table scans (direct read), SRF C-18

table scans (long tables), SRF C-19

table scans (rowid ranges), SRF C-19

table scans (short tables), SRF C-19

timed, SRF 1-118

total file opens, SRF C-19

transaction lock background get time, SRF C-19

transaction lock background gets, SRF C-19

transaction lock foreground requests, SRF C-19

transaction lock foreground wait time, SRF C-19

transaction rollbacks, SRF C-19

transaction tables consistent read rollbacks, SRF C-19

transaction tables consistent reads - undo records applied, SRF C-19

undo block, STU 21-3

Unnecessary process cleanup for SCN batching, SRF C-19

updating, SAD 19-4

user calls, SRF C-20

user commits, SRF C-20

user rollbacks, SRF C-20

user-defined

dropping, SQL 7-478, SQL 7-480, SQL 7-482, SQL 7-492, SQL 7-501, SQL 7-506

user-defined statistics, SCN 141, STU 4-33

views containing, PSA 11-5

where maintained, PSA 11-2

write clones created in background, SRF C-20

write clones created in foreground, SRF C-20

statistics generation for long running operations, GTK 3-27

statistics tables

upgrading, MIG 7-37

statistics types

associating

with columns, SQL 7-211

with datatypes, SQL 7-212

with domain indexes, SQL 7-212

with functions, SQL 7-212

with indextypes, SQL 7-212

with packages, SQL 7-212

disassociating

from columns, SQL 7-470

from domain indexes, SQL 7-470

from functions, SQL 7-470

from indextypes, SQL 7-470

from packages, SQL 7-470

from types, SQL 7-470

Statistics Views Support, ADQ 8-34, ADQ 12-19

STATS command, NET A-93

STATSPACK package, STU 11-7, STU 11-8, STU 18-2

status

propagation, SPR 11-7, RAR 8-22

status codes

meaning of, PC_ 9-14

status codes for error reporting, PCO 8-9

STATUS command

of CMCTL, NET A-95

of LSNRCTL, NET 11-7, NET A-22

of NAMESCTL, NET A-76

Status Details tab, PSG 7-13

from Edit Parallel Server dialog box, PSG 7-18

from Parallel Server Operation Results dialog box, PSG 7-13

Status tab

from Edit Parallel Server dialog box, PSG 7-17

status variables, PC_ 9-2

STDDEV aggregate function, PLS 5-3

STDDEV function, SQL 4-86

STDDEV_POP function, DWG 17-47

STDDEV_SAMP function, DWG 17-47

STDDEVP function, SQL 4-87

STDDEVS function, SQL 4-88

STEP clause

mimicking, PLS 3-12

stepwise refinement, PLS 1-2

STMLEN parameter, PCO 8-22

STMT_AUDIT_OPTION_MAP table

auditing option type codes, SRF 2-163

Stop a Queue, ADQ 9-39

STOP action

in the WHENEVER statement, PC_ 9-25

of WHENEVER directive, PC_ F-119, PCO 8-17, PCO F-93

result of, PC_ 9-25

stop columns

in partitioning and EXPLAIN PLAN statement, STU 5-15

STOP command

of CMCTL, NET A-96

of LSNRCTL, NET 11-7, NET A-24

of NAMESCTL, NET A-76

STOP statement in Oracle Trace, STU 14-21

stop() - oracle.jms.AQjmsConnection.stop(), JPR 2-47

stop(Session, boolean, boolean, boolean) - oracle.jms.AQjmsDestination.stop(javax.jms.Session, boolean, boolean, boolean), JPR 2-71

STOPNOW command

of CMCTL, NET A-97

stopping

listener for directory database, OID 10-6

Oracle Directory Replication Server, OID 3-8

Oracle Parallel Server database, PSG 7-9

replication server instances, OID 3-8

stop-server commands, OID 2-30, OID 3-2, OID 4-15

storage

altering tablespaces, SAD 9-12

clusters, SCN 10-53

datafiles, SCN 3-16

file, STU 20-5

fragmentation in parallel DDL, SCN 190

hash clusters, SCN 10-55

index partitions, SCN 11-36

indexes, SCN 10-28

logical structures, SCN 3-6, SCN 10-2

nested tables, ADO 7-3

nulls, SCN 10-8

object tables, ADO 7-1

parallel INSERT, SCN 153

quotas and, SAD 22-17

REFs, ADO 7-2

restricting for users, SCN 293

revoking tablespaces and, SAD 22-17, SCN 293

table partitions, SCN 11-26

tablespace quotas and, SCN 293

triggers, SCN 82, SCN 106

unlimited quotas, SAD 22-17

user quotas on, SCN 1-41

view definitions, SCN 10-15

storage access in clustered systems, PSC 2-5

storage character sets, NLS A-6

storage characteristics

resetting, SQL 7-611

STORAGE clause, SQL 7-605

CREATE TABLE statement, STU 20-24

examples, STU 20-24

modifying parameters, STU 20-33

modifying SQL.BSQ file, STU 20-33

of ALTER CLUSTER, SQL 7-4

of ALTER INDEX, SQL 7-31, SQL 7-36

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER MATERIALIZED VIEW LOG, SQL 7-58

of ALTER ROLLBACK SEGMENT, SQL 7-78, SQL 7-79

of CREATE CLUSTER, SQL 7-256

of CREATE INDEX, SQL 7-300

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-334

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG. See CREATE TABLE

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.

of CREATE ROLLBACK SEGMENTS, SQL 7-368

of CREATE TABLE, SQL 7-384, SQL 7-394

of CREATE TABLESPACE, SQL 7-420

OPTIMAL parameter, STU 20-30

parallel execution, SCN 190

parallel query, DWG 18-58

using, SCN 4-12

See also storage parameters

storage devices

configuring, LEG 3-2

on UNIX, LEG 3-7, LEG 3-8

on Windows, LEG 3-8, LEG 3-9, LEG 3-10

labeled volumes, LEG 3-11

labeling a volume

on UNIX, LEG 3-14

on Windows, LEG 3-15, LEG 3-16

labeling and mounting volumes, LEG 3-13

LSM server features, LEG 3-2

mounting a volume

on UNIX, LEG 3-16

on Windows, LEG 3-17

recycling volumes, LEG 3-20

removing storage volumes from media index, LEG 3-20

resource attributes, LEG 3-5

tape device

auto media management, LEG 3-19

no-rewind device name to prevent data loss, LEG 3-2

types that LSM supports, LEG 3-2

unmounting a volume

on UNIX, LEG 3-18

on Windows, LEG 3-18

volume pools, LEG 3-10, LEG 3-11, LEG 3-12

STORAGE IN ROW clause

of ALTER TABLE, SQL 7-141

STORAGE keyword, SUT 8-29

storage options

clustered tables, PSA 8-4, PSC A-22

extent size, PSA 8-9, PSA 8-11, PSA 8-12, PSC 7-7

index, PSA 8-6

rollback segment, PSC 7-7

table, PSA 8-4

storage parameters, SUT 2-50

altering, SAD 13-12

applicable objects, SAD 12-8

data dictionary, SAD 19-26

default, SAD 12-8

estimating export requirements, SUT 1-9

example, SAD 12-13

exporting tables, SUT 1-17

for the data dictionary, SAD 19-27

INITIAL, SAD 13-12

INITRANS, SAD 13-12

MAXEXTENTS UNLIMITED, SCN 197

MAXTRANS, SAD 13-12

MINEXTENTS, SAD 13-12

NEXT, SCN 153

OPTIMAL (in rollback segments), SAD 11-6, SCN 4-26, SCN 197

OPTIMAL parameter, SUT 2-50

overriding

Import, SUT 2-51

parallel direct-load INSERT, SCN 153

PCTFREE, ADG 2-9, SAD 13-12

PCTINCREASE, SCN 153

PCTUSED, ADG 2-9, SAD 13-12

preallocating

direct path load, SUT 8-16

precedence of, SAD 12-13

rollback segments, SAD 11-7

setting, SAD 12-8 to SAD 12-13, SCN 4-12

snapshot log

altering, RAR 7-17

SYSTEM rollback segment, SAD 11-9

temporary for a direct path load, SUT 8-11

temporary segments, SAD 12-13

STORAGE_ERROR exception, PLS 6-6

when raised, PLS 7-39

STORE AS clause, ADO 9-29

STORE IN clause, SAD 15-11

STORE IN DEFAULT clause

of CREATE INDEX, SQL 7-303

STORE IN tablespace clause

of CREATE INDEX, SQL 7-303

store tables, PLS 4-4

store-and-forward replication. See asynchronous replication

store-and-forward transport, in Oracle8i, OID 2-14

stored functions, ADG 9-5, SCN 44, SCN 48, SQL 7-285

creating, ADG 9-9

describing, OCI 6-2

importing, SUT 2-58

stored outlines

creating and using, STU 10-4

downgrading, MIG 13-44

execution plans and plan stability, STU 10-2

hints, STU 10-3

matching with SQL statements, STU 10-3

moving tables, STU 10-7

OUTLN_PKG package, SPR 58-1

storage requirements, STU 10-4

using, STU 10-5

viewing data for, STU 10-6

stored packages

importing, SUT 2-58

stored procedure

opening a cursor, PCO 6-36

sample programs, PCO 6-36

stored procedures, ADG 9-5, SCN 24, SCN 44, SCN 48

argument values, ADG 9-52

calling, SCN 27

contrasted with anonymous blocks, SCN 53

creating, ADG 9-9

describing, OCI 6-2

direct path load, SUT 8-24

distributed query creation, ADG 9-46, DDS 3-3

encapsulating privileges, ADG 11-17

exceptions, ADG 9-43, ADG 9-44

importing, SUT 2-58

in Oracle Trace, STU 14-25

invoker's rights, ADG 11-10

invoking, ADG 9-49

Java, NLS 6-15

managing privileges, DDS 2-32

names of, ADG 9-5

opening a cursor, PCO 6-32

overloading names of, ADG 9-13

parameter

default values, ADG 9-9

privileges, ADG 9-52

privileges for recompiling, SAD 19-25

program example, PC_ 7-23

registering with the database, STU 11-8

remote, ADG 9-53

remote object security, DDS 2-32

remote objects and, ADG 9-54

sample programs, PCO 6-25

storing, ADG 9-9

synonyms, ADG 9-56

triggers contrasted with, SCN 82

turning into a web page, ADG 12-2

using privileges granted to PUBLIC, SAD 23-17

variables and constants, SCN 26

See also procedures

stored procedures, Java, GTK 3-18

stored scripts

creating, RMN 3-27

creating RMAN, RMN 3-27

deleting, RMN 3-28

executing, RMN 3-28

executing RMAN, RMN 3-28

listing all, RMN 3-29

managing, RMN 3-27

printing, RMN 3-29

Recovery Manager, RMN 1-11

replacing, RMN 3-28

stored subprogram

calling, PCO 6-22

creating, PCO 6-21

packaged versus standalone, PCO 6-21

stored versus inline, PCO D-4

using to improve performance, PCO D-4

stored subprogram, calling, PCO 6-21

stored subprograms, PLS 1-18

calling, PC_ 7-23

creating, PC_ 7-21

packaged versus stand-alone, PC_ 7-20

stored versus inline, PC_ 7-20

storing data

in multi-byte character sets, NLS 3-15

strategies

backup, SBR 3-4 to SBR 3-11

ARCHIVELOG mode, SBR 3-5

NOARCHIVELOG mode, SBR 3-4

recovery

determining when media recovery is necessary, SBR 3-18

stream

reading

temporary LOBs, ADL 10-58

tape drive, SAD 7-22

writing, ADL 10-152

Stream Message, ADQ 12-24

stream record format, SUT 5-90

stream record format records, SUT 3-6

streaming, ADL 9-76, ADL 9-91

do not enable buffering, when using, ADL 9-237

write, ADL 9-201

STRING

external datatype, OCI 3-12

string comparison semantics, PLS B-2

string comparisons, SUT 5-15

and WHERE clause, NLS 4-8

SQL*Loader, SUT 5-46

STRING datatype, PC_ 4-6, PCO 4-9

string host variables

declaring, PC_ 5-8

string literals, PLS 2-9

continuing on the next line, PCO 2-13

string manipulation using OCI, NLS 5-7

STRING subtype, PLS 2-19

strings

passing as parameters, OCI 2-31

striping, OID 13-8, OID 13-10, STU 20-22

analyzing, DWG 4-5

and disk affinity, DWG 18-47

example, DWG 14-10

examples, STU 20-23

local, DWG 4-4

manual, DWG 4-3, STU 20-23

media recovery, DWG 4-8

operating systems, DWG 4-3

temporary tablespace, DWG 18-52

strong authentication, OID 2-21

strong authentication for directory naming, NET 2-51

Struct Component Alignment, PC_ E-2

structs

array of, PC_ 8-17, PC_ A-2

as host variables, PC_ 4-39

C, using, PC_ 17-32

for collection object types, PC_ 18-3

generating C structs for a REF, PC_ 17-33

pointers as host variables, PC_ 4-47

structs (structures)

cannot be nested, PC_ 4-41

structural access items, OID 9-20

access control points, OID 9-20

modifying, OID 9-28

structural object class type, OID 2-8, OID 2-9

structural object classes, converting, OID 6-4

structure rules, not enforced by Oracle Internet Directory, OID 2-10

structure theorem, PLS 3-2

structure, audit log entries, OID 5-25

Structured Payload, ADQ 8-7

structured payload, ADQ 1-7

Structured Payload/Message Types, ADQ 12-20

Structured Query Language (SQL), SCN 1-51, SCN 10

See also SQL

Structured Query Language. See SQL

structures

arrays of, OCI 5-22

data blocks

shown in rowids, SCN 12-18

data dictionary, SCN 1-29, SCN 2-1

datafiles

shown in rowids, SCN 12-18

locking, SCN 239

logical, SCN 1-5, SCN 4-1

data blocks, SCN 1-7, SCN 4-2, SCN 4-3

extents, SCN 1-7, SCN 4-2, SCN 4-12

schema objects, SCN 1-6, SCN 10-2

segments, SCN 1-7, SCN 4-2, SCN 4-18

tablespaces, SCN 1-5, SCN 3-1, SCN 3-6

memory, SCN 1-12, SCN 7-1

physical, SCN 1-8

control files, SCN 1-10, SCN 362

datafiles, SCN 1-8, SCN 3-1, SCN 3-16

redo log files, SCN 1-9, SCN 347

processes, SCN 1-12, SCN 1-15, SCN 8-1

structures (structs)

nesting not permitted for host, PC_ 4-41

stubs, PLS 3-19, PLS 7-3

subclasses, OID 2-8

subconfig, OID F-4

subentries, OID 2-10

subordinate naming contexts, OID 2-19

SUBPARTITION BY HASH clause, SAD 15-11

of CREATE TABLE, SQL 7-387, SQL 7-403

SUBPARTITION clause, SAD 15-11, SAD 15-15, SAD 15-30, SCN 11-63

of ANALYZE, SQL 7-203

of CREATE INDEX, SQL 7-303

of CREATE TABLE, SQL 7-404

of DELETE, SQL 7-466

of INSERT, SQL 7-542

of LOCK TABLE, SQL 7-548

of SELECT, SQL 7-575

of UPDATE, SQL 7-618

subpartition locks

DML, SCN 11-46

subpartitioned

tables

loading, SUT 8-6

subpartition-extended table names, SQL 2-70

in DML statements, SQL 2-71

restrictions on, SQL 2-71

syntax, SQL 2-71

subpartitions, SAD 15-2

adding, SQL 7-156

adding rows to, SQL 7-540

allocating extents for, SQL 7-150, SQL 7-157

coalescing, SQL 7-156

converting into nonpartitioned tables, SQL 7-162

creating, SQL 7-387, SQL 7-404

deallocating unused space from, SQL 7-150, SQL 7-157

inserting rows into, SQL 7-542

locking, SQL 7-547

logging insert operations, SQL 7-152

moving to a different segment, SQL 7-158

physical attributes

changing, SQL 7-145

removing rows from, SQL 7-160, SQL 7-466

renaming, SQL 7-157

revising values in, SQL 7-618

specifying, SQL 7-403

statistics, SCN 134, STU 8-4

SUBPARTITIONS clause, SAD 15-11, SAD 15-15, SAD 15-30

of CREATE TABLE, SQL 7-403

subprogram, PL/SQL, PCO 6-4

subprogram, PL/SQL or Java, PCO 6-21

subprograms, PLS 7-2

advantages, PLS 7-3

declaring, PLS 7-10

how calls are resolved, PLS 7-27

local, PLS 1-18

overloading, PLS 7-24

packaged, PLS 1-18, PLS 7-11

parts, PLS 7-2

procedure versus function, PLS 7-6

recursive, PLS 7-39

standalone, PLS 1-18

stored, PLS 1-18

subqueries, DDS 2-33, SCN 21, SQL 5-19, SQL 7-569, SQL 7-572

CHECK constraints prohibit, SCN 271

containing subqueries, SQL 5-25

converting to joins, STU 4-74

correlated, DWG 18-49, SQL 5-25

defined, SQL 5-19

definition of, PC_ 6-9

example of, PC_ 6-9, PC_ 6-10

in DDL statements, SCN 188

in DML statements

serializable isolation, SCN 224

in remote updates, DDS 1-34, SCN 404

inline views, SCN 10-17

NOT IN, STU 4-61

optimizing IN subquery, STU 4-78

query processing, SCN 21

to insert table data, SQL 7-409

uses for, PC_ 6-9

using in the SET clause, PC_ 6-10

using in the VALUES clause, PC_ 6-9

See also queries

subquery, PCO 5-10, PLS 5-11

example, PCO 5-10, PCO 5-11

using in the SET clause, PCO 5-11

using in the VALUES clause, PCO 5-10

subquery snapshots, REP A-6

AND expression and, REP 3-15

EXIST clause and, REP 3-15

filter columns requirement, REP 3-15

joins for, REP 3-15

many-to-many references, REP 3-15

many-to-one references, REP 3-15

number of columns in master tables, REP 3-15

subquery unnesting, STU 9-10

subregistry, OID F-4

subSchemaSubentry

adding object classes to, OID 2-10

holding schema definitions, OID 2-10

modifying, OID 2-10

Subscribe, ADQ 1-9

Subscribe Support, ADQ 8-26

Subscriber must be specified - error, ADQ D-8

Subscriber name must be specified - error, ADQ D-3

Subscriber, Adding, ADQ 9-53

Subscriber, Altering, ADQ 9-58

Subscriber, Removing, ADQ 9-62

SUBSCRIPT_BEYOND_COUNT exception, PLS 6-6

SUBSCRIPT_OUTSIDE_LIMIT exception, PLS 6-6

subscription & recipient lists, ADQ 1-10

subscription handle, OCI 2-12

attributes, OCI A-38

Subscription, Rule-based, ADQ 8-94

subscriptions

rule-based, SCN 72

Subscriptions and Recipient Lists, ADQ 8-36

sub-shared exclusive mode, PSC 5-9

sub-shared mode, PSC 5-9

SUBSTR function, PLS 6-19, SQL 4-90

SUBSTR operator, MIG 9-16

SUBSTRB function, SQL 4-91

subtotal values

deriving, SQL 7-578

subtree level search, OID 7-6

subtree, displaying, OID 7-3

subtrees

granting access to, OID 9-24, OID 9-31

renaming, OID 7-25

subtypes, PLS 2-13, PLS 2-25

CHARACTER, PLS 2-15

compatibility, PLS 2-26

constrained versus unconstrained, PLS 2-25

DEC, PLS 2-14

DECIMAL, PLS 2-14

defining, PLS 2-25

DOUBLE PRECISION, PLS 2-14

FLOAT, PLS 2-14

INT, PLS 2-14

INTEGER, PLS 2-14

NATURAL, PLS 2-13

NATURALN, PLS 2-13

NUMERIC, PLS 2-14

overloading, PLS 7-26

POSITIVE, PLS 2-13

POSITIVEN, PLS 2-13

REAL, PLS 2-14

SIGNTYPE, PLS 2-13

SMALLINT, PLS 2-14

STRING, PLS 2-19

VARCHAR, PLS 2-19

suggested development approach for data cartridge, DCI 2-14

SUM aggregate function, PLS 5-3

SUM function, SQL 4-91

summaries, SCN 10-18

summary advisor, DWG 15-2

wizard, DWG 15-8

summary management, DWG 8-5, GTK 3-21

compatibility, MIG 9-14

CREATE MATERIALIZED VIEW statement, GTK 3-22

dimensions (dimension schema object), GTK 3-22

materialized views, GTK 3-21

query rewrite, GTK 3-22

refreshing materialized views, GTK 3-22

summary advisory functions package (DBMS_OLAP), GTK 3-22

Sun Solaris, starting Oracle Directory Manager on, OID 4-2

SunSoft's SunNet Manager, DDS 1-33, SCN 403

super user

logging in as, OID 4-4

managing user name and password, OID 5-19

super user login event, OID 5-27

superclass selector, OID 7-14

superclasses, OID 2-8

and inheritance, OID 6-3

attributes in, OID 6-12

attributes of, OID 6-12

of object classes, OID 6-7

superior naming contexts

naming contexts

superior, OID 2-19

supplied packages, SCN 59

invoker or definer rights, SCN 311

suppliers, OID 2-12, OID 2-15, OID 2-16

Support, ADQ 1-9

support for SQL, PLS 5-2

Support for Statistics Views, ADQ 8-34

supported character sets, NLS 3-18

supported character string functionality and character sets, NLS 3-18

surname attribute, OID 2-5

survivability, REP 6-7, SCN 367

design considerations, REP 6-8

implementing, REP 6-9

Oracle Parallel Server and, REP 6-8

suspect save set, LEG 2-8

SUSPEND clause

of ALTER SYSTEM, SQL 7-107

SUSPEND option

ALTER SYSTEM statement, SBR 4-11

suspending a database, SAD 3-13, SBR 4-9

suspend/resume mode, SBR 4-9

sustained recovery mode, SBY 1-9

sustained standby recovery mode, SQL 7-14

terminating, SQL 7-15

timeout period, SQL 7-14

svr_pid.trc file, NET 12-34, NET C-25

swapping, STU 16-5, STU 18-5

library cache, STU 19-16

reducing, STU 19-4

SGA, STU 19-42

switch archiving mode, PSA 3-2, PSA 3-8, PSC B-3

switch command (RMAN), RMN 10-154

SWITCH LOGFILE clause

ALTER SYSTEM statement, SBY 4-11

of ALTER SYSTEM, SQL 7-107

SWITCH LOGFILE option

ALTER SYSTEM statement, SAD 6-16

switch redo log file, SRF 1-63

switches, verifying, LEG B-5

switching processes, STU 18-6

switchlog.sql script, PSG 4-15

sword

definition, OCI 3-27

SYEAR date format element, SQL 2-46

symbolic links

and RMAN, RMN 10-123

symbols

compound, PLS 2-4

definig, PC_ 2-15

simple, PLS 2-3

symmetric multiprocessor, PSC 8-7, PSC 8-11, STU 9-15

Symmetric Multi-Processor (SMP) systems, OID 13-6

symmetric multiprocessors, DWG 5-2, DWG 18-2

SYN synonym for USER_SYNONYMS, SRF 2-163

synchronization, PSC 4-2

determining the costs of, PSA 11-7

synchronous authentication mode, RADIUS, OAS 4-5

synchronous lock gets

analyzing, PSA 12-17

synchronous replication, REP 1-16, REP 2-31, SCN 436

of destination of transactions, REP 2-33

synonyms, REP 2-19, SCN 114

attributes, OCI 6-14

changing the definition of, SQL 7-500

constraints indirectly affect, SCN 255

CREATE statement, DDS 2-29

creating, SAD 18-14, SQL 7-377

definition and creation, DDS 2-29

described, SCN 10-22

describing, OCI 6-2

direct path load, SUT 8-9

displaying dependencies of, SAD 19-31

dropped tables and, ADG 2-10, SAD 13-16

dropping, SAD 18-15

examples, DDS 2-29

Export, SUT 1-50

exporting, SUT 1-59

for data dictionary views, SCN 2-4

granting

system privileges on, SQL 7-526

how to use, ADG 2-35 to ??, ADG 2-36 to ??

inherit privileges from object, SCN 306

local, SQL 7-379

location transparency using, DDS 2-28

managing, SAD 18-14 to SAD 18-15

managing privileges, DDS 2-30

name resolution, DDS 1-41, SCN 412

name resolution in distributed databases, DDS 1-41

overview of, SCN 1-25

partition-extended table names, SCN 11-65

private, SAD 18-14, SCN 10-22

private, dropping, SQL 7-500

privileges for creating, SAD 18-14

privileges for dropping, SAD 18-14

public, SAD 18-14, SCN 10-22, SQL 7-378

dropping, SQL 7-500

remote, SQL 7-379

remote object security, DDS 2-30

removing from the database, SQL 7-500

renaming, SQL 7-554

replication, REP 2-19

stored procedures and packages, ADG 9-56

synonyms for, SQL 7-377

uses of, SCN 10-22

SYNONYMS view, SRF 2-163

syntactic checking, PCO E-2

syntax

continuation lines, PCO 2-13

definition, PLS 11-1

diagram reading, PLS 11-2

embedded SQL statements, PCO 2-15

Export command, SUT 1-9

for CMCTL, NET 11-4

for connect identifiers, NET 11-10

for LSNRCTL, NET 11-3

for NAMESCTL, NET 11-3

Import command, SUT 2-6

rules for configuration files, NET C-2

SQLADR subroutine, PCO 11-14

SQLGLM subroutine, PCO 8-13

SQLNUL subroutine, PCO 11-21

SQLPRC, PCO 11-20

syntax checking

controlling with the SQLCHECK option, PC_ D-2

definition of, PC_ D-2

syntax conventions

Recovery Manager, RMN 10-2

syntax diagram

description of, PC_ F-9

how to read, PC_ F-9

how to use, PC_ F-9

symbols used in, PC_ F-9

syntax diagrams, SQL A-1

description of, PCO F-7

explanation of, RMN 10-2, SQL xi

how to read, PCO F-7

how to use, PCO F-7

keywords, RMN 10-3, SQL xi

loops, SQL A-2

multipart diagrams, SQL A-3

parameters, RMN 10-3, SQL xi

SQL*Loader, SUT 5-4

symbols used in, PCO F-7

syntax, attribute, OID 2-6

syntax, embedded SQL, PC_ 2-4, PCO 2-6

syntaxes

bulkload, OID A-20

bulkmodify, OID A-23

cannot add to subSchemaSubentry, OID 2-10

catalog management tool, OID A-26

LDAP, OID F-6

ldapaddmt, OID A-9

ldapcompare, OID A-17

ldapdelete, OID A-16

ldapmodify, OID A-11

ldapsearch, OID A-4

ldifwrite, OID A-21

stored in schema, OID 2-10

tab in Oracle Directory Manager, OID 6-10

SYS account

initial password, SAD 1-5

objects owned, SAD 1-5

policies for protecting, SAD 21-8

privileges, SAD 1-5

user, SAD 1-5

SYS schema, ADG 11-52

database triggers stored in, SQL 7-433

functions stored in, SQL 7-433

user-created objects in, MIG 9-25

SYS username

data dictionary tables owned by, SCN 2-3

security domain of, SCN 281

statement execution not audited, SCN 332

temporary schema objects owned by, SCN 293

V$ views, SCN 2-7

SYS_CONTEXT function, SQL 4-93

access control, ADG 11-58

dynamic SQL statements, ADG 11-50

parallel query, ADG 11-51

storing session variables, ADG 11-51

syntax, ADG 11-50

USERENV namespace, ADG 11-42

SYS_GROUP for Database Resource Manager, SAD 25-12, SAD 25-20

SYS_GUID function, SQL 4-97

SYS_INCLUDE

system header files in C++, PC_ 12-5

SYS_INCLUDE precompiler option, PC_ 10-39

SYS_OBJECTS view, SRF 2-164

SYS.AUD$ table

audit trail, SAD 24-2

creating and deleting, SAD 24-4

SYS.AUD$ view

purging, SCN 2-5

SYSCATALOG view, SRF 2-163

SYSDATE datatype

example, SUT 4-28

SYSDATE function, ADG 3-9, PCO 4-13, SQL 4-98

SYSDATE keyword

SQL*Loader, SUT 5-55

SYSDBA, PSA 13-16, SUT 1-37

connecting in Pro*C/C++, MIG 9-20

connecting in Pro*COBOL, MIG 9-20

privilege for connecting, PSA 4-5

SYSDBA option

not needed for RMAN, RMN 2-10

SYSDBA privilege, PCO A-3, PSG 6-19, PSG 6-26, PSG 7-24, SCN 5-3

SYSDBA privilege, granting, PSG 6-24

SYSDBA privilegeshow to set, PCO 3-11

SYSDBA system privilege, SQL 7-529

SYSDBA/SYSOPER Privileges, PC_ A-5

sysevent event attribute, ADG 14-4

SYSFILES view, SRF 2-163

SYS.INCEXP table

Export, SUT 1-52

SYS.INCFIL table

Export, SUT 1-52

SYS.INCVID table

Export, SUT 1-53

SYSOPER, PSA 13-16

privilege for connecting, PSA 4-5

SYSOPER privilege, PCO A-3, PSG 6-19, PSG 6-26, PSG 7-24, SCN 5-3

how to set, PCO 3-11

SYSOPER privilege, granting, PSG 6-24

SYSOPER system privilege, SQL 7-529

SYSOPER/SYSDBA privileges

adding users to the password file, SAD 1-12

connecting with, SAD 1-14

determining who has privileges, SAD 1-14

granting and revoking, SAD 1-13

SYSSEGOBJ view, SRF 2-163

SYSTEM

tablespace, SRF 5-2

SYSTEM account

initial password, SAD 1-5

objects owned, SAD 1-5

policies for protecting, SAD 21-8

System Change Number, PSA 7-18

system change number

using V$DATAFILE to view information about, SAD 10-14

when assigned, SAD 6-2

System Change Number (SCN)

incrementation, PSC 6-6

system change number (SCN)

Lamport, PSC 6-6

non-PCM lock, PSC 4-5

system change number. See SCN

system change numbers, PSA 7-18

archive file format, PSA 13-6

archiving redo log files, PSA 13-5

redo log history, PSA 13-7

system change numbers (SCN)

committed transactions, SCN 36

coordination in a distributed database system, DDS 4-15

defined, SCN 36

in-doubt transactions, DDS 5-14

read consistency and, SCN 215, SCN 216

redo logs, SCN 8-10

when determined, SCN 215

System Configuration File, PC_ E-3

system configuration file, PC_ 10-4

system control statements, SCN 1-52, SCN 14, SQL 6-5

PL/SQL support of, SQL 6-5

system date

altering, SQL 7-110

System Environment Variable, OAS 8-15

system events, ADG 14-1

attributes, ADG 14-2

attributes of, SQL 7-433

client events, ADG 14-7

resource manager events, ADG 14-6

tracking, ADG 13-52, ADG 14-1

triggers on, SQL 7-431

system failure

effect on transactions, PC_ 3-17

system failures, SBR 1-12

effect on transactions, PCO 3-14

System Global Area, SAD 2-22

determining buffers in cache, SAD 2-22

system global area, SRF 1-11

buffer areas, SRF 1-24, SRF 1-63

buffer cache, SRF 1-24

flushing, SQL 7-107

holds sequence number cache, ADG 2-33

maximum concurrent transactions, SRF 1-119

rollback segment size, SRF 1-68

size of, SRF 1-24

updating, SQL 7-105

System Global Area (SGA), OID 10-6, OID 12-13, OID 13-7, PC_ 7-20, PCO 6-21

row cache, PSC 4-2

sequence cache, PSC 8-14

sizing, OID 13-8

tuning for Oracle8i, OID 13-8

tuning parameters, OID 13-11

system global area (SGA), SCN 7-2

allocating, SCN 5-6

contents of, SCN 7-3

data dictionary cache, SCN 2-4, SCN 7-10

database buffer cache, SCN 7-3

diagram, SCN 5-2

fixed, SCN 7-3

large pool, SCN 7-12

limiting private SQL areas, SCN 297

overview of, SCN 1-14, SCN 7-2

redo log buffer, SCN 7-6, SCN 35

rollback segments and, SCN 35

shared and writable, SCN 7-3

shared pool, SCN 7-7

size of, SCN 7-13

variable parameters, SCN 5-4

when allocated, SCN 7-2

System Global Area (SGA), defined, PSG 1-2

System Global Area tuning, STU 19-4

system header files

specifying the location of, PC_ 12-5

System Level Access Control, ADQ 8-5, ADQ 12-13

system level planning

planning

system level, PSC 9-4

system monitor, SAD 4-12

system monitor process (SMON), SCN 8-11

defined, SCN 1-17, SCN 8-11

instance recovery, SCN 344

parallel DML instance recovery, SCN 198

parallel DML system recovery, SCN 198

Parallel Server and, SCN 8-11, SCN 198

rolling back transactions, SCN 350

temporary segment cleanup, SCN 8-11

System Network Architecture (SNA), NET 4-4

system objects

importing, SUT 2-12

system operational attributes, OID 5-15

fields in Oracle Directory Manager, OID 5-16

setting

by using ldapmodify, OID 5-18

by using Oracle Directory Manager, OID 5-15

system owned object, See DIRECTORY object

system performance, SRF 1-11

System Privilege, Granting, ADQ 9-42

System Privilege, Revoking, ADQ 9-45

system privileges, ADG 11-28, ADG 11-29, SAD 23-2, SCN 304

ADMIN OPTION, ADO 2-11, SCN 305

ADMINISTER_RESOURCE_MANAGER, SAD 25-3

described, SCN 304

granting, SQL 7-365, SQL 7-519

to a role, SQL 7-520

to a user, SQL 7-520

to all users, SQL 7-520

to PUBLIC, SQL 7-520

granting and revoking, SCN 305

list of, SQL 7-521

revoking, SQL 7-556

from a role, SQL 7-557

from a user, SQL 7-556

from PUBLIC, SQL 7-557

from users, SQL 7-557

user-defined types, ADO 2-10

See also privileges

system requirements, OAS 1-13

CyberSafe, OAS 1-13

DCE integration, OAS 12-2

for migration, MIG 3-15

Identix Biometric, OAS 1-13

Kerberos, OAS 1-13

RADIUS, OAS 1-13

SecurID, OAS 1-13

SSL, OAS 1-14

SYSTEM rollback segment, PSC 7-6, SCN 4-27, SRF 1-105

altering storage parameters of, SAD 11-9

defining, SRF 5-2

system tables

incremental export, SUT 1-51

SYSTEM tablespace, OID 12-12, PSA 3-4, SCN 3-6

cannot drop, SAD 9-22

data dictionary stored in, SCN 2-2, SCN 2-5, SCN 3-6

initial rollback segment, SAD 11-2

media failure, SCN 346

Migration utility, MIG 3-6, MIG 4-6

non-data dictionary tables and, SAD 13-3

online requirement of, SCN 3-9

Oracle Data Migration Assistant, MIG 5-4

procedures stored in, SCN 3-6, SCN 61

raw device, PSG 2-6

recovery of, SBR 5-22

restrictions on taking offline, SAD 10-7

space

insufficient for migration, MIG A-2

when created, SAD 9-4

SYSTEM tablespace, description, PSG 1-12

system time

changing

effect on recovery, SBR 5-25

system undo blocks, PSA 7-5

SYSTEM username

security domain of, SCN 281

SYSTEM_PLAN for Database Resource Manager, SAD 25-10, SAD 25-12, SAD 25-20

SYSTEM_PRIVILEGE_MAP view, SRF 2-163

system-based security, REP A-8

system-specific Oracle documentation, ADG 13-4, PC_ xii, PC_ 1-9, PC_ 2-17, PC_ 3-7, PC_ 5-31, PC_ 5-56, PC_ 20-1

data files, maximum number, PSC B-3

free list overhead, PSC 7-12

MAXLOGHISTORY default, PSA 13-7

PL/SQL wrapper, ADG 9-28

redo log archive destination, PSA 13-7

redo log archive format, PSA 13-7

software constraints, STU 16-7

system-specific reference, PC_ 4-6, PC_ 10-2, PC_ 10-4, PC_ 10-26, PC_ 10-40

SYYYY date format element, SQL 2-46