Oracle8i Generic Documentation Master Index

F variable in SQLDA

factoring matrix

features, GTK 5-4

options, GTK 5-2

facts, DWG 9-2

FAILED_LOGIN_ATTEMPTS parameter

of ALTER PROFILE, SQL 7-70

of CREATE PROFILE, SQL 7-362

failover, OID 1-5, OID 14-1, PSC A-13

FAILOVER parameter, MIG F-11, NET 2-21, NET 2-30, NET 8-4, NET C-39, NET C-86, PSG 4-2

FAILOVER parameters, NET 8-4

failover sites

FAILOVER option, REP 6-10

implementing, REP 6-9

FAILOVER_MODE parameter, NET 8-12, NET 8-13, NET C-43, PSG 5-3

failure

access to files, PSA 14-4

ALERT file, PSC 7-2

instance recovery, PSA 14-4

media, PSA 14-7, PSC A-24

node, PSA 14-2

failure detection

by the Cluster Manager, PSC 9-14

failure of fingerprint authentication, OAS 8-16

failure protection validation, PSC 9-7

failure recognition and recovery. See failover.

failures, SCN 342

Failures, Propagation, ADQ 5-4

false finger threshold, OAS 8-3

FALSE keyword

behavior in Oracle7 and Oracle8i, MIG 9-23

false pings, PSA 9-11, PSC 5-31

FALSE value, PLS 2-9

Fanning-Out of Messages, ADQ 7-15

FAQ, ADQ 6-1

for Oracle objects, ADO 8-1

FAQs, PC_ 1-7

FAST clause, DWG 8-20

fast commit, SCN 8-10

fast full index scans, STU 4-23, STU 12-8

fast refresh, DWG 14-18, SCN 10-19

FAST REFRESH mode

materialized views and downgrading, MIG 13-17

FAST REFRESH restrictions, DWG 8-20

fast refreshes, REP 3-28

and table reorganization, REP A-8

direct path load, REP 3-28

FAST_FULL_SCAN_ENABLED initialization parameter: obsolete

FAST_START_IO_TARGET initialization parameter, SRF 1-38

controlling checkpoints with, STU 20-40

recovery time and the, STU 24-5

FAST_START_IO_TARGET parameter, SCN 354

of ALTER SESSION, SQL 7-87, SQL 7-110

FAST_START_PARALLEL_ROLLBACK, PSC A-4

FAST_START_PARALLEL_ROLLBACK initialization parameter, SRF 1-39, STU 24-17

FAST_START_PARALLEL_ROLLBACK parameter, DWG 18-23

of ALTER SYSTEM, SQL 7-110

fast-start

checkpointing, SCN 354

fault recovery, SCN 354

parallel rollback, SCN 355

rollback on demand, SCN 350

fast-start checkpoints

controlling checkpoints, STU 20-40

FAST_START_IO_TARGET initialization parameter, STU 24-5

LOG_CHECKPOINT_INTERVAL initialization parameter, STU 24-5

LOG_CHECKPOINT_TIMEOUT initialization parameter, STU 24-4

Fast-Start fault recovery, GTK 3-51

see also transaction recovery

fast-start on-demand rollback, STU 24-16

fast-start parallel recovery

compatibility, MIG 9-42

Fast-Start Parallel Rollback

parallel rollback, Fast-Start, PSA 14-16

fast-start parallel rollback, STU 24-16

Fast-start Recovery, PSC 9-5

Fast-start recovery, PSC 9-16

Fast-start Rollback, PSC 9-16, PSC A-4

fast-start rollback

compatibility, MIG 9-12, MIG 9-42

fatal errors

Export, SUT 1-41

Import, SUT 2-46, SUT 2-47

FATAL_ERROR - oracle.xml.parser.v2.XMLParseException.FATAL_ERROR, JPR 4-118

fault tolerance, PSC 3-5

fault tolerance mechanisms, OID 14-3

FDDI

as used in Oracle Parallel Server, PSC 2-5

FDS_CLASS, DDS 7-7

