---

S

S locks

LOCK TABLE command, ADG 8 - 13

S number format element, SQL 2-36

S variable in SQLDA

how value is set, PC_ 15-10

purpose of, PC_ 15-10

same-row writers block writers, SCN 27-10

SAMPLE BLOCK option, SCN 23-34

access path, SCN 23-49

hints cannot override, SCN 23-50

SAMPLE clause

cost-based optimization, SCN 22-16

of SELECT, SQL 7-546

of SELECT and subqueries, SQL 7-542

sample database table

DEPT table, PCO 2-29

EMP table, PCO 2-29

sample database tables

DEPT table, PC_ 2-18

EMP table, PC_ 2-18

sample DCE address, in TNSNAMES.ORA, OAS 13-15

SAMPLE function, GTK 2-24

sample object type code, PC_ 17-24

SAMPLE option, SCN 23-34

access path, SCN 23-49

hints cannot override, SCN 23-50

sample programs, 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-24

coldemo1.pc, PC_ 18-24

concurrent connections, PCO 3-17

cppdemo1.pc, PC_ 12-6

cppdemo2.pc, PC_ 12-9

cppdemo3.pc, PC_ 12-13

cursor operations, PCO 5-18

cursor variable demos, PC_ 4-32

cursor variable use, PCO 6-38

cursor variables

PL/SQL source, PCO 6-38

cv_demo.pc, PC_ 4-33

cv_demo.sql, PC_ 4-32

datatype equivalencing, PCO 4-55

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-8

extp1.pc, PC_ 7-31

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

how to precompile, PC_ 2-20

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-41

Oracle Forms user exit, PCO 12-9

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-38

sample12.pc, PC_ 15-40

SAMPLE12.PCO, PCO 10-28

SAMPLE13.PCO, PCO 2-26

SAMPLE14.PCO, PCO 7-22

sample1.pc, PC_ 2-19

SAMPLE1.PCO, PCO 2-30

sample2.pc, PC_ 4-43

SAMPLE2.PCO, PCO 5-18

sample3.pc, PC_ 8-8

SAMPLE3.PCO, PCO 7-10

sample4.pc, PC_ 5-15

SAMPLE4.PCO, PCO 4-55

sample5.pc, PC_ 20-10

SAMPLE5.PCO, PCO 12-9

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-24

simple query, PCO 2-30

sqlvcp.pc, PC_ 4-22

tables of group items, PCO 7-22

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

sample scripts

RMAN, SBR 5-21

sample table scans, SCN 23-34, SCN 23-49

hints cannot override, SCN 23-50

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

sar UNIX command, STU 18-4, STU 26-83

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

savepoint, PCO 3-24

SAVEPOINT command, ADG 8 - 6, SCN 16-5

SAVEPOINT keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

savepoint name

reusing, PLS 5-44

SAVEPOINT SQL statement, PC_ F-103

SAVEPOINT statement, PCO 3-24, PCO F-78, PLS 5-44, SQL 7-539

example, PCO 3-24

example of, PC_ 3-19

examples, PC_ F-103, PCO F-79

purpose of, PC_ 3-19

syntax, PLS 11-144

savepoints, SCN 1-55, SCN 17-7

creating, PC_ F-103, PCO F-78

definition of, PC_ 3-19

described, SCN 17-7

erasing, SQL 7-214

implicit, SCN 17-4

in-doubt transactions, DDS 3-31

maximum number of, ADG 8 - 6

overview of, SCN 1-55

rolling back to, ADG 8 - 6, SCN 17-6, SQL 7-537

specifying, SQL 7-539

uses for, PC_ 3-19

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

sb1

definition, OCI 3-27

sb2

definition, OCI 3-27

sb4

definition, OCI 3-27

sbttest program, SBR 4-19, SBR 5-21

scalability, STU 11-6, STU 18-8

application, SPS 2-6, SPS 2-13

applications, SPS 2-2

batch jobs, SCN 26-38

client/server architecture, SCN 6-4

database, SPS 2-5

definition, SPS 1-8

determinants, SPS 1-13

disk input and output, SPS 2-3

enhancement for release 7.3, SPS A-11

four levels of, SPS 2-1

hardware, SPS 2-2

network, SPS 2-6

operating system, SPS 2-5

parallel DML, SCN 26-37

parallel SQL execution, SCN 26-2

potential, SPS 1-12

relative, SPS 2-8

serially reusable packages, ADG 10 - 70

shared memory system, SPS 2-5

scalable operations, STU 26-72

scalar type, PLS 2-10

scalar types, PCO 11-18

Scale

using SQLPRC to extract, PC_ F-118, PCO 4-48

scale, PCO 4-4

definition of, PC_ 15-16, PC_ F-118, PCO 4-48

greater than precision, SQL 2-14

negative, SQL 2-14

of NUMBER datatype, SQL 2-13

specifying, PLS 2-13

using sqlprc() to extract, PC_ 15-16

when negative, PC_ 15-16, PC_ F-118, PCO 4-48

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, SCN 23-34

cluster, SCN 23-38, SCN 23-39, SCN 23-40, SCN 23-41

indexed, SCN 23-41

fast full index scan, SCN 23-36

full table, SCN 23-34, SCN 23-48

LRU algorithm, SCN 7-4

multiblock reads, SCN 23-51

parallel query, SCN 26-5

rule-based optimizer, SCN 23-54

hash cluster, SCN 23-39, SCN 23-41

index, SCN 23-35

bitmap, SCN 23-36

bounded range, SCN 23-44

cluster key, SCN 23-41

composite, SCN 23-42

MAX or MIN, SCN 23-46

ORDER BY, SCN 23-47

restrictions, SCN 23-48

selectivity and, SCN 23-51

single-column, SCN 23-42

unbounded range, SCN 23-45

index joins, SCN 23-36, SCN 23-49

range, SCN 23-35, SCN 23-42

bounded, SCN 23-44

MAX or MIN, SCN 23-46

ORDER BY, SCN 23-47

unbounded, SCN 23-45

sample table, SCN 23-34, SCN 23-49

hints cannot override, SCN 23-50

table scan and CACHE clause, SCN 7-4

unique, SCN 23-35, SCN 23-40, SCN 23-41

SCC date format element, SQL 2-41

scenarios, Recovery Manager

backing up archived redo logs, SBR 8-19

cataloging O/S copies, SBR 8-25

deleting obsolete backups and copies, SBR 7-11

duplexing backup sets, SBR 8-22

handling backup errors, SBR 8-26

incremental backups, SBR 8-21

incremental cumulative backups, SBR 8-22

listing backups and copies, SBR 7-10

listing obsolete backups and copies, SBR 7-10

maintaining backups and copies, SBR 8-26

NOARCHIVELOG backups, SBR 8-23

OPS backups, SBR 8-25

parallelization of backups, SBR 8-23

recovering pre-resetlogs backup, SBR 9-37, SBR 9-38

recovery after total media failure, SBR 9-35

reporting database schema, SBR 7-12

reporting datafiles needing backups, SBR 7-10, SBR 8-15

reporting obsolete backups, SBR 7-11

reporting unrecoverable datafiles, SBR 7-11

restoring when databases share name, SBR 9-31

setting size of backup sets, SBR 8-16

scginq AST call wait event, SRF A-47

SCHEDULE_EXECUTION procedure

DBMS_DEFER_SYS package, REP 2-13, REP 2-15, REP 2-17, REP 2-18

SCHEDULE_PUSH procedure

DBMS_DEFER_SYS package, REP 2-13, REP 2-15, REP 2-17, REP 2-18

scheduled link, RAR 2-13

scheduled links

continuous pushes, REP 2-14, REP 2-17

creating, REP 2-12

database link to use, REP 2-12

deleting, REP 2-16

editing, REP 2-15

guidelines, REP 2-14

managing, REP 2-12

number of background processes used, REP 2-13

parallel propagation, REP 2-13, REP 2-40 to REP 2-42

periodic pushes, REP 2-14

serial propagation, REP 2-13, REP 2-40

viewing status, REP 2-15

Scheduled Links folder

Replication Manager, REP 2-15

scheduled purges

editing, REP 2-18

guidelines, REP 2-17

periodic purges, REP 2-18

Scheduling folder

Replication Manager, REP 2-15

Scheduling page

Create Refresh Group property sheet, REP 5-29

schema

creating for snapshots, REP 3-25

definition of, SQL 2-63

naming conventions, DCI 2-5

schema changes

updating recovery catalog, SBR 6-25

SCHEMA clause

of CREATE JAVA, SQL 7-294

schema design guidelines

materialized views, STU 28-7

schema extension, in NDS, NET 6-55

Schema Manager

Snapshot Log property sheet, REP 7-37

schema names

in distributed databases, SCN 33-6

qualifying column names, SCN 14-9

unique within a database, SCN 33-6

schema object privileges, SCN 30-3

DML and DDL operations, SCN 30-5

granting and revoking, SCN 30-4

overview of, SCN 1-41

views, SCN 30-6

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

auditing, SCN 1-44, SCN 31-8

by access, SQL 7-206

by session, SQL 7-206

options, SQL 7-207

successful
SQL statements on, SQL 7-206

compatibility, MIG 8-10

creating

tablespace quota required, SCN 29-14

creating multiple objects, SAD 20-2

default audit options, SAD 25-11

default tablespace for, SCN 29-13

defined, SCN 1-5

defining default buffer pool for, SQL 7-579

dependencies between, SAD 20-23

dependencies of, SCN 21-2

and distributed databases, SCN 21-12

and views, SCN 10-15

on non-existence of other objects, SCN 21-8

triggers manage, SCN 20-21

dependent on lost privileges, SCN 21-6

dimensions, SCN 10-18

disabling audit options, SAD 25-12

distributed database naming conventions for, DDS 1-6, SCN 33-6

domain index, SCN 10-43

dropping, SQL 7-483

enabling audit options on, SAD 25-11

global names, DDS 1-6, SCN 33-6

in a revoked tablespace, SCN 29-14

in other schemas, SQL 2-74

indextype, SCN 10-43

information in data dictionary, SCN 2-2

INVALID status, SCN 21-2

list of, SQL 2-63

listing by type, SAD 20-31

listing information, SAD 20-29

materialized view logs, SCN 10-18

materialized views, SCN 10-17

name resolution, SQL 2-73

names in distributed databases, SCN 33-6

namespaces, SQL 2-68

naming examples, SQL 2-70

naming guidelines, SQL 2-71

naming rules, SQL 2-67

object types, SQL 2-26

on remote databases, SQL 2-74

overview of, SCN 1-10, SCN 1-23, SCN 10-2

partitioned indexes, SQL 2-64

partitioned tables, SQL 2-64

parts of, SQL 2-64

privileges on, SCN 30-3

privileges to access, SAD 24-3

privileges to rename, SAD 20-2

reauthorizing, SQL 6-2

recompiling, SQL 6-2

referring to, SQL 2-71, SQL 7-81

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

remote, accessing, SQL 7-255

renaming, SAD 20-2, SAD 20-3

stopping auditing of, SQL 7-525

trigger dependencies on, SCN 20-25

user-defined operator, SCN 10-44

user-defined types, SCN 13-3

schema statistics

gathering, STU 7-14

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

usage, OCI 14-33, PC_ 19-36

schemas, ADG 12 - 9, SCN 29-2

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

attributes, OCI 6-19

changing for a session, SQL 7-81

contents of, SCN 10-2

contrasted with tablespaces, SCN 10-2

creating, SQL 7-347

creating for multimaster replication, REP 2-9

defined, SCN 29-2

describing, OCI 6-2

export privileges, SUT 1-4

objects in, SCN 10-2

OUTLN, SCN 22-6

specifying for Export, SUT 1-24

star schemas, SCN 24-14, SCN 24-15

normalized tables, SCN 24-15

user-defined datatypes, SCN 13-14

scheme, iteration, PLS 3-10

scientific notation, PLS 2-7, SQL 2-37

scientific notation for FLOAT EXTERNAL, SUT 5-67

SCN, SAD 10-14, SCN 17-5, SPS 4-4

See system change number

System Change Number, SPS 10-4

See also system change numbers

SCN (system change number)

definition, SBR 1-9

scope, PLS 2-37

collection, PLS 4-8

cursor, PLS 5-7

cursor parameter, PLS 5-7

cursor variables, PCO 6-33

definition, PLS 2-37

exception, PLS 6-7

identifier, PLS 2-37

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-8

of WHENEVER statement, PC_ 9-28

package, PLS 8-5

WHENEVER directive, PCO 8-33

SCOPE clause

of column ref constraints, SQL 7-225

scope constraints, SQL 7-225

SCOPE FOR constraint, ADG 16 - 30, ADG 16 - 34

scope, autonomous, ADG 8 - 33

scoped REFs, SCN 13-9, SCN 14-19

script files

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

scripts

CATRMAN.SQL, SBR 6-5

data dictionary, SRF 5-3

downgrading, MIG 12-45

errors while running, MIG 1-3

migrating from Server Manager to SQL*Plus, MIG 10-1

migration, SRF 5-6, SRF 5-7

rerunning, MIG 3-27, MIG 4-17, MIG 7-19, MIG 12-46

SQL scripts, SRF 5-2

upgrading, MIG 7-18

SCSI, SPS 3-3

SDFs, SUT 3-22

.SDNS.ORA file, NET 2-45

SDNS.ORA file, NET 2-45

SDO, SMS 52-1

SDO_ADMIN package, SPR 1 - 14

SDO_GEOM package, SPR 1 - 14

SDO_MIGRATE package, SPR 1 - 14

SDO_TUNE package, SPR 1 - 14

SDU

configuring, NET 7-7

see session data unit

SDU parameter, NET 7-7, NET C-48

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_COLUMN column

PLAN_TABLE table, STU 13-4

secondary indexes

dropping from index-organized tables, MIG 12-8

secondary memory

of object, OCI 13-16

secret key, OAS 7-5

location in RADIUS, OAS 3-20

Secure Sockets Layer (SSL) authentication method

see Oracle Advanced Security

Secure Sockets Layer. See SSL

SecurID, OAS 3-4, OAS 3-5

system requirements, OAS 1-12

SecurID authentication method

see Oracle Advanced Security

SecurID authentication, parameters, OAS B-3

SecurID cards, types of, OAS 6-13

security, REP A-4, SCN 1-41, SCN 29-2

accessing a database, SAD 22-2

administrator of, SAD 22-2

administrator privileges, SCN 5-3

application context, ADG 12 - 22

application developers and, SAD 22-9

application enforcement of, SCN 1-42

auditing, SCN 31-2, SCN 31-6

auditing policies, SAD 22-18

auditing user actions, SCN 1-44

authentication of users, SAD 22-2

data, SAD 22-3, SCN 1-38

database security, SAD 22-2

database users and, SAD 22-2

definer rights, SCN 18-9, SCN 18-19

deleting audit data, SCN 2-5

described, SCN 1-38

discretionary access control, SCN 1-39, SCN 29-2

distributed databases, SCN 33-17

domains, SCN 1-40, SCN 29-2

dynamic predicates, SCN 30-23

enforcement mechanisms, SCN 1-39

establishing policies, SAD 22-1

fine-grained access control, ADG 12 - 26, SCN 30-22

for multimaster replication, REP 8-18

for remote objects, DDS 2-22

for snapshot replication, REP 8-24

general users, SAD 22-4

invoker rights, SCN 18-9, SCN 18-19

message queues, SCN 19-7

multi-byte characters

in role names, SAD 24-5

in role passwords, SAD 24-7

in user passwords, SAD 23-12

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

passwords, SCN 29-7

policies

implementing, SCN 30-24

policies for database administrators, SAD 22-7

policy for applications, ADG 12 - 3, ADG 12 - 7

privilege management policies, SAD 22-5

privileges, SAD 22-2

procedures enhance, SCN 30-8

program interface enforcement of, SCN 8-25

protecting the audit trail, SAD 25-16

REMOTE_OS_ROLES parameter, SAD 24-19

roles to force security, SAD 22-6

roles, advantages, ADG 12 - 4

security officer, SAD 1-3

security policies, SCN 30-22

sensitivity, SAD 22-3

system, SCN 1-38, SCN 2-3

table- or view-based, ADG 12 - 26

using synonyms, DDS 2-23

views and, SCN 10-13

views enhance, SCN 30-6

security between Oracle and non-Oracle clients and servers, OAS 9-7

security domains, SCN 1-40, SCN 29-2

enabled roles and, SCN 30-18

tablespace quotas, SCN 29-13

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

application context, GTK 2-69

fine-grained access control, GTK 2-69

integrated security and directory services, GTK 2-72

multi-tier authentication and authorization, GTK 2-77

native authentication on Windows NT, GTK 2-77

security login, PSC 5-16

security policies

downgrading, MIG 12-37

fine-grained access control, MIG 12-37

security policy, ADG 12 - 1, OAS 7-3

