---

B

B*-tree index, STU 6-15, STU 6-19

B*-tree indexes, SCN 10-27

bitmap indexes vs., SCN 10-32, SCN 10-33

index-organized tables, SCN 10-36

B_TREE_BITMAP_PLANS parameter, SRF 1-16

back-ends, SCN 6-2

background checkpoints completed statistic, SRF C-5

background checkpoints started statistic, SRF C-5

background process, SPS 5-5

ARCH, SPS 21-4

holding instance lock, SPS 7-4, SPS 7-6

instance, SPS 5-4

LGWR, SPS 21-6

optional, SPS 5-5

parallel cache management, SPS 4-12

SMON, SPS 18-27, SPS 22-2

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

described, SCN 8-5

diagrammed, SCN 8-6

Oracle8i processes, SAD 4-9

overview of, SCN 1-18

SNP background process, SRF 1-53

specifying trace files, SRF 1-17

trace files for, SCN 8-14

See also processes

BACKGROUND_CORE_DUMP parameter, SRF 1-16

BACKGROUND_DUMP_DEST parameter, PSC C-11, PSC C-12, SAD 4-11, SRF 1-16

ALERT file, SRF 1-17

of ALTER SYSTEM, SQL 7-101

backslash escape character, SUT 5-20

backup, SPS 21-1

after migration, MIG 6-2

archive log, SPS 21-7

automatic bootstrap, LEG 4-5

before migration, MIG 3-20

compatibility, MIG 8-13, MIG 8-39

conversion to multi-instance, SPS 23-3

EBU, MIG 8-40

export, SPS B-1

files used in recovery, SPS 22-7

LSM server bootstrap, LEG 4-4

maintaining bootstrap information, LEG 4-9

manual bootstrap, LEG 4-9

messages on UNIX, LEG 4-10

monitoring Oracle backups and restores, LEG 4-10

offline, SPS 4-6, SPS 21-12

online, SPS 4-6, SPS 21-12, SPS 21-16

Oracle backup/restore utility, LEG 4-2

parallel, SPS 21-12

preparing a strategy for migration, MIG 2-18

Recovery Manager and EBU, MIG 8-40

viewing volume inventory, LEG 3-20

Backup and Recover service, LEG B-10

backup and recovery system

backup unable to progress, Pending Messages Window, LEG 3-21

bootstrap, LEG 2-5

how LSM backs up data, LEG 2-4

Oracle8, LEG 1-8, LEG 1-9, LEG 1-10

overview of Oracle, LEG 1-8

backup and recovery, incremental, GTK 3-6

BACKUP ANY TABLE system privilege, SQL 7-500

backup command (RMAN), SBR 4-29, SBR 8-2, SBR 8-26, SBR 11-21

format parameter, SBR 4-31

proxy only option, SBR 4-19

proxy option, SBR 4-19

skip offline option, SBR 8-15

backup control files

recovery using, SBR 9-20

BACKUP CONTROLFILE clause

of ALTER DATABASE, SQL 7-9, SQL 7-19

BACKUP CONTROLFILE option

ALTER DATABASE command, SBR 3-6, SBR 13-3

BACKUP CONTROLFILE TO TRACE option

ALTER DATABASE command, SBR 13-3, SBR 13-12

backup files

user-created, cataloging, SBR 6-28

backup formats, SBR 3-12 to SBR 3-14

backup sets, SBR 3-12

logical backups, SBR 3-14

backup methods, SBR 3-8 to SBR 3-11

comparison of, SBR 3-11

Enterprise Backup Utility, SBR 3-11

Export utility, SBR 3-10

operating system, SBR 3-10

Recovery Manager, SBR 3-9

Backup Operators group, LEG B-9

backup options

ARCHIVELOG mode, SBR 3-20

NOARCHIVELOG mode, SBR 3-20

BACKUP parameter, NET C-44, PSC 4-44

backup pieces

naming, SBR 4-31

backup sets

creating using backup command, SBR 4-31

crosschecking, SBR 6-10

duplexing, SBR 8-22

listing, SBR 7-2

naming, SBR 4-31

organizing, SBR 4-29

sizing, SBR 4-31

testing restore of, SBR 6-18

type of backup format, SBR 3-12

Backup Solutions Program (BSP), SBR 4-20

Legato Storage Manager (LSM), SBR 4-20

backup strategy

overview, SBR 1-11 to SBR 1-17