FDS_CLASS_VERSION, DDS 7-7

FDS_INST_NAME, DDS 7-8

feature factoring matrix, GTK 5-4

Feature not supported (string) - error, ADQ D-2

Features

automated coordination ofenqueuing and dequeing, ADQ 1-15

enhanced propagation scheduling capabilities, ADQ 1-16

non-persistent queues, ADQ 1-9

of Advanced Queuing, ADQ viii

publish/subscribe support, ADQ 1-9

queue level access control, ADQ 1-8

features

new, SPR xcvii, PSA iii, PSC xv

new features, MIG 9-9

requiring migration, MIG G-13

features, LSM, LEG 1-4

types of storage devices supported, LEG 3-2

features, new

autolocate option, RMN xxiii

centralized user and privilege management, DDS xxxiv

client load balancing, NET xviii

cman.ora file, NET C-88 to NET C-89

configure compatible command, RMN xxiv

connection load balancing, NET xviii

connect-time failover, NET xviii

create catalog command, RMN xxv

crosscheck commands, RMN xxiv

data corruption protection, SBR xxiv

direct hand-off, NET xviii

directory naming, NET xviii

drop catalog command, RMN xxv

duplexed backup sets, RMN xxv

duplicate command, RMN xxv

encryption algorithm changes, OAS 2-2

enterprise user security, OAS 17-1

FIPS 140-, OAS D-1

generic connectivity, DDS xxxiii

Heterogeneous Services initialization parameters, DDS xxxiv

Java SSL, OAS F-1

listener.ora file, NET C-84

LOG_ARCHIVE_DEST_n parameter, SBR xxv

media management API 2.0, RMN xxiv

Net8 Configuration Assistant, NET xix

Oracle Connection Manager, NET xix

Oracle Enterprise Login Assistant, OAS 19-1

Oracle Enterprise Security Manager, OAS 20-1

Oracle Wallet Manager, OAS 18-1

parallel DML and DDL, DDS xxxiv

Primary/Secondary Instance, PSC A-2

RADIUS authentication, OAS 4-1

remove records from recovery catalog, RMN xxiv

report need backup redundancy command, RMN xxv

resetlogs option in RMAN, RMN xxiv

RMAN disk affinity, RMN xxv

RMAN TSPITR without catalog, RMN xxvi

service naming, NET xviii

service registration, NET xviii

SERVICE_NAME parameter, NET xix

SQL optimization for heterogeneous systems, DDS xxxiv

SSL authentication, OAS 10-1

startup, shutdown, and alter database in RMAN, RMN xxv

suspend/resume database operations, SBR xxiv

TCP/IP with SSL, NET xix

Thin JDBC support, OAS 3-1

tnsnames.ora file, NET C-86 to NET C-88

transportable tablespaces, SBR xxv

unique names for backup pieces by default, RMN xxv

upgrade catalog command, RMN xxv

V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO, RMN xxvi

V$HS_AGENT and V$HS_SESSION, DDS xxxv

FEEDBACK

Export parameter, SUT 1-19

Import parameter, SUT 2-20

feedback

on Oracle documentation, MIG xiii, RAR x, REP xvi

fetch

piecewise, OCI 5-37, OCI 5-41

FETCH DESCRIPTOR SQL statement, PC_ F-61

Fetch Elapsed Time data view, STU 14-11

fetch operation, OCI 4-15

LOB data, OCI 4-15

setting prefetch count, OCI 4-15

FETCH SQL statement, PC_ F-58, PCO F-49

FETCH statement, PC_ 14-26, PCO 5-14, PCO 5-15, PCO F-46, PLS 5-9, PLS 5-23

cursor variable, PCO 6-34

example, PCO 5-14

example of, PC_ 6-14

examples, PC_ F-60, PCO F-48

in dynamic SQL method 4, PCO 11-37

INTO clause, PCO 5-14

INTO clause in, PC_ 6-14

purpose of, PC_ 6-12, PC_ 6-14

results of, PC_ 6-14

syntax, PLS 11-77