security, NAMESCTL utility, NET A-3, NET A-32

security, protocol adapter includes, OAS 11-3

segment

definition, SPS 11-3

header, SPS 7-9

header block, SPS 11-14, SPS 14-7

header contention, SPS 11-6, SPS 19-6

header, contention, SPS 11-6

ID number, SPS 14-5, SPS 14-7

name, SPS 14-7

rollback segment, SPS 6-8

size, SPS 14-7

segment attributes clause

of CREATE TABLE, SQL 7-360, SQL 7-369

segments, SCN 1-11, SCN 4-16, STU 20-26

data, SCN 4-16

data and index

default storage parameters, SAD 12-10

data dictionary, SAD 20-27

deallocating extents from, SCN 4-14

defined, SCN 4-3

displaying information on, SAD 20-32

header block, SCN 4-11

index, SCN 4-17

monitoring, SAD 21-15

overview of, SCN 1-11, SCN 4-16

rollback, SAD 21-1, SCN 4-19

table

high water mark, SCN 25-3

temporary, SCN 1-11, SCN 4-17, SCN 10-10

allocating, SCN 4-17

cleaned up by SMON, SCN 8-11

dropping, SCN 4-16

FILE keyword

SQL*Loader, SUT 8-29

ignore quotas, SCN 29-14

operations that require, SCN 4-18

parallel INSERT, SCN 25-8

tablespace containing, SCN 4-16, SCN 4-18

temporary storage parameters, SAD 12-12

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

object privilege, SQL 7-508

statement, SQL 7-541

SELECT ... FOR UPDATE, DDS 2-25

SELECT ANY SEQUENCE system privilege, SQL 7-499

SELECT ANY TABLE system privilege, SQL 7-500

SELECT command, SCN 16-3

composite indexes, SCN 10-22

FOR UPDATE, ADL 1-49

read consistency, ADG 8 - 11, ADL 2-2

SAMPLE clause

cost-based optimization, SCN 22-16

SAMPLE option, SCN 23-34

access path, SCN 23-49, SCN 23-50

SELECT ... FOR UPDATE, ADG 8 - 17

subqueries, SCN 16-12

See also queries

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 INTO statement

syntax, PLS 11-145

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-18

ordering, SQL 5-20

SELECT privilege for object tables, SCN 14-15, SCN 14-16

SELECT SQL statement, PC_ F-104

select SQLDA

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

SELECT statement, PC_ 6-7, PCO F-79, SQL 5-18

available clauses, PCO 5-9

clauses available for, PC_ 6-8

embedded SQL examples, PC_ F-107, PCO F-82

example, PCO 5-8

example of, PC_ 6-7

INTO clause, PCO 5-8

INTO clause in, PC_ 6-8

purpose of, PC_ 6-7

testing, PC_ 6-8

using host arrays in, PC_ 8-5

using host tables, PCO 7-6

WHERE clause in, PC_ 6-8

SELECT_CATALOG_ROLE role, SQL 7-503

SELECT_ERROR

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

SELECT_ERROR option, PCO 5-8

SELECT_ERROR precompiler option, PCO 14-37

selectivity of predicates, SCN 22-8

histograms, SCN 22-8, SCN 22-10

user-defined selectivity, SCN 22-17

selectivity of queries, SCN 23-51

selectivity, index, STU 6-4

select-list

describing, OCI 4-10

select-list items

naming, PCO 11-4

selector, PLS 5-21

select-project-join views, SCN 23-15

self joins, SQL 5-22

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

selfish style of method invocation, SCN 13-6

self-referential constraints in tables

adding sites with to master groups, REP 2-33

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 3-28

non-blank-padding, PLS B-3

reference based for BFILEs, ADL 5-6

string comparison, PLS B-2

semi-joins, SCN 24-13

send command (RMAN), SBR 5-20, SBR 11-127

sending data

asynchronously, NET 2-4

synchronously, NET 2-4

sensitivity

security, SAD 22-3

separate precompilation

guidelines, PCO 2-27

guidelines for, PC_ 2-17

referencing cursors for, PC_ 2-17

restrictions, PCO 2-28

restrictions on, PC_ 2-17

specifying MAXOPENCURSORS for, PC_ 2-17

using a single SQLCA with, PC_ 2-18

separator, PLS 2-3

SEQ synonym for USER_SEQUENCES, SRF 2-182

sequence, PLS 5-3

data dictionary cache, SPS 4-7, SPS 6-7

log sequence number, SPS 21-5, SPS 21-6

not cached, SPS 6-7, SPS B-3

timestamp, SPS 6-7

sequence cache, STU 2-10

SEQUENCE keyword

SQL*Loader, SUT 5-56

sequence number enqueue, SRF B-2

sequence number generator

application scalability, SPS 2-6

contention, SPS 2-9

distributed locks, SPS 6-6

LM locks, SPS 4-7

on parallel server, SPS 6-6

restriction, SPS 6-7, SPS B-3

skipping sequence numbers, SPS 6-7

sequence number value enqueue, SRF B-2

sequence numbers

cached, SUT 1-55

exporting, SUT 1-55

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-46

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

SEQUENCE_CACHE_ENTRIES parameter, ADG 3 - 40, SAD 15-11, SRF 1-111

obsolete for 8.1, SPS A-5

SEQUENCE_CACHE_HASH_BUCKET parameter, SRF 1-111

sequences, SCN 1-25, SCN 10-19, SQL 2-51, SQL 7-350, SUT 2-49

accessing, ADG 3 - 37

accessing values of, SQL 7-350

altering, ADG 3 - 37, SAD 15-10

attributes, OCI 6-14

auditing, SCN 31-8

caching numbers, ADG 3 - 36

caching sequence numbers, ADG 3 - 40

changing the increment value, SQL 7-76

changing the number of cached values, SQL 7-76

CHECK constraints prohibit, SCN 28-18

creating, ADG 3 - 36, ADG 3 - 41, SAD 15-10, SQL 7-349

creating without limit, SQL 7-350

CURRVAL, ADG 3 - 37, ADG 3 - 39

describing, OCI 6-2

dropping, ADG 3 - 41, SAD 15-11

exporting, SUT 1-55

granting

system privileges on, SQL 7-499

how to use, SQL 2-52

incrementing, SQL 7-349, SQL 7-351

independence from tables, SCN 10-20

initialization parameters, ADG 3 - 36, SAD 15-11

length of numbers, SCN 10-19

managing, SAD 15-9

maximum value

setting or changing, SQL 7-76

minimum value

setting or changing, SQL 7-76

NEXTVAL, ADG 3 - 38

number generation, SCN 10-19

ordering values, SQL 7-76

parallel server, ADG 3 - 37

Parallel Server and, SAD 15-10

privileges for altering, SAD 15-10

privileges for creating, ADG 3 - 37, SAD 15-10

privileges for dropping, SAD 15-11

privileges to alter, ADG 3 - 37

privileges to drop, ADG 3 - 42

privileges to use, ADG 3 - 41

recycling values, SQL 7-76

reducing serialization, ADG 3 - 38

removing from the database, SQL 7-471

renaming, SQL 7-527

restarting, SQL 7-471

at a different number, SQL 7-77

restarting at a predefined limit, SQL 7-350

reusing, SQL 7-350

stopping at a predefined limit, SQL 7-350

synonyms for, SQL 7-355

where to use, SQL 2-52

sequential control, PLS 3-15

sequential processing, SPS 1-2, SPS 1-4

sequential reads, STU 20-5

sequential writes, STU 20-5

serial propagation, REP 2-4

scheduled links, REP 2-13

SERIAL_REUSE parameter, SRF 1-111

serializable aborts statistic, SRF C-17

SERIALIZABLE option, ADG 8 - 19

for ISOLATION LEVEL, ADG 8 - 26

SERIALIZABLE parameter, ADG 8 - 11, SPS 18-11

serializable transactions, ADG 8 - 23, STU 9-5

SERIALIZABLE=TRUE, GTK 6-2

serialization

of transactions, REP 8-3

serially reusable package, PLS 5-64

serially reusable PL/SQL packages, ADG 10 - 70

SERIALLY_REUSABLE pragma, ADG 10 - 71, PLS 5-64

server

configure for external procedures, NET 7-66

configuring a profile, NET 7-15

configuring a region database for Oracle Names, NET 6-26

configuring both multi-threaded servers and dedicated servers, NET 9-10

configuring for connection concentration, NET 7-32

configuring for IIOP connections, NET 7-51

configuring for Java option, NET 7-51

configuring listeners to prespawn dedicated servers, NET 6-73

configuring with local naming, NET 6-14

configuring with the Net8 Configuration Assistant after install, NET 4-22

disconnections, NET 2-3

discovering Oracle Names servers, NET 6-37

in stack communications, NET 2-13

integration with PL/SQL, PC_ 7-2, PLS 1-23

log files, NET 11-20

loopback test, NET 11-4

methods of connecting, NET 8-8

migrating, NET 5-18

starting the database, NET 8-6

testing, NET 8-18

to server interaction, described, NET 2-13

trace files, NET 11-33

troubleshooting, NET 11-3

upgrading, NET 5-18

server backup

automatic bootstrap backup, LEG 4-5

bootstrap backup, LEG 4-4, LEG 4-5

maintaining bootstrap information, LEG 4-9

manual bootstrap backup, LEG 4-9

SERVER clause, DDS 2-9

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 Manager, DDS 1-19, GTK 6-7

differences with SQL*Plus

ampersands, MIG 10-12

blank lines, MIG 10-10

commands, MIG 10-3

comments, MIG 10-7

COMMIT command, MIG 10-14

CREATE LIBRARY command, MIG 10-13

CREATE TYPE command, MIG 10-13

hyphen continuation character, MIG 10-10

startup, MIG 10-2

syntax, MIG 10-7

migrating to SQL*Plus, MIG 10-1

PL/SQL, SCN 16-17, SCN 16-19

privileged commands, SPS 18-19

SQL statements, SCN 16-2

SERVER parameter, NET 6-78, NET 7-7, NET C-48

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

listener process and, SCN 6-6

number, SRF 1-76, SRF 1-103

server resource

administrator, LEG 2-26

name, LEG 2-25

parallelism, LEG 2-25

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-5

LOB functions, OCI C-2

object functions, OCI C-4

relational functions, OCI C-2, OCI C-6

server units

composite limits and, SAD 23-19

SERVER_PRINCIPAL

DCE address parameter, OAS 13-2

DCE parameter, OAS 13-15

SERVERERROR

triggers on, SQL 7-405

SERVERERROR event

triggers on, SQL 7-405

server/memory/user relationship, STU 27-2

servers, SCN 1-33

client/server architecture, SCN 6-2

communicating with clients on Windows NT, LEG B-7

dedicated, SCN 1-18, SCN 8-22

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

dedicated server architecture, SCN 8-3

defined, SCN 1-34

multi-threaded, SCN 1-18

architecture, SCN 8-3, SCN 8-16

dedicated contrasted with, NET 9-2, SAD 4-3, SCN 8-16

processes of, SCN 8-14, SCN 8-16, SCN 8-19

processes of, SCN 1-18

role in two-phase commit, DDS 3-6

shared, SCN 1-18

SERVICE, PSC 4-29

service, NET 6-2, NET C-5

described, NET 6-3

OracleHOME_NAMEAgent, PSC 5-13

OracleHOME_NAMEDataGatherer, PSC 5-30

OracleHOME_NAMEManagementServer, PSC 5-14

OracleServiceSID, PSC 4-9

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

service connections

to clients, SPS 18-28

service context handle

attributes, OCI A-7

description, OCI 2-9

elements of, OCI 2-9

service discovery

See auto-discovery

service interfaces, DCI 1-14

service name

and address storage, in NDS, NET 6-56

character set keyword values, NET C-5

described, NET 2-2, NET 6-3

of remote database, SQL 7-257

verifying, NET 5-17

service name, in Kerberos, OAS Glossary-6

Service names, DDS 6-4

service names, SCN 6-6

service naming

Net8, MIG 8-47

service naming, described, NET 4-3

service naming, Net8, GTK 2-75

SERVICE parameter, NET 6-79

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

examples, ADG 11 - 35, DCI 4-12

service table, in Kerberos, OAS Glossary-6

service ticket, OAS Glossary-6

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

SERVICE, DCE address parameter, OAS 13-2

SERVICE_NAME parameter, NET 4-3, NET 4-9, NET 4-17, NET 5-7, NET 5-19, NET 6-3, NET C-49

SERVICE_NAME parameter in TNSNAMES.ORA file, PSC 4-29

SERVICE_NAMES parameter, NET 5-17, NET 6-4, NET 9-7, SCN 6-6, SRF 1-112

in instance registration, SPS 18-31

SERVICE_NAMES parameter in INITDB_NAME.ORA file, PSC 6-7

Services

Heterogeneous, SCN 33-8

services, LEG B-10, NET 1-3

connecting, NET 1-3

described, NET 1-3

extensibility, DCI 1-6

global database name, NET 1-3

service names, NET 2-2

SERVICES command, NET 2-21, NET A-10

SERVICES.ORA, PSC C-9

SERVICES.ORA file, PSC C-9

session, PCO 3-18, PLS 5-40

definition of, PC_ 3-15

global name resolution for, SQL 7-82

migration, OCI 8-11, OCI 15-103

multiple, SPS 18-7, SPS 18-21, SPS 18-27

waiting for PCM lock conversion, SPS 15-17

session connect time statistic, SRF C-17

session control statements, SCN 1-53, SCN 16-5, SQL 6-5

PL/SQL support of, SQL 6-5

session cursor cache count statistic, SRF C-17

session cursor cache hits statistic, SRF C-17

session data unit

adjusting to improve network performance, NET 3-13

configuring, NET 7-7

Session Data Unit (SDU), STU 22-3, STU 23-5

Session Data Unit (SDU) Size option, NET 7-7

session key, OAS Glossary-6

session layer

described, NET 2-8, NET 2-12

Network Naming (NN), NET 2-12

Network Routing (NR), NET 2-12

Network Session (NS), NET 4-13, NET C-51

NS, NET 2-12, NET 4-13, NET C-51

RAW, NET 4-13, NET 7-55

Transparent Network Substrate (TNS), NET 2-12

Two-Task Common (TTC), NET 2-12

session limits, license

setting initially, SAD 2-13

session locks

releasing, SQL 7-100

session logical reads statistic, SRF C-17

session management, OCI 8-10, OCI 8-13

session memory statistic, STU 19-22

session monitor, SAD 4-8

SESSION parameter, NET 4-18, NET 7-55, NET C-56

session pga memory max statistic, SRF C-17

session pga memory statistic, SRF C-17

session stored procedure space statistic, SRF C-17

session uga memory max statistic, SRF C-18

session uga memory statistic, SRF C-18

session, user

active, SAD 4-16

inactive, SAD 4-17

marked to be terminated, SAD 4-17

terminating, SAD 4-15

viewing terminated sessions, SAD 4-17

SESSION_CACHED_CURSORS parameter, SRF 1-113, STU 18-7, STU 19-18

of ALTER SESSION, SQL 7-88

SESSION_CONTEXT view, SRF 2-182

SESSION_MAX_OPEN_FILES parameter, ADL 1-8, ADL 5-52, ADL 5-67, SRF 1-113

SESSION_PRIVS view, SRF 2-182

SESSION_ROLES view, SQL 7-570, SRF 2-182

queried from PL/SQL block, SCN 30-20

session-based IIOP, NET 7-52

sessions

auditing by, SCN 31-10

auditing connections and disconnections, SAD 25-8

beginning, PC_ F-26, PCO F-17

calculating resource cost limits, SQL 7-68

changing resource cost limits, SQL 7-68

connections contrasted with, SCN 8-4

current user, SCN 18-10

defined, SCN 8-4, SCN 31-10

disconnecting, SQL 7-99

enabling PARALLEL DML, SCN 26-38

granting

system privileges on, SQL 7-499

limit on concurrent, SCN 1-43

by license, SCN 29-20

limiting resource costs, SQL 7-68

limits per instance, SAD 23-2

limits per user, SCN 29-17

listing privilege domain of, SAD 24-23

memory allocation in the large pool, SCN 7-12

modifying characteristics of, SQL 7-81

number of concurrent, SQL 7-103

number of concurrent sessions, SAD 2-13

object cache, SQL 7-86

package state and, ADG 10 - 15, SCN 21-6

Parallel Server session limits, SAD 2-13

resource limits and, SCN 29-16

restricted, SQL 7-99

setting advice for transactions, DDS 3-22

setting maximum for instance, SAD 23-4

setting warning limit for instance, SAD 23-4

stack space in PGA, SCN 7-14

terminating, SQL 7-100

time limits on, SCN 29-17

transaction isolation level, SCN 27-31

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

viewing memory use, SAD 23-25

when auditing options take effect, SCN 31-6

where information is stored, SCN 7-14

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

