B

B*-tree index, STU 12-16, STU 12-20

B_TREE_BITMAP_PLANS initialization parameter: obsolete

back-ends, SCN 6-2

background processes, SAD 4-11 to SAD 4-13, SCN 1-16, SCN 8-5

ARCH, PSA 13-4

described, SCN 8-5

diagrammed, SCN 8-6

holding instance locks, PSC 4-4

LGWR, PSA 13-7

overview of, SCN 1-16

SMON, PSA 4-5, PSA 14-2

SNP, SAD 8-2

SNP background process, SRF 1-50

specifying trace files, SRF 1-16

trace files for, SCN 8-15

See also processes

BACKGROUND_CORE_DUMP initialization parameter, SRF 1-15

BACKGROUND_DUMP_DEST initialization parameter, SAD 4-16, SRF 1-16

ALERT file, SRF 1-16

BACKGROUND_DUMP_DEST parameter, PSG 4-7, PSG C-9, PSG C-10

of ALTER SYSTEM, SQL 7-108

backing up

standby databases, SBY 4-16

tablespaces on a standby database, SBY 4-17

backslash escape character, SUT 5-20

backup

export, PSC B-2

offline, PSC 1-5

online, PSC 1-5

Backup and Recover service, LEG B-10

backup and recovery

definition, SBR 1-3

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 4-6

BACKUP ANY TABLE system privilege, SQL 7-526

backup command (RMAN), RMN 1-33, RMN 5-2, RMN 5-28, RMN 10-22

proxy only option, RMN 1-22

proxy option, RMN 1-22

skip offline option, RMN 5-16

BACKUP CONTROLFILE clause

ALTER DATABASE statement, SBR 1-19, SBR 4-3

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

BACKUP CONTROLFILE TO TRACE clause

ALTER DATABASE statement, SBR 4-3, SBR 4-14

backup methods, SBR 1-20, SBR 1-22

comparison of, SBR 1-22

Backup Operators group, LEG B-9

BACKUP parameter, NET 8-13, NET C-44, PSG 5-3

backup pieces

restricting size, RMN 1-41, RMN 10-145

backup sets

creating using backup command, RMN 1-39

crosschecking, RMN 3-15

duplexing, RMN 5-23

errors during creation, RMN 1-47

listing, RMN 4-2

multiplexing, RMN 1-42

naming, RMN 1-35

organizing, RMN 1-33

parallelizing creating of, RMN 1-45

restoring without RMAN, RMN 6-37

restricting piece size, RMN 1-41

specifying maximum size (in bytes), RMN 1-39, RMN 1-41

specifying number of, RMN 1-35

testing restore of, RMN 3-24

Backup Solutions Program (BSP), RMN 1-23

Legato Storage Manager (LSM), RMN 1-23

backup strategy

overview, SBR 1-12 to SBR 1-23

backup, in Oracle8i, OID 1-5

BACKUP_DISK_IO_SLAVES initialization parameter: obsolete

BACKUP_TAPE_IO_SLAVES initialization parameter, RMN 5-24, SRF 1-16

BACKUP_TAPE_IO_SLAVES parameter

of ALTER SYSTEM, SQL 7-108

backups

after creating new databases, PSG 3-39

full backups, SAD 2-11

guidelines, SAD 1-20

after migration or upgrade, MIG 8-2

after OPEN RESETLOGS option, SBR 3-8

after structural changes to database, SBR 3-7

after UNRECOVERABLE operations, SBY 4-14

archive log, PSA 13-8

archived redo logs, RMN 5-20

backing up using RMAN, RMN 5-10

using RMAN, RMN 5-9

ARCHIVELOG mode in, SBR 3-5

automatic bootstrap, LEG 4-8

automatic location using RMAN, RMN 6-17

backup command (RMAN), RMN 5-2

backup sets, RMN 1-32

Backup Wizard, PSG 4-16

before database creation, PSG 3-32

before migration, MIG 4-26

choosing a strategy, SBR 3-4 to SBR 3-11

closed, SBR 4-4

compatibility, MIG 9-12, MIG 9-39

consistent, PSG 4-16, SBR 1-23, SBR 4-3

whole database, SBR 1-16

control file, SBR 2-6, SBR 2-8, SBR 4-13

using for recovery, RMN 6-22

using RMAN, RMN 5-7

control files, SCN 366