use in dynamic SQL method 3, PC_ 13-20

use in dynamic SQL method 4, PC_ 15-35

used after OPEN command, PC_ F-95

used after OPEN statement, PC_ F-92, PCO F-71, PCO F-73

using in dynamic SQL method 3, PCO 9-20

fetch, batch, PCO 7-7

FETCH_ROW procedure, DDS 9-3

executing queries using pass-through SQL, DDS 9-7

fetches

bulk, DDS 9-9

optimizing round-trips, DDS 9-8

fetching

across commits, PLS 5-50

bulk, PLS 4-38

rows from cursors, PC_ F-58, PC_ F-61, PCO F-46, PCO F-49

fetching in batches

batch fetch, PC_ 8-5

fetching rows in a query, SCN 23

embedded SQL, SCN 14

Fibonacci sequence, PLS 7-39

Fibre Channel

as used in Oracle Parallel Server, PSC 2-6

field conditions

specifying for SQL*Loader, SUT 5-44

field delimiters

new behavior in 8.1.5, SUT 3-18

field length

SQL*Loader specifications, SUT 5-83

field location

SQL*Loader, SUT 5-48

fields, PLS 4-42

character data length and SQL*Loader, SUT 5-73

comparing, SUT 5-15

comparing to literals with SQL*Loader, SUT 5-46

delimited

determining length, SUT 5-73

SQL*Loader, SUT 5-70

enclosed and SQL*Loader, SUT 5-70

length, SUT 5-16

loading all blanks, SUT 5-82

numeric and precision versus length, SUT 5-16

precision, SUT 5-16

predetermined size

length, SUT 5-73

SQL*Loader, SUT 5-83

relative positioning and SQL*Loader, SUT 5-84

specification of position, SUT 5-15

specified with a termination delimiter and SQL*Loader, SUT 5-70

specified with enclosure delimiters and SQL*Loader, SUT 5-70

specifying default delimiters for SQL*Loader, SUT 5-42

specifying for SQL*Loader, SUT 5-47

SQL*Loader delimited

specifications, SUT 5-83

terminated and SQL*Loader, SUT 5-70

FIELDS clause

SQL*Loader, SUT 5-42

terminated by whitespace, SUT 5-85

figurative constants

embedded SQL statements, PCO 2-15

FILE, SUT 6-6

associating with OS file, OCI 7-3

datatype, OCI 3-20

Export parameter, SUT 1-19

Import parameter, SUT 2-20

keyword

SQL*Loader, SUT 8-28

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

file

adding, PSC A-20

archiving redo log, PSC 1-5

dropping, PSA 3-8, PSC A-20

exported, PSC B-2

maximum number, PSC B-3

redo log, PSC 1-5, PSC A-20

renaming, PSC A-20

restricted operations, PSC A-19

FILE columns

Import, SUT 2-57

file extension

for INCLUDE files, PCO 2-21

file I/O, PLS 8-18

FILE keyword, SUT 8-28

file length limit, PCO 2-16

file management locks, SCN 241

File menu, in Oracle Directory Manager, OID 4-10

FILE parameter

in SQL*Loader command file, SUT 6-6

SQL*Loader command line, SUT 6-6

file storage

designing, STU 20-5

file to lock mapping, PSA 7-4

FILE_LOCK view, PSA 7-4, PSA 9-7, PSC A-11, SRF 2-144

FILE_PING view, SRF 2-144

FILECLOSEALL(), ADL 11-11, ADL 11-56, ADL 11-71

filenames

case significance, SRF 1-3

listing for backup, SBR 4-2

name and number, SRF 1-40

normalization of with DBMS_BACKUP_RESTORE, SPR 6-2

normalize, MIG 8-9

quotation marks, SUT 5-19

specifying multiple SQL*Loader, SUT 5-23

SQL*Loader, SUT 5-18

SQL*Loader bad file, SUT 5-25

files

ALERT, PSA 14-4, PSC 7-2

ALERT and trace files, SCN 8-10, SCN 8-15

allocating extents, PSA 8-10