SESSIONS parameter, SRF 1-114

ensuring LM lock capacity, SPS 16-6

SESSIONS_PER_USER parameter

of ALTER PROFILE, SQL 7-64

of CREATE PROFILE, SQL 7-339

session-specific variables, PLS 8-11

Set Alternate Key Columns dialog

Replication Manager, REP 2-20, REP 2-25

SET CACHE_CHECKPOINT_INTERVAL command, NET A-54

SET clause, PCO 5-10

in UPDATE statements, PC_ 6-10

of ALTER SESSION, SQL 7-81

of ALTER SYSTEM, SQL 7-100

of UPDATE, SQL 7-588

purpose of, PC_ 6-10

use of subqueries in, PC_ 6-10

using a subquery, PCO 5-10

SET command, NET A-12, NET A-53

AUTORECOVERY option, SBR 14-12

LOGSOURCE variable, SBR 14-8, SBR 14-12

set command (RMAN), SBR 11-129

duplex parameter, SBR 8-22

executed within run, SBR 11-133

maxcorrupt for datafile option, SBR 8-26

newname parameter, SBR 4-53, SBR 9-9

SET COMPATIBILITY command

SQL*Plus scripts, MIG 9-6

SET CONNECT_TIMEOUT command, NET A-14

SET CONSTRAINT(S) statement, SQL 7-568

SET CONSTRAINTS command

DEFERRABLE or IMMEDIATE, SCN 28-21

SET CURRENT_LISTENER command, NET A-14

SET DATABASE clause

of CREATE CONTROLFILE, SQL 7-246

Set Date dialog

Replication Manager, REP 2-12, REP 2-16

SET DEFAULT_DOMAIN command, NET A-55

SET DESCRIPTOR SQL statement, PC_ F-107

SET DESCRIPTOR statement, PC_ 14-18, PCO F-82

SET DISPLAYMODE command

of LSNRCTL, reference, NET A-16

SET FORWARDING_AVAILABLE command, NET A-56

SET INSTANCE command, SPS 18-6, SPS 18-18, SPS 18-20

instance startup, SPS 18-6, SPS 18-20

requires Net8, SPS 18-17

Set Interval dialog

Replication Manager, REP 2-13, REP 2-16

SET LOG_DIRECTORY command, NET A-17

SET LOG_FILE command, NET A-17

SET LOG_FILE_NAME command, NET A-57

SET LOG_STATS_INTERVAL command, NET A-58

SET LOG_STATUS command, NET A-18

SET NAMESCTL_TRACE_LEVEL command, NET A-59

set operator, PLS 5-6

set operators, SQL 3-12, SQL 7-550

SET PASSWORD command

of LSNRCTL, NET 8-5

of LSNRCTL, reference, NET A-18

of NAMESCTL, reference, NET A-60

SET RAWMODE command

of LSNRCTL, reference, NET A-19

SET REQUESTS_ENABLED command, NET A-61

SET RESET_STATS_INTERVAL command, NET A-62

SET ROLE command, ADG 12 - 4, ADG 12 - 14, SCN 16-5

how password is set, SAD 24-7

when using operating system roles, ADG 12 - 15

when using operating-system roles, SAD 24-19

SET ROLE statement, SQL 7-570

SET SAVE_CONFIG_INTERVAL command, NET A-63

SET SAVE_CONFIG_ON_STOP command, NET A-20

of NAMESCTL, reference, NET A-63

Set Scheduled Link dialog

Replication Manager, REP 2-12

SET SERVER command, NET A-64

SET STARTUP_WAITTIME command, NET A-20

SET STATEMENT_ID clause

of EXPLAIN PLAN, SQL 7-487

SET TRACE_FILE_NAME command, NET A-65

SET TRACE_LEVEL command, NET A-66

SET TRANSACTION command, ADG 8 - 8, SCN 16-5

ISOLATION LEVEL, SCN 27-7, SCN 27-31

ISOLATION LEVEL clause, ADG 8 - 26

READ ONLY, SCN 4-21

SERIALIZABLE, ADG 8 - 19, ADG 8 - 26

USE ROLLBACK SEGMENT option, SAD 21-13

SET TRANSACTION statement, PLS 5-46, SQL 7-572, STU 20-29

example, PCO 3-26

example of, PC_ 3-23

purpose of, PC_ 3-23

READ ONLY parameter, PCO 3-27

READ ONLY parameter in, PC_ 3-23

requirements for, PC_ 3-23

restrictions, PCO 3-27

restrictions on, PC_ 3-23

syntax, PLS 11-149

SET TRC_DIRECTORY command, NET A-21

SET TRC_FILE command, NET A-21

SET TRC_LEVEL command, NET A-22

SET UNTIL command, SPS 22-11

SET UNUSED clause

of ALTER TABLE, SQL 7-137

SET UNUSED option for columns, SCN 10-6

Set Up Server dialog box, LEG B-8

SET_ACTION

procedure in DBMS_APPLICATION_INFO, STU 5-2

SET_CLIENT_INFO

procedure in DBMS_APPLICATION_INFO, STU 5-2

SET_COLUMNS procedure

DBMS_REPCAT package, REP 2-25

set_disabled, RAR 8-39

SET_DISABLED procedure

DBMS_DEFER_SYS package, REP 2-15, REP 2-17, REP 2-18

SET_MODULE

procedure in DBMS_APPLICATION_INFO, STU 5-2

SET_SESSION_LONGOPS procedure

syntax change, MIG 8-33

SETLINKS, PSC 2-9

SETLINKS utility, PSC 2-9

DB_NAME.TBL file, PSC 2-9

OP.TBL, PSC 4-3

TEMPLATE.TBL, PSC 2-13, PSC 4-3

setting archive buffer parameters, SAD 7-22

setting internal LOBs to empty, ADL 3-8

setting LOBs to NULL, ADL 3-7

setting NLS parameters, NLS 2-1

Setting up access to Foreign Systems, DDS 6-7

setup master site, RAR 2-4

setup wizard

Create Master Sites page, REP 2-32

Create Scheduled Link property sheet, REP 2-14, REP 2-17

Create Schema dialog, REP 2-9

creating

administrator accounts, REP 2-8

propagator accounts, REP 2-8

receiver accounts, REP 2-8

Customize Master Site property sheet, REP 2-10

Edit DB Connection property sheet, REP 2-17, REP 2-18

Edit Scheduled Link property sheet, REP 2-14

Finish page, REP 2-10

New Master Site dialog, REP 2-8

Replication Manager, REP 2-7

SGA, SRF 1-11

determining buffers in cache, SAD 2-11

flushing, SQL 7-99

See Also system global area

updating, SQL 7-98

See system global area

SGA size, STU 19-7, STU 26-20

SGA statistics, STU 16-2

SGA, defined, PSC 1-9

SGADEF file, GTK 6-7

shadow column groups, REP 6-8

shadow processes, SCN 8-22

open cursors and, MIG 2-17

SHADOW_CORE_DUMP parameter, SRF 1-114

share locks

share table locks (S), SCN 27-24

share locks (S)

LOCK TABLE command, ADG 8 - 13

SHARE ROW EXCLUSIVE lock mode, SQL 7-521

share row exclusive locks (SRX)

LOCK TABLE command, ADG 8 - 15

SHARE UPDATE lock mode, SQL 7-521

SHARED clause

of CREATE DATABASE LINK, SQL 7-256

shared data structures mode, OCI 2-19

shared database links, DDS 2-6

configurations, DDS 2-8

creating, DDS 2-8

to dedicated servers, DDS 2-9

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

shared disk storage subsystem, PSC 2-5

shared disk system

advantages, SPS 3-6

implementations, SPS 3-3

scalability, SPS 2-3

with shared nothing system, SPS 3-9

shared exclusive mode, SPS 8-7

shared global area (SGA), SCN 7-2

See also system global area

SHARED keyword, DDS 2-8

shared library, DCI 4-2

naming conventions, DCI 2-7

shared memory system

scalability, SPS 2-5

tightly coupled, SPS 3-3

shared mode, OCI 2-19

database access, SPS 4-2

datafiles, SPS 6-2

file operation restrictions, SPS A-18

instance number, SPS 18-16

instance recovery, SPS 22-2

OCIInitialize(), OCI 2-20

OCIStmtPrepare(), OCI 2-21

recovery restrictions, SPS 22-7

rollback segments, SCN 4-27

rollback segments and, SAD 21-3

startup, SPS 18-15

using environmental variables, OCI 2-21

shared nothing system

advantages, SPS 3-8

disadvantages, SPS 3-8

disk access, SPS 3-2

massively parallel systems, SPS 3-7

overview, SPS 3-7

scalability, SPS 2-3

with shared disk system, SPS 3-9

SHARED option, SPS 18-13

shared Oracle home, PSC B-12

shared pool, SCN 7-6, STU 2-10

allocation of, SCN 7-10

ANALYZE command and, SAD 20-8, SCN 7-11

contention, STU 2-11

dependency management and, SCN 7-11

described, SCN 7-6

flushing, SCN 7-11

keeping objects pinned in, STU 10-3

multi-threaded server and, STU 19-21

object dependencies and, SCN 21-10

overview of, SCN 1-16

procedures and packages, SCN 18-17

row cache and, SCN 7-10

size of, SCN 7-6

tuning, STU 19-10, STU 19-23

shared resource system, SPS 17-13

shared server processes

changing the minimum number of, SAD 4-6

creating additional, SQL 7-105

maximum number, SRF 1-75

privileges to change number of, SAD 4-6

terminating, SQL 7-105

trace files for, SAD 4-10

shared server processes (Snnn), SCN 8-14, SCN 8-19

described, SCN 8-19

shared servers, SCN 1-18

advantages and disadvantages, NET 3-10

cannot connect with administrator privileges, SCN 5-3

configuring, STU 23-4

described, NET 2-20

processes, STU 21-13

recommended for, NET 3-10

see also multi-threaded servers

shared SQL area, SPS 5-5, SPS 12-6

shared SQL areas, SCN 7-8, SCN 16-7

ANALYZE command and, SAD 20-8, SCN 7-11

dependency management and, SCN 7-11

described, SCN 7-8

finding large areas, STU 10-5

identical SQL statements, STU 10-2

keeping in the shared pool, STU 10-3

loading SQL into, SCN 16-11

memory allocation, STU 19-15

overview of, SCN 1-16, SCN 16-7

parse locks and, SCN 27-29

procedures, packages, triggers and, SCN 7-10

size of, SCN 7-8

statements considered, STU 10-1

shared SQL for remote and distributed statements, DDS 2-26

shared structures

interoperability, MIG 8-17

SHARED_MEMORY_ADDRESS parameter, SCN 7-13, SRF 1-115

SHARED_POOL_RESERVED_MIN_ALLOC parameter, SRF 1-115

SHARED_POOL_RESERVED_SIZE parameter, SRF 1-115, STU 19-24, STU 19-25

V$SHARED_POOL_RESERVED, SRF 3-105

SHARED_POOL_SIZE initialization parameter

changes in release 8.1, MIG 6-3, MIG 7-34

parallel execution allocation, MIG B-9

SHARED_POOL_SIZE parameter, SCN 7-6, SRF 1-116, STU 19-20, STU 19-25

allocating library cache, STU 19-15

system global area size and, SCN 7-13

tuning the shared pool, STU 19-21

short records with missing data

SQL*Loader, SUT 5-42

short waits

definition, STU 20-47

short-circuit evaluation, PLS 2-44

shortcuts

CONNECT, for auditing, SAD 25-8

object auditing, SAD 25-9

object privileges, SAD 24-3

statement level auditing options, SAD 25-8

SHORTINT

C Language datatype, SUT 5-59

SHOW

Import parameter, SUT 1-4, SUT 2-28

SHOW CACHE_CHECKPOINT INTERVAL command, NET A-67

SHOW command, NET A-24

PARAMETERS option, SRF 1-9

SHOW CONNECT_TIMEOUT command, NET A-24

SHOW CURRENT_LISTENER command, NET A-24

SHOW DEFAULT_DOMAIN command, NET A-69

SHOW DISPLAYMODE command, NET A-24

SHOW FORWARDING_AVAILABLE command, NET A-68

SHOW INSTANCE command, SPS 18-19, SPS 18-20

SHOW LOG_DIRECTORY command, NET A-24

SHOW LOG_FILE command, NET A-24

SHOW LOG_FILE_NAME command, NET A-70

SHOW LOG_STATS_INTERVAL command, NET A-71

SHOW LOG_STATUS command, NET A-24

SHOW NAMESCTL_TRACE_LEVEL command, NET A-72

SHOW PARAMETERS command, SPS 18-19, SPS 18-21

instance number, SPS 18-16

SHOW PASSWORD command, NET A-24

SHOW RAW_MODE command, NET A-24

SHOW REQUESTS_ENABLED command, NET A-73

SHOW RESETS_STATS_INTERVAL command, NET A-74

SHOW SERVER command, NET A-74

SHOW SGA command, SPS 18-19, SPS 18-21

SHOW SGA statement, STU 19-6

SHOW STARTUP_WAITTIME command, NET A-24

SHOW STATUS command, NET A-75

SHOW SYSTEM_QUERIES command, NET A-76

SHOW TRACE_FILE_NAME command, NET A-77

SHOW TRACE_LEVEL command, NET A-78

SHOW TRC_DIRECTORY command, NET A-24

SHOW TRC_FILE command, NET A-24

SHOW TRC_LEVEL command, NET A-24

SHOW USE_PLUGANDPLAY command, NET A-24

SHOW VERSION command, NET A-79

SHOW_TNS_INFO parameter, NET C-79

SHOWSAVE_CONFIG_ON_STOP command, NET A-24

SHRINK clause

of ALTER ROLLBACK SEGMENT, SQL 7-74

Shut Down menu

Abort Instance option, SAD 3-12

Immediate option, SAD 3-11

SHUTDOWN

triggers on, SQL 7-405

shutdown, SCN 5-9, SCN 5-10

abnormal, SCN 5-6, SCN 5-10

audit record, SCN 31-5

deallocation of the SGA, SCN 7-2

prohibited by dispatcher processes, SCN 8-20

steps, SCN 5-9

SHUTDOWN ABORT command, SCN 5-10

crash recovery required, SCN 32-4

SHUTDOWN command, NET A-80

ABORT option, SAD 3-12, SBR 13-7, SBR 14-17, SBR 14-18, SBR 14-26, SBR 15-12, SPS 18-27

consistent whole database backups, SBR 3-3

IMMEDIATE option, SAD 3-11, SPS 18-27

NORMAL option, SAD 3-11

specifying an instance, SPS 18-20

shutdown command (RMAN), SBR 11-137

SHUTDOWN event

triggers on, SQL 7-405

shutdown of the Oracle Parallel Server database, PSC 6-24

setting Oracle Parallel Server parameters, PSC 6-39

with SYSDBA privilege, PSC 5-28

with SYSOPER privilege, PSC 5-28

shutdown results, PSC 6-24

shutdown types, PSC 6-22

abort, PSC 6-22

immediate, PSC 6-22

normal, PSC 6-22

shutdown database and other services, PSC 6-22

shutdown database only, PSC 6-22

shutting down a database, SAD 3-1

shutting down an instance, SPS 18-26

abnormal shutdown, SPS 18-27

aborting the instance, SAD 3-12

archiving redo log files, SPS 21-10

changing startup order, SPS 18-16

connecting and, SAD 3-9

connecting as INTERNAL, SAD 3-10

example of, SAD 3-11

forcing a log switch, SPS 21-10

immediately, SAD 3-11

lost sequence numbers, SPS 6-7

normally, SAD 3-10

unarchived log files, SPS 21-4

SID, NET 5-7, PSC 4-8, PSC C-6

defined, PSC 1-11

value, PSC 3-4, PSC 6-3

sid, NET 4-9

SID field, NET 7-69

SID parameter, NET 4-9, NET 5-7, NET C-49, SPS 18-6

SID Prefix, PSC 3-4, PSC 4-8

SID, configuring on the listener, NET 6-71

SID, defined, PSC 1-11

SID_DESC parameter, NET C-60, PSC C-6

SID_LIST parameter, NET 4-13, NET 6-8, NET C-57, NET C-60

SID_LIST_listener_name parameter, PSC 4-12, PSC 4-37, PSC C-6

SID_NAME parameter, NET 6-71, NET 7-66, NET 7-69, NET C-59, PSC C-6

SID_startup, PSC 4-29, PSC C-8

SIDALRT.LOG file, PSC C-12

SIDBSP0.TRC file, PSC C-12

SIDDBWR.TRC file, PSC C-11

side effect, DCI 5-6

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

controlling, PLS 7-7

SIDLCKN.TRC file, PSC C-12, PSC C-13

SIDLMDN.TRC file, PSC C-12

SIDLMON.TRC file, PSC C-12

SIDP00N.TRC file, PSC C-12

SIDs in LISTENER.ORA file, SCN 6-6