BACKUP_DISK_IO_SLAVES parameter, SRF 1-17

BACKUP_TAPE_IO_SLAVES initialization parameter, SBR 8-23

BACKUP_TAPE_IO_SLAVES parameter, SRF 1-17

of ALTER SYSTEM, SQL 7-101

backups

after creating new databases

full backups, SAD 2-7

guidelines, SAD 1-20

after OPEN RESETLOGS option, SBR 3-19

after structural changes to database, SBR 3-18

after UNRECOVERABLE operations, SBR 16-28

archived redo logs, SBR 8-19

using RMAN, SBR 8-8

ARCHIVELOG mode in, SBR 3-16

backup command (RMAN), SBR 8-2

backup sets, SBR 4-28

before database creation, SAD 2-4

choosing a strategy, SBR 3-15 to SBR 3-24

consistent, SBR 1-16

consistent whole database, SBR 3-2

control file, SBR 2-7, SBR 2-9, SBR 3-8, SBR 13-11

using RMAN, SBR 8-6, SBR 8-7

control files, SCN 32-25

cumulative incremental, SBR 4-42, SBR 4-50, SBR 4-53, SBR 8-22, SBR 16-7, SBR 16-30

data warehouse, STU 11-9

datafile, SBR 3-8

using RMAN, SBR 8-4, SBR 8-5, SBR 8-6

datafiles, SCN 32-25

DBVERIFY utility, SBR 13-5

definition, SBR 1-2

disk mirroring, STU 26-44

distributed databases, SBR 3-22

ARCHIVELOG mode, SBR 3-22

NOARCHIVELOG mode, SBR 3-22

duplexing, SBR 8-22

effects of archiving on, SAD 7-4, SBR 2-16

Enterprise Backup Utility, SBR 3-10

Export utility, SBR 3-10, SBR 3-14, SBR 3-22

for read-only tablespaces, SCN 32-26

for replication, REP 7-17

frequency, SBR 3-18

full, SBR 4-37

generating reports for, SBR 7-2

guidelines, SBR 3-14 to SBR 3-24

distributed database constraints, SBR 3-22

Export utility, SBR 3-22

frequency, SBR 3-18

multiplexing files, SBR 3-17

often-used tablespaces, SBR 3-19

storing old backups, SBR 3-21

structural changes, SBR 3-18

testing strategies, SBR 3-24

unrecoverable operations, SBR 3-19

whole database backups after OPEN RESETLOGS, SBR 3-19

image copies, SBR 4-28, SBR 4-45

importance, SBR 1-11

inconsistent, SBR 1-16

closed database, SBR 3-4

in NOARCHIVELOG mode, SBR 3-4

whole database, SBR 3-4

incremental, SBR 8-21

differential, SBR 4-40

using RMAN, SBR 8-9

keeping, SBR 8-26

listing files needed, SBR 13-2

logical, definition, SBR 1-2

NOARCHIVELOG mode, in, SBR 3-16, SBR 8-23

noncumulative incremental, SBR 4-40

offline, SBR 3-18

online, SBR 3-18

online redo logs, SBR 3-23

options

ARCHIVELOG mode, SBR 3-20

NOARCHIVELOG mode, SBR 3-20

overview of, SCN 1-45, SCN 32-23

parallel, SCN 32-16

Parallel Server Environment, SBR 8-25

parallelization, SBR 4-34, SBR 8-23

partial, SCN 1-50, SCN 32-24

physical, definition, SBR 1-2

planning before database creation, SBR 3-14

procedures, SBR 13-3 to SBR 13-17

offline tablespaces, SBR 13-10

procedures for

offline datafiles, SBR 13-10

recovery catalog, SBR 4-14

Recovery Manager, SCN 1-51, SCN 32-15

Recovery Manager types, SBR 4-28

Recovery Manager, user tags for, SBR 4-46

reporting objects needing backups, SBR 7-5

restoring dropped snapshots

Import, SUT 2-51

restoring whole database backup, SBR 14-17

RMAN error handling, SBR 8-26

status

checking backup, SBR 13-7

stored scripts, SBR 6-20

storing, SBR 3-21

tablespace, SBR 3-19, SBR 13-8

using RMAN, SBR 8-4, SBR 8-5, SBR 8-6

techniques to avoid, SBR 3-23

test strategies, SBR 3-24

to disk, SBR 3-10