archiving redo log, PSA 13-3, PSA 13-4, PSA 13-6

control file, PSA 13-7, PSC 7-5

dropping, PSA 3-8, PSA 13-15

Export and Import dump file, ADO 2-16

HOSTS, LEG B-9

initialization parameter, SCN 5-4, SCN 5-6

LISTENER.ORA, SCN 6-6

multiplexed, PSA 13-8

number, absolute, PSC 7-3

number, relative, PSC 7-3

Oracle database, SCN 1-5, SCN 1-8, SCN 346

parameter, PSA 1-2, PSA 1-9

password, SCN 292

administrator privileges, SCN 5-3

PFILE, PSA 1-4, PSA 1-5

redo log, PSA 13-3, PSA 13-6, PSA 13-7, PSC 7-3

renaming, PSA 3-8, PSA 13-15

restricted operations, PSA 13-15

size, PSC 5-20

specifying as a redo log file group, SQL 7-516

specifying as datafiles, SQL 7-516

specifying as tempfiles, SQL 7-516

SQL*Loader bad file, SUT 3-11

SQL*Loader discard file, SUT 3-13

SQL*Loader file processing options string, SUT 5-24

used in recovery, PSA 14-7

See also control files, datafiles, redo log files

FILESIZE, SUT 1-20

filespec clause, SQL 7-516

of CREATE CONTROLFILE, SQL 7-263

of CREATE DATABASE, SQL 7-268

of CREATE LIBRARY, SQL 7-316

of CREATE TABLESPACE, SQL 7-419

of CREATE TEMPORARY TABLESPACE, SQL 7-424

FILESPERSET parameter

tuning backups, STU 20-63

filesperset parameter

backup command (RMAN), RMN 10-27

specifying number of files in a backup set, RMN 1-36

FILEXT$ view, SRF 2-146

FILLER field

example, SUT 4-39

new behavior in 8.1.5, SUT 3-19

using as argument to init_spec, SUT 5-47

FILLER support, PCO A-7

filter columns, REP 3-37

for simple subquery snapshots, REP 3-15

filters

finalize() - oracle.jms.AQjmsConnection.finalize(), JPR 2-45

Find Attributes button, in Oracle Directory Manager, OID 6-20

Find Objects button, in Oracle Directory Manager, OID 4-12, OID 6-6

findAttrDecl(String) - oracle.xml.parser.v2.ElementDecl.findAttrDecl(java.lang.String), JPR 4-33

findElementDecl(String) - oracle.xml.parser.v2.DTD.findElementDecl(java.lang.String), JPR 4-25

findEntity(String, boolean) - oracle.xml.parser.v2.DTD.findEntity(java.lang.String, boolean), JPR 4-25

finding bootstrap, LEG 5-5

findNotation(String) - oracle.xml.parser.v2.DTD.findNotation(java.lang.String), JPR 4-25

fine grain locking, PSC 8-6, PSC A-11

fine grain locks

DBA lock, PSC 5-15

one lock element to one block, PSC 5-15

fine grained quiesce, REP A-7

fine-grained access control, GTK 3-69, SAD 21-4, SCN 325

application context, ADG 11-14, ADG 11-18, ADG 11-45, ADG 11-47

compatibility, MIG 9-12

DBMS_RLS package, SPR 44-1, GTK 3-69

features, ADG 11-36

introduction, ADG 11-4, ADG 11-35

performance, ADG 11-37

fine-grained access support, SUT 2-49

finger utility, NET 10-9

fingerprint

accuracy, OAS 8-2, OAS 8-4

authentication failure, OAS 8-16

FIPS 140-1

configuration, OAS lvii

sqlnet.ora parameters, OAS D-2

FIPS compliance, SQL B - 3

FIPS flagger

interactive SQL statements and, ADG 7-2

warns of array usage, PC_ 8-4, PCO 7-6

warns of missing Declare Section, PC_ 4-12

warns of use of pointers as host variables, PC_ 5-7

FIPS flagger and its uses, PCO cxxviii