SIDSMON.TRC file, PSC C-11

SIGN function, SQL 4-36

signal handling

requirements for Oracle's operating system dependent call, NET 9-14

UNIX considerations, NET 9-13

using in conjunction with Net8, NET 9-14

signature checking, SCN 21-11

signature mismatch, DCI 5-9

signatures

PL/SQL library unit dependencies, ADG 10 - 28

to manage remote dependencies, ADG 10 - 29

significant characters, PLS 2-5

SIGNTYPE subtype, PLS 2-12

SILENT

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

simple comparison conditions, SQL 5-15

simple expressions, SQL 5-3

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

database management, SCN 33-20

Simple Network Management Protocol (SNMP) support

database management, DDS 1-20, SCN 33-20

simple subquery snapshots

many-to-many references, REP 3-13

many-to-one references, REP 3-13

simple symbol, PLS 2-3

SIN function, SQL 4-36

single domain naming model, NET 2-37

single instance database, SPS 1-15

single shared mode, SPS 4-2, SPS 10-5

single sign-on, OAS 11-3, OAS 21, GTK 3-9

Single Sign-On, described, NET 4-32

single table aggregate requirements, STU 29-13

SINGLE TABLE clause

of CREATE CLUSTER, SQL 7-239

SINGLE TABLE HASHKEYS, SCN 10-57

single table load

discontinued, SUT 5-34

single tier, STU 18-11

SINGLE_PROCESS parameter, SPS 18-15

single-byte character sets

Import, SUT 2-56

single-line comment, PLS 2-9

single-process systems

enabling distributed recovery, DDS 3-35

SINGLEROW

SQL*Loader, SUT 5-43

single-row functions, SQL 4-3

miscellaneous, SQL 4-4

single-table hash clusters, SCN 10-57

compatibility, MIG 8-10

dropping, MIG 12-9

single-table-only hash cluster, GTK 2-26

single-task linking, GTK 6-5

support, OCI 1-27

single-task message wait event, SRF A-47

SINH function, SQL 4-36

site autonomy, DDS 1-16, SCN 1-35, SCN 33-16

site ownership

dynamic, REP 6-4

primary, REP 6-4

site priority

altering, SPR 34 - 20, RAR 8-96

as a backup method during timestamp conflict resolution, REP 6-20

managing, REP 6-29

site priority groups, REP 6-29

adding members to, SPR 34 - 9, RAR 8-84, REP 6-30

altering members

priorities, REP 6-30

values, REP 6-31

creating, REP 6-30

syntax, SPR 34 - 43, RAR 8-121

dropping, SPR 34 - 52, RAR 8-132, REP 6-32

dropping members, REP 6-31

removing members from, SPR 34 - 52, RAR 8-133

using, REP 6-29

sites

dropping by priority level, REP 6-32

size

datafile, SAD 10-4

hash clusters, SAD 18-4

rollback segments, SAD 21-4

SIZE clause

of CREATE CLUSTER, SQL 7-238

of filespec clause, SQL 7-491

size constraint, subtype, PLS 2-25

size limit, varray, PLS 4-5

Size of an Integer and ROWID, PC_ E-2

size of backup sets, setting, SBR 4-31

SIZE option

allocating extents, SPS 17-14

SIZE parameter

of ALTER CLUSTER, SQL 7-4

SIZES procedure, STU 10-5

skew

workload, STU 27-32

skewing parallel DML workload, SCN 26-19

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, SBR 8-15

skip parameters

for arrays of structures, OCI 5-18

for standard arrays, OCI 5-20

skip readonly option (RMAN)

backup command, SBR 8-15

skip_corrupt_blocks procedure, SAD 19-5, SAD 19-11

SKIP_UNUSABLE_INDEXES parameter, SCN 21-8, SUT 2-28

of ALTER SESSION, SQL 7-88

SMALLINT datatype, SUT 5-59

ANSI, SQL 2-24

DB2, SQL 2-25

SQL/DS, SQL 2-25

SMALLINT subtype, PLS 2-13

smartcard, definition, OAS Glossary-7

smartcards, OAS 1-8, OAS 3-4

and RADIUS, OAS 1-7, OAS 3-4, OAS 3-7, OAS 3-22, OAS C-2

smit utility

restarting cdsadv service, OAS 13-14

SMON background process, SCN 8-11

See also system monitor process

SMON enqueue, SRF B-2

SMON process, PSC 1-10, SPS 5-6

instance recovery, SPS 22-2, SPS 22-3

recovery after SHUTDOWN ABORT, SPS 18-27

transaction recovery, SPS A-13

smon timer wait event, SRF A-47

SMP, SPS 1-15

SMP architecture

disk affinity, SCN 26-49

SNA, NET 4-26

snapshot, PC_ 3-16, PCO 3-19, PLS 5-41

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

refresh, SCN 8-13

same as materialized view, SCN 1-25, SCN 34-3

updatable, REP 1-8, SCN 34-9

snapshot control files, SBR 4-14

specifying location, SBR 5-3

snapshot descriptor, OCI 2-15

snapshot group

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

snapshot groups

managing, REP 5-6 to REP 5-23

snapshot log

Import, SUT 2-51

Snapshot Log property sheet, REP 7-23

General page, REP 7-37

Options page, REP 7-23

Storage page, REP 7-23

snapshot logs

altering, REP 7-23

privileges required, REP 7-23

deleting rows

privileges required, REP 7-25

dropping, REP 7-28

privileges required, REP 7-28

filter columns

adding, REP 7-23

managing space, REP 7-23

master table

dropping, REP 7-28

purging, SPR 45 - 4, SPR 45 - 5, RAR 8-255, RAR 8-256, RAR 8-257, REP 7-24

purging, REP 7-24

manual, REP 7-24

privileges required, REP 7-24

reducing space allocated to, REP 7-24

reorganizing master tables with, REP 7-25

storage parameters, SAD 12-10

truncating, REP 7-24

privileges required, REP 7-25

truncating master table with, REP 7-26

underlying table for, REP 3-15

snapshot logs. See materialized view logs.

snapshot refresh

job queue processes (SNPn), SCN 1-20, SCN 8-13

physical ROWIDs, MIG 11-6

snapshot refresh groups

managing, REP 7-35

snapshot refreshes

complete, REP 3-22

fast, REP 3-22

force, REP 3-23

group

refresh interval, REP 3-24

snapshot registration at master sites, REP A-4

snapshot site replication, REP 5-1 to REP 5-32

snapshot sites

changing masters, SPR 34 - 76, RAR 8-161

creating

syntax, SPR 34 - 37, RAR 8-114

creating refresh groups for, REP 5-29

database links for, REP 3-26

dropping, SPR 34 - 53, RAR 7-9, RAR 8-134

offline instantiation

advanced replication, REP 8-17

propagating changes to master, SPR 10 - 15, RAR 8-37

refreshing

syntax, SPR 34 - 64, RAR 8-148

scheduled links for, REP 2-12

guidelines, REP 2-14

scheduled purge for

guidelines, REP 2-17

snapshot sites and migration, REP B-6

snapshot too old message, SCN 27-5

SNAPSHOT_LOGS view, RAR 9-34

snapshots

altering definition, REP 5-27

cloning

offline instantiation, REP 8-14

cloning for basic replication, REP 8-15

complex, REP 3-5

value for PCTFREE, REP 3-22

value for PCTUSED, REP 3-22

creating, REP 5-24

creating schema for, REP 3-25

data dictionary views for, RAR 9-32 to RAR 9-37

datatypes supported, REP 3-17, REP 5-26

deleting from snapshot groups, REP 5-28

distributed database recovery, SBR 15-17

editing, REP 5-27

editing storage settings, REP 5-27

enabling/disabling replication for, REP 8-37

executing against, OCI 4-7

group, REP 1-4, SCN 34-6

groups

advanced management of, REP 7-2

importing, SUT 2-50

log

Import, SUT 2-50

managing, REP 5-23

managing base table, REP 5-27

master table

Import, SUT 2-51

media recovery and, SBR 15-17

offline instantiation of, SPR 22 - 2, SPR 22 - 3, RAR 8-55, RAR 8-57

primary key, REP A-3

read-only

registration, REP 7-37

simple with subqueries, REP A-3

unregistering, REP 7-37

refresh, REP 3-22, REP 3-24

failures, REP 7-34

querying for last refresh time, REP 7-37

retries, REP 7-34

troubleshooting, REP 7-34, REP 7-35

refresh groups, REP 5-28

data dictionary views, RAR 9-32

refreshing, SPR 45 - 7, SPR 45 - 9, SPR 45 - 10, RAR 8-259, RAR 8-261, RAR 8-263

replication

security for, REP 8-24

restoring dropped

Import, SUT 2-51

ROWID, REP 3-5

simple subquery

AND expression and, REP 3-13

EXISTS clause and, REP 3-13

filter columns requirement, REP 3-13

joins and, REP 3-13

number of columns in master tables, REP 3-13

site, REP 1-4, SCN 34-5

sites

changing masters, REP 7-3

SNAPSHOTS view, RAR 9-32

storage parameters, SAD 12-10

too old

OPTIMAL storage parameter and, SAD 21-5

trace file, REP 7-35

troubleshooting, REP 7-34

updatable

deferred constraints, REP A-4

updating, REP 3-22

upgrading, MIG 7-25

upgrading to primary key, REP B-10

using PL/SQL triggers with base tables, REP 5-27

viewing information about, REP 7-37

Snapshots page

Create Refresh Group property sheet, REP 5-29

snapshots. See Also materialized views

snapshots. See materialized views.

SNAPSHOTS view, RAR 9-32

SNMP, STU 12-5

SNMP support

database management, SCN 33-20

SNMPAGENT role, SQL 7-503

Snnn background processes, SCN 8-14

SNP background processes, REP 2-11, SRF 1-53

about, SAD 8-2

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

message propagation, SCN 19-10

.so files

naming conventions, DCI 2-7

software code areas, SCN 7-17

shared by programs and utilities, SCN 7-17

Software Packager, Oracle, GTK 2-58

software requirements, PSC 2-2, PSC 2-3

software versions, SAD 1-21

SOME, SCN 23-6

SOME comparison operator, PLS 5-5

SOME operator, SQL 3-6

sort areas, SCN 7-16

memory allocation, STU 20-34

process local area, STU 2-11

sort enhancements, SPS A-10

sort improvements, GTK 2-26

SORT MERGE JOIN, SPS 12-3

sort operations, SCN 3-12

sort segment enqueue, SRF B-2

sort segments, SCN 3-12

sort space, SPS A-10

SORT_AREA_RETAINED_SIZE parameter, SCN 7-16, SRF 1-117, STU 19-41, STU 20-36

of ALTER SESSION, SQL 7-88

of ALTER SYSTEM, SQL 7-108

SORT_AREA_SIZE parameter, SCN 4-18, SCN 7-16, SRF 1-118, STU 6-15, STU 7-21, STU 19-41, STU 26-22

and parallel execution, STU 26-22

cost-based optimization and, SCN 24-9

index creation and, ADG 6 - 2, SAD 16-3

of ALTER SESSION, SQL 7-89

of ALTER SYSTEM, SQL 7-108

tuning sorts, STU 20-35

SORT_DIRECT_WRITES parameter, SPS A-14, SRF 1-118

SORT_MULTIBLOCK_READ_COUNT parameter, SRF 1-119, STU 20-37, STU 26-29

of ALTER SESSION, SQL 7-89

of ALTER SYSTEM, SQL 7-108

SORT_READ_FAC parameter, SRF 1-119

SORT_SPACEMAP_SIZE parameter, SRF 1-119

SORT_WRITE_BUFFER_SIZE parameter, SRF 1-120

SORT_WRITE_BUFFERS parameter, SRF 1-120

SORTED INDEXES

direct path loads, SUT 5-43

example, SUT 4-25

SQL*Loader, SUT 8-17

sorting

character data, NLS 2-25

double characters, NLS 2-26

following language conventions, NLS 2-25

maximum memory, SRF 1-117

multiple column indexes

SQL*Loader, SUT 8-17

optimum sort order

SQL*Loader, SUT 8-18

order, NLS 2-25

ORDER BY queries, SRF 1-81

presorting in direct path load, SUT 8-16

SORTED INDEXES statement

SQL*Loader, SUT 8-17

specifying non-default, NLS 2-27, NLS 2-28

sort-merge joins, SCN 24-4

access path, SCN 23-46

cost-based optimization, SCN 24-9

example, SCN 23-46

sorts

(disk) statistic, STU 20-34

(memory) statistic, STU 20-34

avoiding on index creation, STU 20-37

tuning, STU 20-34

sorts (disk) statistic, SRF C-18

sorts (memory) statistic, SRF C-18

sorts (rows) statistic, SRF C-18

Sorts in Memory data view, STU 15-11

Sorts on Disk data view, STU 15-11

SOUNDEX function, SQL 4-37

source data for tuning, STU 12-1

source database

definition, MIG 1-3

SOURCE_ROUTE parameter, NET 4-12, NET 5-11, NET 7-11, NET 7-12, NET 7-34, NET 7-37, NET 7-42, NET C-41

SOURCE_SIZE view, SRF 2-182

SP date format element suffix, SQL 2-45

space

adding to the database, SAD 9-4

allocating extents, SPS 17-13

deallocating unused, SPS 17-16

determining unused, SPS 17-16

free blocks, SPS 11-2, SPS 11-17

free list, SPS 11-2

not allocated to instance, SPS 11-6, SPS 17-12

reducing snapshot log, REP 7-24

SGA, SPS 18-21

sources of free blocks, SPS 11-6

unavailable in exclusive mode, SPS 17-11

used by indexes, SAD 16-14

space management, STU 26-70

compression of free space in blocks, SCN 4-9

data blocks, SCN 4-5

direct-load INSERT, SCN 25-8

extents, SCN 4-11

MINIMUM EXTENT parameter, SCN 26-33

parallel DDL, SCN 26-33

parallel execution, STU 27-12

PCTFREE, SAD 12-2, SCN 4-6

PCTUSED, SAD 12-4, SCN 4-6

reducing transactions, STU 27-12

row chaining, SCN 4-10

segments, SCN 4-16

space management transaction enqueue, SRF B-2

space requirements

copying data, MIG 2-15

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

spaces

where allowed, PLS 2-2

spaghetti code, PLS 3-15

sparse collection, PLS 4-3

Spatial

compatibility, MIG 8-15

spatial applications

index-organized tables, SCN 10-42

Spatial cartridge

use in power demand example, DCI 11-54

spatial data, GTK 2-10

SPAWN command, NET A-25

special characters, SUT A-2

specialized servers, SPS 1-5

specification

cursor, PLS 5-12

function, PLS 7-6

method, PLS 9-8

object, PLS 9-5

package, PLS 8-5

procedure, PLS 7-4

SPECIFICATION clause

of ALTER PACKAGE, SQL 7-60

specifying destinations

for archived redo logs, SAD 7-11, SBR 2-19

specifying multiple ARCH processes, SAD 7-20

speed-down, SPS 1-8, SPS 1-13

speedup

definition, SPS 1-7

with batch processing, SPS 1-13

spelled numbers

specifying, SQL 2-45

spin count, STU 18-9

SPIN_COUNT parameter, SRF 1-120

SPINCOUNT parameter, STU 21-2

SPLIT PARTITION clause, SAD 13-18

ALTER INDEX command, SAD 13-18

ALTER TABLE command, SAD 13-11, SAD 13-17

of ALTER INDEX, SQL 7-33, SQL 7-40

of ALTER TABLE, SQL 7-150

SPLIT PARTITION command

no-logging mode, SCN 11-58, SCN 25-7

rules of parallelism, SCN 26-25

splitting mirrors

suspend/resume mode, SBR 13-9

SPOOL

Migration utility option, MIG 3-14

SPTH date format element suffix, SQL 2-45

SPX

described, NET 4-25

parameters for addresses, NET 6-79

SQL, ADQ 1-5, SCN 16-2, SMS 46-1

benefits of, PC_ 1-3

comparison operators, PLS 5-5

compatibility, MIG 8-14

cursors used in, SCN 16-6

Data Definition Language (DDL), SCN 16-4

Data Manipulation Language (DML), SCN 16-3

data manipulation statements, PLS 5-2

description of, SQL 1-2

dynamic, PLS 10-2

dynamic SQL, SCN 16-19

embedded, SCN 1-53, SCN 16-5, SQL 1-3

user-defined datatypes, SCN 13-14

Embedded SQL, PC_ 1-3

extension

partition or subpartition name, SCN 11-63

functions, SCN 16-2, SQL 4-1

column default values, SCN 10-8

COUNT, SCN 10-35

in CHECK constraints, SCN 28-18

NVL, SCN 10-8

optimizing view queries, SCN 23-23

key words, SUT A-2

keywords, SQL A-1

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-52, SCN 16-2