conversion to multi-instance, PSG 9-3

correlating RMAN channels with, RMN 9-14

creating standby database from, SBY 1-20

cumulative incremental, RMN 1-53, RMN 1-54, RMN 1-62, RMN 1-65, RMN 5-23, SBY 3-6, SBY 3-14, SBY 3-23, STU 20-50, STU 20-51, STU 20-52, STU 20-53

datafile, SBR 1-15

using RMAN, RMN 5-5, RMN 5-6

datafiles, SCN 366

DBVERIFY utility, SBR 4-16

definition, SBR 1-2

disk mirroring, DWG 4-8

distributed databases, SBR 3-9

ARCHIVELOG mode, SBR 3-9

NOARCHIVELOG mode, SBR 3-9

duplexing, RMN 5-23

EBU, MIG 9-40

effects of archiving on, SAD 7-4

Export utility, SBR 3-10

failed RMAN, RMN 9-31

files used in recovery, PSA 14-7

for read-only tablespaces, SCN 367

for replication, REP 6-10

frequency, SBR 1-23, SBR 3-6

full, RMN 1-49

generating reports for, RMN 4-2

golden rule, SBR 3-2

guidelines, SBR 3-2 to SBR 3-12

distributed database constraints, SBR 3-9

Export utility, SBR 3-10

frequency, SBR 3-6

multiplexing files, SBR 3-6

often-used tablespaces, SBR 3-7

storing old backups, SBR 3-8

structural changes, SBR 3-7

testing strategies, SBR 3-12

unrecoverable objects, SBR 3-8

whole database backups after OPEN RESETLOGS, SBR 3-8

hung, RMN 9-23

image copies, RMN 1-32, RMN 1-57

importance, SBR 1-12

inconsistent, SBR 1-23, SBR 4-3

closed database, SBR 1-18

in NOARCHIVELOG mode, SBR 1-18

whole database, SBR 1-18

incremental, RMN 1-50, RMN 5-22

differential, RMN 1-51

using RMAN, RMN 5-11

keeping, RMN 5-27

listing files needed, SBR 4-2

logical, definition, SBR 1-2

LSM server bootstrap, LEG 4-7

maintaining bootstrap information, LEG 4-11

manual bootstrap, LEG 4-11

messages on UNIX, LEG 4-12

methods, SBR 1-20

monitoring Oracle backups and restores, LEG 4-12

NOARCHIVELOG mode, in, RMN 5-25, SBR 3-4

noncumulative incremental, RMN 1-52

of primary database, SBY 1-20

of standby database, SBY 4-16

offline, PSA 13-16, SBR 3-6

online, PSA 13-16, PSA 13-21, SBR 3-6

online redo logs, SBR 3-10

operating system, SBR 1-22

Oracle backup/restore utility, LEG 4-2

overview of, SCN 1-44, SCN 364

parallel, PSA 13-16, SCN 357

Parallel Server Environment, RMN 5-26

parallelization, RMN 1-45, RMN 5-24

partial, SCN 1-49, SCN 366

physical, definition, SBR 1-2

planning before database creation, SBR 3-2

preparing a strategy for migration, MIG 3-21

procedures, SBR 4-3 to SBR 4-20

offline datafiles, SBR 4-12

offline tablespaces, SBR 4-12

recovering pre-RESETLOGS, RMN 6-42

recovery catalog, RMN 1-16

using control file as repository, RMN 3-39

Recovery Manager, PSG 4-9, SCN 1-50, SCN 356

Recovery Manager and EBU, MIG 9-40

reporting objects needing backups, RMN 4-5

restoring dropped snapshots

Import, SUT 2-49

restoring whole database backup, SBR 5-15

RMAN error handling, RMN 5-28

specifying number of files per set, RMN 1-36

split mirror

using RMAN, RMN 5-12

status

checking backup, SBR 4-8

stored scripts, RMN 3-27

storing, SBR 3-8

tablespace, SBR 3-7, SBR 4-8

using RMAN, RMN 5-5, RMN 5-6

tags, RMN 1-58

techniques to avoid, SBR 3-10

test strategies, SBR 3-12

troubleshooting failed RMAN, RMN 9-19, RMN 9-22, RMN 9-26, RMN 9-29

tuning, STU 20-61

types, RMN 1-32, SBR 1-13, SBR 4-3 to SBR 4-20

types of, SCN 1-49