FIPS flagging, SQL 7-88

FIPS precompiler option, PC_ 10-21, PCO cxxviii, PCO 14-20

FIPS standard, SCN 14

firewall support, NET 4-8

Net8 Firewall Proxy, NET 4-8

Oracle Connection Manager, NET 4-8

firewalls

and SSL, OAS 10-10

FIRST collection method, PLS 4-23

FIRST_ROWS, SRF 1-86

FIRST_ROWS hint, DWG 18-21, SQL 2-64, STU 4-11, STU 7-7

FIRST_VALUE function, DWG 17-42, SQL 4-34

FIX_CORRUPT_BLOCKS procedure, SAD 20-2, SAD 20-7

example, SAD 20-11

FIXED - oracle.xml.parser.v2.AttrDecl.FIXED, JPR 4-7

fixed locking, PSA 7-12

fixed locks

comparing with releasable, PSC 5-5

fixed mode, lock element, PSC 5-19

fixed PCM locks

specifying, PSA 9-4

fixed record length

example, SUT 4-34

fixed user database links

07_DICTIONARY_ACCESSIBILITY initialization parameter, DDS 1-18

advantages and disadvantages, DDS 1-18

FIXED_DATE initialization parameter, ADG 3-9, SRF 1-39

FIXED_DATE parameter

of ALTER SYSTEM, SQL 7-110

fixed-format records, SUT 3-4

flag, PLSQL_V2_COMPATIBILITY, PLS 5-69

FLAGGER parameter

of ALTER SESSION, SQL 7-88

flagging of nonstandard features, SCN 14

flags, PCO 8-9

warning flags, PC_ 9-15

FLOAT

external datatype, OCI 3-11

FLOAT datatype, PC_ 4-6, PCO 4-7, SQL 2-19, SUT 5-59

EXTERNAL format

FLOAT EXTERNAL data values

SQL*Loader, SUT 5-67

FLOAT subtype, PLS 2-14

floating-point numbers, SQL 2-19

FLOOR function, SQL 4-35

FLUSH command, NET A-34

FLUSH SHARED POOL clause

of ALTER SYSTEM, SQL 7-107

flush()

as a function of UTL_TCP, SPR 66-12

FLUSH_NAME command, NET A-35

flushing, OCI 13-10

object changes, OCI 10-14

objects, OCI 13-10

flushing buffer, ADL 5-21

temporary LOB, ADL 10-187

FM format model modifier, SQL 2-51

FM number format element, SQL 2-41

FOR CATEGORY clause

of CREATE OUTLINE, SQL 7-342

FOR clause, PCO 7-16

FOR EACH ROW clause, ADG 13-12

of CREATE TRIGGER, SQL 7-432

FOR loops, PLS 3-10

cursor, PLS 5-13

dynamic range, PLS 3-12

iteration scheme, PLS 3-10

loop counter, PLS 3-10

nested, PLS 3-14

FOR PARTITION clause, SAD 15-24

FOR UPDATE clause, PLS 5-8

LOBs, ADL 2-7

LOBs locator, ADL 5-2

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-327

of SELECT, SQL 7-572, SQL 7-580

restriction on, PLS 5-19

when to use, PLS 5-48

FOR UPDATE OF clause, PCO 3-21

locking rows with, PC_ 3-24

purpose of, PC_ 3-24

when to use, PC_ 3-24

FORALL statement, PLS 4-32

syntax, PLS 11-82

using with BULK COLLECT clause, PLS 4-41

FORCE ANY TRANSACTION system privilege, SQL 7-529

FORCE CLAUSE

of DROP OPERATOR, SQL 7-489

FORCE clause, DWG 8-20

COMMIT statement, DDS 5-13

of COMMIT, SQL 7-231

of COMMIT statement, PC_ F-26, PCO F-17

of CREATE VIEW, SQL 7-458

of DISASSOCIATE STATISTICS, SQL 7-471

of DROP INDEX, SQL 7-481

of DROP INDEXTYPE, SQL 7-482