tuning, STU 20-52

types, SBR 3-2, SBR 13-3 to SBR 13-17

types of, SCN 1-49

using Export to supplement, SCN 32-25

using multiple conflict resolution methods for, REP 6-11

whole database, SBR 3-2, SBR 13-3 to SBR 13-5

backup control files and, SBR 3-3

preparing to take, SBR 13-4

using RMAN, SBR 8-3

whole database backup, SCN 1-50, SCN 32-23

backups, using RMAN, SBR 8-2

BAD

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

bad file

rejected records in SQL*Loader, SUT 3-12

specifying bad records, SUT 6-3

specifying for SQL*Loader, SUT 5-25

bad param destination state, SAD 7-14

BADDN keyword

SQL*Loader, SUT 5-25

BADFILE keyword

SQL*Loader, SUT 5-25

bandwidth, SPS 1-11, SPS 2-2, SPS 2-12, SPS 3-3, SPS 3-4, SPS 3-5, SPS 3-6, STU 26-3

base backup

Export, SUT 1-44

base tables, SCN 1-24

data dictionary, SCN 2-2

incremental export and, SUT 1-48

See also views

base type, PLS 2-12, PLS 2-24

basic loop, PLS 3-6

basic replication, REP 3-1

uses of, REP 1-10, SCN 34-11

Basic Statistics for Parse/Execute/Fetch drilldown data view, STU 15-18

batch applications, SPS 1-12, SPS 1-13

batch fetch, PCO 7-7

advantage of, PC_ 8-5

example, PCO 7-7

example of, PC_ 8-5

number of rows returned, PCO 7-8

number of rows returned by, PC_ 8-7

Batch Size setting

Create New Scheduled Link property sheet, REP 2-13

batched allocate scn lock request wait event, SRF A-20

BC (B.C.) date format element, SQL 2-41, SQL 2-43

BC/AD abbreviation

language of, NLS 2-14

BECOME USER system privilege, SQL 7-502

BEFORE clause

of CREATE TRIGGER, SQL 7-403

BEFORE triggers, SCN 20-9, SQL 7-403

complex security authorizations, ADG 13 - 48

correlation names and, ADG 13 - 16

defined, SCN 20-9

derived column values, ADG 13 - 49

specifying, ADG 13 - 7

when fired, SCN 20-21

BEGIN BACKUP clause

of ALTER TABLESPACE, SQL 7-168

BEGIN BACKUP option, SPS 21-15

ALTER TABLESPACE command, SBR 13-6

BEGIN_DISCRETE_TRANSACTION procedure, STU 9-1, STU 9-3

BEGIN_INSTANTIATION procedure

DBMS_OFFLINE_OG package, REP 8-16

BEGIN_LOAD procedure

DBMS_OFFLINE_OG package, REP 8-17

BEGIN_TABLE_REORGANIZATION procedure

DBMS snapshot package, REP 7-25

BEGINDATA

control file keyword, SUT 5-21

BEGIN/END option

ALTER TABLESPACE command, SBR 6-28

being written redo log enqueue, SRF B-3

benefit of tuning, STU 2-3

benefits

provided by TNS, NET 2-6

benefits of Oracle Advanced Security, OAS 1-3

bequeath, NET 9-15

connecting with, NET 8-8

described, NET 4-27

event programming, NET 9-14

parameters for addresses, NET 6-78

BEQUEATH_DETACH parameter, NET 7-24, NET 9-15, NET C-7

bequeathed sessions, NET 2-25

BETWEEN, SCN 23-7

BETWEEN comparison operator, PLS 2-45, PLS 5-5

BFILE

datatype, OCI 3-20, SQL 2-20

locators, SQL 2-20

BFILE check if exists wait event, SRF A-13

BFILE check if open wait event, SRF A-13

BFILE closure wait event, SRF A-13

BFILE columns

exporting, SUT 1-56

BFILE datatype, ADL 1-3, PLS 2-21, SCN 12-14, SUT 5-107

BFILE get length wait event, SRF A-13

BFILE get name object wait event, SRF A-14

BFILE get path object wait event, SRF A-14

BFILE internal seek wait event, SRF A-14

BFILE open wait event, SRF A-15

BFILE read wait event, SRF A-15

BFILENAME function, SQL 4-8

BFILENAME(), ADL 5-5

BFILES, PC_ 16-2

definition, PCO 13-2

