Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
Generic Documentation Master Index
D
D date format element, SQL 2-46
D number format element, SQL 2-41
daemons, OID 3-2
DAEMON.TRACE_DIRECTORY parameter, NET C-5
DAEMON.TRACE_LEVEL parameter, NET C-6
DAEMON.TRACE_MASK parameter, NET C-6
dangling REFs, ADO 1-7,
SCN 13-10
dangling refs, PLS 9-33
DAP. See Directory Access Protocol (DAP)
.dat files, generated by bulkload, OID 7-29
DATA
SQL*Loader command-line parameter, SUT 6-4
data
abstraction, PLS 9-2
access to, SCN 1-50
concurrent, SCN 212
control of, SCN 280
fine-grained access control, SCN 325
message queues, SCN 73
security domains, SCN 280
comparative, STU 11-5
consistency of
defined, SCN 1-54
examples of lock behavior, SCN 243
locks, SCN 213
manual locking, SCN 242
read consistency, SCN 1-30
repeatable reads, SCN 216
transaction level, SCN 216
underlying principles, SCN 225
conversion, NLS 4-5
delimiter marks in data and SQL*Loader, SUT 5-72
design tuning, STU 2-8
distinguishing different input formats for SQL*Loader, SUT 5-51
distributed manipulation of, SCN 1-34
encapsulation, PLS 1-16
exporting, SUT 1-24
formatted data and SQL*Loader, SUT 4-28
generating unique values with SQL*Loader, SUT 5-56
how stored in tables, SCN 10-4
including in control files, SUT 5-21
integrity, OAS 1-5,
PLS 5-41
ensuring with multiple column groups, REP 5-10
parallel propagation, REP 6-21
serial propagation, REP 6-21
integrity checking on input, SQL 2-18
integrity of, SCN 1-29,
SCN 10-4,
SCN 252
CHECK constraints, SCN 271
enforcing, SCN 254,
SCN 255
overview, SCN 1-57
parallel DML restrictions, SCN 202
referential, SCN 253
two-phase commit, SCN 1-35
types, SCN 253
loading data contained in the SQL*Loader control file, SUT 5-54
loading in sections
SQL*Loader, SUT 8-15
loading into more than one table
SQL*Loader, SUT 5-51
loading LONG
SQL*Loader, SUT 5-64
locks, PLS 5-42
locks on, SCN 230
maximum length of delimited data for SQL*Loader, SUT 5-73
moving between operating systems using SQL*Loader, SUT 5-74
partitioning, DWG 5-4
privacy, OAS 1-4
purging, DWG 14-7
replicating, SCN 1-36
retrieving, SQL 5-19
saving in a direct path load, SUT 8-12
saving rows
SQL*Loader, SUT 8-18
security of, SAD 21-3
sources for tuning, STU 11-2
SQL*Loader methods of loading into tables, SUT 5-32
substitutions, DWG 13-5
sufficiency check, DWG 19-15
undo
storing, SQL 7-367
unsorted
SQL*Loader, SUT 8-17
values optimized for SQL*Loader performance, SUT 5-54
volume, STU 11-2
data block addresses
translating to lock name, PSA 8-13
data block corruption
repairing, SAD 20-2 to
SAD 20-14
data blocks, PSA 7-5,
SCN 1-7,
SCN 4-2,
STU 20-10
allocating for extents, SCN 4-14
altering size of, SAD 2-22
block-level recovery, SCN 355
cached in memory, SCN 8-8
clustered, SCN 10-53
coalescing extents, SCN 4-14
coalescing free space in blocks, SCN 4-10
controlling free space in, SCN 4-5
factors affecting size of, ADG 2-6
format, SCN 4-3
free lists and, SCN 4-10
hash keys and, SCN 10-59
how rows stored in, SCN 10-5
managing space in, SAD 12-2 to
SAD 12-6
operating system blocks versus, SAD 2-22
overview, SCN 4-2
PCTFREE in clusters, SAD 16-5
reading multiple, SRF 1-30
read-only transactions and, SCN 243
row directory, SCN 10-7
shared in clusters, SAD 16-2,
SCN 10-49
shown in ROWIDs, ADG 3-22
shown in rowids, SCN 12-17,
SCN 12-18
size of, SAD 2-22,
SRF 1-27,
SRF 1-28
space available for inserted rows, SCN 4-9
stored in the buffer cache, SCN 7-3
transaction entry settings, SAD 12-7
types accessed by transactions, PSA 6-3
verifying, SAD 10-12
writing to disk, SCN 8-8
data cache, STU 23-2
data cartridge
definition, DCI 1-2
development process, DCI 2-2
domains, DCI 1-4
external procedures (guidelines), DCI 4-15
installation, DCI 2-4
interfaces, DCI 1-14
method, DCI 1-8
naming conventions, DCI 2-8
suggested development approach, DCI 2-14
data cartridges
OCI functions, OCI xvii,
OCI 2-3
data control in OO4O, ADG 1-19
data conversion, ADG 3-25,
SQL 2-36
ANSI datatypes, ADG 3-24,
SCN 12-23
assignments, ADG 3-25
expression evaluation, ADG 3-27
implicit versus explicit, SQL 2-38
program interface, SCN 8-27
SQL*Loader, SUT 3-8
SQL/DS and DB2 datatypes, ADG 3-24,
SCN 12-23
when performed implicitly, SQL 2-36
when specified explicitly, SQL 2-37
data definition conversion
Import utility, MIG 3-13
data definition language, SCN 1-52,
SUT 5-3
asynchronous, SPR 37-63,
RAR 8-129
auditing, SCN 335
BEGINDATA keyword, SUT 5-21
BLANKS keyword, SUT 5-46
CHARACTERSET keyword
SQL*Loader, SUT 5-31
column_name, SUT 5-16
commit implied by, SCN 35
CONCATENATE keyword, SUT 5-36
CONSTANT keyword, SUT 5-47,
SUT 5-54
CONTINUEIF keyword, SUT 5-36
date mask, SUT 5-16
DEFAULTIF keyword, SUT 5-80
defined, SCN 1-52
delimiter_spec, SUT 5-16
described, SCN 12
DISABLED_CONSTRAINTS keyword
SQL*Loader, SUT 8-21
DISCARDDN keyword, SUT 5-28
DISCARDMAX keyword
SQL*Loader, SUT 5-30
embedding in PL/SQL, SCN 28
events and triggers, SQL 7-430
EXCEPTIONS keyword
SQL*Loader, SUT 8-21
expanded syntax diagrams, SUT 5-15
EXTERNAL keyword, SUT 5-67
field_condition, SUT 5-15
FILE keyword
SQL*Loader, SUT 8-28
FLOAT keyword, SUT 5-67
in transactions, PC_ 3-17
INFILE keyword, SUT 5-22
length, SUT 5-16
loading data in sections
SQL*Loader, SUT 8-15
locks, SCN 239
NULLIF keyword, SUT 5-81
parallel DDL, SCN 159
parallel keyword
SQL*Loader, SUT 8-27
parsing with DBMS_SQL, SCN 28
pos_spec, SUT 5-15
POSITION keyword, SUT 5-48
precision, SUT 5-16
processing statements, SCN 23
RECNUM keyword, SUT 5-47
REENABLE keyword
SQL*Loader, SUT 8-21
roles and privileges, SCN 323
SEQUENCE keyword, SUT 5-56
SQL statements, OCI 1-7
statements, SQL 6-1
and implicit commit, SQL 6-2
causing recompilation, SQL 6-2
PL/SQL support of, SQL 6-2
supplying asynchronous, SPR 37-63,
RAR 8-129
syntax diagrams
high-level, SUT 5-4
SYSDATE keyword, SUT 5-55
TERMINATED keyword, SUT 5-70
UNRECOVERABLE keyword
SQL*Loader, SUT 8-19
WHITESPACE keyword, SUT 5-70
data definition language (DDL)
description, PCO 5-2
embedded, PCO 14-32
data dictionary, SRF 2-1,
STU 2-12,
STU 11-3,
STU 19-22
access to, SCN 2-3
adding comments to, SQL 7-228
adding objects to, SCN 2-5
ALL prefixed views, SCN 2-6
audit trail (SYS.AUD$), SCN 2-5
backups, SCN 366
base tables, SRF 5-2
cache, SCN 7-10,
SRF 3-71,
SRF 3-88,
SRF 3-89,
SRF 3-90,
SRF 3-91,
SRF 3-92
location of, SCN 7-7
changing storage parameters, SAD 19-28
compatibility, MIG 9-25
compile-time errors, ADG 9-42
conflicts with control files, SAD 5-8
content of, SCN 2-2,
SCN 7-10
procedures, SCN 61
contents with generic connectivity, DDS C-3
datafiles, SCN 3-6,
SCN 366,
SRF 1-40
DBA prefixed views, SCN 2-6
defined, SCN 1-29,
SCN 2-2
dependencies tracked by, SCN 109
DICTIONARY view, SRF 2-156
dictionary-managed tablespaces, SCN 3-8
dropped tables and, ADG 2-10,
SAD 13-16
DUAL table, SCN 2-7
dynamic performance tables, SCN 2-7
installing for Heterogeneous Services, DDS 7-2
integrity constraints in, ADG 4-27
location, SRF 5-2
locks, SCN 239
mapping for generic connectivity, DDS C-4
objects, PSC 4-2
Oracle server name/SQL Server name, DDS C-4
owner of, SCN 2-3
prefixes to views of, SCN 2-5
procedure source code, ADG 9-43
protection, MIG 9-25
public synonyms for, SCN 2-4
purging pending rows from, DDS 5-15,
DDS 5-16
querying views, PSA 12-9
replication, REP 1-14,
SCN 434
rollback segments, SRF 1-105
row cache, PSC 4-2
row cache and, SCN 7-10
schema object views, ADG 2-41,
SAD 19-29
scripts, SRF 5-3
segments in the, SAD 19-27
sequence cache, PSC 8-14
setting storage parameters of, SAD 19-26
SQL scripts, SRF 5-2
statistics in, SCN 138,
STU 4-10,
STU 8-13
partition statistics, SCN 11-13
structure of, SCN 2-3
SYSTEM tablespace, SCN 2-2,
SCN 2-5,
SCN 3-6
tables, DDS 6-4,
SRF 2-2
translation support for generic connectivity, DDS C-2
updates of, SCN 2-5
USER prefixed views, SCN 2-6
uses of, SCN 2-3
table and column definitions, SCN 20
V$DBFILE view, SAD 2-16
V$LOGFILE view, SAD 2-16
validity of procedures, SCN 61
views, PSA 3-5,
SRF 1-40
overview, SRF 2-2
user views, SRF 2-1
views used in optimization, SCN 138,
STU 8-13
data dictionary cache locks, PSA 7-19
data dictionary views, SBR 4-6,
SBR 4-7,
SBR 4-12
DBA_DB_LINKS, DDS 2-21,
DDS 5-7,
DDS 5-9
deferred transactions, RAR 9-47
generic connectivity, DDS C-3
Heterogeneous Services, DDS 7-9,
DDS B-1
replication, RAR 9-1
snapshots, RAR 9-53
USER, DDS 5-7,
DDS 5-9
data encryption, ADG 11-4,
ADG 11-72
distributed systems, DDS 1-30
Data Encryption Standard, SPR 23-1
Data Encryption Standard (DES), ADG 11-72
data field
specifying the SQL*Loader datatype, SUT 5-48
data file
adding, PSC A-20
dropping, PSC A-20
maximum number, PSC B-3
recovery, PSC A-24
renaming, PSC A-20
tablespace, PSC A-20
taking offline or online, PSC A-20
data files, PSG 1-3
access in high availability, PSC 9-6
adding, PSA 9-2,
PSA 9-5,
PSA 9-8
allocating extents, PSA 8-10
backing up, PSA 13-1
described, PSG 1-12
disk contention, PSC 7-2
file ID, PSA 7-3
instance recovery, PSA 14-4,
PSC 7-3
mapping locks to blocks, PSC 5-20
multiple files per table, PSA 8-9,
PSA 8-11,
PSC 7-21
number of blocks, PSA 7-3
parallel recovery, PSA 14-7
raw devices, PSG 2-6
recovery, PSA 14-7
shared, PSC 7-2
tablespace name, PSA 7-3
unspecified for PCM locks, PSC 5-20
validity, PSA 9-7
data files and data blocks
examining, PSA 7-3
data integrity, OAS 1-5,
OID 2-20,
OID 2-23,
OID 2-25,
PC_ 3-13,
PCO 3-12
definition of, PC_ 3-16
data lock, PCO 3-12
data locks, PC_ 3-16
conversion, SCN 227
duration of, SCN 226
escalation, SCN 227
data manipulation language
auditing, SCN 335
defined, SCN 1-52
described, SCN 12
locks acquired by, SCN 236
operations
and triggers, SQL 7-429
during index creation, SQL 7-301
during index rebuild, SQL 7-144
parallel DML, SCN 159,
SCN 192
partition locks, SCN 11-45
privileges controlling, SCN 307
processing statements, SCN 19
serializable isolation for subqueries, SCN 224
SQL statements, OCI 1-8
statements, SQL 6-4
PL/SQL support of, SQL 6-4
statements allowed in distributed transactions, DDS 1-33,
SCN 404
transaction model for parallel DML, SCN 196
triggers and, SCN 83,
SCN 104
data manipulation language (DML), PCO 5-7
data marts
definition of, DWG 20-2
dependent, DWG 20-2
differences from data warehouse, DWG 20-2
independent, DWG 20-2
Data Migration Assistant, GTK 2-4,
GTK 3-60
data mining, GTK 3-24
data models, SCN 1-20
data modification attack, OAS 2-5
data object number
extended ROWID, ADG 3-21,
ADG 3-22
extended rowid, SCN 12-17
in extended rowids, SQL 2-27
data path loads
direct and conventional, SUT 8-2
data privacy, OID 2-20,
OID 2-26
using SSL, OID 1-5
data privacy and integrity
components of, OAS 12-3
data propagation
and dependency maintenance, REP 6-21
reduced, REP A-6
synchronous, REP 2-31
data recovery
direct path load
SQL*Loader, SUT 8-13
data segments, SCN 1-7,
SCN 4-18,
SCN 10-4
data servers
changing password to, OID 5-30
data structures
new for 8.0, OCI 2-5
data subsetting, REP A-6
data transfer, maximizing, NET 5-8
data views in Oracle Trace, STU 14-6
Average Elapsed Time, STU 14-11
CPU Statistics, STU 14-12
Disk Reads, STU 14-9
Disk Reads/Execution Ratio, STU 14-9
Disk Reads/Logical Reads Ratio, STU 14-10
Disk Reads/Rows Fetched Ratio, STU 14-9
Execute Elapsed Time, STU 14-11
Fetch Elapsed Time, STU 14-11
Logical Reads, STU 14-9
Logical Reads/Rows Fetched Ratio, STU 14-9
Number of Rows Processed, STU 14-12
Parse Elapsed Time, STU 14-11
Parse/Execution Ratio, STU 14-10
Re-Parse Frequency, STU 14-10
Rows Fetched/Fetch Count Ratio, STU 14-12
Rows Sorted, STU 14-12
Sorts in Memory, STU 14-12
Sorts on Disk, STU 14-12
Total Elapsed Time, STU 14-11
Waits by Average Wait Time, STU 14-13
Waits by Event Frequency, STU 14-13
Waits by Total Wait Time, STU 14-13
data warehouses, DWG 8-2
definition of, DWG 20-2
differences from data marts, DWG 20-2
dimension tables
(lookup tables), DWG 8-7
dimensions, DWG 16-2
fact tables (detail tables), DWG 8-7
partitioned tables, DWG 5-6
refresh tips, DWG 14-22
refreshing, DWG 14-2
star queries, DWG 16-2
data warehousing, GTK 3-21 to
GTK 3-30,
PSC 8-5
bitmap indexes, SCN 10-34
Database Resource Manager, GTK 3-48,
SAD 25-2
dimension schema objects, SCN 1-28,
SCN 10-20
dimensions, STU 4-62
DISABLE VALIDATE state, GTK 3-28
function-based indexes, GTK 3-24
hierarchies, SCN 1-28,
SCN 10-20
materialized views, GTK 3-21,
SCN 10-18
refreshing table data, SCN 194
related features, GTK 3-30
SAMPLE function, GTK 3-24
star queries, STU 4-62
statistics gathering
COMPUTE STATISTICS clause of CREATE and ALTER INDEX statements, GTK 3-27
DBMS_STATS package, GTK 3-26
summaries, SCN 10-18
transportable tablespaces, GTK 3-23
Data Warehousing database, PSG 1-10
data()
function of UTL_SMTP, SPR 65-8
database
accounts
creating, SQL 7-451
allowing generation of redo logs, SQL 7-12
allowing reuse of control files, SQL 7-269
allowing unlimited resources to users, SQL 7-361
application administrator, ADG 11-8
applications and security, ADG 11-5
archiving mode, PSA 3-2,
PSA 3-8
backup, PSC 1-5
buffers, STU 19-31
cancel-based recovery, SQL 7-13
terminating, SQL 7-14
change-based recovery, SQL 7-14
changing characteristics of, SQL 7-263
changing global name, SQL 7-15
changing the name of, SQL 7-263,
SQL 7-264
character set
specifying, SQL 7-271
connect strings, SQL 2-80
converting from Oracle7 data dictionary, SQL 7-11
creating, SQL 7-268
design techniques for Oracle Parallel Server, PSA 6-2
designing, PSA A-2
designing media recovery, SQL 7-12
enabling automatic extension of, SQL 7-271
erasing all data from, SQL 7-268
export and import, PSC B-2
global name in a distributed system, ADG 2-38
granting system privileges on, SQL 7-521
limiting resources for users, SQL 7-360
managed recovery of, SQL 7-8
modifying, SQL 7-10
mounted but not open, PSA 3-8
mounting, SQL 7-11,
SQL 7-268
naming, SQL 7-11
number of archived log files, PSA 13-7,
PSC 7-5
number of instances, PSA 3-3,
PSC 7-21
opening, SQL 7-11,
SQL 7-268
after media recovery, SQL 7-12
recovering, SQL 7-13
with backup control file, SQL 7-14
re-creating control file for, SQL 7-263
redo log files
specifying, SQL 7-265
remote
accessing, SQL 5-26
authenticating users to, SQL 7-275
connecting to, SQL 7-274
inserting into, SQL 7-542
service name of, SQL 7-275
table locks on, SQL 7-548
resetting
current log sequence, SQL 7-12
to an earlier version, SQL 7-15
restricting users to read-only transactions, SQL 7-12
resuming activity, SQL 7-108
rollback segments, PSA 3-4
scalability, PSC 8-12
security and schemas, ADG 11-19
specifying datafiles for, SQL 7-265
standby, PSA 14-17
starting NOMOUNT, PSA 14-11
suspending activity, SQL 7-107
time-based recovery, SQL 7-13
user and application user, ADG 11-6
database administrator
role during migration, MIG 2-7
database administrator (DBA), STU 1-8
privileges for export, SUT 1-3
database administrators, SAD 1-2
application administrator versus, SAD 21-11
initial priorities, SAD 1-17 to
SAD 1-21
operating system account, SAD 1-4
password files for, SAD 1-7
responsibilities of, SAD 1-2
roles
about, SAD 1-6
for security, SAD 21-8
security and privileges of, SAD 1-4
security for, SAD 21-8
security officer versus, SAD 1-3,
SAD 21-2
user accounts, SAD 1-4
utilities for, SAD 1-17
database administrators (DBAs)
authentication, SCN 291
data dictionary views, SCN 2-6
DBA role, ADO 2-11,
SCN 324
password files, SCN 292
responsible for backup and recovery, SCN 342
database authentication, SAD 22-8
database block buffers parameter, OID 13-10
database block size parameter, OID 13-10
database buffers
after committing transactions, SCN 36
buffer cache, SCN 7-3,
SCN 8-8
clean, SCN 8-8
committing transactions, SCN 8-10
defined, SCN 1-14,
SCN 7-3
dirty, SCN 7-4,
SCN 8-8
free, SCN 7-4
multiple buffer pools, SCN 7-5
pinned, SCN 7-4
size of cache, SCN 7-5
writing of, SCN 8-8
database changes
making permanent, PLS 5-43
undoing, PLS 5-44
database character set, PLS 2-20
Database Configuration Assistant, GTK 2-4,
GTK 3-59
and log files, PSC 7-5
and object creation for Oracle Parallel Server, PSA 3-1
and the IFILE parameter, PSA 1-3
placement of IFILE parameter, PSA 1-3
database connection
for object applications, OCI 10-10
Database Connection event, STU 14-5
database connections, OID 2-32
concurrent, OID 13-11,
OID F-5
pooling, OID 1-4
database creation during installation, PSG 3-7
database event notification, ADG 14-1,
ADG 15-5
database events
and triggers, SQL 7-431
database instance registration
client load balancing, GTK 3-76,
PSC 8-10
connect-time failover, PSC 8-10
database link
creating synonym for, PC_ 3-14
defining, PC_ 3-14
example using, PC_ 3-14
using in INSERT statement, PC_ F-69
where stored, PC_ 3-14
database links, NET 4-15,
NET 6-68,
SCN 1-28,
SQL 5-26
advantages, DDS 1-13
auditing, DDS 1-31
authentication, DDS 1-25
without passwords, DDS 1-26
closing, DDS 2-18,
DDS 3-2,
SQL 7-84
connected user, DDS 2-12,
DDS 2-36
advantages and disadvantages, DDS 1-17
definition, DDS 1-17
connection qualifiers, REP 2-14
connections
controlling, DDS 3-2
determining open, DDS 2-24
creating, DDS 2-8,
RAR 2-12,
RAR 2-17,
RAR 5-4,
SQL 2-79,
SQL 7-273
connected user, DDS 2-12,
DDS 2-36
connected user, shared, DDS 2-36
current user, DDS 2-12,
DDS 2-37
example, DDS 1-20
fixed user, DDS 2-11,
DDS 2-34
fixed user, shared, DDS 2-35
obtaining necessary privileges, DDS 2-8
private, DDS 2-9
public, DDS 2-10
scenarios, DDS 2-34
shared, DDS 2-14,
DDS 2-15
specifying types, DDS 2-9
creating synonyms with, SQL 7-379
current user, DDS 1-16,
DDS 2-12,
SQL 7-274
advantages and disadvantages, DDS 1-19
definition, DDS 1-17
data dictionary views
ALL, DDS 5-7,
DDS 5-9
DBA_DB_LINKS, DDS 5-7,
DDS 5-9
USER, DDS 2-21,
DDS 5-7,
DDS 5-9
defined, SCN 1-28
definition, DDS 1-10
diagnosing problems with, REP B-2
distributed queries, DDS 1-34
distributed transactions, DDS 1-35
dropping, DDS 2-19
enforcing global naming, DDS 2-3
enterprise users and, DDS 1-28
fixed user, DDS 2-34
advantages and disadvantages, DDS 1-18
definition, DDS 1-17
global
definition, DDS 1-16
global database link, NET 4-15
global names, DDS 1-13
global object names, DDS 1-36
granting system privileges on, SQL 7-521
handling errors, DDS 3-3
heterogeneous systems, DDS 6-2,
DDS 7-4
incomplete specifications, REP B-6
job queues and, SAD 8-8
limiting number of connections, DDS 2-20
listing, DDS 2-21,
DDS 5-7,
DDS 5-9
managing, DDS 2-18
minimizing network connections, DDS 2-14
name resolution, DDS 1-36
schema objects, DDS 1-38
views, synonyms, and procedures, DDS 1-41
when global database name is complete, DDS 1-37
when global database name is partial, DDS 1-37
when no global database name is specified, DDS 1-37
names for, DDS 1-15
naming, SQL 2-79
partition-extended table names, SCN 11-65
passwords
viewing, DDS 2-22
private
definition, DDS 1-16
private database, NET 4-15
public, SQL 7-274
definition, DDS 1-16
dropping, SQL 7-475
public database, NET 4-15
referential integrity in, DDS 3-3
referring to, SQL 2-81
remote queries, DDS 1-33
remote transactions, DDS 1-33,
DDS 1-35
removing from the database, SQL 7-475
replication, REP 2-12
resolution, DDS 1-36,
SCN 406
restrictions, DDS 1-23
roles on remote database, DDS 1-23,
SCN 393
schema objects, DDS 1-21
name resolution, DDS 1-22
synonyms for, DDS 1-22
service names used within link names, DDS 2-13
shared, DDS 1-12,
SQL 7-274
configuring, DDS 2-16
creating, DDS 2-14
creating links to dedicated servers, DDS 2-16
creating links to multi-threaded (MTS) servers, DDS 2-17
determining whether to use, DDS 2-14
shared SQL, DDS 1-34
snapshot sites, REP 3-32,
REP 7-15
syntax of, SQL 2-80
tuning distributed queries, DDS 3-3
tuning queries with hints, DDS 3-8
tuning using collocated inline views, DDS 3-4
types of links, DDS 1-16
types of users, DDS 1-17
username and password, SQL 2-80
users
specifying, DDS 2-11
using cost-based optimization, DDS 3-5
using in DELETE statement, PCO F-32
using in INSERT statement, PCO F-56
using in UPDATE statement, PCO F-88
viewing, DDS 2-21
database management system (DBMS), SCN 1-2
object-relational DBMS, SCN 13-2
Oracle server, SCN 1-4
principles, SCN 1-20
database mount locks, PSA 7-19
database objects
dropping, SQL 7-510
export privileges, SUT 1-4
exporting LONG columns, SUT 1-57
nonschema, SQL 2-69
schema, SQL 2-68
transferring across a network
Import, SUT 2-47
Database Resource Manager, GTK 3-48,
SAD 25-1 to
SAD 25-22,
STU 18-4,
STU 18-7,
STU 23-4,
STU 23-5
administering system privilege, SAD 25-3 to
SAD 25-5
DBMS_RESOURCE_MANAGER package, GTK 3-49
DBMS_RESOURCE_MANAGER_PRIVS package, GTK 3-49
enabling, SAD 25-18
ALTER SYSTEM statement, SAD 25-18
RESOURCE_MANAGER_PLAN initialization parameter, SAD 25-18
managing resource consumer groups, SAD 25-14
changing resource consumer groups, SAD 25-15
granting the switch privilege, SAD 25-15,
SAD 25-16
revoking the switch privilege, SAD 25-16
setting initial resource consumer group, SAD 25-14
switching a session, SAD 25-15
switching sessions for a user, SAD 25-15
multiple level CPU resource allocation, SAD 25-13
pending area, SAD 25-7 to
SAD 25-10
resource allocation methods, GTK 3-49,
SAD 25-3
CPU resource, SAD 25-10
EMPHASIS, SAD 25-8,
SAD 25-10
limiting degree of parallelism, SAD 25-10
PARALLEL_DEGREE_LIMIT_ABSOLUTE, SAD 25-10
ROUND-ROBIN, SAD 25-11
resource consumer groups, GTK 3-49,
SAD 25-2
creating, SAD 25-11 to
SAD 25-12
DEFAULT_CONSUMER_GROUP, SAD 25-11,
SAD 25-12,
SAD 25-15,
SAD 25-17
deleting, SAD 25-12
LOW_GROUP, SAD 25-12,
SAD 25-20
managing, SAD 25-14 to
SAD 25-17
OTHER_GROUPS, SAD 25-7,
SAD 25-9,
SAD 25-11,
SAD 25-14,
SAD 25-20
parameters, SAD 25-11
SYS_GROUP, SAD 25-12,
SAD 25-20
updating, SAD 25-12
resource plan directives, GTK 3-49,
SAD 25-3,
SAD 25-8
CPU_Pn, SAD 25-12
deleting, SAD 25-14
PARALLEL_DEGREE_LIMIT_P1, SAD 25-8,
SAD 25-13
parameters, SAD 25-12
specifying, SAD 25-12 to
SAD 25-14
updating, SAD 25-14
resource plans, GTK 3-49,
SAD 25-3
creating, SAD 25-6 to
SAD 25-11
DELETE_PLAN_CASCADE, SAD 25-11
deleting, SAD 25-11
examples, SAD 25-6,
SAD 25-18
parameters, SAD 25-10
plan schemas, SAD 25-7,
SAD 25-11,
SAD 25-13,
SAD 25-18,
SAD 25-22
subplans, SAD 25-6,
SAD 25-7,
SAD 25-11
SYSTEM_PLAN, SAD 25-10,
SAD 25-12,
SAD 25-20
top plan, SAD 25-7,
SAD 25-8,
SAD 25-18
updating, SAD 25-10
validating plan schema changes, SAD 25-8
views, SAD 25-21
database resource manager
compatibility, MIG 9-13
database schema
generating reports, RMN 4-8
database server error, OID C-2
Database Services tab in Net8 Assistant, NET 7-14
database structures
control files, SCN 1-10,
SCN 362
data blocks, SCN 1-7,
SCN 4-2,
SCN 4-3
data dictionary, SCN 1-29,
SCN 2-1
datafiles, SBR 1-6,
SCN 1-8,
SCN 3-1,
SCN 3-16
extents, SCN 1-7,
SCN 4-2,
SCN 4-12
logical, SCN 1-5
memory, SCN 1-12,
SCN 7-1
online redo log, SBR 1-9
overview, SBR 1-6 to
SBR 1-11
physical, SBR 1-6 to
SBR 1-11
processes, SCN 1-12,
SCN 1-15,
SCN 8-1
redo log files, SBR 1-9,
SCN 1-9,
SCN 347
revealing with rowids, SCN 12-18
rollback segments, SBR 1-8
schema objects, SCN 1-6,
SCN 10-2
segments, SCN 1-7,
SCN 4-2,
SCN 4-18
tablespaces, SCN 1-5,
SCN 3-1,
SCN 3-6
database SUSPEND/RESUME, GTK 3-52
database tables
creating for DBMS_TRACE, SPR 53-3
database triggers, PLS 1-19,
SCN 81
autonomous, PLS 5-58
See also
triggers
database triggers.
See
triggers
database types
new, PC_ 17-35
database users
enrolling, SAD 1-20
database writer, SAD 4-11,
SAD 10-13
database writer process (DBWn)
tuning, DWG 18-56,
STU 18-10
database writer process (DBW
n
), SBR 1-7,
SCN 8-8
checkpoints, SCN 8-8
defined, SCN 8-8
least recently used algorithm (LRU), SCN 8-8
media failure, SCN 346
multiple DBW
n
processes, SCN 8-8
overview of, SCN 1-17
trace file, SCN 346
when active, SCN 8-8
write-ahead, SCN 8-9
writing to disk at checkpoints, SCN 8-11
database writer process (DBWR)
checkpoint, SRF 1-63
database, dedicated for directory, OID 2-30
database, defined, PSG 1-2
databases
access control
overview, SCN 1-50
password encryption, SCN 285
security domains, SCN 280
administering, SAD 1-1
administration, DDS 2-1
altering availability, SAD 3-8 to
SAD 3-9
altering physical structure
standby databases, effect on, SBY 1-27
attributes, OCI 6-19
auditing, SAD 24-1
available installation types, SAD 2-6
backing up, SCN 1-49,
SCN 364
after creation of, SAD 1-20
full backups, SAD 2-11
using Recovery Manager, RMN 1-33
backing up for migration, MIG 4-26
block size, SRF 4-4
clone database, SCN 5-8
closing, SCN 5-10
aborting the instance, SCN 5-10,
SCN 344
configuring, SCN 5-4
contain schemas, SCN 280
control files of, SAD 5-2
creating, SAD 2-1 to
SAD 2-26,
SAD 7-6
opening and, SAD 1-20
troubleshooting problems, SAD 2-16
creating duplicate, RMN 7-2
on a remote host, RMN 7-10
creating test, RMN 7-2
data structure changes
incremental export and, SUT 1-49
database limits, SRF 4-1
db identifier, RMN 3-10
default language, SRF 1-77
defined, SCN 1-5
describing, OCI 6-2
design of
implementing, SAD 1-20
dismounting, SCN 5-11
distributed, NET 2-2,
SCN 1-34
changing global database name, SCN 7-12
nodes of, SCN 1-34
overview of, SCN 1-32,
SCN 1-34
site autonomy of, DDS 1-24,
SCN 394
statement optimization on, STU 4-94
table replication, SCN 1-36
two-phase commit, SCN 1-35
downgrading, MIG 13-52
dropping, SAD 2-16
full export, SUT 1-21
full import, SUT 2-22
global database name
about, SAD 2-20
global database names
in a distributed system, SAD 2-20
hardware evaluation, SAD 1-18
incremental export, SUT 1-45
layout, DWG 5-3
limitations on usage, SCN 295
listing for backups, SBR 4-2
logical structure of, SAD 1-19
media recovery procedures, SBR 5-1 to
SBR 5-31
media recovery scenarios, SBR 6-1
migration of, SAD 2-4
modes of archiving, SCN 358
mounting, SCN 5-6
mounting a database, SAD 3-5
mounting to an instance, SAD 3-8
name, SRF 1-32,
SRF 1-33
name stored in control file, SBR 2-3,
SCN 362
names
about, SAD 2-20
conflicts in, SAD 2-20
naming, PC_ 3-8
open and closed, SCN 5-3
opening, SCN 5-8
a closed database, SAD 3-8
acquiring rollback segments, SCN 4-27
opening read-only, SCN 5-9
password encryption, SAD 21-5
physical structure, SAD 1-19,
SBR 1-6 to
SBR 1-11
physical structure of, SAD 1-19
planning, SAD 1-19
preparing for Export, SUT 1-9
privileges for exporting, SUT 1-3
production, SAD 21-10,
SAD 21-11
read-only, opening, SAD 3-9
recovery
after control file damage, SBR 6-13
after OPEN RESETLOGS option, SBR 5-36
recovery of, SCN 1-44,
SCN 342
reducing fragmentation via full export/import, SUT 2-44
registering in recovery catalog, RMN 3-9
renaming, SAD 2-20,
SAD 5-5,
SAD 5-7
repository for Oracle Names, NET 4-13
resource limits, SRF 1-104,
SRF 1-105
restricting access, SAD 3-9
reusing existing data files
Import, SUT 2-20
scalability, SCN 6-4,
SCN 158,
SCN 194
security.
See also
security.
shutting down, SAD 3-10 to
SAD 3-13,
SCN 5-10
specifying control files, SAD 2-21
staging, DWG 8-2
standby, SCN 5-7,
SCN 367
advantages, SBY 1-2
control files, SBY 4-12,
SBY 4-15
creating, procedures for, SBY 2-8,
SBY 2-12,
SBY 2-13,
SBY 2-14,
SBY 2-32
datafiles, taking offline, SBY 4-13
direct path operations, SBY 4-13
failover to, SBY 1-12,
SBY 1-14,
SBY 3-20
initialization parameters, SBY 2-19
manual recovery mode, SBY 1-8,
SBY 2-31,
SBY 3-4
read-only mode, SBY 1-10,
SBY 3-17
redo log files, altering, SBY 4-12
renaming datafiles, SBY 4-11
sustained recovery mode, SBY 1-9
transmitting archived redo logs, SBY 3-13
starting, NET 11-8
starting up, SAD 3-2 to
SAD 3-7,
SCN 5-2
forced, SCN 5-11
structure of
distributed database, SAD 1-19
structures
control files, SCN 1-10,
SCN 362
data blocks, SCN 1-7,
SCN 4-2,
SCN 4-3
data dictionary, SCN 1-29,
SCN 2-1
datafiles, SCN 1-8,
SCN 3-1,
SCN 3-16
extents, SCN 1-7,
SCN 4-2,
SCN 4-12
logical, SCN 1-5,
SCN 4-1
memory, SCN 1-12,
SCN 7-1
physical, SCN 1-8
processes, SCN 1-12,
SCN 1-15,
SCN 8-1
redo log files, SCN 1-9,
SCN 347
revealing with rowids, SCN 12-18
schema objects, SCN 1-6,
SCN 10-2
segments, SCN 1-7,
SCN 4-2,
SCN 4-18
tablespaces, SCN 1-5,
SCN 3-1,
SCN 3-6
suspending, SBR 4-9
suspending and resuming, SAD 3-13
test, SAD 21-10
test migration results, MIG 8-13
tuning
archiving large databases, SAD 7-19
responsibilities for, SAD 1-21
tuning after migration, MIG 8-14
types of, SAD 2-6
unregistering in recovery catalog, RMN 3-11
user responsibilities, SAD 1-3
valid characters for database name, SRF 1-32
viewing datafiles and redo log files, SAD 2-16
whole database backups, SBR 4-3
data-dependent routing, PSA 5-16
DATAFILE clause, STU 20-23
of ALTER DATABASE, SQL 7-8,
SQL 7-16
of CREATE CONTROLFILE, SQL 7-265
of CREATE DATABASE, SQL 7-271
DATAFILE clauses
of ALTER DATABASE, SQL 7-8
DATAFILE END BACKUP clause
of ALTER DATABASE, SQL 7-17
datafile headers
importance for recovery, SBR 1-6
DATAFILE OFFLINE clause
of ALTER DATABASE, SQL 7-17
DATAFILE OFFLINE DROP clause
ALTER DATABASE statement, SBY 4-13
DATAFILE ONLINE clause
of ALTER DATABASE, SQL 7-17
DATAFILE ONLINE option
ALTER DATABASE statement, SBR 5-30
DATAFILE option
table, PSA 8-12
tablespace, PSC A-20
DATAFILE RESIZE clause
of ALTER DATABASE, SQL 7-17
datafiles, SBR 1-6
adding to a tablespace, SAD 10-5
adding to primary database, SBY 4-10,
SBY 5-22,
SBY 5-47
backing up, SBR 1-15,
SCN 366
offline, SBR 4-12
using Recovery Manager, RMN 1-33,
RMN 5-5,
RMN 5-6
backup, SCN 366
backups needed, listing, RMN 4-10,
RMN 4-11,
RMN 4-13,
RMN 5-16
backups, listing, RMN 4-2
bringing online, SQL 7-17
bringing online and offline, SAD 10-7
cataloging, RMN 3-9
checking associated tablespaces, SAD 9-41
checking backup status, SBR 4-8
compatibility, MIG 9-23
contents of, SCN 3-17
copies, listing, RMN 4-2
creating, SAD 10-5,
SBY 5-22
creating new, SQL 7-16
data dictionary, SCN 3-6,
SCN 366
database administrators access, SAD 1-4
datafile 1, SCN 3-6
backup, SCN 366
SYSTEM tablespace, SCN 3-6
default directory, SAD 10-5
deleting, SBY 5-25
designing media recovery, SQL 7-12
disabling automatic extension, SQL 7-17
dropping, SAD 9-22
NOARCHIVELOG mode, SAD 10-8
enabling automatic extension, SQL 7-17,
SQL 7-421
fully specifying filenames, SAD 10-5
guidelines for managing, SAD 10-2 to
SAD 10-4
identifying filenames, SAD 10-10
in online or offline tablespaces, SCN 3-17
listing
for backup, SBR 4-2
unrecoverable, RMN 4-5
location, SAD 10-4
losing, SBR 6-2
in ARCHIVELOG mode, SBR 6-3
in NOARCHIVELOG mode, SBR 6-2
mapping blocks to PCM locks, SRF 1-40
maximum number, SRF 1-31
minimum number of, SAD 10-2
MISSING, SAD 5-8
modifying, SQL 7-16
monitoring, SAD 10-13
named in control files, SBR 2-3,
SCN 362
offline during migration, MIG 4-4
online, SAD 10-8
overview, SBR 1-6
overview of, SCN 1-5,
SCN 1-8,
SCN 3-16
parallel recovery, SCN 351
parameter, SRF 1-29,
SRF 1-31
placement on disk, STU 20-19
preventing overwrite during import, SUT 2-20
privileges to rename, SAD 10-9
privileges to take offline, SAD 10-8
read-only, SCN 3-11
recovery, SCN 346
read-only tablespaces and, SCN 3-12
recovering, SQL 7-14
recovery
guidelines, RMN 1-61,
RMN 6-18
using RMAN, RMN 6-18
without backup, SBR 5-5
re-creating, SBR 5-5
re-creating lost, SQL 7-16
relationship to tablespaces, SCN 3-2
relocating, SAD 10-9,
SAD 10-11
relocating, example, SAD 10-10
renaming, SAD 10-9,
SAD 10-11,
SBY 5-24,
SQL 7-15
after recovery, SBR 6-4
effect on standby database, SBY 4-11
renaming for single tables, SAD 10-9
resizing, SQL 7-17
restoring, RMN 1-59,
RMN 6-2,
RMN 6-10
to default location, SBR 5-5
reusing, SAD 10-5,
SQL 7-517
reusing during import, SUT 2-20
shown in ROWIDs, ADG 3-22
shown in rowids, SCN 12-17,
SCN 12-18
size of, SAD 10-4,
SQL 7-517
specifying, SQL 7-516,
SUT 6-4
for a tablespace, SQL 7-421
specifying buffering for SQL*Loader, SUT 5-24
specifying for SQL*Loader, SUT 5-22
specifying format for SQL*Loader, SUT 5-24
storing separately from redo log files, SAD 10-4
SYSTEM tablespace, SCN 3-6
taking offline, SCN 3-17,
SQL 7-17
temporary, SCN 3-18
unavailable when database is opened, SAD 3-4
unrecoverable, SCN 358
unspecified for PCM locks, SRF 1-40
usage, SBR 1-7
verifying data blocks, SAD 10-12
viewing
backup status, SBR 4-8
files needing recovery, SBR 5-2
general status of, SAD 10-13
V$DBFILE and V$LOGFILE views, SAD 2-16
datatype
internal versus external, PCO 2-8
datatype conversion
between internal and external types, PCO 4-40
datatype equivalencing, PC_ 2-7
advantages, PCO 4-42
example, PCO 4-46
guidelines, PCO 4-48
datatypes, ADG 3-2,
PLS 2-11,
SCN 12-2,
SCN 12-3,
SQL 2-9
allowed in replicated tables, REP 7-2
allowed in snapshots, REP 3-22
ANSI, SCN 12-23
ANSI/ISO, ADG 3-24
ANSI-supported, SQL 2-12
array types, ADO 1-8,
SCN 13-11
associating statistics with, SQL 7-212
BFILE, OCI 3-20,
PLS 2-22,
SQL 2-14,
SQL 2-25
Export, SUT 1-58
BINARY_INTEGER, PLS 2-12
binding and defining, OCI 12-6
BLOB, OCI 3-20,
PLS 2-23,
SQL 2-14,
SQL 2-25
BOOLEAN, PLS 2-23,
SCN 12-2
built-in, SQL 2-13
syntax, SQL 2-11
BYTEINT, SUT 5-60
CHAR, ADG 3-2,
ADG 3-5,
PLS 2-15,
SCN 12-5,
SQL 2-13,
SQL 2-15,
SUT 5-64
character, SCN 12-5,
SCN 12-14,
SQL 2-14
choosing a character datatype, ADG 3-5
CLOB, OCI 3-21,
PLS 2-23,
SQL 2-14,
SQL 2-25
COBOL, PCO 4-13
codes used in descriptors, PC_ 15-15
coercing NUMBER to VARCHAR2, PC_ 15-15,
PCO 11-19
collection, DCI 1-8
collections, SCN 13-11
column lengths for character types, ADG 3-6
comparison rules, SQL 2-32
compatibility, MIG 9-26
conflicting character datatype fields, SUT 5-73
constrained, PLS 7-4
conversion
table of, SQL 2-37
conversions, OCI 3-21,
PC_ 5-11,
PC_ 5-12,
PCO 4-39
conversions of
by program interface, SCN 8-27
non-Oracle types, SCN 12-23
Oracle to another Oracle type, SCN 12-24
converting SQL*Loader, SUT 3-8,
SUT 5-69
converting to LOBs FAQ, ADL 6-3
data conversion, ADG 3-25
DATE, ADG 3-8,
ADG 3-10,
PLS 2-24,
SCN 12-10,
SQL 2-13,
SQL 2-21,
SUT 5-65
DB2, ADG 3-24,
SCN 12-23
DBMS_DESCRIBE, SPR 12-5
dealing with ORACLE internal, PC_ 15-15
dealing with Oracle internal, PCO 11-19
DECIMAL, SUT 5-61
default in SQL*Loader, SUT 5-48
DESC_TAB, SPR 51-30
descriptor codes, PCO 11-19
determining character field lengths for SQL*Loader, SUT 5-73
determining DATE length, SUT 5-74
direct path loading, OCI 9-41,
OCI A-48
DOUBLE, SUT 5-60
equivalencing, PC_ 5-12
description, PCO 4-42
example, PCO 4-45
equivalencing, purpose of, PC_ 2-7
extensibility, DCI 1-7
external, OCI 3-4,
OCI 3-7,
SQL 2-10
families, PLS 2-11
FILE, OCI 3-20
FLOAT, SUT 5-59
for piecewise operations, OCI 5-38
GRAPHIC, SUT 5-66
GRAPHIC EXTERNAL, SUT 5-66
how they relate to tables, SCN 10-3
implicit conversion, PLS 2-28
in PL/SQL, SCN 12-2
INTEGER, SUT 5-59
internal, OCI 3-3,
OCI 3-5,
PC_ 4-2,
PCO 11-16
new in Oracle8
i
, MIG E-2
internal codes, OCI 3-5
internal versus external, PC_ 2-6
list of available, SCN 12-2
list of internal, PC_ 15-13
LOB datatypes, SCN 12-12
BFILE, SCN 12-14
BLOB, SCN 12-13
CLOB and NCLOB, SCN 12-14
default logging mode, SCN 152
LONG, ADG 3-18,
PLS 2-16,
SCN 12-7,
SQL 2-13,
SQL 2-19
Export, SUT 1-57
Import, SUT 2-59
storage of, SCN 10-8
LONG RAW, ADG 3-18,
ADG 3-20,
PLS 2-16,
SQL 2-13,
SQL 2-22
manipulating with OCI, OCI 11-5
mapping, DDS 6-4
ODBC, DDS D-2
ODBC to Oracle, DDS D-2
OLE DB, DDS D-3
OLE DB to Oracle, DDS D-3
mapping and manipulation functions
server roundtrips, OCI C-6
mapping from Oracle to C, OCI 11-2
mapping, Oracle methodology, OCI 11-4
mapping, OTT, OCI 14-9
multimedia, SCN 13-3
national character, PLS 2-20
native
conflicting length specifications in SQL*Loader, SUT 5-68
SQL*Loader, SUT 5-59
NCHAR, ADG 3-2,
ADG 3-5,
PLS 2-20,
SQL 2-14,
SQL 2-15
NCHAR and NVARCHAR2, SCN 12-7
NCLOB, OCI 3-21,
SPR 18-3,
PLS 2-23,
SQL 2-14,
SQL 2-26
need to coerce, PC_ 15-15,
PCO 11-19
nested tables, ADO 1-9,
SCN 10-10,
SCN 13-12
nonscalar, SUT 5-93
NUMBER, ADG 3-7,
PLS 2-13,
SCN 12-8,
SQL 2-17
SQL*Loader, SUT 5-70
NUMER, SQL 2-13
numeric EXTERNAL, SUT 5-67
NVARCHAR2, ADG 3-2,
ADG 3-5,
PLS 2-21,
SQL 2-13,
SQL 2-16
object type, DCI 1-8
object types, ADO 1-2,
SCN 1-21,
SCN 13-4
of columns, SCN 1-22
Oracle, OCI 3-2,
PC_ 2-6
OTT mappings, PC_ 19-10
PLS_INTEGER, PLS 2-14
PL/SQL
numeric codes for, SPR 12-9
PL/SQL equivalents, PCO 11-18
RAW, ADG 3-20,
PLS 2-16,
SQL 2-13,
SQL 2-22,
SUT 5-67
RAW and LONG RAW, SCN 12-15
RECORD, PLS 4-42
REF (relationship), DCI 1-8
REF CURSOR, PLS 5-16
restrictions on using, PC_ 17-38
ROWID, ADG 3-21,
SPR 45-1,
PLS 2-17,
SCN 12-15,
SCN 12-16,
SQL 2-13,
SQL 2-26
scalar versus composite, PLS 2-11
SMALLINT, SUT 5-59
specifying the SQL*Loader datatype of a data field, SUT 5-48
SQL/DS, ADG 3-24,
SCN 12-23
summary, SCN 12-3
summary of datatypes, ADG 3-2
support for, REP A-7
TABLE, PLS 4-2
UROWID, PLS 2-17,
SQL 2-13,
SQL 2-27
user-defined, SCN 13-1,
SCN 13-3
statistics, SCN 141,
STU 4-33
user-defined type equivalencing, PC_ F-110
VARCHAR, ADG 3-5,
SCN 12-6,
SQL 2-17,
SUT 5-62
VARCHAR2, ADG 3-2,
ADG 3-5,
PLS 2-19,
SCN 12-6,
SQL 2-13,
SQL 2-16
SQL*Loader, SUT 5-70
VARGRAPHIC, SUT 5-61
VARRAY, PLS 4-4
when to reset, PC_ 15-15,
PCO 11-19
ZONED, SUT 5-60
Datatypes, Specifying, DCI 4-7
DATE
external datatype, OCI 3-14
date arithmetic, ADG 3-27
date constraints
checking for bad, MIG 8-4
DATE datatype, ADG 3-8,
PC_ 4-8,
PLS 2-24,
SCN 12-10,
SQL 2-21
arithmetic with, SCN 12-11
centuries, ADG 3-10
changing default format of, SCN 12-10
converting, PCO 4-41
converting from character or numeric value, SQL 2-21
data conversion, ADG 3-25
default format, PCO 4-41
delimited form and SQL*Loader, SUT 5-70
determining length, SUT 5-74
Julian dates, SCN 12-11
mask
SQL*Loader, SUT 5-74
midnight, SCN 12-11
partition pruning, SCN 11-21
partitioning, SCN 11-12,
SCN 11-21
SQL*Loader, SUT 5-65
DATE datatypes
external, PCO 4-6
internal format, PCO 4-6
date folding
with query rewrite, DWG 19-24
date format elements, SQL 2-45
and NLS, SQL 2-48
capitalization, SQL 2-45
ISO standard, SQL 2-49
RR, SQL 2-49
suffixes, SQL 2-50
date format models, SQL 2-45
punctuation in, SQL 2-45
text in, SQL 2-45
date format strings, GTK 7-2
date formats, NLS 2-14,
NLS 4-10
and partition bound expressions, NLS 2-15
Heterogeneous Services, DDS A-7
date functions, SQL 4-5
date mask, SUT 5-16
date parameters, NLS 2-13
DATE String Format
explicit control over, PCO 4-41
DATE_FORMAT precompiler option, PCO 14-16
DATE_OF_INSERT column
TKPROF_TABLE table, STU 6-18
dates
arithmetic using, SQL 2-21
comparison rules, SQL 2-32
converting, PLS 2-29
ISO standard, NLS 2-18,
NLS 4-11
Julian, SQL 2-22
language used for, SRF 1-76
NLS_DATE_LANGUAGE parameter, NLS 2-16
setting SYSDATE, SRF 1-39
specifying in RMAN commands, RMN 2-3
TO_CHAR and TO_DATE functions, SRF 1-75
TO_CHAR default format, PLS 2-29
DAY date format element, SQL 2-48
days
format element, NLS 2-17
language of names, NLS 2-17
db block gets statistic, STU 19-28,
STU 21-4,
STU 21-21
db identifier, RMN 3-10
obtaining, RMN 6-35
problems registering copied database, RMN 3-10
DB_BLOCK_BUFFERS, OID 13-8
DB_BLOCK_BUFFERS initialization parameter, SRF 1-24
setting before database creation, SAD 2-22
DB_BLOCK_BUFFERS parameter, PSC 5-32,
STU 19-31,
STU 19-36,
STU 20-45
buffer cache and, SCN 7-5
ensuring LM lock capacity, PSA 10-3
GC_RELEASABLE_LOCKS, PSA 9-8
system global area size and, SCN 7-13
DB_BLOCK_CHECKING initialization parameter, SAD 20-4,
SAD 20-5,
SRF 1-25
DB_BLOCK_CHECKING parameter
of ALTER SESSION, SQL 7-87
of ALTER SYSTEM, SQL 7-109
DB_BLOCK_CHECKPOINT_BATCH initialization parameter: obsolete
DB_BLOCK_CHECKSUM initialization parameter, SAD 10-12,
SRF 1-26
DB_BLOCK_CHECKSUM parameter
of ALTER SYSTEM, SQL 7-109
DB_BLOCK_LRU_EXTENDED_STATISTICS initialization parameter: obsolete
DB_BLOCK_LRU_LATCHES parameter, STU 19-36,
STU 19-40
DB_BLOCK_LRU_STATISTICS initialization parameter: obsolete
DB_BLOCK_MAX_DIRTY_TARGET initialization parameter, SRF 1-27
DB_BLOCK_MAX_DIRTY_TARGET parameter
of ALTER SYSTEM, SQL 7-109
DB_BLOCK_SIZE initialization parameter, SRF 1-28
database buffer cache size and, SAD 2-22
migration, MIG 4-6,
MIG 5-5
setting before creation, SAD 2-22
DB_BLOCK_SIZE parameter, DWG 18-25,
PSA 1-8
and parallel query, DWG 18-25
buffer cache and, SCN 7-5
same for all instances, PSA 1-8
system global area size and, SCN 7-13
tuning backups, STU 20-63
DB_DOMAIN attribute, USERENV, ADG 11-44
DB_DOMAIN initialization parameter, MIG F-15,
SRF 1-28
compatibility, MIG B-9
setting before database creation, SAD 2-20
DB_DOMAIN parameter, PSA 1-8,
PSG 4-8
DB_FILE_DIRECT_IO_COUNT
parameter, STU 20-63
DB_FILE_DIRECT_IO_COUNT initialization parameter, SRF 1-29
DB_FILE_DIRECT_IO_COUNT parameter
of ALTER SYSTEM, SQL 7-110
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, SRF 1-30
DB_FILE_MULTIBLOCK_READ_COUNT parameter, DWG 18-26,
STU 4-26,
STU 4-29,
STU 20-38
cost-based optimization, STU 4-59
of ALTER SESSION, SQL 7-87
of ALTER SYSTEM, SQL 7-110
DB_FILE_NAME_CONVERT initialization parameter, RMN 1-65,
RMN 8-8,
SBY 2-20,
SBY 2-21,
SBY 5-2,
SBY 5-9,
SRF 1-31
for primary and standby databases, SBY 2-19
using with RMAN duplicate command, RMN 7-7
DB_FILE_SIMULTANEOUS_WRITES initialization parameter: obsolete
DB_FILES initialization parameter, SBY 5-9,
SRF 1-31
DB_FILES parameter, PSA 1-8,
SCN 7-17
ensuring LM lock capacity, PSA 10-3
same for all instances, PSA 1-8
DB_NAME initialization parameter, MIG F-15,
RMN 8-8,
SBY 5-9,
SRF 1-32
setting before database creation, SAD 2-20
DB_NAME parameter, PSA 1-8,
PSA 1-9,
PSG 1-15,
PSG 4-4,
PSG 4-7,
SCN 363
same for all instances, PSA 1-8
db_name
.conf file
creating, PSG B-2
environ parameter, PSG B-5
inst_init_ora parameter, PSG B-5,
PSG B-7
inst_oracle_sid parameter, PSG B-4,
PSG B-6
inst_sid_list parameter, PSG C-4
instance parameters, PSG B-6
listener configuration, PSG B-8
lsnr_listener_name parameter, PSG B-5,
PSG B-9,
PSG C-4
node#
inst_init_ora parameter, PSG B-5
node#
tns_admin parameter, PSG B-5
node_list parameter, PSG B-4,
PSG C-3
oracle_home parameter, PSG B-5
overview, PSG B-2,
PSG B-10
parameter expansion, PSG B-3
parameter syntax, PSG B-3
parameters, PSG B-4
parameters node overrides, PSG B-6
sample, PSG B-10
service discovery, PSG C-3
tns_admin parameter, PSG B-5,
PSG B-8
DB_VERIFY utility, SAD 20-4,
SAD 20-5
DB_WRITER_PROCESSES initialization parameter, SRF 1-33,
STU 20-43,
STU 20-44
DB_WRITER_PROCESSES parameter, SCN 1-17
DB2 compatibility features, PCO A-4
DB2 datatypes, SQL 2-28
conversion to Oracle datatypes, SQL 2-29
restrictions on, SQL 2-30
DB2 load utility, SUT B-1
placement of statements
DISCARDDDN, SUT B-3
DISCARDS, SUT B-3
restricted capabilities of SQL*Loader, SUT B-3
RESUME keyword, SUT 5-32
SQL*Loader compatibility
ignored statements, SUT B-2
DBA Management Pack, GTK 2-3
DBA role, SAD 1-6,
SAD 23-5,
SCN 324,
SQL 7-530
EXP_FULL_DATABASE role, SUT 1-9
user-defined types, ADO 2-11
DBA.
See
database administrators.
DBA Studio
defined, PSG 2-3
limitations, PSG 6-34
DBA_ views, SCN 2-6
DBA_2PC_NEIGHBORS view, DDS 5-9,
SRF 2-95
using to trace session tree, DDS 5-9
DBA_2PC_PENDING view, DDS 5-7,
DDS 5-15,
DDS 5-25,
SQL 7-84,
SRF 2-95
using to list in-doubt transactions, DDS 5-7
DBA_ALL_TABLES view, SRF 2-3,
SRF 2-96
DBA_ANALYZE_OBJECTS view, SRF 2-96
DBA_ASSOCIATIONS view, SRF 2-7,
SRF 2-96
DBA_AUDIT_EXISTS view, SRF 2-96
DBA_AUDIT_OBJECT view, SRF 2-97
DBA_AUDIT_SESSION view, SRF 2-99
DBA_AUDIT_STATEMENT view, SRF 2-99
DBA_AUDIT_TRAIL view, SRF 2-101
DBA_BLOCKERS view, SRF 2-103
DBA_CATALOG view, SRF 2-103
DBA_CLU_COLUMNS view, SRF 2-103
DBA_CLUSTER_HASH_EXPRESSIONS view, SRF 2-103
DBA_CLUSTERS view, SRF 2-103
DBA_COL_COMMENTS view, SQL 7-228,
SRF 2-104
DBA_COL_PRIVS view, SRF 2-104
DBA_COLL_TYPES view, SRF 2-104
DBA_CONS_COLUMNS view, SRF 2-104
DBA_CONSTRAINTS view, SRF 2-104
DBA_CONTEXT view, SRF 2-104
DBA_DATA_FILES view, DWG 18-71,
SAD 9-40,
SBR 4-6,
SBR 4-7,
SBR 4-12,
SRF 1-40,
SRF 2-104,
SRF 2-146
DBA_DB_LINKS view, DDS 2-21,
DDS 5-7,
DDS 5-9,
SRF 2-105
DBA_DDL_LOCKS view, SRF 2-105
DBA_DEPENDENCIES view, SRF 2-106
DBA_DIM_ATTRIBUTES view, SRF 2-106
DBA_DIM_CHILD_OF view, SRF 2-106
DBA_DIM_HIERARCHIES view, SRF 2-106
DBA_DIM_JOIN_KEY view, SRF 2-106
DBA_DIM_LEVEL_KEY view, SRF 2-107
DBA_DIM_LEVELS view, SRF 2-107
DBA_DIMENSIONS view, SRF 2-106
DBA_DIRECTORIES view, SRF 2-107
DBA_DML_LOCKS view, SRF 2-107
DBA_ERRORS view, SRF 2-108
debugging stored procedures, ADG 9-43
DBA_EXP_FILES view, SRF 2-108
DBA_EXP_OBJECTS view, SRF 2-108
DBA_EXP_VERSION view, SRF 2-109
DBA_EXTENTS view, DWG 18-71,
SRF 2-109
DBA_FREE_SPACE view, SRF 2-110
DBA_FREE_SPACE_COALESCED view, SRF 2-110
DBA_IND_COLUMNS view, SRF 2-111
DBA_IND_EXPRESSIONS view, SRF 2-111
DBA_IND_PARTITIONS view, SRF 2-111
DBA_IND_SUBPARTITIONS view, SRF 2-25,
SRF 2-111
DBA_INDEXES view, SRF 2-111,
STU 12-17
collecting statistics for, SRF 2-111
filling with data, SAD 19-7
DBA_INDEXTYPE_OPERATORS view, SRF 2-112
DBA_INDEXTYPES view, SRF 2-112
DBA_INTERNAL_TRIGGERS view, SRF 2-112
DBA_JOBS view, SRF 2-112
jobs in system, viewing, SAD 8-14
DBA_JOBS_RUNNING
running jobs, viewing, SAD 8-14
DBA_JOBS_RUNNING view, SRF 2-112
DBA_KGLLOCK view, SRF 2-113
DBA_LIBRARIES view, SRF 2-113
DBA_LOB_PARTITIONS view, SRF 2-113
DBA_LOB_SUBPARTITIONS view, SRF 2-113
DBA_LOBS view, SRF 2-113
DBA_LOCK_INTERNAL view, SRF 2-114
DBA_LOCKS view, SRF 2-114
DBA_METHOD_PARAMS view, SRF 2-114
DBA_METHOD_RESULTS view, SRF 2-115
DBA_MVIEW_AGGREGATES view, SRF 2-115
DBA_MVIEW_ANALYSIS view, SRF 2-115
DBA_MVIEW_DETAIL_RELATIONS view, SRF 2-115
DBA_MVIEW_JOINS view, SRF 2-115
DBA_MVIEW_KEYS view, SRF 2-116
DBA_MVIEWS view, SRF 2-43,
SRF 2-116
DBA_NESTED_TABLES view, SRF 2-116
DBA_OBJ_AUDIT_OPTS view, SRF 2-117
DBA_OBJECT_SIZE view, SRF 2-116
DBA_OBJECT_TABLES view, SRF 2-117