of DROP TYPE, SQL 7-507

of REVOKE schema_object_privileges, SQL 7-561

of ROLLBACK, SQL 7-565

of ROLLBACK statement, PC_ F-99, PCO F-77

ROLLBACK statement, DDS 5-13

FORCE mode, warning notice, PSG 7-8

FORCE option

object type dependencies, ADO 2-15

FORCE PARALLEL DML clause

of ALTER SESSION, SQL 7-84

FORCE parameter

and job-to-instance affinity, SPR 17-12

force refreshes, REP 3-29

FORCE TRANSACTION system privilege, SQL 7-529

forcing

COMMIT or ROLLBACK, DDS 5-8, DDS 5-12

forcing a log switch, SAD 6-16

with the ALTER SYSTEM statement, SAD 6-16

foreground processes

instance shutdown, PSA 4-5

foreign function libraries

exporting, SUT 1-57

importing, SUT 2-58

FOREIGN KEY clause

of constraint_clause, SQL 7-236, SQL 7-240

foreign key constraints, DWG 7-5, SQL 7-240

changes in parent key values, SCN 266

constraint checking, SCN 273

defining, ADG 4-25, ADG 4-26

deleting parent table rows and, SCN 267

enabling, ADG 4-20, ADG 4-27

maximum number of columns in, SCN 263

NOT NULL constraint and, ADG 4-10

nulls and, SCN 265

one-to-many relationship, ADG 4-10

one-to-n relationships, ADG 4-10

UNIQUE key constraint and, ADG 4-10

updating parent key tables, SCN 266

updating tables, SCN 268, SCN 269

foreign key joins

snowflake schemas, DWG 16-3

foreign keys, SCN 1-57

defined, SCN 1-58

partially null, SCN 266

privilege to use parent key, SCN 307

representing many-to-one entity relationship with, ADO 9-7

foreign tables

rowids of, SQL 2-27

forget phase

two-phase commit, DDS 4-16

formal parameters, PLS 5-8

format

of functions, PLS 7-6

of packaged subprograms, PLS 7-11

of procedures, PLS 7-3

format elements, NLS 4-10, NLS 4-11

C, NLS 4-11

D, NLS 2-22, NLS 4-11

day, NLS 2-17

G, NLS 2-22, NLS 4-11

IW, NLS 4-11

IY, NLS 4-11

L, NLS 2-23, NLS 4-11

month, NLS 2-17

RM, NLS 2-14, NLS 4-10

RN, NLS 4-11

format mask, PCO 4-41

format masks

TO_DATE function, ADG 3-8

when needed, PLS 2-29

format models, SQL 2-38

changing the return format, SQL 2-39

date, SQL 2-45

date, changing, SQL 2-45

date, default, SQL 2-45

date, format elements, SQL 2-45

date, maximum length, SQL 2-45

modifiers, SQL 2-51

number, SQL 2-40

number, elements of, SQL 2-41

specifying, SQL 2-40

FORMAT precompiler option, PCO 14-22

purpose, PCO 2-12

FORMAT statement

in Oracle Trace, STU 14-21

FORMAT statement in DB2

not allowed by SQL*Loader, SUT B-4

formats

and SQL*Loader input records, SUT 5-52

calendar, NLS 2-17

currency, NLS 2-23

for dates and numbers. See format models

numeric, NLS 2-21

of distinguished names, OID 2-3

of return values from the database, SQL 2-38

of values stored in the database, SQL 2-38

formats of COBOL statements

ANSI, PCO 2-12

TERMINAL, PCO 2-12

formatter tables

in Oracle Trace, STU 14-5

formatting errors

SQL*Loader, SUT 5-25

Forms

upgrading Oracle Forms applications, MIG 10-12

forward declarations, PLS 7-10

when needed, PLS 7-10, PLS 7-42

forward reference, PCO 5-13

forward references, PLS 2-36

why not allowed, PC_ 6-12

forward type definitions, PLS 9-29

%FOUND cursor attribute, PLS 5-35, PLS 5-39

fractured block detection, RMN 1-67