security, PC_ 16-2

BFILEs, ADL 1-2

initializing, ADL 5-5

loading, SUT 5-99

maximum number of open, ADL 1-8, ADL 5-136

multi-threaded server (MTS), ADL 5-10

binary data

BFILEs, SCN 12-14

BLOBs, SCN 12-13

RAW and LONG RAW, ADG 4 - 18, SCN 12-14

binary files

formatting using Oracle Trace, STU 15-5

binary large object, see BLOB

binary large objects. See BLOBs.

binary operator, PLS 2-41

binary operators, SQL 3-1

binary sorting, NLS 2-25

BINARY_INTEGER datatype, PLS 2-11

bind array

determining size, SUT 5-75

determining size of for SQL*Loader, SUT 5-77

minimizing SQL*Loader memory requirements, SUT 5-80

minimum requirements, SUT 5-75

size with multiple SQL*Loader INTO TABLE clauses, SUT 5-80

specifying, SUT 6-4

specifying number of rows, SUT 6-7

SQL*Loader performance implications, SUT 5-76

bind descriptor, PC_ 13-26, PC_ 15-5, PCO 11-4

definition of, PC_ 13-26

information in, PC_ 13-26

bind descriptors

information in, PCO 9-26

bind enqueue, SRF B-2

bind functions, OCI 15-42

bind handle

attributes, OCI A-20

description, OCI 2-10

bind operation, OCI 4-5, OCI 5-2, OCI 12-2

associations made, OCI 5-3

example, OCI 5-6

initializing variables, OCI 5-3

LOBs, OCI 5-10

named datatypes, OCI 5-10, OCI 12-2

named vs. positional, OCI 5-4

OCI array interface, OCI 5-4

OCI_DATA_AT_EXEC mode, OCI 5-11

PL/SQL, OCI 5-5

positional vs. named, OCI 5-4

ref cursor variables, OCI 5-12

REFs, OCI 5-10, OCI 12-3

static arrays, OCI 5-10

steps used, OCI 5-6

bind queries

executing, DDS 7-7

bind SQLDA, PCO 11-3

purpose of, PC_ 15-3

bind variable, PLS 5-16

bind variables, PCO 9-26, STU 19-16

input host variables, PC_ 13-26

optimization, SCN 23-52

user-defined types, SCN 13-14

BIND_INOUT_VARIABLE, DDS 7-3

BIND_INOUT_VARIABLE procedure, DDS 7-6

BIND_OUT_VARIABLE, DDS 7-3

BIND_OUT_VARIABLE procedure, DDS 7-6

BIND_VARIABLE, DDS 7-3

binding, PLS 4-30

arrays, OCI 12-3

definition of, PC_ 13-4

OCINumber, OCI 12-8

PL/SQL placeholders, OCI 2-39

summary, OCI 5-12

BINDING clause

of CREATE OPERATOR, SQL 7-319, SQL 7-320

binding host variables, PCO 9-4

BINDSIZE

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

BINDSIZE command-line parameter

SQL*Loader, SUT 5-76

biometric authentication, OAS 7-1

biometrics

see Oracle Advanced Security

bitmap

mapping to ROWIDs, STU 6-17

BITMAP clause

of CREATE INDEX, SQL 7-279

BITMAP CONVERSION row source, STU 6-20

bitmap index, STU 6-13, STU 6-18, STU 11-7

creating, STU 6-16

inlist iterator, STU 13-23

maintenance, STU 6-15

size, STU 6-20

storage considerations, STU 6-14

when to use, STU 6-13

bitmap indexes, GTK 3-4, SCN 10-32

ALTER TABLE no longer invalidates, GTK 2-25

cardinality, SCN 10-33

invalidations, MIG 8-25

during migration, MIG 6-3

when downgrading, MIG 12-12

new ALTER TABLE options

MINIMIZE RECORDS PER BLOCK, GTK 2-25

NOMINIMIZE RECORDS PER BLOCK, GTK 2-25

nulls and, SCN 10-8, SCN 10-35

parallel query and DML, SCN 10-33

partitioned tables, SCN 11-14

scans of, SCN 23-36

star transformation, SCN 24-16

BITMAP keyword, STU 6-16

bitmap tablespace management, SCN 3-8

temporary tablespaces, SCN 3-13

BITMAP_MERGE_AREA_SIZE parameter, SRF 1-18, STU 6-15, STU 6-19, STU 7-22