parallel execution, SCN 26-2

parameters, SQL A-1

parsing of, SCN 16-7

PL/SQL and, SCN 1-55, SCN 16-15

pseudocolumn, PLS 5-3

recursive, SCN 16-6

cursors and, SCN 16-7

removing incompatibilities for downgrading, MIG 12-25

reserved words, SCN 16-3, SUT A-2

row operators, PLS 5-6

session control statements, SCN 16-5

set operators, PLS 5-6

shared SQL, SCN 16-7

special characters, SUT A-2

standards, SQL 1-2, SQL B - 1

statement-level rollback, SCN 17-4

statements

auditing, SQL 7-200

determining the cost of, SQL 7-486

summary of statements, PCO F-4

support in PL/SQL, PLS 1-20

syntax, SQL 7-1, SQL A-1

system control statements, SCN 16-5

transaction control statements, SCN 16-5

transactions and, SCN 1-53, SCN 17-2, SCN 17-5

types of statements in, SCN 1-52, SCN 16-3

optimizing, SCN 23-3

user-defined datatypes, SCN 13-13, SCN 14-8

embedded SQL, SCN 13-14

OCI, SCN 13-15

SQL area

shared, SPS 12-6

SQL area tuning, STU 19-7

SQL areas

private, SCN 7-8

persistent, SCN 7-8

runtime, SCN 7-8

shared, SCN 1-16, SCN 7-8, SCN 16-7

SQL capabilities

data dictionary tables, DDS 6-11

SQL codes

returned by SQLGLS routine, PCO 8-35

sql command (RMAN), SBR 11-140

SQL commands

applying log files, SBR 14-14

for recovering tablespace, SBR 14-14

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

SQLCA, PC_ 9-16

SQL cursor

syntax, PLS 11-151

SQL DDL

BFILE security, ADL 5-8

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

SQLDA, PC_ 13-26, PC_ 15-4

SQL dialect, DDS 5-3

SQL directives

CONTEXT USE, PC_ 11-9, PC_ F-33

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-111

VAR, PC_ F-116, PCO F-89

WHENEVER, PC_ F-119, PCO F-91

SQL directives CONTEXT USE, PCO F-21

SQL DML

BFILE security, ADL 5-8

SQL errors

ORA-00900, DDS 4-11

ORA-02015, DDS 4-11

SQL functions

aggregate, SQL 4-5

character

returning character values, SQL 4-3

returning number values, SQL 4-3

date, SQL 4-4

new in Oracle8i, MIG E-3

number, SQL 4-3

object reference, SQL 4-4

single-row, SQL 4-3

miscellaneous, SQL 4-4

SQL Loader, STU 26-63

SQL operators

applying to fields, SUT 5-88

SQL Parse event, STU 15-5

SQL query

binding placeholders. See bind operation

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

defining output variables. See define operation

fetching results, OCI 4-14

statement type, OCI 1-9

SQL scripts

creating the data dictionary, SRF 5-2

migrating from Server Manager to SQL*Plus, MIG 10-1

optional, SRF 5-3

required, SRF 5-2

SQL service, DDS 5-2

capabilities, DDS 5-3

data dictionary views, DDS 6-8

SQL statement

controlling transactions, PCO 3-19

instance-specific, SPS 18-18

optimizing to improve performance, PCO D-5

reducing parsing, DDS 7-4

restrictions, SPS B-2

static versus dynamic, PCO 2-6

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

using to manipulate data, PCO 5-7

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

SQL statements, OCI 1-7, SCN 1-52, SCN 16-3, SCN 16-8

ALLOCATE, PC_ F-12, PCO F-10

ALLOCATE DESCRIPTOR, PCO F-12

ALLOCATE DESCRIPTOR TYPE, PC_ F-14

array processing, SCN 16-13

auditing, SCN 31-7, SCN 31-9

overview, SCN 1-44

when records generated, SCN 31-4

auditing by access, SQL 7-199

auditing by proxy, SQL 7-199

auditing by session, SQL 7-199

auditing by user, SQL 7-199

auditing successful, SQL 7-199

avoiding the use of indexes, STU 6-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, SCN 23-3, SCN 23-13

optimizing, SCN 23-13

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-31

converting

examples of, SCN 23-10

creating cursors, SCN 16-11

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

decomposition, STU 8-3

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-486

determining type prepared, OCI 4-4

dictionary cache locks and, SCN 27-30

disabling audit options, SAD 25-12

distributed

defined, SCN 23-4, SCN 33-11

optimization of, SCN 23-30

routing to nodes, SCN 16-11

distributed databases and, DDS 1-11

embedded, SCN 16-5

ENABLE THREADS, PC_ F-50

enabling audit options on, SAD 25-10

ensuring the use of indexes, STU 6-6

executable versus directive, PC_ 2-3

EXECUTE, PC_ F-53, PCO F-40

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

EXECUTE DESCRIPTOR, PCO F-42

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

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

executing, OCI 4-6

execution, ADG 8 - 2, SCN 16-8, SCN 16-13

execution plans of, SCN 22-2

failure in, SCN 32-2

FETCH, PC_ F-58, PCO F-45, PCO F-48

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

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

FREE, PC_ F-63, PCO F-50

GET DESCRIPTOR, PCO F-51

handles, SCN 1-17

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

inefficient, STU 18-7

INSERT, PC_ F-68, PCO F-54

larger than 32 KB, SPR 48 - 12

LOB APPEND, PC_ F-72, PCO F-57

LOB ASSIGN, PC_ F-73, PCO F-58

LOB CLOSE, PC_ F-73, PCO F-58

LOB COPY, PC_ F-74, PCO F-59

LOB CREATE, PC_ F-74, PCO F-59

LOB DESCRIBE, PC_ F-75, PCO F-60

LOB DISABLE BUFFERING, PC_ F-76, PCO F-61

LOB ENABLE BUFFERING, PC_ F-77, PCO F-62

LOB ERASE, PC_ F-77, PCO F-62

LOB FILE CLOSE, PC_ F-78, PCO F-63

LOB FILE SET, PC_ F-79, PCO F-64

LOB FLUSH BUFFER, PC_ F-79, PCO F-64

LOB FREE TEMPORARY, PC_ F-80, PCO F-65

LOB LOAD, PC_ F-80, PCO F-65

LOB OPEN, PC_ F-81, PCO F-66

LOB READ, PC_ F-82, PCO F-67

LOB TRIM, PC_ F-82, PCO F-67

LOB WRITE, PC_ F-83, PCO F-68

mapping to non-Oracle datastores, DDS 7-2

matching with outlines, STU 7-27

modifying indexed data, STU 6-5

multiple, DDS 7-4

not allowed in triggers, ADG 13 - 20

number of triggers fired by single, SCN 20-21

OBJECT CREATE, PC_ F-84

OBJECT DELETE, PC_ F-85

OBJECT DEREF, PC_ F-86

OBJECT FLUSH, PC_ F-87

OBJECT GET, PC_ F-88

OBJECT RELEASE, PC_ F-89

OBJECT SET, PC_ F-90

OBJECT UPDATE, PC_ F-91

OPEN, PC_ F-92, PCO F-69, PCO F-70, PCO F-71

OPEN DESCRIPTOR, PC_ F-94, PCO F-71

optimization

complex statements, SCN 23-13

types of statements, SCN 23-3

optimizing to improve performance, PC_ C-5

overview, SCN 1-52

parallel execution, SCN 26-2

parallelizing, SCN 26-2, SCN 26-10

parse locks, SCN 27-29

parsing, SCN 16-11

PREPARE, PC_ F-96, PCO F-73

preparing for execution, OCI 4-4

privileges required for, ADG 12 - 11, SCN 30-3

processing, OCI 4-2

recursive, STU 10-1

OPTIMIZER_GOAL does not affect, SCN 23-32

referencing dependent objects, SCN 21-4

REGISTER CONNECT, PC_ F-98

remote

defined, SCN 23-4, SCN 33-11

reparsing, STU 18-6

resource limits and, SCN 29-16

ROLLBACK, PC_ F-99, PCO F-74

rolling back, SQL 7-537

rules for executing, PC_ C-5

SAVEPOINT, PC_ F-103, PCO F-78

SELECT, PC_ F-104, PCO F-79

SET DESCRIPTOR, PC_ F-107, PCO F-82

simple, SCN 23-3

stopping auditing of, SQL 7-523

successful execution, SCN 17-3

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

tracking the occurrence in a session, SQL 7-197

transactions, SCN 16-14

triggers on, SCN 20-2, SCN 20-8

triggering events, SCN 20-6

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-52, SCN 16-3, SCN 23-3

undoing, SQL 7-537

UPDATE, PC_ F-112, PCO F-85

when constraint checking occurs, ADG 5 - 18

SQL string

applying SQL operators to fields, SUT 5-88

example, SUT 4-28

quotation marks, SUT 5-19

SQL text match, STU 31-7, STU 31-22

SQL trace facility, STU 12-6, STU 14-2, STU 14-6, STU 19-8, STU 19-39

enabling, STU 14-4

example of output, STU 14-15

output, STU 14-12

parse calls, STU 19-8

statement truncation, STU 14-14

steps to follow, STU 14-3

trace file, STU 12-3

trace files, STU 14-4

when to enable, SAD 4-12

SQL*Forms

display error screen in, PC_ 20-8

IAP constants, PCO 12-8

IAP constants in, PC_ 20-8

returning values to, PC_ 20-8, PCO 12-8

reverse return code switch in, PC_ 20-8

user exit, PCO 12-3

SQL*Loader, GTK 2-36, GTK 2-47, GTK 2-56, SCN 1-6, SMS 24-1

about, SAD 1-17

appending rows to tables, SUT 5-32

bad file, SUT 3-12

BADDN keyword, SUT 5-25

BADFILE keyword, SUT 5-25

basics, SUT 3-2

bind arrays and performance, SUT 5-76

BINDSIZE

command-line parameter, SUT 6-4

BINDSIZE command-line parameter, SUT 5-76

case studies, SUT 4-1

case studies (direct path load), SUT 4-25

case studies (extracting data from a formatted report), SUT 4-28

case studies (loading combined physical records), SUT 4-15

case studies (loading data into multiple tables), SUT 4-19

case studies (loading delimited, free-format files), SUT 4-11

case studies (loading fixed-length data), SUT 4-8

case studies (loading variable-length data), SUT 4-5

case studies associated files, SUT 4-3

choosing which rows to load, SUT 5-40

command-line parameters, SUT 6-2

CONCATENATE keyword, SUT 5-36

concepts, SUT 3-1

concurrent sessions, SUT 8-27

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-9

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-9

DB2 load utility, SUT B-1

DIRECT command line parameter, SUT 8-10

DIRECT command-line parameter, SUT 6-5

direct load

NOLOGGING mode, SCN 11-58, SCN 25-7

parallel direct load, SCN 25-2

similar to direct-load INSERT, SCN 25-2

direct path method, SUT 3-15

DISCARD command-line parameter, SUT 6-5

discard file, SUT 3-14

discarded records, SUT 3-12

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-50

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 6 - 2, SAD 16-3

inserting rows into tables, SUT 5-33

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-14

methods for loading data into tables, SUT 5-32

methods of loading data, SUT 3-15

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-26, SUT 8-30

parallel loading, SUT 8-27

PARFILE command-line parameter, SUT 6-6

partition operations, SCN 11-48, SCN 11-50

preparing tables for case studies, SUT 4-4

READBUFFERS keyword, SUT 5-24

rejected records, SUT 3-12

replacing rows in tables, SUT 5-33

required privileges, SUT 3-15

reserved words, SUT A-2

ROWS command-line parameter, SUT 6-7

SILENT command-line parameter, SUT 6-8

SINGLEROW index keyword, SUT 5-43

SKIP command-line parameter, SUT 6-9

SKIP keyword, SUT 5-35

SORTED INDEXES during direct path loads, SUT 5-43

specifying columns, SUT 5-46

specifying datafiles, SUT 5-22

specifying field conditions, SUT 5-44

specifying fields, SUT 5-46

specifying more than one data file, SUT 5-23

suppressing messages, SUT 6-8

updating rows, SUT 5-33

USERID command-line parameter, SUT 6-9

SQL*Loader log file

global information, SUT 7-2

SQL*Menu

PL/SQL, SCN 16-16

SQL*Module

applications, ADG 10 - 4

FIPS flagger, SCN 16-6

for Ada, MIG 8-19

stored procedures, SCN 16-18

SQL*Net

connecting using Version 2, PC_ 3-4

migrating to Net8, MIG 6-4, MIG 8-46

relinking, MIG 9-2

SQL*Net V1

cannot use with Oracle8i, MIG 9-2

upgrading from V1 to V2, MIG 8-46

use with Oracle8i, MIG 9-2

See Net8

SQL*Net and Net8 differences, NET 5-2

SQL*Net break/reset to client wait event, SRF A-16

SQL*Net break/reset to dblink wait event, SRF A-17

SQL*Net Easy Configuration, described, NET 5-2

SQL*Net message from client wait event, SRF A-17

SQL*Net message from dblink wait event, SRF A-17

SQL*Net message to client wait event, SRF A-18

SQL*Net message to dblink wait event, SRF A-18

SQL*Net more data from client wait event, SRF A-18

SQL*Net more data from dblink wait event, SRF A-19

SQL*Net more data to client wait event, SRF A-19

SQL*Net more data to dblink wait event, SRF A-19

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

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

SQL*Net See Net8

SQL*Net, level required by Biometric Authentication Service, OAS 7-5

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

ALERT file, SCN 8-15

anonymous blocks, ADG 10 - 4, SCN 16-17

applying log files, SBR 14-12

compile-time errors, ADG 10 - 42

connecting with, SCN 29-4

creating a sequence, SPR 1 - 5

differences with Server Manager

ampersands, MIG 10-12

blank lines, MIG 10-10

commands, MIG 10-3

comments, MIG 10-7

COMMIT command, MIG 10-14

CREATE LIBRARY command, MIG 10-13

CREATE TYPE command, MIG 10-13

hyphen continuation character, MIG 10-10

startup, MIG 10-2

syntax, MIG 10-7

executing a package, SCN 18-6

executing a procedure, SCN 18-4

invoking stored procedures, ADG 10 - 50

loading a procedure, ADG 10 - 10

lock and latch monitors, SCN 27-29

migrating from Server Manager to, MIG 10-1

parallel recovery, SCN 32-11

session variables, SCN 16-17

SET SERVEROUTPUT ON command, ADG 10 - 3

SHOW ERRORS command, ADG 10 - 42

showing size of SGA, SCN 7-13

SQL statements, SCN 16-2

statistics monitor, SCN 29-19

stored procedures, SCN 16-18

using to test SELECT statements, PC_ 6-8

versus embedded SQL, PC_ 1-3

SQL*Plus commands

See commands, SQL*Plus

SQL*Plus script, STU 12-7

SQL*Plus scripts

upgrading, MIG 9-6

SQL, dynamic, PC_ 2-6

SQL_CURSOR, PC_ F-12, PCO F-10

SQL_SINGLE_RCTX

defined constant, PC_ 5-52

definition of, PC_ 5-47

SQL_STATEMENT column

TKPROF_TABLE, STU 14-18

SQL_TRACE parameter, SCN 8-15, SRF 1-120, STU 14-5

of ALTER SESSION, SQL 7-89

trace files and, SAD 4-10

SQL92, SCN 27-2, SQL 1-2

Oracle compliance with, SQL B - 2

SQL92_SECURITY initialization parameter, GTK 6-2

SQL92_SECURITY parameter, SRF 1-120

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-3

components in, PC_ 9-19

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

declaring, PC_ 9-16

description of, PC_ 9-16

explicit versus implicit checking of, PC_ 9-3

fields, PCO 8-23

including multiple times, PC_ 5-34

interaction with Oracle, PCO 2-10

overview, PCO 2-9

overview of, PC_ 2-9

SQLCABC component in, PC_ 9-19

SQLCABC field, PCO 8-23

SQLCAID component in, PC_ 9-19

SQLCAID field, PCO 8-23

sqlcode component in, PC_ 9-19

SQLCODE field, PCO 8-23

sqlerrd, PC_ 9-21

SQLERRD(3) field, PCO 8-24

SQLERRD(5) field, PCO 8-25

sqlerrd[2] component in, PC_ 9-21

sqlerrmc component in, PC_ 9-20

SQLERRMC field, PCO 8-24

sqlerrml component in, PC_ 9-20

SQLERRML field, PCO 8-24

sqlwarn, PC_ 9-22

SQLWARN(4) flag, PCO 8-25

use in separate precompilations, PC_ 2-18

using in separate precompilations, PCO 2-28

using more than one, PC_ 9-16

using with Net8, PCO 8-19

using with SQL*Net, PC_ 9-16

SQLCA status variable

data structure, PCO 8-20

declaring, PCO 8-21

effect of MODE option, PCO 8-4