fragmentation

external, DWG 18-44

parallel DDL, SCN 190

reducing database fragmentation via full export/import, SUT 2-44

free list

and Export utility, PSC B-3

cluster, PSC A-22

exclusive mode, PSC B-2

free list group

enhanced for release 7.3, PSC A-11

free list groups

and cache coherency, PSA 6-10

assigned to instance, PSC 7-20, PSC 7-23

assigning to session, PSA 8-8

definition, PSC 7-13

setting !blocks, PSA 9-4

unused space, PSA 8-14

used space, PSA 8-14

using to partition data, PSA 8-1

free lists, PSC 7-21, SCN 4-10

free space

coalescing, SAD 9-12

coalescing extents, SCN 4-14

SMON process, SCN 1-18, SCN 8-11

coalescing within data blocks, SCN 4-10

free lists, SCN 4-10

listing free extents, SAD 19-32

parameters for data blocks, SCN 4-5

section of data blocks, SCN 4-5

tablespaces and, SAD 9-41

free space list

locating space, SRF 1-47

FREE SQL statement, PC_ 17-6, PC_ F-63

FREE statement, PCO F-51

free() function, PC_ 15-37

example of using, PC_ 15-37

FREE_LIST_INST parameter (Oracle Version 6), PSC A-22, PSC A-23

FREE_LIST_PROC parameter (Oracle Version 6), PSC A-22, PSC A-23

FREED_EXTENTS, PSC A-12

freeing

objects, OCI 10-32, OCI 13-9

temporary LOBs, ADL 10-28

thread context, PC_ 11-9, PC_ F-29, PCO 12-8, PCO F-20

FREELIST GROUPS

storage option, PSA 1-6

FREELIST GROUPS clause, PSA 1-7, PSA 8-4, PSA 8-12, SRF 1-47

FREELIST GROUPS parameter

description, SAD 12-10

of STORAGE clause, SQL 7-608

FREELIST GROUPS storage option

clustered tables, PSC A-22

instance number, PSC 7-20

FREELISTS

creating for clustered tables, PSA 8-5

creating for indexes, PSA 8-6

parameter, PSC 7-12

storage option, PSA 8-4

FREELISTS clause, PSA 8-4

indexes, PSA 8-6

maximum value, PSA 8-4, SRF 1-28

FREELISTS parameter, DWG 18-56

description, SAD 12-11

of STORAGE clause, SQL 7-608

FREELISTS storage option

clustered tables, PSC A-22

FREETEMPORARY(), ADL 10-28

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY initialization parameter: obsolete

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY parameter, PSC A-8

Frequently Asked Questions, PC_ 1-7

Frequently asked questions, ADQ 6-1

frequently asked questions

about Oracle objects, ADO 8-1

FROM clause

of queries, SQL 5-23

of REVOKE system_privileges_and_roles, SQL 7-557

of SELECT, SQL 7-574

FROM COLUMNS clause

of DISASSOCIATE STATISTICS, SQL 7-471

FROM FUNCTIONS clause

of DISASSOCIATE STATISTICS, SQL 7-471

FROM INDEXES clause

of DISASSOCIATE STATISTICS, SQL 7-471

FROM INDEXTYPES clause

of DISASSOCIATE STATISTICS, SQL 7-471

FROM PACKAGES clause

of DISASSOCIATE STATISTICS, SQL 7-471

FROM PUBLIC clause

of REVOKE schema_object_privileges, SQL 7-561

FROM role clause

of REVOKE schema_object_privileges, SQL 7-561

FROM TYPES clause

of DISASSOCIATE STATISTICS, SQL 7-471

FROM user clause

of REVOKE schema_object_privileges, SQL 7-561

FROMUSER

Import parameter, SUT 2-21

front-ends, SCN 6-2

FTP

Export files, SUT 1-53

FULL

Export parameter, SUT 1-21

full backups, RMN 1-49

full database mode

Import, SUT 2-22

FULL hint, SQL 2-65, STU 7-10, STU 12-7