bitmapped indexes, SQL 7-279

bitmapped tablespaces, SAD 9-5

blank padding

specifying in format models, SQL 2-46

suppressing, SQL 2-46

blank padding data

performance considerations, ADG 4 - 6

BLANK_TRIMMING parameter, SRF 1-18

blank-padding semantics, PLS B-3

blanks

BLANKS keyword for field comparison, SUT 5-15

loading fields consisting of blanks, SUT 5-82

preserving, SUT 5-87

SQL*Loader BLANKS keyword for field comparison, SUT 5-45

trailing, SUT 5-73

trimming, SUT 5-82

whitespace, SUT 5-82

BLANKS keyword

SQL*Loader, SUT 5-45

BLOB, DCI 6-2

datatype, OCI 3-20

EMPTY_BLOB function, DCI 6-4

transactional support of, SQL 2-21

BLOB datatype, ADL 1-2, PLS 2-22, SQL 2-21

BLOBs, SCN 12-13

BLOBs support, REP A-3

BLOBs loading, SUT 5-99

block

allocating dynamically, SPS 17-15

anonymous, PLS 7-2, SCN 16-15, SCN 18-9

associated with instance, SPS 11-11

block-level recovery, SCN 32-14

cleanout, SPS A-14

contention, SPS 6-9, SPS 11-15, SPS 15-6, SPS 17-11, SPS 17-13

database, SCN 4-3

See also data blocks

deferred rollback, SPS 6-9, SPS A-19

distributed lock, SPS 5-5

free space, SPS 11-2

instance lock, SPS 4-12

label, PLS 2-39

maximum size, PLS 5-50

multiple copies, SPS 4-5, SPS 4-12, SPS 5-5

PCM lock, SRF 1-44

PL/SQL, PLS 11-7

redo log, SRF 1-67

rollback segment, SRF 1-46

segment header, SPS 11-14

size, SRF 1-28

structure, PLS 1-2

when written to disk, SPS 4-5, SPS 9-8, SRF 1-46

block contention, STU 2-11

block sampling, SCN 22-14

Block Server Process

definition, SPS 1-17, SPS 5-7

block server process (BSP), SCN 27-6

block size, SRF 4-3, STU 20-15

DB_BLOCK_SIZE initialization parameter, MIG 3-6, MIG 4-5

minimums for migration, MIG 3-6, MIG 4-5

blocking AST, SPS 8-3

blocking modes, OCI 2-36

blocking transactions, SCN 27-11

block-level recovery, SCN 27-21, SCN 32-14

blocks

associated with instance, SPS 22-3

BNDDFCLP variable (SQLDA), PCO 11-14

BNDDFCRCP variable (SQLDA), PCO 11-14

BNDDFMT variable (SQLDA), PCO 11-9

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

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

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

BNDDI variable (SQLDA), PCO 11-11

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

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

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

BNDDV variable (SQLDA), PCO 11-8

BNDDVLN variable (SQLDA), PCO 11-9

BNDDVTYP variable (SQLDA), PCO 11-11

body

cursor, PLS 5-12

function, PLS 7-6

method, PLS 9-8

object, PLS 9-5

package, PLS 8-7

procedure, PLS 7-4

triggers, ADG 13 - 14, ADG 13 - 17, ADG 13 - 18, ADG 13 - 20

BODY clause

of ALTER PACKAGE, SQL 7-60

Boolean

expression, PLS 2-46

literal, PLS 2-8

value, PLS 2-46

BOOLEAN datatype, PLS 2-22, SCN 12-2

Boolean expressions, ADG 4 - 27

bootstrap

automatic backups, LEG 4-5

finding, LEG 5-5

maintaining bootstrap information, LEG 4-9

manual backups, LEG 4-9

server backups, LEG 4-4, LEG 4-5

bottlenecks

disk I/O, STU 20-20

memory, STU 19-1

branch automation, REP A-3

branch blocks, SCN 10-28

branches

detaching, OCI 8-7

resuming, OCI 8-7

BREAK action

of WHENEVER, PC_ F-120

bringing online

tablespaces, SAD 9-10

broadcast

distribution value, STU 13-8

broken jobs

about, SAD 8-12

marking, SAD 8-13

running, SAD 8-13

browsable save set, LEG 2-8

browse policy, LEG 2-6

BSP

definition, SPS 1-17, SPS 5-7