explicit versus implicit checking, PCO 8-3

purpose, PCO 8-19

SQLCABC field, PCO 8-23

sqlca.h

listing of, PC_ 9-17

use of SQLCA_STORAGE_CLASS with, PC_ 2-17

SQLCAID component, PC_ 9-19

SQLCAID field, PCO 8-23

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-38

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

declaring, PCO 8-5

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-23

interpreting its value, PCO 8-23

SQLCODE function, PLS 6-18

syntax, PLS 11-153

SQLCODE status variable

declaring, PC_ 9-13, PCO 8-5

description, PCO 8-3

effect of MODE option, PCO 8-4

SQL92 deprecated feature, PCO 8-3

usage, PCO 8-4

when declared with the SQLCA, PC_ 9-14

when used, PC_ 9-14

SQLCODE variable

interpreting values of, PCO 8-10

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-23

conversion to Oracle datatypes, SQL 2-25

restrictions on, SQL 2-25

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-24

using with batch fetch, PCO 7-8

SQLERRD(3) variable, PCO 8-22

SQLERRD(5) field, PCO 8-25

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-155

sqlerrmc component, PC_ 9-20

SQLERRMC field, PCO 8-24

SQLERRMC variable, PCO 8-22

sqlerrml component, PC_ 9-20

SQLERRML field, PCO 8-24

SQLERROR

WHENEVER directive condition, PC_ F-120

SQLERROR condition, PCO 8-28

in the WHENEVER statement, PC_ 9-24

meaning of, PC_ 9-24

of WHENEVER directive, PCO 8-28

WHENEVER directive, PCO F-92

SQLErrorGetText(), PC_ 5-52

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

SQLFC parameter, PCO 8-35

SQLGLM subroutine

example, PCO 8-27

parameters, PCO 8-26

provides DSNTIAR support for DB2 conversions, PCO 8-27

purpose, PCO 8-26

restrictions, PCO 8-27

syntax, PCO 8-26

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-34, PCO 8-35

parameters, PCO 8-35

SQL codes returned by, PCO 8-35

syntax, PCO 8-35

using to obtain SQL text, PCO 8-34

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

replacement for, PCO 12-14

syntax for, PC_ 20-8

using in user exit, PCO 12-8

SQLIEM subroutine

restrictions, PCO 8-27

SQLJ See Oracle SQLJ

sqlld2() function, PC_ 5-56

sqlld2t() function

see SQLLDAGetName, PC_ 5-53

SQLLDA routine, PCO 3-17

SQLLDAGetName, PC_ 5-53

sqlldat() function

see SQLCDAGetCurrent, PC_ 5-53

SQLLIB

and embedded SQL, PC_ 2-5

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 calls

relinking, MIG 9-5

work against Oracle8i, MIG 9-5

SQLLIB function

SQLSQLDAAlloc, PC_ 5-52

SQLVarcharGetLength, PC_ 5-53

SQLNET.ALTERNATE_PORT parameter, NET C-23

SQLNET.AUTHENTICATION_KERBEROS5_ SERVICE parameter, NET C-17

SQLNET.AUTHENTICATION_SERVICES parameter, NET C-16

SQLNET.AUTHENTICATION_TIMEOUT parameter, NET C-24

SQLNET.CLIENT_AUTHENTICATION parameter, NET C-26

SQLNET.CLIENT_REGISTRATION parameter, NET 7-23, NET C-17

SQLNET.CRYPTO_CHECKSUM_CLIENT parameter, NET C-17

SQLNET.CRYPTO_CHECKSUM_SERVER parameter, NET C-18

SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT parameter, NET C-18

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER parameter, NET C-18

SQLNET.CRYPTO_SEED parameter, NET C-19

SQLNET.ENCRYPTION_CLIENT parameter, NET C-19

SQLNET.ENCRYPTION_SERVER parameter, NET C-19

SQLNET.ENCRYPTION_TYPES_CLIENT parameter, NET C-20

SQLNET.ENCRYPTION_TYPES_SERVER parameter, NET C-20

SQLNET.EXPIRE_TIME parameter, NET 7-23, NET C-20

SQLNET.IDENTIX_FINGERPRINT_DATABASE parameter, NET C-21

SQLNET.IDENTIX_FINGERPRINT_DATABASE_ PASSWORD parameter, NET C-21

SQLNET.IDENTIX_FINGERPRINT_DATABASE_ USER parameter, NET C-21

SQLNET.IDENTIX_FINGERPRINT_METHOD parameter, NET C-21

SQLNET.KERBEROS5_CC_NAME parameter, NET C-22

SQLNET.KERBEROS5_CLOCKSKEW parameter, NET C-22

SQLNET.KERBEROS5_CONF parameter, NET C-22

SQLNET.KERBEROS5_KEYTAB parameter, NET C-23

SQLNET.KERBEROS5_REALMS parameter, NET C-23, NET C-25

SQLNET.LOG file

sample client-side error stack, NET 11-17

SQLNET.LOG file contents, NET 11-18

SQLNET.ORA file, PSC 4-13

configuring, PSC 4-32

NAMES_DIRECTORY_PATH parameter, PSC 4-32

see profiles (SQLNET.ORA)

sqlnet.ora file

modifying so CDS can resolve names, OAS 13-17

sample, OAS A-2

SQLNET.RADIUS_ALTERNATE_PORT parameter, NET C-23

SQLNET.RADIUS_ALTERNATE_RETRIES parameter, NET C-24

SQLNET.RADIUS_AUTHENTICATION parameter, NET C-24

SQLNET.RADIUS_AUTHENTICATION_INTERFACE parameter, NET C-24

SQLNET.RADIUS_AUTHENTICATION_PORT parameter, NET C-24

SQLNET.RADIUS_AUTHENTICATION_TIMEOUT parameter, NET C-25

SQLNET.RADIUS_CHALLENGE_RESPONSE parameter, NET C-25

SQLNET.RADIUS_SEND_ACCOUNTING parameter, NET C-26

SQLNETthread_id.TRC file, NET 11-37, NET C-29

SQLNET.TRC file, NET 11-37, NET C-29

SQLNET.TRC file contents, NET 11-32

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-38

SQLRowidGet(), PC_ 5-53

SQLSQLDAAlloc, PC_ 5-52

SQLSQLDAFree(), PC_ 5-52

SQLSTATE

class codes, PC_ 9-4

declaring, PC_ 9-4, PCO 8-6

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-10

coding scheme, PCO 8-10

effect of MODE option, PCO 8-4

interpreting values, PCO 8-10

predefined classes, PCO 8-11

predefined status codes and conditions, PCO 8-13

subclass code, PCO 8-10

usage, PCO 8-4

SQLSTM parameter, PCO 8-35

SQLSTM routine, PCO 8-35

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

SQLUTLCHAIN.SQL, STU 12-7

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-25

SQLWARNING

condition WHENEVER directive, PCO F-92

WHENEVER directive condition, PC_ F-120

SQLWARNING condition, PCO 8-28

in the WHENEVER statement, PC_ 9-24

meaning of, PC_ 9-24

of WHENEVER directive, PCO 8-28

SQRT function, SQL 4-38

SRC parameter, NET 7-39, NET C-80

SRV parameter, NET 7-39, NET C-80

SRX locks

LOCK Table command, ADG 8 - 15

SS date format element, SQL 2-41

SSL, OAS 1-7, GTK 2-70, NET 7-28

cipher suites, OAS B-8

configuring, OAS 9-25

client authentication parameter, OAS B-9

components in an Oracle environment, OAS 9-5

configuring for IIOP, NET 7-64

handshake, OAS 9-7

Public Key Infrastructure, GTK 2-73

requiring client authentication, OAS 9-28

system requirements, OAS 1-12

version parameter, OAS B-9

wallet location, parameter, OAS B-10

X.509v3 certificates, GTK 2-71

ssl, NET 7-64

SSL authentication method

see Oracle Advanced Security

SSL_CIPHER_SUITES parameter, NET C-26

SSL_CLIENT_ AUTHENTICATION, NET 7-64

SSL_VERSION, NET 7-64

SSL_VERSION parameter, NET C-26

SSSSS date format element, SQL 2-41

ST enqueue, STU 27-12

stack, PLS 9-13

stack communications

and Net8, NET 2-12

described, NET 2-6

server side interaction, NET 2-13

stack space, SCN 7-14

staging database, STU 28-1

staging file, STU 28-1

STALE status

of redo log members, SAD 6-15

STALE_TOLERATED mode, STU 31-19

standalone procedures

dropping, SQL 7-467

stand-alone Recovery Manager commands, SBR 4-8

standalone subprogram, PLS 1-18

standard cards, using SecurID, OAS 6-14

Standard Header Files, PC_ E-2

STANDARD package, STU 10-4

standard SQL, SQL B - 1

Oracle extensions to, SQL B - 5

standards, SCN 1-3

ANSI, ADG 8 - 19

ANSI/ISO, SCN 1-3, SCN 28-5, SCN 28-16

isolation levels, SCN 27-2, SCN 27-10

FIPS, SCN 16-6

integrity constraints, SCN 28-5, SCN 28-16

Oracle adherence, SCN 1-3

standby control file

creating, SQL 7-19

standby database

activating, SQL 7-11

compatibility, MIG 8-41

designing media recovery, SQL 7-12

migrating to Oracle8i, MIG 8-41

mounting, SCN 5-7, SQL 7-11

recovering, SQL 7-13, SQL 7-14

survivability, SCN 32-26

standby databases, SBR 16-2 to SBR 16-29, SPS 18-33, SPS 22-16

advantages, SBR 16-2

altering control files, SBR 16-25

archived redo logs

transmitting, SBR 16-7

control files

refreshing, SBR 16-29

creating, SBR 16-2

procedures, SBR 16-3

datafiles

renaming, SBR 16-24

taking offline, SBR 16-27

definition, SBR 16-2

direct path operations, SBR 16-27

effect of altering primary database, SBR 16-22

initialization parameters, SBR 16-25

maintaining, SBR 16-6

manual recovery mode

procedures, SBR 16-6

standby database, SBR 16-5

modes, SBR 16-5

read-only mode, SBR 16-5, SBR 16-19

redo log files

altering, SBR 16-24

sustained recovery mode, SBR 16-5

transmitting archived redo logs, SBR 16-7

standby transmission mode

definition of, SAD 7-15

Net8 and, SAD 7-15

RFS processes and, SAD 7-15

STANDBY_ARCHIVE_DEST initialization parameter, SBR 16-26

STANDBY_ARCHIVE_DEST parameter, SRF 1-121

of ALTER SYSTEM, SQL 7-108

STAR hint, SCN 24-15, SQL 2-60, STU 7-52

star joins, SCN 24-14

star query, SCN 24-14, STU 11-8

denormalized views, SCN 24-15

extended star schemas, SCN 24-15

hints, SCN 24-15

indexes, SCN 24-15

star transformation, SCN 24-16

tuning, SCN 24-15

star schema, STU 11-8

star schemas

denormalized views, SCN 24-15

star transformation, SCN 24-16, STU 7-66, STU 11-8

example, SCN 24-16

restrictions, SCN 24-20

STAR_TRANSFORMATION hint, SCN 24-19, SQL 2-62, STU 7-66, STU 11-8

STAR_TRANSFORMATION_ENABLED parameter, SCN 24-19, SRF 1-121, STU 7-67, STU 11-8

of ALTER SESSION, SQL 7-89

star-query optimization, GTK 3-3

START

defined, PSC 1-4

on Windows NT, PSC 1-4

Start, NET 8-3

start, NET 8-5

START CMAN command, NET 8-7

start columns

in partitioning and EXPLAIN PLAN, STU 13-15

START command

of CMCTL, reference, NET A-90

of LSNRCTL, NET 6-64, NET 8-5

of LSNRCTL, reference, NET A-25

of NAMESCTL, NET 6-31, NET 6-36, NET 8-3

of NAMESCTL, reference, NET A-81

START option

automatic archiving, SRF 1-60

START statement in Oracle Trace, STU 15-19, STU 15-20

Start Up Instance dialog box, SAD 3-2

START WITH clause, PLS 5-4

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

of CREATE SEQUENCE, SQL 7-351

of SELECT, SQL 7-548

of SELECT and subqueries, SQL 7-543

START_CLIENT_CACHE, NET 8-4

START_CLIENT_CACHE command, NET A-83

starting

an instance

with multi-threaded servers, NET 9-4

an instance with dispatchers, NET 9-8

Console, PSC 5-15, PSC 6-14

listener, NET 8-5, PSC 4-9, PSC 4-18, PSC 4-39

Management Server, PSC 5-14, PSC 6-14

Net8 Assistant, NET 4-29

Net8 components, NET 8-2

Oracle Connection Manager, NET 8-7

Oracle Data Gatherer, PSC 5-30

Oracle Enterprise Manager, PSC 5-13

Oracle Intelligent Agents, PSC 5-13, PSC 6-14, PSC B-12

Oracle Names client cacher, NET 8-4

Oracle Names server, NET 6-31, NET 8-3

Oracle Parallel Server database, PSC 4-9, PSC 6-18, PSC 8-5

Oracle Performance Manager, PSC 7-4

from Console, PSC 5-32

standalone, PSC 5-31

the Console, PSC 6-14

the database, NET 8-6

starting a database

about, SAD 3-1

general procedures, SAD 3-2

starting an instance

at database creation, SAD 3-3

automatically at system startup, SAD 3-6

database closed and mounted, SAD 3-4

database name conflicts and, SAD 2-9

dispatcher processes and, SAD 4-5

enabling automatic archiving, SAD 7-9

examples of, SAD 3-6

exclusive mode, SAD 3-6

forcing, SAD 3-5

general procedures, SAD 3-2

mounting and opening the database, SAD 3-4

multi-threaded server and, SAD 3-2

normally, SAD 3-4

parallel mode, SAD 3-6

problems encountered while, SAD 3-5

recovery and, SAD 3-5

remote instance startup, SAD 3-6

restricted mode, SAD 3-4

with multi-threaded servers, SAD 4-4

without mounting a database, SAD 3-3

starting up

after file operations, SPS 15-6, SPS A-18

creating database and, SPS 14-3

database name, SRF 1-33

during instance recovery, SPS 14-4

exclusive mode, SPS 17-13, SPS 18-12

global constant parameters, SPS 6-9, SPS 18-9

instance number, SRF 1-52

remote instance, SPS 18-6, SPS 18-7, SPS 18-8, SPS 18-20

rollback segments, SPS 6-8, SPS 14-5

shared mode, SPS 18-15, SPS A-18

startup order, SPS 18-16, SRF 1-52

verifying access to files, SPS 6-2

STARTUP

triggers on, SQL 7-405

startup, SCN 5-2, SCN 5-5

allocation of the SGA, SCN 7-2

starting address, SCN 7-13

audit record, SCN 31-5

forcing, SCN 5-6

prohibited by dispatcher processes, SCN 8-20

recovery during, SCN 32-4

restricted mode, SCN 5-6

results, PSC 6-24

setting Parallel Server parameters for, PSC 6-37

steps, SCN 5-5

SYSDBA privilege, PSC 5-28

SYSOPER privilege, PSC 5-28

Startup (START)

defined, PSC 1-4

described, PSC 1-8

on Windows NT, PSC 1-4

STARTUP command, SAD 3-2, SPS 14-3, SPS 18-6, SPS 18-13

database name, SRF 1-33

FORCE option, SAD 3-5

MOUNT option, SAD 3-4, SBR 14-28, SBR 14-30, SPS 22-13

NOMOUNT option, SAD 2-6, SAD 3-3

of NAMESCTL, reference, NET A-83

of NAMESCTL, restriction, NET A-3, NET A-31

OPEN option, SPS 18-13

PFILE option, SPS 18-6, SPS 18-8

RECOVER option, SAD 3-5

specifying an instance, SPS 18-20

specifying database name, SAD 3-3

startup command (RMAN), SBR 11-142

STARTUP event

triggers on, SQL 7-405

STARTUP FORCE command

crash recovery required, SCN 32-4

startup troubleshooting, NET 8-11

startup types, PSC 6-19

force, PSC 6-19

mount, PSC 6-19

no mount, PSC 6-19

open, PSC 6-19

restrict, PSC 6-19

STARTUP_WAITTIME parameter, NET C-63

state

session, of package objects, ADG 10 - 15

statement

assignment, PLS 11-3

CLOSE, PLS 5-10, PLS 5-24, PLS 11-14

COMMIT, PLS 11-28

DELETE, PLS 11-49

dynamic SQL, PLS 10-2

EXECUTE IMMEDIATE, PLS 10-3

EXIT, PLS 11-61

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

FORALL, PLS 4-32

GOTO, PLS 11-84

IF, PLS 11-86

INSERT, PLS 11-89

LOCK TABLE, PLS 11-96

LOOP, PLS 11-98

NULL, PLS 11-104