user-created, cataloging, RMN 3-35

using Export to supplement, SCN 367

using Recovery Manager, SBR 1-21

using RMAN, RMN 5-2

viewing volume inventory, LEG 3-20

whole database, SBR 1-13, SBR 4-3

backup control files and, SBR 1-17

preparing to take, SBR 4-4

using RMAN, RMN 5-3

whole database backup, SCN 1-49, SCN 364

BAD

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

bad files

rejected records in SQL*Loader, SUT 3-11

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, DWG 5-2, DWG 18-2, PSC 2-4, PSC 2-5, PSC 8-11, STU 9-15

base backup

Export, SUT 1-45

base schema

attributes

deleting, OID 6-19

modifying, OID 6-19

object classes, OID 6-4

base schema attributes, OID 6-18

base search, OID 7-6

base tables, SCN 1-23

data dictionary, SCN 2-3

incremental export and, SUT 1-49

See also views

base types, PLS 2-13, PLS 2-25

basic loops, PLS 3-6

Basic Operations, Operational Interface, ADQ 11-1

Basic Statistics for Parse/Execute/Fetch drilldown data view, STU 14-19

batch error mode, OCI 4-8

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 processing

and partitioning, PSA 5-17

batching line-mode commands, OID 6-17

BC (B.C.) date format element, SQL 2-46, SQL 2-48

BC/AD abbreviation

language of, NLS 2-17

BECOME USER system privilege, SQL 7-528

BEFORE clause

of CREATE TRIGGER, SQL 7-428

BEFORE triggers, SCN 90, SQL 7-428

complex security authorizations, ADG 13-48

correlation names and, ADG 13-16

defined, SCN 90

derived column values, ADG 13-49

specifying, ADG 13-7

when fired, SCN 102

BEGIN BACKUP clause

of ALTER TABLESPACE, SQL 7-180

BEGIN BACKUP option, PSA 13-20

ALTER TABLESPACE statement, SBR 4-5

BEGIN_DISCRETE_TRANSACTION procedure, STU 17-2, STU 17-3

BEGINDATA

control file keyword, SUT 5-21

BEGIN/END clause

ALTER TABLESPACE statement, RMN 3-35

Begins With, Oracle Directory Manager filter, OID 6-8

benefits

of tuning, STU 2-3

benefits of Oracle Advanced Security, OAS 1-4

bequeath, NET 2-19, NET 10-12

described, NET 4-4

event programming, NET 10-11

Bequeath protocol

ARGS parameter, NET B-3

ARGV0 parameter, NET B-3

PROGRAM parameter, NET B-3

BEQUEATH_DETACH parameter, NET 8-23, NET 10-12, NET C-5

bequeathed sessions, NET 2-19

BETWEEN, STU 4-68

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

BFILE

datatype, OCI 3-20, SQL 2-25

locators, SQL 2-25

BFILE class, See JDBC

BFILE datatype, PLS 2-22, SCN 12-14, SUT 5-106

BFILE-buffering, See JDBC

BFILENAME function, SQL 4-17

BFILENAME(), ADL 11-24, ADL 11-183

advantages of using, ADL 11-7

BFILES, PC_ 16-2

definition, PCO 13-2

security, PC_ 16-2

BFILEs

accessing, ADL 11-5

closing, ADL 11-196

columns

exporting, SUT 1-58

importing, SUT 2-57

converting to CLOB or NCLOB, ADL 11-47

creating an object in object cache, ADL 5-20

datatype, ADL 2-2, ADL 2-3

DBMS_LOB read-only procedures, ADL 3-9

DBMS_LOB,offset and amount parameters in bytes, ADL 3-7

equal locators, check for, ADL 11-165

initializing using BFILENAME(), ADL 2-6

loading, SUT 5-98

locators, ADL 2-5

maximum number of open, ADL 4-2, ADL 11-143

multi-threaded server (MTS), ADL 11-12

OCI functions to read/examine values, ADL 3-15

OCI read-only functions, ADL 3-15

Oracle Objects for OLE (OO4O)

opening/closing methods, ADL 3-34

properties, ADL 3-36

read-only methods, ADL 3-36

Pro*C/C++ precompiler statements, ADL 3-24

Pro*COBOL precompiler embedded SQL statements, ADL 3-28

reading with DBMS_LOB, ADL 3-8

read-only support, ADL 4-16