full index scans, STU 4-23

full partition-wise joins, DWG 5-12, STU 5-20

full scan, PCO D-6

description of, PC_ C-6

full table scans, STU 4-21, STU 4-46, STU 9-3

LRU algorithm and, SCN 7-4

multiblock reads, STU 4-26

parallel execution, SCN 161, SCN 162

rule-based optimizer, STU 4-46

selectivity and, STU 4-25

function calls, tracing, OID 5-23

function expressions

built-in, SQL 5-5

function names

coding guidelines, OCI 2-36

function prototype

definition of, PC_ 10-13

function-based indexes, GTK 3-24, SAD 14-11 to SAD 14-13, SCN 10-26, SQL 7-295, STU 12-12

and query rewrite, SQL 7-93

compatibility, MIG 9-10

creating, SQL 7-298

dependencies, SCN 10-28, SCN 113

DISABLED, SCN 114

disabling, SQL 7-40, SQL 7-116

enabling, SQL 7-37, SQL 7-40, SQL 7-116

invalidations

during upgrade, MIG 8-14

privileges, SCN 10-28, SCN 114

returning values of type methods, ADO 6-30

UNUSABLE, SCN 114

functions, PLS 7-1, PLS 7-6

3GL, calling, SQL 7-316

See also SQL functions

access to tables and packages, SQL 7-442

associating statistics with, SQL 7-212

attributes, OCI 6-8

avoiding run-time compilation, SQL 7-28

cannot serve as host variables, PC_ 4-16

changing the declaration of, SQL 7-28

codes, OCI 15-237

datatype of return value, SQL 7-288

declaring

as a Java method, SQL 7-289

as C functions, SQL 7-289

defining an index on, SQL 7-298

disassociating statistics types from, SQL 7-478

examples, SQL 7-289

executing, SQL 7-226

from parallel query process, SQL 7-288

expressions, SQL 5-5

external, SQL 7-285, SQL 7-354

function-based indexes, SCN 10-26

hash functions, SCN 10-58

invalidating local objects dependent on, SQL 7-478

issuing COMMIT or ROLLBACK statements, SQL 7-84

Java

parallel execution, SCN 203

LAG/LEAD, DWG 17-46

linear regression, DWG 17-48

naming rules, SQL 2-74

new and updated calls, OCI 1-13

parameter, PLS 7-6

parts, PLS 7-7

PL/SQL, SCN 44, SCN 48

contrasted with procedures, SCN 1-55, SCN 44

DETERMINISTIC, SCN 114, STU 4-70

deterministic, STU 4-70

parallel execution, SCN 203

privileges for, SCN 309

roles, SCN 322

See also procedures

privileges executed with, SQL 7-188, SQL 7-441

ranking, DWG 17-24

recompiling, SAD 19-25

recompiling invalid, SQL 7-28

re-creating, SQL 7-286, SQL 7-312

removing from the database, SQL 7-478

replicating, REP 2-17

reporting, DWG 17-43

RETURN clause, PLS 7-7

schema executed in, SQL 7-188, SQL 7-441

specification, PLS 7-7

specification of

in CREATE TYPE, SQL 7-442

specifying schema and user privileges for, SQL 7-288

SQL, SCN 11

COUNT, SCN 10-38

default column values, SCN 10-9

in CHECK constraints, SCN 271

in views, SCN 10-15

new in Oracle8i, MIG E-3

NVL, SCN 10-9

optimizing view queries, STU 4-84

statistics, DWG 17-46

stored, SQL 7-285

storing return value of, SQL 7-227

synonyms for, SQL 7-377

syntax, PLS 11-84

user-defined, SQL 4-118

extensible optimization, SCN 140, STU 4-32

using a saved copy of, SQL 7-288

windowing, DWG 17-35

See Also PL/SQL

FUNCTIONS clause

of ASSOCIATE STATISTICS, SQL 7-210, SQL 7-212

Funneling-in of Messages, ADQ 7-15

fuzzy reads, SCN 213

FX format model modifier, SQL 2-51