OPEN, PLS 5-8, PLS 11-113

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

OPEN-FOR-USING, PLS 10-5

RAISE, PLS 11-132

RETURN, PLS 11-138

ROLLBACK, PLS 11-140

SAVEPOINT, PLS 11-144

SELECT INTO, PLS 11-145

SET TRANSACTION, PLS 11-149

UPDATE, PLS 11-159

statement failures, SBR 1-12

definition, SBR 1-12

statement handle

attributes, OCI A-14

description, OCI 2-10

statement terminator, PLS 11-12

statement triggers, SCN 20-8

conditional code for statements, ADG 13 - 17

described, SCN 20-8

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 20-21

See also triggers

STATEMENT_ID column

PLAN_TABLE table, STU 13-3

statement-level read consistency, SCN 27-5

statement-level rollback, PCO 3-23, PLS 5-43

breaking deadlocks, PCO 3-24

description of, PC_ 3-22

to break deadlocks, PC_ 3-22

statements

See SQL statements

static arrays

binding, OCI 5-10

defining, OCI 5-17

STATIC clause

of ALTER TYPE, SQL 7-174

of CREATE TYPE, SQL 7-416

of CREATE TYPE BODY, SQL 7-422

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-14

dropped columns, MIG C-11

renamed columns, MIG C-13

obsolete in Oracle8i, MIG 8-24, MIG C-15

static hashing

lock mastering scheme, SPS 8-9

STATISTICS

Export parameter, SUT 1-23

statistics, STU 16-2, STU 27-31, STU 31-23, SUT 2-63

associating

with columns, SQL 7-195

with datatypes, SQL 7-196

with domain indexes, SQL 7-196

with functions, SQL 7-196

with indextypes, SQL 7-196

with packages, SQL 7-196

auditing conflict resolution, REP 7-18

checkpoint, SCN 8-11

collecting, SPR 34 - 66, RAR 8-150

computing exactly, SQL 7-188

consistent gets, STU 19-26, STU 21-4, STU 21-22

current value, STU 16-4

db block gets, STU 19-26, STU 21-4

dbwr checkpoints, SRF 1-68

deleting, REP 7-19

deleting from the data dictionary, SQL 7-190

dispatcher processes, STU 21-7

estimated, SCN 22-14

block sampling, SCN 22-14

row sampling, SCN 22-14

estimating, SQL 7-188

exporting and importing, SCN 22-8

extensible optimization, SCN 22-16

for conflict resolution, REP 7-18

forcing disassociation, SQL 7-445

from ANALYZE, SCN 22-13

from B*-tree or bitmap index, SCN 22-12

gathering with DBMS_STATS, STU 7-9

generating, STU 7-7

generating and managing with DBMS_STATS, SCN 22-12

generating for cost-based optimization, STU 7-7

HIGH_VALUE and LOW_VALUE, SCN 23-52

max session memory, STU 19-22

on indexes, SQL 7-283

operating system, STU 26-83

optimizer goal, SCN 23-32

optimizer mode, SCN 23-31

optimizer use of, SCN 22-7, SCN 22-8, SCN 23-32

partitioned tables and indexes, SCN 11-14

partitions and subpartitions, SCN 22-11

physical reads, STU 19-26

query servers, STU 21-14

queuing, SCN 19-11

rate of change, STU 16-5

selectivity of predicates, SCN 22-8

histograms, SCN 22-8, SCN 22-10

user-defined, SCN 22-17

session memory, STU 19-22

shared server processes, STU 21-10, STU 21-15

sorts (disk), STU 20-34

sorts (memory), STU 20-34

specifying for Export, SUT 1-23, SUT 2-27

timed, SRF 1-124

tuning, SPS 19-2

undo block, STU 21-3

updating, SAD 20-4

user-defined

dropping, SQL 7-452, SQL 7-454, SQL 7-456, SQL 7-466, SQL 7-475, SQL 7-480

user-defined statistics, SCN 22-17

when to generate, STU 7-24

statistics generation for long running operations, GTK 2-28

statistics types

disassociating

from columns, SQL 7-444

from functions, SQL 7-444

from packages, SQL 7-444

from types, SQL 7-444

disassociating from domain indexes, SQL 7-444

disassociating from indextypes, SQL 7-444

STATS command, NET A-91

status, NET 8-5

propagation, SPR 10 - 6, RAR 8-25

status codes

meaning of, PC_ 9-14

status codes for error reporting, PCO 8-22

STATUS command

of CMCTL, reference, NET A-92

of LSNRCTL, NET 8-5

of LSNRCTL, reference, NET A-27

of NAMESCTL, reference, NET A-84

Status Details tab, PSC 6-25

from Edit Parallel Server dialog box, PSC 6-29

from Parallel Server Operation Results dialog box, PSC 6-25

Status tab

from Edit Parallel Server dialog box, PSC 6-28

status variables, PC_ 9-2

STDDEV aggregate function, PLS 5-3

STDDEV function, SQL 4-38

Step, SAD 1-18, SAD 1-20

STEP clause

mimicking, PLS 3-12

stepwise refinement, PLS 1-2

STMLEN parameter, PCO 8-35

STMT_AUDIT_OPTION_MAP table

auditing option type codes, SRF 2-183

stop, NET 8-5

STOP action

in the WHENEVER statement, PC_ 9-25

of WHENEVER directive, PC_ F-120, PCO 8-30, PCO F-92

result of, PC_ 9-25

stop columns

in partitioning and EXPLAIN PLAN, STU 13-15

STOP command

of CMCTL, reference, NET A-92

of LSNRCTL, NET 6-64, NET 8-5

of LSNRCTL, reference, NET A-29

of NAMESCTL, reference, NET A-85

STOP NOW command

of CMCTL, reference, NET A-93

Stop on Error setting

Create New Scheduled Link property sheet, REP 2-13

STOP statement in Oracle Trace, STU 15-19, STU 15-20

stopping

listener, PSC 4-16, PSC 4-37

Oracle Parallel Server database, PSC 6-21

storage

altering tablespaces, SAD 9-8

clusters, SCN 10-49

datafiles, SCN 3-16

file, STU 20-5

fragmentation in parallel DDL, SCN 26-33

hash clusters, SCN 10-51

index partitions, SCN 11-37

indexes, SCN 10-26

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

nested tables, SCN 14-19

nulls, SCN 10-7

object tables, SCN 14-18

parallel INSERT, SCN 25-8

quotas and, SAD 23-14

REFs, SCN 14-19

restricting for users, SCN 29-14

revoking tablespaces and, SAD 23-14, SCN 29-14

table partitions, SCN 11-27

tablespace quotas and, SCN 29-14

triggers, SCN 20-2, SCN 20-25

unlimited quotas, SAD 23-14

user quotas on, SCN 1-42

view definitions, SCN 10-14

storage character sets, NLS A-6

supported, NLS A-7

storage characteristics

resetting, SQL 7-581

STORAGE clause, SQL 7-575

CREATE TABLE statement, STU 20-24

examples, STU 20-24

modifying parameters, STU 20-33

modifying SQL.BSQ, STU 20-33

of ALTER CLUSTER, SQL 7-4

of ALTER INDEX, SQL 7-30

of ALTER MATERIALIZED VIEW, SQL 7-46

of ALTER MATERIALIZED VIEW LOG, SQL 7-54

of ALTER ROLLBACK SEGMENT, SQL 7-73, SQL 7-74

of CREATE INDEX, SQL 7-281

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

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

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.

of CREATE ROLLBACK SEGMENTS, SQL 7-346

of CREATE TABLE, SQL 7-361, SQL 7-370

of CREATE TABLESPACE, SQL 7-394

OPTIMAL, STU 20-30

parallel execution, SCN 26-33

parallel query, STU 27-21

using, SCN 4-11

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-132

STORAGE keyword, SUT 8-29

storage options

clustered tables, SPS 17-6, SPS A-20

extent size, SPS 6-8, SPS 17-11, SPS 17-13, SPS 17-14

index, SPS 17-8

rollback segment, SPS 6-8

table, SPS 17-6

Storage page

Snapshot Log property sheet, REP 7-23

STORAGE parameter

of ALTER INDEX, SQL 7-30, SQL 7-35

storage parameters, SUT 2-52

applicable objects, SAD 12-7

changing settings, SAD 12-11

data dictionary, SAD 20-26

default, SAD 12-7

estimating export requirements, SUT 1-9

exporting tables, SUT 1-16

for the data dictionary, SAD 20-27

INITIAL, SAD 12-7, SAD 14-11

INITRANS, SAD 12-9, SAD 14-11

MAXEXTENTS, SAD 12-8

MAXEXTENTS UNLIMITED, SCN 26-40

MAXTRANS, SAD 12-9, SAD 14-11

MINEXTENTS, SAD 12-8, SAD 14-11

NEXT, SAD 12-8, SCN 25-8

calculating, SCN 25-9

OPTIMAL (in rollback segments), SAD 21-5, SCN 4-25, SCN 26-40

OPTIMAL parameter, SUT 2-53

overriding

Import, SUT 2-53

parallel direct-load INSERT, SCN 25-8

PCTFREE, ADG 3 - 9, SAD 14-10

PCTINCREASE, SAD 12-8, SCN 25-8, SCN 25-10

PCTUSED, ADG 3 - 9, SAD 14-10

preallocating

direct path load, SUT 8-16

precedence of, SAD 12-11

rollback segments, SAD 21-8

setting, SCN 4-11

snapshot log

altering, REP 7-23

SYSTEM rollback segment, SAD 21-9

temporary for a direct path load, SUT 8-11

temporary segments, SAD 12-12

storage settings

editing for snapshots, REP 5-27

storage_clause

of CREATE CLUSTER, SQL 7-238

STORAGE_ERROR exception, PLS 6-6

when raised, PLS 7-38

STORE AS clause, ADG 16 - 32

STORE IN DEFAULT clause

of CREATE INDEX, SQL 7-285

STORE IN tablespace clause

of CREATE INDEX, SQL 7-285

store table, PLS 4-4

store-and-forward replication, REP 2-3

stored functions, ADG 10 - 5, SCN 1-26, SCN 18-2, SCN 18-6, SQL 7-267

creating, ADG 10 - 9

describing, OCI 6-2

importing, SUT 2-61

stored outlines

assigning category names to, STU 7-28

creating, using, STU 7-28

downgrading, MIG 12-36

dropping, STU 7-30

dropping unused, STU 7-30

execution plans and Plan Stability, STU 7-25

hints, STU 7-26

managing with OUTLN_PKG, STU 7-30

matching with SQL statements, STU 7-27

OUTLN_PKG package, SPR 55 - 1

reassigning categories, STU 7-31

storage requirements, STU 7-27

tables, moving, STU 7-31

using, STU 7-28

viewing data for, STU 7-29

stored packages

importing, SUT 2-61

stored procedure

opening a cursor, PCO 6-38

sample programs, PCO 6-38

stored procedures, ADG 10 - 5, SCN 1-26, SCN 16-15, SCN 18-2, SCN 18-6, SPS 7-8

argument values, ADG 10 - 53

calling, SCN 16-18

contrasted with anonymous blocks, SCN 18-9

creating, ADG 10 - 9

describing, OCI 6-2

direct path load, SUT 8-24

distributed query creation, ADG 10 - 47, DDS 4-3

exceptions, ADG 10 - 44, ADG 10 - 45

importing, SUT 2-61

in Oracle Trace, STU 15-24

invoking, ADG 10 - 50

KEEP, STU 10-5

managing privileges, DDS 2-25

names of, ADG 10 - 5

opening a cursor, PCO 6-34

overloading names of, ADG 10 - 12

parameter

default values, ADG 10 - 9

privileges, ADG 10 - 53

privileges for recompiling, SAD 20-25

program example, PC_ 7-23

READ_MODULE, STU 5-5

registering with the database, STU 5-1, STU 12-7

remote, ADG 10 - 54

remote object security, DDS 2-25

remote objects and, ADG 10 - 55

sample programs, PCO 6-24

SET_ACTION, STU 5-3

SET_CLIENT_INFO, STU 5-4

SET_MODULE, STU 5-2

SIZES, STU 10-5

storing, ADG 10 - 9

synonyms, ADG 10 - 56

triggers contrasted with, SCN 20-2

using privileges granted to PUBLIC, ADG 12 - 22, SAD 24-16

variables and constants, SCN 16-17

See also procedures

stored procedures, Java, GTK 2-19

stored scripts

creating, SBR 6-20

deleting, SBR 6-22

executing, SBR 6-21

listing all, SBR 6-22

managing, SBR 6-20

printing, SBR 6-22

Recovery Manager, SBR 4-10

replacing, SBR 6-21

stored subprogram, PLS 1-18, PLS 7-11

calling, PCO 6-23

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

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-14

strategies

backup, SBR 3-15 to SBR 3-24

backups

ARCHIVELOG mode, SBR 3-16

NOARCHIVELOG mode, SBR 3-16

recovery

deciding what to recovery, SBR 3-28

determining when media recovery is necessary, SBR 3-30

stream

tape drive, SAD 7-23

stream record format, SUT 5-91

stream record format records, SUT 3-6

STRING

external datatype, OCI 3-11

string comparison semantics, PLS B-2

string comparisons, SUT 5-15

and WHERE clause, NLS 4-7

SQL*Loader, SUT 5-46

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

string host variables

declaring, PC_ 5-8

string literal, PLS 2-8

string literals

continuing on the next line, PCO 2-13

string manipulation using OCI, NLS 5-6

STRING subtype, PLS 2-18

strings

passing as parameters, OCI 2-31

striping, STU 20-22, STU 26-38

analyzing, STU 26-41

and disk affinity, STU 27-16

example, STU 26-63

examples, STU 20-24

local, STU 26-40

manual, STU 20-23, STU 26-38, STU 26-39

media recovery, STU 26-44

operating system, STU 26-38

operating system software, STU 20-25

Oracle, STU 26-39

temporary tablespace, STU 26-70

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

structure theorem, PLS 3-2

structured payload, ADQ 1-5

Structured Query Language (SQL), SCN 1-52, SCN 16-2

See also SQL

Structured Query Language. See SQL.

structures

arrays of, OCI 5-17

data blocks

shown in rowids, SCN 12-18

data dictionary, SCN 1-30, SCN 2-1

datafiles

shown in rowids, SCN 12-18

locking, SCN 27-28

logical, SCN 1-5, SCN 1-9, SCN 4-1

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

extents, SCN 1-10, SCN 4-2, SCN 4-11

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

segments, SCN 1-10, SCN 4-2, SCN 4-16

tablespaces, SCN 1-9, SCN 3-1, SCN 3-6

memory, SCN 1-14, SCN 7-1

physical, SCN 1-5, SCN 1-11

control files, SCN 1-13, SCN 32-21

datafiles, SCN 1-11, SCN 3-1, SCN 3-16

redo log files, SCN 1-12, SCN 32-7

processes, SCN 1-14, SCN 1-17, SCN 8-1

structures (structs)

nesting not permitted for host, PC_ 4-41

stub, PLS 3-19, PLS 7-3

SUBPARTITION BY HASH clause

of CREATE TABLE, SQL 7-364, SQL 7-378

SUBPARTITION clause

of ANALYZE, SQL 7-188

of CREATE INDEX, SQL 7-285

of CREATE TABLE, SQL 7-379

of DELETE, SQL 7-441

of INSERT, SQL 7-515

of LOCK TABLE, SQL 7-521

of SELECT, SQL 7-546

of UPDATE, SQL 7-587

subpartition locks

DML, SCN 11-46

SUBPARTITION option, SCN 11-63

subpartition-extended table names, SQL 2-65

in DML statements, SQL 2-65

restrictions on, SQL 2-66

syntax, SQL 2-66

subpartitions

adding, SQL 7-146

adding rows to, SQL 7-513

allocating extents for, SQL 7-140, SQL 7-146

coalescing, SQL 7-146

converting into nonpartitioned tables, SQL 7-152

creating, SQL 7-364, SQL 7-379

deallocating unused space from, SQL 7-141, SQL 7-146

inserting rows into, SQL 7-515

locking, SQL 7-520

logging insert operations, SQL 7-142

moving to a different segment, SQL 7-147

physical attributes

changing, SQL 7-135

removing rows from, SQL 7-150, SQL 7-441

renaming, SQL 7-147

revising values in, SQL 7-587

specifying, SQL 7-378

statistics, SCN 22-11

SUBPARTITIONS clause

of CREATE TABLE, SQL 7-378

subprogram, PLS 7-2

advantages, PLS 7-3

declaring, PLS 7-9

how calls are resolved, PLS 7-25

local, PLS 1-18

overloading, PLS 7-23

packaged, PLS 1-18, PLS 7-10

parts, PLS 7-2

procedure versus function, PLS 7-5

recursive, PLS 7-38

standalone, PLS 1-18

stored, PLS 1-18, PLS 7-11