reference semantics, ADL 2-3

security, ADL 11-8, ADL 11-9

storage devices, ADL 2-2

using JDBC to read/examine, ADL 3-42

using Pro*C/C++ precompiler to open and close, ADL 3-25

binary data

BFILEs, SCN 12-14

BLOBs, SCN 12-13

RAW and LONG RAW, ADG 3-20, SCN 12-15

binary files

formatting using Oracle Trace, STU 14-5

binary large object, see BLOB

binary large objects. See BLOBs

binary operators, PLS 2-42, SQL 3-1

binary sorting, NLS 2-28

BINARY_INTEGER datatype, PLS 2-12

bind argument, PLS 10-3

bind arrays

determining size of for SQL*Loader, SUT 5-75, SUT 5-76

minimizing SQL*Loader memory requirements, SUT 5-79

minimum requirements, SUT 5-75

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

specifying, SUT 6-4

specifying number of rows, SUT 6-7

SQL*Loader performance implications, SUT 5-75

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 event, OID 5-27

bind functions, OCI 15-43

bind handle

attributes, OCI A-21

description, OCI 2-10

bind mode

specifying for access control subjects, OID 9-23, OID 9-30

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

PL/SQL, OCI 5-5

positional vs. named, OCI 5-4

ref cursor variables, OCI 5-17

REFs, OCI 5-10, OCI 12-3

static arrays, OCI 5-10

steps used, OCI 5-6

bind queries

executing using pass-through SQL, DDS 9-7

bind SQLDA, PCO 11-3

purpose of, PC_ 15-3

bind variables, ADG 11-48, PCO 9-25, STU 19-17

input host variables, PC_ 13-26

optimization, STU 4-27

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

BIND_INOUT_VARIABLE procedure, DDS 9-3, DDS 9-7

BIND_OUT_VARIABLE procedure, DDS 9-3, DDS 9-6

BIND_VARIABLE procedure, DDS 9-3

binding, OID 2-33, 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-17

BINDING clause

of CREATE OPERATOR, SQL 7-339, SQL 7-340

binding data to internal LOBs, restriction removal, ADL 4-17

binding host variables, PCO 9-4

binds

HEX to RAW or RAW to HEX conversion, ADL 7-16

updating more than 4,000 bytes

internal persistent LOBs, ADL 9-256

See also INSERT statements and UPDATE statements

BINDSIZE

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

Biometric Authentication Service

authenticating users, OAS 8-15

enabling, OAS 8-8

overview, OAS 8-2

troubleshooting, OAS 8-16

Biometric Manager

installation, OAS 8-5

BITMAP clause

of CREATE INDEX, SQL 7-297

BITMAP CONVERSION row source, STU 12-20

bitmap indexes, DWG 6-2, GTK 4-4, SCN 10-34, SQL 7-297, STU 12-14, STU 12-19

ALTER TABLE no longer invalidates, GTK 3-25

cardinality, SCN 10-35

creating, STU 12-16

inlist iterator, STU 5-22

invalidations, MIG 9-26

during migration, MIG 8-12

when downgrading, MIG 13-19

maintenance, STU 12-15

new ALTER TABLE clauses

MINIMIZE RECORDS PER BLOCK, GTK 3-25

NOMINIMIZE RECORDS PER BLOCK, GTK 3-25

nulls and, DWG 6-5, SCN 10-9, SCN 10-38

on partitioned tables, DWG 6-6

parallel query and DML, DWG 6-3, SCN 10-35

partitioned tables, SCN 11-13

scans of, STU 4-24

size, STU 12-21

storage considerations, STU 12-15

when to use, STU 12-13

BITMAP keyword, STU 12-16

bitmap tablespace management, SCN 3-8

temporary tablespaces, SCN 3-13

BITMAP_MERGE_AREA_SIZE initialization parameter, SRF 1-17

BITMAP_MERGE_AREA_SIZE parameter, STU 4-30, STU 12-16, STU 12-19

bitmaps

mapping to rowids, STU 12-18

blank padding

specifying in format models, SQL 2-51

suppressing, SQL 2-51

blank padding data

performance considerations, ADG 3-6

BLANK_TRIMMING initialization parameter, SRF 1-17

blank-padding semantics, PLS B-3

blanks

loading fields consisting of blanks, SUT 5-82

preserving, SUT 5-87

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