See Backup Solutions Program

BSP background process, SCN 27-6

BSP0 process, PSC 1-10

BUFFER

Export parameter, SUT 1-16

direct path export, SUT 1-43

Import parameter, SUT 2-19

buffer busy waits wait event, SRF A-20

buffer cache, SCN 7-3, SCN 8-8, SPS 5-5, STU 2-10

coherency, SPS 4-12

database, SRF 1-25

distributed locks, SPS 2-7

extended buffer cache (32-bit), SCN 7-14

instance recovery, SPS 22-3

memory allocation, STU 19-29

minimizing I/O, SPS 4-5, SPS 4-12

multiple buffer pools, SCN 7-5

partitioning, STU 19-33

reducing buffers, STU 19-29

reducing cache misses, STU 19-29

tuning, STU 19-25

written to disk, SPS 4-5

buffer cache management enqueue, SRF B-2

buffer deadlock wait event, SRF A-21

buffer flushing, described, NET 3-14

buffer for checkpoint wait event, SRF A-21

buffer get, STU 4-5

buffer latch wait event, SRF A-22

buffer not pinned statistics, STU 19-27

buffer pinned statistics, STU 19-27

buffer pool

default cache, STU 19-31

keep cache, STU 19-32

multiple, STU 19-31, STU 19-32

RECYCLE cache, STU 19-31

syntax, STU 19-35

buffer pools, SCN 7-5

buffer read retry wait event, SRF A-22

buffer state, SPS 9-10

buffer, redo log, SPS 5-5

BUFFER_POOL clause, STU 19-35

BUFFER_POOL parameter

of STORAGE clause, SQL 7-579

BUFFER_POOL_KEEP parameter, SCN 7-5, SRF 1-19

BUFFER_POOL_name parameter, STU 19-34

BUFFER_POOL_RECYCLE parameter, SCN 7-5, SRF 1-19

buffering LOB operations, OCI 7-11

buffering multiple rows, DDS 7-8

buffers

buffer cache in SGA, SAD 2-11

calculating for export, SUT 1-16

database buffer cache, SCN 1-16, SCN 7-3, SCN 8-8

Fast-Start Checkpointing, SCN 32-13

incremental checkpoint, SCN 8-8

LOBs, ADL 2-14

number of, SRF 1-25

redo log buffer, SCN 1-16, SCN 7-6

space required by

LONG DATA

SQL*Loader, SUT 5-64

VARCHAR data

SQL*Loader, SUT 5-63

specifying with SQL*Loader BINDSIZE parameter, SUT 5-77

bug fixes, SAD 1-21

BUILD DEFERRED clause

materialized views and downgrading, MIG 12-10

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

BUILD IMMEDIATE clause

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

build methods, STU 29-5

BUILD_PART_INDEX procedure, SCN 11-30

building custom applications with Net8 OPEN, NET 9-8

built-in function, PLS 2-51

bulk binds, ADG 10 - 22, PLS 4-29

compatibility, MIG 8-14

DML statements, ADG 10 - 23

FOR loops, ADG 10 - 25

SELECT statements, ADG 10 - 24

usage, ADG 10 - 23

BULK COLLECT clause, PLS 4-34

bulk fetch, PLS 4-35

bulk updates, REP 7-31

%BULK_ROWCOUNT cursor attribute, PLS 4-36

business rule, STU 1-8, STU 2-3, STU 2-7

business rules

enforcing in application code, SCN 28-5

enforcing using stored procedures, SCN 28-5

enforcing with constraints, SCN 1-58, SCN 28-1

advantages of, SCN 28-5

enforcing with triggers, SCN 1-59

BY ACCESS clause

of AUDIT schema_objects, SQL 7-206

of AUDIT sql_statements, SQL 7-199

BY proxy clause

of AUDIT (SQL statements), SQL 7-199

of NOAUDIT sql_statements, SQL 7-524

BY REF phrase, ADG 11 - 28

BY SESSION clause

of AUDIT schema_objects, SQL 7-206

of AUDIT sql_statements, SQL 7-199

BY user clause

of AUDIT sql_statements, SQL 7-199

of NOAUDIT sql_statements, SQL 7-524

by-reference parameter passing, PLS 7-21

Byte Ordering, PC_ E-2

BYTEINT datatype, SUT 5-59, SUT 5-60

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

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

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

by-value parameter passing, PLS 7-21

---