subprogram, PL/SQL, PCO 6-4

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

subqueries, DDS 2-25, SCN 16-12, SQL 5-18, SQL 7-541, SQL 7-544

CHECK constraints prohibit, SCN 28-18

containing subqueries, SQL 5-24

converting to joins, SCN 23-13

correlated, SQL 5-24

defined, SQL 5-18

definition of, PC_ 6-9

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

in DDL statements, SCN 26-31

in DML statements

serializable isolation, SCN 27-14

in remote updates, DDS 1-11, SCN 33-11

inline views, SCN 10-16

NOT IN, SCN 24-13

optimizing IN subquery, SCN 23-17

query processing, SCN 16-12

to insert table data, SQL 7-384

uses for, PC_ 6-9

using in the SET clause, PC_ 6-10

using in the VALUES clause, PC_ 6-9

See also queries

subqueries for snapshots, REP A-3

subquery, PCO 5-10, PLS 5-11

correlated, STU 27-18

example, PCO 5-10

using in the SET clause, PCO 5-10

using in the VALUES clause, PCO 5-10

subquery snapshots

AND expression and, REP 3-13

EXIST clause and, REP 3-13

filter columns requirement, REP 3-13

joins for, REP 3-13

many-to-many references, REP 3-13

many-to-one references, REP 3-13

number of columns in master tables, REP 3-13

Subscribe, ADQ 1-7

SUBSCRIPT_BEYOND_COUNT exception, PLS 6-6

SUBSCRIPT_OUTSIDE_LIMIT exception, PLS 6-6

subscription & recipient lists, ADQ 1-8

subscription handle, OCI 2-11

attributes, OCI A-37

subscriptions

rule-based, SCN 19-5, SCN 19-6

sub-shared exclusive mode, SPS 8-7

sub-shared mode, SPS 8-7

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

SUBSTRB function, SQL 4-39

subtotal values

deriving, SQL 7-549

subtype, PLS 2-12, PLS 2-24

CHARACTER, PLS 2-14

compatibility, PLS 2-26

DEC, PLS 2-13

DECIMAL, PLS 2-13

defining, PLS 2-24

DOUBLE PRECISION, PLS 2-13

FLOAT, PLS 2-13

INT, PLS 2-13

INTEGER, PLS 2-13

NATURAL, PLS 2-12

NATURALN, PLS 2-12

NUMERIC, PLS 2-13

overloading, PLS 7-24

POSITIVE, PLS 2-12

POSITIVEN, PLS 2-12

REAL, PLS 2-13

SIGNTYPE, PLS 2-12

SMALLINT, PLS 2-13

STRING, PLS 2-18

VARCHAR, PLS 2-18

suggested development approach for data cartridge, DCI 2-14

SUM aggregate function, PLS 5-3

SUM function, SQL 4-40

summaries, SCN 10-17

summary advisor, STU 32-14

summary management, GTK 2-22, STU 28-3

compatibility, MIG 8-13

CREATE MATERIALIZED VIEW statement, GTK 2-22

dimensions (dimension schema object), GTK 2-22

materialized view, GTK 2-22

query rewrite, GTK 2-22

refreshing materialized views, GTK 2-22

summary advisory functions package (DBMS_OLAP), GTK 2-23

summary of planning results, NET 3-15

summed dirty queue length statistic, SRF C-18

SunSoft's SunNet Manager, SCN 33-20

SunSoft'sSunNetManager, DDS 1-20

supplied packages, SCN 18-16

invoker or definer rights, SCN 30-8

Support, ADQ 1-7

support for SQL, PLS 5-2

supported character sets, NLS 3-16

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

survivability, REP 8-11, SCN 32-26

design considerations, REP 8-13

Parallel Server and, REP 8-12

suspect save set, LEG 2-8

SUSPEND clause

of ALTER SYSTEM, SQL 7-100

SUSPEND option

ALTER SYSTEM command, SBR 13-9

SUSPEND_MASTER_ACTIVITY procedure

DBMS_REPCAT package, REP 2-23

suspending a database, SBR 13-9

suspend/resume mode, SBR 13-9

sustained recovery mode, SBR 16-5

sustained standby recovery mode, SQL 7-14

terminating, SQL 7-14

timeout period, SQL 7-14

SVR_PID.TRC file contents, NET 11-32

swapping, STU 17-4, STU 18-4

library cache, STU 19-15

reducing, STU 19-4

SGA, STU 19-41

switch archiving mode, SPS 14-2, SPS 14-9, SPS B-2

switch command (RMAN), SBR 11-144

Switch current to new buffer statistic, SRF C-5

SWITCH LOGFILE clause

of ALTER SYSTEM, SQL 7-100

SWITCH LOGFILE option

ALTER SYSTEM command, SAD 6-16

switch redo log file, SRF 1-67

switches, verifying, LEG B-5

switching processes, STU 18-4

sword

definition, OCI 3-27

SYEAR date format element, SQL 2-41

symbol

compound, PLS 2-4

simple, PLS 2-3

symbols

defining, PC_ 2-16

symmetric multiprocessor, SPS 2-5, SPS 3-2, SPS 3-4, STU 26-3

configuration, SPS 1-15

in loosely coupled system, SPS 3-5

parallel processing, SPS 1-5

SYN synonym for USER_SYNONYMS, SRF 2-183

synchronization

cost of, SPS 1-10, SPS 1-17, SPS 2-9, SPS 2-11, SPS 2-12

non-PCM, SPS 4-16

overhead, SPS 1-10

synchronized replication enqueue, SRF B-2

synchronous authentication mode, RADIUS, OAS 3-4

synchronous data operations, NET 2-4

synchronous data propagation, REP 1-15, REP 8-6, SCN 34-16

synchronously replicated transactions

destination of, REP 8-8

synonym

database links, PCO 3-15

synonyms, SCN 21-8

attributes, OCI 6-14

changing the definition of, SQL 7-474

constraints indirectly affect, SCN 28-5

CREATE command, DDS 2-22

creating, ADG 3 - 43, SAD 15-12, SQL 7-355

definition and creation, DDS 2-22

described, SCN 10-20

describing, OCI 6-2

direct path load, SUT 8-9

displaying dependencies of, SAD 20-32

dropped tables and, ADG 3 - 10, SAD 14-12

dropping, ADG 3 - 44, SAD 15-12

examples, DDS 2-23

Export, SUT 1-49

for data dictionary views, SCN 2-4

granting

system privileges on, SQL 7-499

inherit privileges from object, SCN 30-3

local, SQL 7-356

location transparency using, DDS 2-22

managing, SAD 15-11

managing privileges, DDS 2-24

name resolution, DDS 2-18

overview of, SCN 1-26

partition-extended table names, SCN 11-65

private, SAD 15-11, SCN 10-20

private, dropping, SQL 7-474

privileges, ADG 3 - 43

privileges for creating, SAD 15-12

privileges for dropping, SAD 15-12

public, SAD 15-11, SCN 10-20, SQL 7-356

dropping, SQL 7-474

remote, SQL 7-356

remote object security, DDS 2-24

removing from the database, SQL 7-474

renaming, SQL 7-527

stored procedures and packages, ADG 10 - 56

synonyms for, SQL 7-355

uses of, SCN 10-20

using, ADG 3 - 43

SYNONYMS view, SRF 2-183

syntactic checking, PCO E-2

syntax

continuation lines, PCO 2-13

embedded SQL statements, PCO 2-15

Export command, SUT 1-10

for CMCTL, NET A-89 to NET A-93

for listener configuration parameters, NET C-50 to NET C-64

for local naming configuration parameters, NET C-31 to NET C-49

for LSNRCTL, NET 8-15, NET A-4 to NET A-30

for NAMESCTL, NET A-34 to NET A-88

for Oracle Connection Manager configuration parameters, NET C-76 to NET C-80

for Oracle Names server configuration parameters, NET C-65 to NET C-75

for profile configuration parameters, NET C-7 to NET C-30

for protocol configuration parameters, NET C-81

Import command, SUT 2-7

loops, SQL A-2

multipart diagrams, SQL A-3

rules for configuration files, NET C-2

SQLADR subroutine, PCO 11-14

SQLGLM subroutine, PCO 8-26

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, SBR 11-2

syntax definition, PLS 11-1

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 diagram, reading, PLS 11-2

syntax diagrams, SQL A-1

description of, PCO F-7

explanation of, SBR 11-2

how to read, PCO F-7

how to use, PCO F-7

keywords, SBR 11-3

parameters, SBR 11-3

SQL*Loader, SUT 5-4

symbols used in, PCO F-7

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

SYS

initial password, SAD 1-5

objects owned, SAD 1-5

policies for protecting, SAD 22-7

privileges, SAD 1-5

user, SAD 1-5

SYS schema

database triggers stored in, SQL 7-407

functions stored in, SQL 7-407

user-created objects in, MIG 8-24

SYS username

data dictionary tables owned by, SCN 2-3

security domain of, SCN 29-3

statement execution not audited, SCN 31-5

temporary schema objects owned by, SCN 29-14

V$ views, SCN 2-7

SYS_CONTEXT function, SQL 4-40

SYS_GUID function, SQL 4-41

SYS_INCLUDE

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

SYS_INCLUDE precompiler option, PC_ 10-39

SYS_OBJECTS view, SRF 2-184

SYS.AUD$

audit trail, SAD 25-2

creating and deleting, SAD 25-4

SYS.AUD$ view

purging, SCN 2-5

SYSCATALOG view, SRF 2-183

SYSDATE datatype

example, SUT 4-28

SYSDATE function, ADG 4 - 9, PCO 4-7, SQL 4-42

SYSDATE keyword

SQL*Loader, SUT 5-56

SYSDBA, SPS 18-13, SPS 18-21, SPS 18-26, SPS 21-11, SUT 1-36

connecting in Pro*C/C++, MIG 8-18

connecting in Pro*COBOL, MIG 8-19

SYSDBA privilege, PCO A-3, PSC 5-21, PSC 5-28, PSC 6-38, SCN 5-3

SYSDBA privilege, granting, PSC 5-26

SYSDBA privileges, how to set, PCO 3-12

SYSDBA system privilege, SQL 7-502

SYSDBA/SYSOPER Privileges, PC_ A-5

SYSFILES view, SRF 2-183

SYS.INCEXP table

Export, SUT 1-51

SYS.INCFIL table

Export, SUT 1-51

SYS.INCVID table

Export, SUT 1-52

SYSOPER, SPS 18-13, SPS 18-21, SPS 18-26, SPS 21-11

SYSOPER privilege, PCO A-3, PSC 5-21, PSC 5-28, PSC 6-38, SCN 5-3

how to set, PCO 3-12

SYSOPER privilege, granting, PSC 5-26

SYSOPER system privilege, SQL 7-502

SYSOPER/SYSDBA privileges

adding users to the password file, SAD 1-12

connecting with, SAD 1-14

determining who has privileges, SAD 1-13

granting and revoking, SAD 1-13

SYSSEGOBJ view, SRF 2-183

SYSTEM

initial password, SAD 1-5

objects owned, SAD 1-5

policies for protecting, SAD 22-7

user, SAD 1-5

System Change Number (SCN)

checking for a datafile, SAD 10-14

in-doubt transactions, DDS 3-32

system change number (SCN), SPS 10-4

archive file format, SPS 21-5

archiving redo log files, SPS 21-4

definition, SBR 1-9

incrementation, SPS 4-4

Lamport, SPS 4-7

non-PCM lock, SPS 7-5

redo log history, SPS 21-6

use in distributed recovery, SBR 15-17

when determined, SAD 6-2

system change numbers (SCN)

committed transactions, SCN 17-5

coordination in a distributed database system, DDS 3-17

defined, SCN 17-5

read consistency and, SCN 27-5

redo logs, SCN 8-10

when determined, SCN 27-5

system commit number enqueue, SRF B-2

System Configuration File, PC_ E-3

system configuration file, PC_ 10-3

system control statements, SCN 1-53, SCN 16-5, SQL 6-5

PL/SQL support of, SQL 6-5

system date

altering, SQL 7-102

System Environment Variable, OAS 7-15

system events, ADG 14 - 1

attributes, ADG 14 - 2

attributes of, SQL 7-407

client events, ADG 14 - 5

resource manager events, ADG 14 - 4

tracking, ADG 13 - 52, ADG 14 - 1

triggers on, SQL 7-405

system failure

effect on transactions, PC_ 3-17

system failures, SBR 1-12

effect on transactions, PCO 3-20

System Global Area, SAD 2-11

system global area

holds sequence number cache, ADG 3 - 40

System Global Area (SGA), PC_ 7-20, PCO 6-21, SAD 2-11

buffer areas, SRF 1-25, SRF 1-67

buffer cache, SRF 1-25

in parallel server, SPS 5-5

instance, SPS 5-4

maximum concurrent transactions, SRF 1-125

parameter file, SPS 18-3

rollback segment size, SRF 1-72

row cache, SPS 6-6

sequence cache, SPS 6-6

SHOW SGA command, SPS 18-21

size of, SRF 1-25

statistics, SPS 18-21

system global area (SGA), SCN 7-2

allocating, SCN 5-5

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 29-18

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

redo log buffer, SCN 7-6, SCN 17-5

rollback segments and, SCN 17-5

shared and writable, SCN 7-3

shared pool, SCN 7-6

size of, SCN 7-12

variable parameters, SCN 5-4

when allocated, SCN 7-2

System Global Area (SGA), defined, PSC 1-9

system global area. See SGA.

System Global Area tuning, STU 19-5

system header files

specifying the location of, PC_ 12-5

System Identifier (SID) option

Net8 Assistant

System Identifier (SID) option, NET 6-71

system monitor process (SMON), SCN 8-11

defined, SCN 1-19, SCN 8-11

instance recovery, SCN 32-4

parallel DML instance recovery, SCN 26-41

parallel DML system recovery, SCN 26-41

Parallel Server and, SCN 8-11, SCN 26-41

rolling back transactions, SCN 32-10

temporary segment cleanup, SCN 8-11

System Network Architecture (SNA), NET 4-26

system objects

importing, SUT 2-13

system performance, SRF 1-11

system privileges, SAD 24-2, SCN 30-2

ADMIN OPTION, SCN 14-14, SCN 30-3

described, SCN 30-2

granting, SQL 7-343, SQL 7-493

to a role, SQL 7-494

to a user, SQL 7-494

to all users, SQL 7-494

to PUBLIC, SQL 7-494

granting and revoking, SCN 30-3

list of, SQL 7-495

revoking, SQL 7-529

from a role, SQL 7-530

from a user, SQL 7-529

from all users, SQL 7-530

from PUBLIC, SQL 7-530

user-defined types, SCN 14-13

See also privileges

system requirements, OAS 1-11, OAS 11-2

CyberSafe, OAS 1-12

for migration, MIG 2-15

Identix Biometric, OAS 1-12

Kerberos, OAS 1-12

RADIUS, OAS 1-12

SecurID, OAS 1-12

SSL, OAS 1-12

SYSTEM rollback segment, SCN 4-26, SPS 6-8, SRF 1-110

altering storage parameters of, SAD 21-9

system tables

incremental export, SUT 1-50

SYSTEM tablespace, SCN 3-6, SPS 14-5

cannot drop, SAD 9-15

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

datafile 1, SCN 3-16

initial rollback segment, SAD 21-2

media failure, SCN 32-6

Migration utility, MIG 2-6, MIG 3-6

non-data dictionary tables and, SAD 14-3

online requirement of, SCN 3-9

Oracle Data Migration Assistant, MIG 4-4

procedures stored in, SCN 3-6, SCN 18-18

recovery of, SBR 14-23

restrictions on taking offline, SAD 10-7

space

insufficient for migration, MIG A-2

when created, SAD 9-4

SYSTEM tablespace raw device, PSC 2-6

system time, changing

effect on recovery, SBR 14-26

SYSTEM username

security domain of, SCN 29-3

SYSTEM_PRIVILEGE_MAP view, SRF 2-183

system-based security, REP A-4

system-specific Oracle documentation, ADG 13 - 4, PC_ 1-10, PC_ 2-18, PC_ 3-7, PC_ 5-31, PC_ 5-56, PC_ 20-1

archived redo log name, SPS 21-5

client-server processing, SPS 1-20

datafiles, maximum number, SPS B-3

free list overhead, SPS 11-5

instance number range, SPS 17-12

MAXLOGHISTORY default, SPS 21-6

Net8 connect string, SPS 18-17

password file name, SPS 18-26

PL/SQL wrapper, ADG 10 - 27

recovery process allocation, SPS 22-15

redo log archive destination, SPS 21-6

redo log archive format, SPS 21-6

software constraints, STU 17-6

supported Oracle configurations, SPS 1-14

system change number

Lamport, SPS 4-7

SCN, SPS 4-5

USE_ASYNC_IO, STU 26-30

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

SYYYY date format element, SQL 2-41

---