trailing, SUT 5-73

trimming, SUT 5-82

whitespace, SUT 5-82

BLANKS keyword

SQL*Loader, SUT 5-46

for field comparison, SUT 5-15

BLOB, DCI 6-2

datatype, OCI 3-20

EMPTY_BLOB function, DCI 6-4

BLOB datatype, PLS 2-23, SQL 2-25

transactional support of, SQL 2-25

BLOB-buffering,See JDBC

BLOBs, SCN 12-13

class, See JDBC

datatype, ADL 2-2

DBMS_LOB, offset and amount parameters in bytes, ADL 3-7

loading, SUT 5-98

modify via DBMS_LOB, ADL 3-8

using JDBC to modify, ADL 3-39

using JDBC to read/examine BLOB values, ADL 3-39

using oracle.sql.BLOB methods to modify, ADL 3-39

BLOBs support, REP A-7

block

cleanout, PSC A-16

deferred rollback, PSC A-21

multiple copies, PSC 1-4

when written to disk, PSC 1-4

block contention, STU 2-13

block level locking, PSC 4-13

block range granules, DWG 5-3

block sampling, STU 8-3

Block Server Process

and consistent-read blocks, PSA 12-2

definition, PSC 6-5

block server process (BSP), SCN 217

blocking AST, PSC 5-29

blocking modes, OCI 2-37

blocking transactions, SCN 221

block-level recovery, SCN 231, SCN 355

blocks, STU 20-10

allocating dynamically, PSA 8-13

anonymous, PLS 7-2, SCN 24, SCN 53

associated with instance, PSA 14-3, PSC 7-24

block size

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

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

block-level recovery, SCN 355

classes and synchronization, PSA 6-9

contention, PSA 7-14, PSC 7-7, PSC 7-21

on indexes, PSA 5-5

contention for, PSA 8-9, PSA 8-11

database, SCN 4-3

deferred rollback, PSC 7-7

label, PLS 2-40

multiple copies, PSC 4-9

PCM lock, SRF 1-40

PL/SQL, PLS 11-10

redo log, SRF 1-63

rollback segment, SRF 1-42

sampling, SCN 138

size, SRF 1-28, SRF 4-4

structure, PLS 1-2

when written to disk, PSC 5-22, SRF 1-42

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

BNF notation, PC_ xvi

body

cursor, PLS 5-12

function, PLS 7-7

method, PLS 9-8

object, PLS 9-5

package, PLS 8-8

procedure, PLS 7-4

triggers, ADG 13-14 to ADG 13-20

BODY clause

of ALTER PACKAGE, SQL 7-65

boldface, defined, NET xx, PSG xxiii

BooksOnLine Sample Application, ADQ 8-1

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

Boolean expressions, ADG 3-27, PLS 2-47

Boolean literals, PLS 2-9

bootstrap

automatic backups, LEG 4-8

finding, LEG 5-5

maintaining bootstrap information, LEG 4-11

manual backups, LEG 4-11

server backups, LEG 4-7

bottlenecks

disk I/O, STU 20-18

memory, STU 19-2

BOTTOM_N function, DWG 17-31

braces, DCI clix, PC_ xvi

brackets, PC_ xvi

brackets, defined, NET xx, PSG xxiii

branch automation, REP A-6

branch blocks, SCN 10-30

minimizing contention for, PSA 6-11

branches

detaching, OCI 8-7

resuming, OCI 8-7

BREAK action

of WHENEVER, PC_ F-119

broadcast

distribution value, STU 5-8

broken jobs

about, SAD 8-12

running, SAD 8-13

browsable save set, LEG 2-8

browse policy, LEG 2-6

BSP process, PSC 6-2

definition, PSC 6-5

BSP. See Backup Solutions Program

BSP. See block server process

BSTAT/ESTAT, OID 13-8

B-tree indexes, DWG 6-6, SCN 10-29

bitmap indexes versus, DWG 6-3

bitmap indexes vs., SCN 10-34, SCN 10-35

index-organized tables, SCN 10-40

BUFFER

Export parameter, SUT 1-16

direct path export, SUT 1-44

Import parameter, SUT 2-18

buffer cache

coherency, PSC 4-9

database, SRF 1-24

distributed locks, PSC 8-6

instance recovery, PSA 14-3

minimizing I/O, PSC 1-4, PSC 4-9

size, OID 13-8

written to disk, PSC 1-4

buffer cache management, PSC 1-4

buffer caches, SCN 7-3, SCN 8-8, STU 2-12

database, SCN 1-14, SCN 7-3, SCN 8-8

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

memory allocation, STU 19-31

multiple buffer pools, SCN 7-5

partitioning, STU 19-35

reducing buffers, STU 19-31

reducing cache misses, STU 19-31

tuning, STU 19-27

buffer flushing, described, NET 5-9

buffer get, STU 2-10

buffer not pinned statistics, STU 19-29

buffer pinned statistics, STU 19-29

buffer pools, SCN 7-5

default cache, STU 19-33

keep cache, STU 19-33

multiple, STU 19-32, STU 19-33

RECYCLE cache, STU 19-33

setting for parallel operations, DWG 18-36

syntax, STU 19-36

buffer state, PSC 5-24, PSC 5-25

BUFFER_POOL clause, STU 19-36

BUFFER_POOL parameter

description, SAD 12-11

of STORAGE clause, SQL 7-609

BUFFER_POOL_KEEP initialization parameter, SRF 1-18

BUFFER_POOL_KEEP parameter, SCN 7-6

BUFFER_POOL_name parameter, STU 19-35

BUFFER_POOL_RECYCLE initialization parameter, SRF 1-19

BUFFER_POOL_RECYCLE parameter, SCN 7-6

buffering

disable

internal persistent LOBs, ADL 9-248

enable

internal persistent LOBs, ADL 9-236

flush

internal persistent LOBs, ADL 9-242

buffering LOB operations, OCI 7-9

buffers

buffer cache in SGA, SAD 2-22

calculating for export, SUT 1-16

database buffer cache

fast-start checkpointing, SCN 354

incremental checkpoint, SCN 8-8

multiple rows, DDS 9-8

number of, SRF 1-24

redo log, SCN 1-14, SCN 7-6

space required by

LONG DATA in SQL*Loader, SUT 5-64

VARCHAR data in SQL*Loader, SUT 5-63

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

BUILD DEFERRED clause

materialized views and downgrading, MIG 13-17

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

BUILD IMMEDIATE clause

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

build methods, DWG 8-18

BUILD_PART_INDEX procedure, SCN 11-29

building custom applications with Net8 OPEN, NET 10-7

built-in functions, PLS 2-52

bulk binds, ADG 9-24, PLS 4-29

compatibility, MIG 9-13

DML statements, ADG 9-25

downgrading, MIG 13-34

FOR loops, ADG 9-27

SELECT statements, ADG 9-26

usage, ADG 9-25

BULK COLLECT clause, PLS 4-37

bulk fetches, PLS 4-38

optimizing data transfers using, DDS 9-9

bulk returns, PLS 4-39

bulk tools, OID 4-15

bulk updates, REP B-4

%BULK_ROWCOUNT cursor attribute, PLS 4-34

bulkdelete, OID 7-30, OID A-25

and NLS, OID 11-9

cleaning up audit log entries, OID 5-24

bulkload, OID A-20

and NLS, OID 11-8

creating indexes, OID 7-29

.dat files, OID 7-29

generating input files, OID 7-29

-load option, OID 7-29

syntax, OID A-20

bulkload.sh, OID 7-29

bulkmodify

and NLS, OID 11-9

LDIF file-based modification, OID A-23

syntax, OID A-23

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

enforcing in application code, SCN 255

enforcing using stored procedures, SCN 255

enforcing with constraints, SCN 1-57, SCN 251

advantages of, SCN 255

BY ACCESS clause

of AUDIT schema_objects, SQL 7-222

of AUDIT sql_statements, SQL 7-215

BY proxy clause

of AUDIT (SQL statements), SQL 7-214

of NOAUDIT sql_statements, SQL 7-551

BY REF phrase, ADG 10-28

BY SESSION clause

of AUDIT schema_objects, SQL 7-222

of AUDIT sql_statements, SQL 7-214

BY user clause

of AUDIT sql_statements, SQL 7-214

of NOAUDIT sql_statements, SQL 7-551

by-reference parameter passing, PLS 7-22

Byte array too small - error, ADQ D-14

Byte Ordering, PC_ E-2

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

BYTES column

PLAN_TABLE table, STU 5-5

Bytes Message, ADQ 12-25

by-value parameter passing, PLS 7-22