Index

A B C D E F G H I J K L M N O P Q R S T U V W X Z

Symbols

?, 2.3.11

@, 2.3.11

A

abort response, 34.3.1.1.3

two-phase commit, 34.3.1.1.3

accounts

DBA operating system account, 1.5.1

ADD LOGFILE clause

ALTER DATABASE statement, 11.3.1

ADD LOGFILE MEMBER clause

ALTER DATABASE statement, 11.3.2

adding

columns, 20.6.6

columns in compressed tables, 20.6.6.1

ADMIN_TABLES procedure

creating admin table, 25.3.1.1

DBMS_REPAIR package, 25.2.1

example, 25.4.1.1, 25.4.1.2

ADMINISTER_RESOURCE_MANAGER system privilege, 27.1.3

administering

the Scheduler, 30

administration

distributed databases, 32

administrative user accounts

SYS, 1.5.2, 1.5.2

SYSBACKUP, 1.5.2

SYSDG, 1.5.2

SYSKM, 1.5.2

administrator passwords, synchronizing password file and data dictionary, 1.7.2.2

ADR

See automatic diagnostic repository

ADR base, 9.1.4

ADR home, 9.1.4

ADRCI utility, 9.1.3.8

advanced index compression, 21.3.7.2

advanced row compression, 20.2.6

Advisor

Data Repair, 9.1.1

Undo, 16.4

AFTER SUSPEND system event, 19.2.4.1

AFTER SUSPEND trigger, 19.2.4.1

example of registering, 19.2.6

agent

Heterogeneous Services, definition of, 31.1.2

aggregate functions

statement transparency in distributed databases, 32.7

alert log, 9.1.3.2

about, 8.1.1

size of, 8.1.1.1

using, 8.1.1

viewing, 9.5

when written, 8.1.1.3

alert thresholds

setting for locally managed tablespaces, 19.1.1

alerts

server-generated, 8.1.2

tablespace space usage, 19.1.1

threshold-based, 8.1.2

viewing, 19.1.2

ALL_DB_LINKS view, 32.5.1, 32.5.1

allocation

extents, 20.6.4

ALTER CLUSTER statement

ALLOCATE EXTENT clause, 22.4

using for hash clusters, 23.4

using for index clusters, 22.4

ALTER DATABASE ADD LOGFILE statement

using Oracle Managed Files, 17.3.6.1

ALTER DATABASE statement

ADD LOGFILE clause, 11.3.1

ADD LOGFILE MEMBER clause, 11.3.2

ARCHIVELOG clause, 12.3.2

CDBs, 40.4, 40.4

CLEAR LOGFILE clause, 11.8

CLEAR UNARCHIVED LOGFILE clause, 11.2.1.1

data files online or offline, 14.4.3

database partially available to users, 3.2.1

DATAFILE...OFFLINE DROP clause, 14.4.2

DROP LOGFILE clause, 11.5.1

DROP LOGFILE MEMBER clause, 11.5.2

MOUNT clause, 3.2.1

NOARCHIVELOG clause, 12.3.2

OPEN clause, 3.2.2

READ ONLY clause, 3.2.3

RENAME FILE clause, 14.5.2.2

temp files online or offline, 14.4.3

UNRECOVERABLE DATAFILE clause, 11.8

ALTER INDEX statement

COALESCE clause, 21.2.13

MONITORING USAGE clause, 21.4.6

ALTER PLUGGABLE DATABASE statement, 40.4, 42.3.1.2

UNPLUG INTO clause, 38.7

ALTER SEQUENCE statement, 24.2.3

ALTER SESSION statement

ADVISE clause, 35.4.3.3

CLOSE DATABASE LINK clause, 33.2

Enabling resumable space allocation, 19.2.2.2

SET CONTAINER clause, 40.2.2

SET SQL_TRACE initialization parameter, 8.1.1.3

setting time zone, 2.4.9.1

ALTER SYSTEM statement

ARCHIVE LOG ALL clause, 12.3.3

CDBs, 40.5

CONTAINER clause, 40.5

DISABLE DISTRIBUTED RECOVERY clause, 35.9.2

ENABLE DISTRIBUTED RECOVERY clause, 35.9.2

ENABLE RESTRICTED SESSION clause, 3.2.4

enabling Database Resource Manager, 27.6

PDBs, 42.4

QUIESCE RESTRICTED, 3.4.1

RESUME clause, 3.5

SCOPE clause for SET, 2.6.5.1

SET RESOURCE_MANAGER_PLAN, 27.6

SET SHARED_SERVERS initialization parameter, 5.3.3.2

setting initialization parameters, 2.6.5

SUSPEND clause, 3.5

SWITCH LOGFILE clause, 11.6

UNQUIESCE, 3.4.2

ALTER TABLE statement

ADD (column) clause, 20.6.6

ALLOCATE EXTENT clause, 20.6.4

DEALLOCATE UNUSED clause, 20.6.4

DISABLE ALL TRIGGERS clause, 18.4.2

DISABLE integrity constraint clause, 18.5.3.1

DROP COLUMN clause, 20.6.8.1

DROP integrity constraint clause, 18.5.3.3

DROP UNUSED COLUMNS clause, 20.6.8.2

ENABLE ALL TRIGGERS clause, 18.4.1

ENABLE integrity constraint clause, 18.5.3.1, 18.5.3.1

external tables, 20.13.3

MODIFY (column) clause, 20.6.5

modifying index-organized table attributes, 20.12.3.1

MOVE clause, 20.6.3, 20.6.3, 20.6.3.1, 20.6.3.2, 20.6.3.2, 20.12.3.2

reasons for use, 20.6.1

RENAME COLUMN clause, 20.6.7

SET UNUSED clause, 20.6.8.2

ALTER TABLESPACE statement

adding an Oracle managed data file, example, 17.3.3.3

adding an Oracle managed temp file, example, 17.3.4.2

ONLINE clause, example, 13.6.2

READ ONLY clause, 13.7.1

READ WRITE clause, 13.7.2

RENAME DATAFILE clause, 14.5.2.1.1

RENAME TO clause, 13.9

taking data files/temp files online/offline, 14.4.3

ALTER TRIGGER statement

DISABLE clause, 18.4.2

ENABLE clause, 18.4.1

altering

(Scheduler) windows, 29.7.3.3

event schedule, 29.5.2.4

event-based job, 29.5.2.2

indexes, 21.4

job classes, 29.7.1.3

jobs, 29.2.3

programs, 29.3.3

schedules, 29.4.3

ANALYZE statement

CASCADE clause, 18.2.2

CASCADE clause, FAST option, 18.2.2

corruption reporting, 25.3.1.3

listing chained rows, 18.2.3

remote tables, 33.4.2.2.2

validating structure, 18.2.2, 25.3.1

analyzing schema objects, 18.2

analyzing tables

distributed processing, 33.4.2.2.2

APPEND hint, 20.2.6.1

Application Continuity, 2.8.4

application development

distributed databases, 31.5, 33, 33.5

application development for distributed databases, 33

analyzing execution plan, 33.4.4

database links, controlling connections, 33.2

handling errors, 33.3, 33.5

handling remote procedure errors, 33.5

managing distribution of data, 33.1

managing referential integrity constraints, 33.3

terminating remote connections, 33.2

tuning distributed queries, 33.4

tuning using collocated inline views, 33.4.1

using cost-based optimization, 33.4.2

using hints to tune queries, 33.4.3

ARCHIVE_LAG_TARGET initialization parameter, 11.2.6.1

archived redo log files

alternate destinations, 12.4.3

archiving modes, 12.3.2

data dictionary views, 12.8.1

destination availability state, controlling, 12.4.2

destination status, 12.4.2

destinations, specifying, 12.4

failed destinations and, 12.6

mandatory destinations, 12.6.1.1

minimum number of destinations, 12.6.1

multiplexing, 12.4.1

normal transmission of, 12.5

re-archiving to failed destination, 12.6.2

sample destination scenarios, 12.6.1.2

standby transmission of, 12.5

status information, 12.8.1

transmitting, 12.5

ARCHIVELOG mode, 12.2.2

advantages, 12.2.2

archiving, 12.2

automatic archiving in, 12.2.2

definition of, 12.2.2

distributed databases, 12.2.2

enabling, 12.3.2

manual archiving in, 12.2.2

running in, 12.2.2

switching to, 12.3.2

taking data files offline and online in, 14.4.1

archiver process (ARCn), 5.5

trace output (controlling), 12.7

archiving

alternate destinations, 12.4.3

changing archiving mode, 12.3.2

controlling number of processes, 12.3.4

destination availability state, controlling, 12.4.2

destination failure, 12.6

destination status, 12.4.2

manual, 12.3.3, 12.3.3

NOARCHIVELOG vs. ARCHIVELOG mode, 12.2

setting initial mode, 12.3.1

to failed destinations, 12.6.2

trace output, controlling, 12.7

viewing information on, 12.8.1

at-sign, 2.3.11

attribute-clustered tables, 20.2.9

auditing

database links, 31.3.3

authentication

database links, 31.3.2.1

operating system, 1.6.3.2

selecting a method, 1.6.2

using password file, 1.6.4.1

AUTO_TASK_CONSUMER_GROUP

of Resource Manager, 26.5

AUTOEXTEND clause, 14.3.1

for bigfile tablespaces, 13.8.3

automatic big table cache, 6.2

automatic diagnostic repository, 9.1.1, 9.1.3.1

in Oracle Client, 9.1.4

in Oracle Clusterware, 9.1.4

in Oracle Real Application Clusters, 9.1.4

structure, contents and location of, 9.1.4

automatic file extension, 14.3.1

automatic maintenance tasks

assigning to maintenance windows, 26.3.2

definition, 26.1

enabling and disabling, 26.3.1

predefined, 26.1

resource allocation, 26.5.1

Scheduler job names, 26.2

automatic segment space management, 13.2.1.2

automatic undo management, 2.4.4, 16.2, 16.2

migrating to, 16.6

B

background processes, 5.5

FMON, 14.9.2.1.1

BACKGROUND_DUMP_DEST initialization parameter, 9.1.3.1

backups

after creating new databases, 2.3.13

effects of archiving on, 12.2.1

batch jobs, authenticating users in, 2.8.3

big table cache, 6.2, 6.2

bigfile tablespaces

creating, 13.2.2.1

creating temporary, 13.2.5.2

description, 13.2.2

setting database default, 2.4.8.1

BLANK_TRIMMING initialization parameter, 20.6.5

BLOB data type, 20.3.1

block size, redo log files, 11.2.4

BLOCKSIZE clause

of CREATE TABLESPACE, 13.4

C

CACHE option

CREATE SEQUENCE statement, 24.2.4.2.2

caches

sequence numbers, 24.2.4.2

calendaring expressions, 29.4.5.1

calls

remote procedure, 31.5.2

capacity planning

space management

capacity planning, 19.7

CASCADE clause

when dropping unique or primary keys, 18.5.3.1

CATBLOCK.SQL script, 8.2.1

catcon.pl, 40.7

CDB resource plans, 44.1.2

CDB_PDB_HISTORY view, 43.11

CDB_PDBS view, 43.5

CDBs, 35.10, 36.1

administering, 40, 41

ALTER DATABASE statement, 40.4

ALTER PLUGGABLE DATABASE statement, 40.4

ALTER SYSTEM statement, 40.5

CDB resource plans

viewing information about, 44.8

common users

definition, 36.1.2

compatibility violations, 40.4.5.1

connecting to, 40.2

ALTER SESSION statement, 40.2.2

CONNECT command, 40.2.1

container data objects, 43.1.1

querying, 43.7

containers, 36.1.1, 43.4

CONTAINERS clause, 43.8

creating, 37

current container, 40.1.1, 43.9

data definition language (DDL), 40.6

Database Resource Manager, 44

DBMS_SQL package, 40.3

EM Express, 37.5

ENABLE PLUGGABLE DATABASE clause, 37.4.1.1

executing PL/SQL code, 40.3

initialization parameters, 43.10

local users

definition, 36.1.2

modifying, 40.4, 40.4.3, 40.5

monitoring, 43

Oracle Database Vault, 40.1.2

Oracle Managed Files, 37.4.1.2.2

PDB_FILE_NAME_CONVERT initialization parameter, 37.4.1.2.3

PDBs

modifying, 40.4

planning creation, 37.2

plugging in PDBs

CREATE PLUGGABLE DATABASE statement, 38.1.2

methods for, 38.1.1

preparing for, 38.2

prerequisites for, 36.3

purpose of, 36.2

root container

definition, 36.1.1

modifying, 40.4.4

SEED FILE_NAME_CONVERT clause, 37.4.1.2.1

seed PDB, 36.1.1

shutting down, 40.8

SQL scripts, 40.7

standby database, 40.1.2

tools for, 36.4.2

Transparent Data Encryption, 40.1.2

unplugging PDBs, 38.7

viewing information about, 43

views, 43.2

centralized user management

distributed systems, 31.3.2.4

chain condition syntax, 29.6.4

chain rules, 29.6.4

chain steps

defining, 29.6.3

chained rows

eliminating from table, procedure, 18.2.3.2

CHAINED_ROWS table

used by ANALYZE statement, 18.2.3.1

chains

creating, 29.6.2

creating and managing job, 29.6

creating jobs for, 29.6.6

disabling, 29.6.10

dropping, 29.6.7

dropping rules from, 29.6.9

enabling, 29.6.5

handling stalled, 29.6.18

monitoring running, 29.6.17

overview, 28.2.7

pausing, 29.6.14

running, 29.6.8

setting privileges, 30.1.1

steps

pausing, 29.6.14

skipping, 29.6.15

stopping, 29.6.12

stopping individual steps, 29.6.13

change vectors, 11.1.2

CHAR data type

increasing column length, 20.6.5

character set

choosing, 2.1.1.1

CHECK_OBJECT procedure

DBMS_REPAIR package, 25.2.1

example, 25.4.2

finding extent of corruption, 25.3.2

checkpoint process (CKPT), 5.5

checksums

for data blocks, 14.7

redo log blocks, 11.7, 11.7

CLEAR LOGFILE clause

ALTER DATABASE statement, 11.8, 11.8

clearing redo log files, 11.2.1.1, 11.8

client/server architectures

distributed databases, 31.1.3, 31.1.3

globalization support, 31.6.1

CloneDB, 2.9

CLONEDB parameter, 38.4.1

clonedb.pl Perl script, 2.9.2

cloning

a database, 1.2.11, 2.9

an Oracle home, 1.2.11

CLOSE DATABASE LINK clause

ALTER SESSION statement, 33.2

closing database links, 32.4.1

closing windows, 29.7.3.5

clusters

about, 22.1

allocating extents, 22.4

altering, 22.4

analyzing, 18.2

cluster indexes, 22.5

cluster keys, 22.1, 22.2.2, 22.2.3

clustered tables, 22.1, 22.2.1, 22.3.1, 22.4.1, 22.5.1

columns for cluster key, 22.2.2

creating, 22.3

data dictionary views reference, 22.6

deallocating extents, 22.4

dropping, 22.5

estimating space, 22.2.3, 22.2.5

guidelines for managing, 22.2

location, 22.2.4

privileges, 22.3, 22.4, 22.5.1

selecting tables, 22.2.1

single-table hash clusters, 23.3.2

truncating, 18.3

validating structure, 18.2.2

coalescing indexes

costs, 21.2.13

cold backup

performing with a detached Oracle Scheduler job, 29.2.2.8

collocated inline views

tuning distributed queries, 33.4.1

column encryption, 2.8.2

columns

adding, 20.6.6

adding to compressed table, 20.6.6.1

displaying information about, 20.14

dropping, 20.6.8, 20.6.8.3

dropping in compressed tables, 20.6.8.4

encrypted, 20.2.13

increasing length, 20.6.5

invisible, 20.2.12

modifying definition, 20.6.5

renaming, 20.6.7

virtual, 20.1

virtual, indexing, 21.2.2

commands

submitting, 1.3

COMMENT statement, 20.14

comments

adding to problem activity log, 9.2.7

COMMIT COMMENT statement

used with distributed transactions, 35.2, 35.4.3.2

commit phase, 34.3.1, 34.5.4

in two-phase commit, 34.3.2, 34.3.2.2

commit point site, 34.2.5

commit point strength, 34.2.5.2, 35.1

determining, 34.2.5.2

distributed transactions, 34.2.5, 34.2.5.2

how the database determines, 34.2.5.2

commit point strength

definition, 34.2.5.2

specifying, 35.1

COMMIT statement

FORCE clause, 35.5, 35.5.1.1, 35.5.2

forcing, 35.4.2

two-phase commit and, 31.4.6

COMMIT_POINT_STRENGTH initialization parameter, 34.2.5.2, 35.1

committing transactions

commit point site for distributed transactions, 34.2.5

common users

definition, 36.1.2

prefix, 40.6.1

COMMON_USER_PREFIX parameter, 40.6.1

compatibility level, 2.5.9

COMPATIBLE Initialization Parameter, 2.5.9

components

srvctl component names and abbreviations, 4.4

compression

indexes, 21.3.7

advanced compression, 21.3.7.2

prefix compression, 21.3.7.1

levels, 20.2.6

tables, 20.2.6

adding a column, 20.6.6.1

dropping columns in, 20.6.8.4

tablespaces, 13.2.3

CON_DBID_TO_ID function, 43.9

CON_GUID_TO_ID function, 43.9

CON_NAME_TO_ID function, 43.9

CON_UID_TO_ID function, 43.9

configuring

an Oracle database, 2

Oracle Scheduler, 30.1

CONNECT command

starting an instance, 3.1.4

CONNECT command, SQL*Plus, 1.3.2.4

CDBs, 40.2.1

connected user database links, 32.2.3.2

advantages and disadvantages, 31.2.7.1

definition, 31.2.7

example, 31.2.8

REMOTE_OS_AUTHENT initialization parameter, 31.2.7.1

connecting

with SQL*Plus, 1.3.2

connection qualifiers

database links and, 32.2.4

connections

terminating remote, 33.2

constraints

D

data

loading using external tables, 20.13.2

data block corruption

repairing, 25.1

data blocks

altering size of, 2.5.5.1

nonstandard block size, 2.5.5.2

shared in clusters, 22.1

specifying size of, 2.5.5

standard block size, 2.5.5

verifying, 14.7

data definition language (DDL)

CDBs, 40.6

data dictionary

conflicts with control files, 10.4.1

purging pending rows from, 35.6, 35.6.2

E

ECID, 9.1.2.2

editions

in CONNECT command, 1.3.2.4

managing, 18.10

e-mail notifications, Scheduler, 29.8.4

EMPHASIS resource allocation method, 27.5.5

empty tables

dropping segments, 19.4

ENABLE PLUGGABLE DATABASE clause, 37.4.1.1

ENABLE_PLUGGABLE_DATABASE initialization parameter, 37.4.2

enabling

chains, 29.6.5

jobs, 29.2.8

programs, 29.3.6

window groups, 29.7.4.6

windows, 29.7.3.8

enabling recoverer process

distributed transactions, 35.9.2

encryption

column, 20.2.13

tablespace, 13.2.4

encryption, transparent data, 2.8.2

enterprise users

definition, 31.3.2.4.2

environment variables

ORACLE_SID, 2.3.1

error logging, DML

inserting data with, 20.4.4

errors

alert log and, 8.1.1

assigning names with PRAGMA_EXCEPTION_INIT, 33.5

critical, 9.1.1

exception handler, 33.5

integrity constrain violation, 33.3

ORA-00028, 5.8.2

ORA-01090, 3.3

ORA-01173, 10.4.2

ORA-01176, 10.4.2

ORA-01177, 10.4.2

ORA-01215, 10.4.2

ORA-01216, 10.4.2

ORA-01578, 14.7

ORA-01591, 35.8.2

ORA-02049, 35.8.1

ORA-02050, 35.4.1

ORA-02051, 35.4.1

ORA-02054, 35.4.1

RAISE_APPLICATION_ERROR() procedure, 33.5

remote procedure, 33.5

rollback required, 33.3

trace files and, 8.1.1

when creating control file, 10.4.2

while starting a database, 3.1.5.5

while starting an instance, 3.1.5.5

event message

passing to event-based job, 29.5.2.5

event schedule

altering, 29.5.2.4

creating, 29.5.2.3

event-based job

altering, 29.5.2.2

creating, 29.5.2.1

passing event messages to, 29.5.2.5

events

using to start Scheduler jobs, 29.5

events (Scheduler)

overview, 29.5.1

example

setting maximum utilization limit for plans and subplans, 27.7.2

examples

managing parallel statement execution using Resource Manager, 27.7.4

exception handler, 33.5

EXCEPTION keyword, 33.5

exceptions

assigning names with PRAGMA_EXCEPTION_INIT, 33.5

integrity constraints, 18.5.5

user-defined, 33.5

executing

remote external jobs, 30.1.3

execution context identifier, 9.1.2.2

execution plans

analyzing for distributed queries, 33.4.4

export operations

restricted mode and, 3.1.5.4

expressions, calendaring, 29.4.5.1

EXTENT MANAGEMENT LOCAL clause

CREATE DATABASE, 2.4.2

extents

allocating cluster extents, 22.4

allocating for tables, 20.6.4

data dictionary views for, 19.6.2

deallocating cluster extents, 22.4

displaying free extents, 19.6.2.3

external destinations, Oracle Scheduler

about, 28.2.4

creating, 29.2.2.4.2

external jobs

retrieving stdout and stderr, 28.3.1.2.1, 28.3.1.2.2, 29.2.2.10

external jobs, Oracle Scheduler, 28.3.1.2

external procedures

credentials, 5.7.2

directory objects, 5.7.2

managing processes for, 5.7.1

external tables

altering, 20.13.3

creating, 20.13.2

defined, 20.13.1

dropping, 20.13.5

privileges required, 20.13.6

uploading data example, 20.13.2

F

fast recovery area

as archive log destination, 12.4.1.1

initialization parameters to specify, 2.5.3

with Oracle managed files, 17.2

fault diagnosability infrastructure, 9.1.1

file mapping

examples, 14.9.4

how it works, 14.9.2

how to use, 14.9.3

overview, 14.9.1

structures, 14.9.2.2

views, 14.9.3.3

file system

used for Oracle managed files, 17.1.1.2

file watchers

about, 29.5.3.1

changing detection interval, 29.5.3.5

creating, 29.5.3.3

managing, 29.5.3.5

FILE_MAPPING initialization parameter, 14.9.3.1

filenames

Oracle Managed Files, 17.3.1

files

creating Oracle Managed Files, 17.3, 17.3.6.2

finalizing

an incident package, definition, 9.10.1.1

FINISH_REDEF_TABLE procedure

dml_lock_timeout parameter, 20.7.3

FIX_CORRUPT_BLOCKS procedure

DBMS_REPAIR, 25.2.1

example, 25.4.3

marking blocks corrupt, 25.3.3.1

fixed user database links

advantages and disadvantages, 31.2.7.2

creating, 32.2.3.1

definition, 31.2.7

example, 31.2.8

Flashback Drop

about, 20.11

purging recycle bin, 20.11.4

querying recycle bin, 20.11.3

recycle bin, 20.11.1

restoring objects, 20.11.5

Flashback Table

overview, 20.9

flood-controlled incidents

defined, 9.1.2.1

viewing, 9.3

FMON background process, 14.9.2.1.1

FMPUTL external process

used for file mapping, 14.9.2.1.2

FORCE clause

COMMIT statement, 35.5

ROLLBACK statement, 35.5

force full database caching mode, 6.5

disabling, 6.5.4

enabling, 6.5.3

prerequisites, 6.5.2

FORCE LOGGING clause

CREATE CONTROLFILE, 2.4.10.1

CREATE DATABASE, 2.4.10

CREATE TABLESPACE, 13.5

performance considerations, 2.4.10.2

FORCE LOGGING mode, 20.4.2.4

forcing

COMMIT or ROLLBACK, 35.3.1, 35.4.2

forcing a log switch, 11.6

using ARCHIVE_LAG_TARGET, 11.2.6

with the ALTER SYSTEM statement, 11.6

forget phase

in two-phase commit, 34.3.3

free space

listing free extents, 19.6.2.3

tablespaces and, 13.14.3

full transportable export/import, 15.2

function-based indexes, 21.3.6

G

GDS configuration, 2.7.2

generic connectivity

definition, 31.1.2.3

global coordinators, 34.2.4

distributed transactions, 34.2.4

Global Data Services, 2.7.2

global database consistency

distributed databases and, 34.3.2.2

global database links, 31.2.6

creating, 32.2.2.3

global database names

changing the domain, 32.1.4

database links, 31.2.4

loopback, 31.2.4.1

enforcing for database links, 31.2.5

enforcing global naming, 32.1.2

forming distributed database names, 32.1.1

impact of changing, 31.4.9.1

querying, 32.1.3

global object names

database links, 31.4.7

distributed databases, 32.1

global users, 32.8.5

schema-dependent in distributed systems, 31.3.2.4.1

schema-independent in distributed systems, 31.3.2.4.2

GLOBAL_NAME view

using to determine global database name, 32.1.3

GLOBAL_NAMES initialization parameter

database links, 31.2.5

globalization support

client/server architectures, 31.6.1

distributed databases, 31.6

GRANT statement

SYSOPER/SYSDBA privileges, 1.7.3.1

granting privileges and roles

SYSOPER/SYSDBA privileges, 1.7.3.1

groups, Oracle Scheduler, 28.2.10

growth trends

of database objects, 19.7.3

GUID

PDBs, 36.1.1

GV$DBLINK view, 32.5.2

H

hash clusters

advantages and disadvantages, 23.1

altering, 23.4

choosing key, 23.3.3.1

contrasted with index clusters, 23.1

controlling space use of, 23.3.3

creating, 23.3

data dictionary views reference, 23.6

dropping, 23.5

estimating storage, 23.3.4

examples, 23.3.3.5.1

hash function, 23.1, 23.2.2, 23.3, 23.3.3.1, 23.3.3.2, 23.3.3.3

HASH IS clause, 23.3, 23.3.3.2

HASHKEYS clause, 23.3, 23.3.3.4

single-table, 23.3.2

SIZE clause, 23.3.3.3

sorted, 23.3.1

hash functions

for hash cluster, 23.1

health checks, 9.1.1

Health Monitor, 9.7

checks, 9.7.1.1

generating reports, 9.7.3

running, 9.7.2

viewing reports, 9.7.3

viewing reports using ADRCI, 9.7.3.3

heterogeneous distributed systems

definition, 31.1.2

Heterogeneous Services

overview, 31.1.2

hints, 33.4.3

DRIVING_SITE, 33.4.3.2

NO_MERGE, 33.4.3.1

using to tune distributed queries, 33.4.3

HP OpenView, 31.3.4.3

Hybrid Columnar Compression, 20.2.6

I

IBM NetView/6000, 31.3.4.3

IM column store

See In-Memory Column Store

import operations

PDBs, 15.2.3, 15.2.4

restricted mode and, 3.1.5.4

incident package

correlated, 9.10.1.3

correlated, creating, editing, and uploading, 9.10.4

correlated, deleting, 9.10.5

creating, editing and uploading custom, 9.10

customizing, 9.10.3, 9.10.3.2

defined, 9.1.1

viewing, 9.10.3.1

incident packaging service, 9.1.1

incidents

about, 9.1.2

flood-controlled, 9.1.2.1

viewing, 9.3

index clusters

See clusters

indexes

advanced index compression, 21.3.7.2

altering, 21.4

analyzing, 18.2

choosing columns to index, 21.2.2

cluster indexes, 22.3.2, 22.4.1, 22.5

coalescing, 21.2.13, 21.4.2

column order for performance, 21.2.3

creating, 21.3

data dictionary views reference, 21.7

deferred segment creation, 21.2.6

determining unusable status of, 21.4.3, 21.4.3

disabling and dropping constraints cost, 21.2.14

dropping, 21.2.5, 21.6, 21.6

estimating size, 21.2.7

estimating space use, 19.7.2

explicitly creating a unique index, 21.3.2

function-based, 21.3.6

guidelines for managing, 21.1

invisible, 21.2.11, 21.2.11

keeping when disabling constraint, 18.5.3

keeping when dropping constraint, 18.5.3

limiting for a table, 21.2.4

monitoring space use of, 21.5

monitoring usage, 21.4.6

multiple on a set of columns, 21.2.12

parallelizing index creation, 21.2.9

rebuilding, 21.2.13, 21.4.2, 21.4.2

rebuilt after direct-path INSERT, 20.4.2.5.2

renaming, 21.4.5

setting storage parameters for, 21.2.7

shrinking, 19.3.3

space used by, 21.5

statement for creating, 21.3.1

tablespace for, 21.2.8

temporary segments and, 21.2.1

unusable, 21.2.11, 21.3.8, 21.4.3

validating structure, 18.2.2

when to create, 21.2.2

index-organized tables

analyzing, 20.12.5

AS subquery, 20.12.2.6

converting to heap, 20.12.7

creating, 20.12.2

described, 20.12.1

INCLUDING clause, 20.12.2.5

maintaining, 20.12.3

ORDER BY clause, using, 20.12.6

parallel creation, 20.12.2.6

prefix compression, 20.12.2.7

rebuilding with MOVE clause, 20.12.3.2

storing nested tables, 20.12.2.3

storing object types, 20.12.2.3

threshold value, 20.12.2.4

in-doubt transactions, 34.4

after a system failure, 35.4.1

automatic resolution, 34.4.1, 34.4.1.1

deciding how to handle, 35.4

deciding whether to perform manual override, 35.4.2

defined, 34.3.1.2

manual resolution, 34.4.2

manually committing, 35.5.1

manually committing, example, 35.7

manually overriding, 35.4.2, 35.5

manually overriding, scenario, 35.7

manually rolling back, 35.5.2

overview, 34.4

pending transactions table, 35.7.6

purging rows from data dictionary, 35.6, 35.6.2

recoverer process and, 35.9.2

rolling back, 35.5, 35.5.1.1, 35.5.2, 35.5.2

SCNs and, 34.4.3

simulating, 35.9

tracing session tree, 35.3.2

viewing database links, 35.3.1

INITIAL parameter

cannot alter, 20.6.2

initialization parameter file

about, 2.5.1

creating, 2.3.4

creating by copying and pasting from alert log, 2.6.9

creating for database creation, 2.3.4

default locations, 3.1.2.1

editing before database creation, 2.5

individual parameter names, 2.5.2

sample, 2.5.1.2

search order, 3.1.2.1

server parameter file, 2.6

initialization parameters

about, 2.5.1

and database startup, 3.1.2.1

ARCHIVE_LAG_TARGET, 11.2.6.1

changing, 2.6.5.1

clearing, 2.6.6

COMMIT_POINT_STRENGTH, 34.2.5.2, 35.1

CONTROL_FILES, 2.5.4, 2.5.4, 10.2.1, 10.3.1

DB_BLOCK_CHECKING, 25.3.1.4

DB_BLOCK_CHECKSUM, 11.7, 14.7

DB_BLOCK_SIZE, 2.5.5, 13.4

DB_CACHE_SIZE, 13.4

DB_DOMA, 2.5.2

DB_DOMAIN, 2.5.2.2

DB_FILES, 14.1.1.1

DB_NAME, 2.5.2

DB_nK_CACHE_SIZE, 13.4, 15.6

DISPATCHERS, 5.3.4.3

FILE_MAPPING, 14.9.3.1

GLOBAL_NAMES, 31.2.5

LOG_ARCHIVE_DEST, 12.4.1

LOG_ARCHIVE_DEST_n, 12.4.1, 12.6.2

LOG_ARCHIVE_DEST_STATE_n, 12.4.2

LOG_ARCHIVE_MAX_PROCESSES, 12.3.4

LOG_ARCHIVE_MIN_SUCCEED_DEST, 12.6.1

LOG_ARCHIVE_TRACE, 12.7

OPEN_LINKS, 32.4.3

PROCESSES, 2.5.6

REMOTE_LOGIN_PASSWORDFILE, 1.7.2

REMOTE_OS_AUTHENT, 31.2.7.1

resetting, 2.6.6

RESOURCE_MANAGER_PLAN, 27.6, 27.6

server parameter file and, 2.6, 2.6.10

SET SQL_TRACE, 8.1.1.3

setting, 2.6.5.1

shared server and, 5.3.1

SHARED_SERVERS, 5.3.3.2

SORT_AREA_SIZE, 21.2.1

SPFILE, 2.6.4, 3.1.2.2

SQL_TRACE, 8.1.1

STATISTICS_LEVEL, 20.5

UNDO_MANAGEMENT, 2.4.4

UNDO_TABLESPACE, 2.5.8.2, 16.2.1

INITRANS parameter

altering, 20.6.2

In-Memory Column Store

compression, 6.7.1.2

enabling for a database, 6.7.3

enabling for materialized views, 6.7.6

enabling for tables, 6.7.4

enabling for tablespaces, 6.7.5

Oracle Data Pump, 6.7.7

Oracle Enterprise Manager Cloud Control, 6.7.8

population options, 6.7.1.3

INMEMORY_CLAUSE_DEFAULT parameter, 6.7.2

INMEMORY_FORCE parameter, 6.7.2

INMEMORY_MAX_POPULATE_SERVERS parameter, 6.7.2

INMEMORY_QUERY parameter, 6.7.2

INMEMORY_SIZE parameter, 6.7.2

INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT parameter, 6.7.2

INSERT statement

with DML error logging, 20.4.4

installing

patches, 1.2.10

instance caging, 27.8.1

with maximum utilization limit, 27.8.1

instances

aborting, 3.3.4

managing CPU for multiple, 27.8.1

shutting down immediately, 3.3.2

shutting down normally, 3.3.1

transactional shutdown, 3.3.3

integrity constraints

J

job classes

altering, 29.7.1.3

creating, 29.7.1.2

dropping, 29.7.1.4

managing Scheduler job attributes, resources, and priorities with, 29.7.1

overview, 28.2.8

viewing, 28.2.8

job coordinator, 28.4.2

job credentials, 29.2.2.3

job destination ID, defined, 29.2.5, 29.8.2

job log, Scheduler

viewing, 29.8.1

job recovery (Scheduler), 30.4.1.4

job scheduling

dependency, 28.1

event-based, 28.1

time-based, 28.1

JOB_QUEUE_PROCESSES initialization parameter, 28.4.2.2, A.1.2

jobs

altering, 29.2.3

copying, 29.2.9

creating, 29.2.2

creating and managing Scheduler, 29.2

creating for chains, 29.6.6

credentials, 28.2.6

database, 28.3.1.1

detached, 28.3.1.5

disabling, 29.2.7

dropping, 29.2.6

e-mail notifications, 29.8.4

enabling, 29.2.8

event-based, 29.5.2.1

external, 28.3.1.2

lightweight, 28.3.1.6

lightweight, example of creating, 29.2.2.2.2

monitoring, 29.8

monitoring with events raised by the Scheduler, 29.8.3

multiple-destination, 28.3.2

status of child jobs, 30.2.2

overview, 28.2.3

priorities, 29.7.2

remote database, 28.3.1.1

remote external

about, 28.3.1.2.2

running, 29.2.4

script jobs, 28.3.1.7

starting when a file arrives on a system, 29.5.3

starting with events raised by your application, 29.5.2

status, 29.8, 30.6.2

stopping, 29.2.5

troubleshooting remote, 30.4.1.3

viewing information on running, 30.2.2

join views

definition, 24.1.2.1

DELETE statements, 24.1.5.2.2

key-preserved tables in, 24.1.5.1

modifying, 24.1.5

rules for modifying, 24.1.5.2

updating, 24.1.5

joins

statement transparency in distributed databases, 32.7

K

key-preserved tables

in join views, 24.1.5.1

in outer joins, 24.1.5.3

keys

cluster, 22.1, 22.2.3

keystore, 13.2.4, 20.2.13

L

large objects, 20.3.1

lightweight jobs, 28.3.1.6

example of creating, 29.2.2.2.2

links

See database links

LIST CHAINED ROWS clause

of ANALYZE statement, 18.2.3.1

listeners

removing with srvctl, 4.4

listing database links, 32.5.1, 35.3.1, 35.3.2

loading data

using external tables, 20.13.2

LOBs, 20.3.1

local coordinators, 34.2.3

distributed transactions, 34.2.3

local users

definition, 36.1.2

locally managed tablespaces, 13.2.1

automatic segment space management in, 13.2.1.2

DBMS_SPACE_ADMIN package, 13.12

detecting and repairing defects, 13.12

migrating SYSTEM from dictionary-managed, 13.13

shrinking, temporary, 13.8.5

temp files, 13.2.5.1

temporary, creating, 13.2.5.1

location transparency in distributed databases

creating using synonyms, 32.6.2

creating using views, 32.6.1

restrictions, 32.7

using procedures, 32.6.3.3

lock timeout interval

distributed transactions, 35.8

locks

in-doubt distributed transactions, 35.8, 35.8.2

monitoring, 8.2.1

log

window (Scheduler), 29.7.3

log sequence number

control files, 11.1.3.2

log switches

description, 11.1.3.2

forcing, 11.6, 11.6

log sequence numbers, 11.1.3.2

multiplexed redo log files and, 11.2.1.1

privileges, 11.6

using ARCHIVE_LAG_TARGET, 11.2.6

waiting for archiving to complete, 11.2.1.1

log writer process (LGWR), 5.5

multiplexed redo log files and, 11.2.1.1

online redo logs available for use, 11.1.3

trace files and, 11.2.1.1

writing to online redo log files, 11.1.3

LOG_ARCHIVE_DEST initialization parameter

specifying destinations using, 12.4.1

LOG_ARCHIVE_DEST_n initialization parameter, 12.4.1

REOPEN attribute, 12.6.2

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 12.4.2

LOG_ARCHIVE_DUPLEX_DEST initialization parameter

specifying destinations using, 12.4.1

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 12.3.4

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 12.6.1

LOG_ARCHIVE_TRACE initialization parameter, 12.7

LOGGING clause

CREATE TABLESPACE, 13.5

logging mode

direct-path INSERT, 20.4.2.4

NOARCHIVELOG mode and, 20.4.2.4.1

logging_clause, 38.1.2.7, 42.3.1.1

logical corruptions from DBMS_REPAIR, 25.3.2

logical standby, 28.5

logical volume managers

mapping files to physical devices, 14.9, 14.9.4.3

used for Oracle Managed Files, 17.1.1.1

LOGON trigger

setting resumable mode, 19.2.3

logs

job, 30.2.3

window (Scheduler), 29.7.3, 30.2.3

LONG columns, 32.7

LONG RAW columns, 32.7

M

maintenance tasks, automatic

See automatic maintenance tasks

maintenance window

creating, 26.4.2

definition, 26.1

MAINTENANCE_WINDOW_GROUP, 26.2

modifying, 26.4.1

predefined, 26.6.1

removing, 26.4.3

Scheduler, 26.2

managing

sequences, 24.2.1

space threshold alerts for the undo tablespace, 16.5.6

synonyms, 24.3.1

tables, 20

views, 24.1

manual archiving

in ARCHIVELOG mode, 12.3.3

manual overrides

in-doubt transactions, 35.5

materialized views

In-Memory Column Store, 6.7.6

materializing deferred segments, 20.2.15

MAXDATAFILES parameter

changing, 10.3.3.2

MAXINSTANCES, 10.3.3.2

MAXLOGFILES parameter

changing, 10.3.3.2

CREATE DATABASE statement, 11.2.5

MAXLOGHISTORY parameter

changing, 10.3.3.2

MAXLOGMEMBERS parameter

changing, 10.3.3.2

CREATE DATABASE statement, 11.2.5, 11.2.5

MAXTRANS parameter

altering, 20.6.2

media recovery

effects of archiving on, 12.2.1

migrated rows

eliminating from table, procedure, 18.2.3.2

MINEXTENTS parameter

cannot alter, 20.6.2

mirrored files

control files, 2.5.4, 10.2.2

online redo log, 11.2.1.1

online redo log location, 11.2.2

online redo log size, 11.2.3

MISSING data files, 10.4.1

monitoring

performance, 8.2

running chains, 29.6.17

MONITORING clause

CREATE TABLE, 20.5

MONITORING USAGE clause

of ALTER INDEX statement, 21.4.6

mounting a database, 3.1.5.3

moving control files, 10.3.2

multiple instances, managing CPU for, 27.8.1

multiple jobs

dropping, 29.2.6.2

multiple temporary tablespaces, 13.2.6, 13.2.6.3

multiple-destination jobs, Oracle Scheduler, 28.3.2

status of child jobs, 30.2.2

multiplexed control files

importance of, 10.2.2

multiplexing

archived redo log files, 12.4.1

control files, 10.2.2

redo log file groups, 11.2.1

redo log files, 11.2.1, 11.2.1

multitenant architecture, 35.10, 36.1

purpose of, 36.2

multitenant container databases

See CDBs

multitenant environment, 36.1

N

name resolution in distributed databases

database links, 31.4.7

impact of global name changes, 31.4.9.1

procedures, 31.4.9

schema objects, 31.2.9.4, 31.4.8

synonyms, 31.4.9

views, 31.4.9

when global database name is complete, 31.4.7.1

when global database name is partial, 31.4.7.2

when no global database name is specified, 31.4.7.3

named user limits

setting initially, 2.5.10

networks

connections, minimizing, 32.3

distributed databases use of, 31.1.1

NEXT parameter

altering, 20.6.2

NEXTVAL pseudo-column, 24.2.4.1, 24.2.4.1.1

restrictions, 24.2.4.1.3

NO DATA clause, 38.1.2.9, 38.4.2

NO_DATA_FOUND keyword, 33.5

NO_MERGE hint, 33.4.3.1

NOARCHIVELOG mode

archiving, 12.2

definition, 12.2.1

dropping data files, 14.4.2

LOGGING mode and, 20.4.2.4.1

media failure, 12.2.1

no hot backups, 12.2.1

running in, 12.2.1

switching to, 12.3.2

taking data files offline in, 14.4.2

NOCACHE option

CREATE SEQUENCE statement, 24.2.4.2.2

NOLOGGING clause

CREATE TABLESPACE, 13.5

NOLOGGING mode

direct-path INSERT, 20.4.2.4

noncdb_to_pdb.sql script, 38.4.3, 38.6.1.2

non-CDBs

cloning as PDBs, 38.4

moving to PDBs, 38.6

normal transmission mode

definition, 12.5.1

Novell NetWare Management System, 31.3.4.3

O

object privileges

for external tables, 20.13.6

objects

See schema objects

offline tablespaces

priorities, 13.6.1

taking offline, 13.6.1

online redefinition of tables, 20.7

abort and cleanup, 20.7.6

examples, 20.7.9

features of, 20.7.1

intermediate synchronization, 20.7.5

redefining a single partition

rules for, 20.7.8.1

redefining partitions, 20.7.8

restrictions, 20.7.7

Virtual Private Database policies, 20.7.3.2

with DBMS_REDEFINITION, 20.7.3

online redo log files

See online redo logs

online redo logs

P

package

See incident package

packages

DBMS_FILE_TRANSFER, 14.7

DBMS_METADATA, 18.11.1

DBMS_REDEFINITION, 20.7.2, 20.7.3, 20.7.10, 20.7.10

DBMS_REPAIR, 25.2

DBMS_RESOURCE_MANAGER, 27.1.2, 27.1.3, 27.1.3, 27.2.4.1

DBMS_RESOURCE_MANAGER_PRIVS, 27.1.3, 27.1.3

DBMS_RESUMABLE, 19.2.4.3

DBMS_SPACE, 19.3.4, 19.6.1

DBMS_STATS, 18.2.1, 20.5

DBMS_STORAGE_MAP, 14.9.3.2, 14.9.3.3

packaging and uploading problems, 9.10.2

parallel execution

managing, 5.6

parallel hints, 5.6, 5.6

parallelizing index creation, 21.2.9

resumable space allocation, 19.2.1.5

parallel hints, 5.6, 5.6

parallel statement execution

directive attributes for managing, 27.7.4

managing using Resource Manager, 27.3.3.3

PARALLEL_DEGREE_LIMIT_ABSOLUTE resource allocation method, 27.5.5

parallelizing table creation, 20.2.4, 20.3.3

parameter files

See initialization parameter file

partitioned tables, 20.2.2

moving a partition online, 20.6.3.2

redefining partitions online, 20.7.8

rules for, 20.7.8.1

password

setting for SYSTEM account in CREATE DATABASE statement, 2.4.1

setting SYS in CREATE DATABASE statement, 2.4.1

password file

adding users, 1.7.3

creating, 1.7.1

ORAPWD utility, 1.7.1

removing, 1.7.4.2

setting REMOTE_LOGIN_PASSWORD, 1.7.2

synchronizing administrator passwords with the data dictionary, 1.7.2.2

viewing members, 1.7.3.2

password file authentication, 1.6.4.1

passwords

case sensitivity of, 1.6.2, 1.6.4.1, 1.6.4.2

password file, 1.7.3

setting REMOTE_LOGIN_PASSWORD parameter, 1.7.2

patches

installing, 1.2.10

Oracle Restart, 4.3

PATH_PREFIX clause, 38.1.2.3

pausing chains and chain steps, 29.6.14

PCTINCREASE parameter, 20.6.2

PDB resource plans, 44.1.3

PDB_FILE_NAME_CONVERT initialization parameter, 37.4.1.2.3

pdb_force_logging_clause, 42.3.1.1

PDB_PLUG_IN_VIOLATIONS view, 40.4.5.1

pdb_save_or_discard_state clause, 40.4.6

PDBs, 35.10, 36.1

administering, 42

ALTER SYSTEM statement, 42.4

CDB resource plans, 44.1.2

creating, 44.3

directives, 44.1.2.4

disabling, 44.4.2

enabling, 44.4.1

managing, 44.7.1

shares, 44.1.2.2

utilization limits, 44.1.2.3

viewing information about, 44.8

cloning, 38.4

compatibility violations, 40.4.5.1

connecting to, 40.2, 42.2

ALTER SESSION statement, 40.2.2

CONNECT command, 40.2.1

creating using the seed, 38.3

current container, 40.1.1

Database Resource Manager, 44

DBMS_SQL package, 40.3

definition, 36.1

dropping, 38.8

EM Express, 37.5

executing PL/SQL code, 40.3

GUID, 36.1.1

import operations, 15.2.3, 15.2.4

modifying, 42.3

moving non-CDBs into, 38.6, 38.6.1

open mode, 40.4.5, 43.6

preserving on restart, 40.4.6

PDB resource plans, 44.1.3

creating, 44.5

disabling, 44.6.2

modifying, 44.7.2

PDBs resource plans

enabling, 44.6.1

plugging in, 38.5

CREATE PLUGGABLE DATABASE statement, 38.1.2

methods for, 38.1.1

preparing for, 38.2

prerequisites for, 36.3

purpose of, 36.2

renaming, 42.3.1.3

services, 42.5

SHUTDOWN command, 42.3.2, 42.3.2.2

shutting down, 40.8

STARTUP command, 40.4.5.3, 42.3.2, 42.3.2.1

tools for, 36.4.2

unplugging, 38.7

views, 43.2

pending area for Database Resource Manager plans, 27.5.9

validating plan schema changes, 27.5.7

pending transaction tables, 35.7.6

performance

index column order, 21.2.3

location of data files and, 14.1.3

monitoring, 8.2

plan schemas for Database Resource Manager, 27.3.1.1, 27.6, 27.9.4

validating plan changes, 27.5.7

plans for Database Resource Manager

examples, 27.7

PL/SQL

replaced views and program units, 24.1.3

pluggable databases

See PDBs

PRAGMA_EXCEPTION_INIT procedure

assigning exception names, 33.5

predefined user accounts, 2.8.1

prefix compression, 20.12.2.7, 21.3.7.1

prepare phase

abort response, 34.3.1.1.3

in two-phase commit, 34.3.1

prepared response, 34.3.1.1.1

read-only response, 34.3.1.1.2

recognizing read-only nodes, 34.3.1.1.2

steps, 34.3.1.2

prepare/commit phases

effects of failure, 35.8.1

failures during, 35.4.1

locked resources, 35.8

pending transaction table, 35.7.6

prepared response

two-phase commit, 34.3.1.1.1

prerequisites

for creating a database, 2.1.1.2

PRIMARY KEY constraints

associated indexes, 21.3.3.1

dropping associated indexes, 21.6

enabling on creation, 21.3.3

foreign key references when dropped, 18.5.3.1

indexes associated with, 21.3.3

priorities

job, 29.7.2

private database links, 31.2.6

private synonyms, 24.3.1

privileges

adding redo log groups, 11.3

altering index, 21.4

altering tables, 20.6

closing a database link, 33.2

creating database links, 32.2.1

creating tables, 20.3

creating tablespaces, 13.2

database administrator, 1.5

drop table, 20.10

dropping indexes, 21.6

dropping online redo log members, 11.5.2

dropping redo log groups, 11.5.1

enabling and disabling triggers, 18.4

for external tables, 20.13.6

forcing a log switch, 11.6

managing with procedures, 32.6.3.4

managing with synonyms, 32.6.2.2

managing with views, 32.6.1

manually archiving, 12.3.3

renaming objects, 18.6

renaming redo log members, 11.4

RESTRICTED SESSION system privilege, 3.1.5.4

Scheduler, 30.6.1

sequences, 24.2.2, 24.2.2, 24.2.5

setting chain (Scheduler), 30.1.1

synonyms, 24.3.2, 24.3.4

taking tablespaces offline, 13.6.1

truncating, 18.3.3

using a view, 24.1.4

using sequences, 24.2.4

views, 24.1.2, 24.1.3, 24.1.7

problem activity log

adding comments to, 9.2.7

problems

about, 9.1.2

adding comments to activity log, 9.2.7

problems (critical errors)

packaging and uploading, 9.10.2

procedures

external, 5.7.1

location transparency in distributed databases, 32.6.3

name resolution in distributed databases, 31.4.9

remote calls, 31.5.2

process monitor (PMON), 5.5

processes

See server processes

PROCESSES initialization parameter

setting before database creation, 2.5.6

PRODUCT_COMPONENT_VERSION view, 1.4.2

programs

altering, 29.3.3

creating, 29.3.2

creating and managing, to define Scheduler jobs, 29.3

disabling, 29.3.5

dropping, 29.3.4

enabling, 29.3.6

overview, 28.2.1

public database links, 31.2.6

connected user, 32.8.3

fixed user, 32.8.1

public fixed user database links, 32.8.1

public synonyms, 24.3.1

PURGE_LOST_DB_ENTRY procedure

DBMS_TRANSACTION package, 35.6.1

Q

queries

distributed, 31.4.2

distributed application development issues, 33.4

location transparency and, 31.5.1.2

remote, 31.4.1

question mark, 2.3.11

quiescing a database, 3.4

quotas

tablespace, 13.1.2

R

RAISE_APPLICATION_ERROR() procedure, 33.5

read consistency

managing in distributed databases, 35.10

read-only database

opening, 3.2.3

read-only databases

limitations, 3.2.3

read-only response

two-phase commit, 34.3.1.1.2

read-only tables, 20.6.9

read-only tablespaces

data file headers when rename, 13.9

delaying opening of data files, 13.7.4

making read-only, 13.7.1

making writable, 13.7.2

WORM devices, 13.7.3

Real Application Clusters

allocating extents for cluster, 22.4

sequence numbers and, 24.2.2

threads of online redo log, 11.1.1

rebuilding indexes, 21.4.2

costs, 21.2.13

online, 21.4.2

reclaiming unused space, 19.3

RECOVER clause

STARTUP command, 3.1.5.6

recoverer process, 5.5

disabling, 35.9.2

distributed transaction recovery, 35.9.2

enabling, 35.9.2

pending transaction table, 35.9.2

recovering

Scheduler jobs, 30.4.1.4

recovery

creating new control files, 10.3.3.2

Recovery Manager

starting a database, 3.1.1.2

starting an instance, 3.1.1.2

recycle bin

about, 20.11.1

purging, 20.11.4

renamed objects, 20.11.1

restoring objects from, 20.11.5

viewing, 20.11.3

REDEF_TABLE procedure, 20.7.2

example, 20.7.9

redefining tables online

See online redefinition of tables

redo log files

S

Sample Schemas

description, 2.8.5

savepoints

in-doubt transactions, 35.5, 35.5.2

schagent utility, 30.1.3.3.1

Scheduler

administering, 30

architecture, 28.4

CDB, 46.1

closing a PDB, 46.4

configuring, 30.1

credentials for jobs, 28.2.6

data dictionary views reference, 30.6.2

e-mail notifications, 29.8.4

examples of using, 30.5

import and export, 30.3

invocations to CDB, 46.1

maintenance window, 26.2

monitoring and managing, 30.2

monitoring jobs, 29.8

objects, 28.2

overview, 28.1

security, 30.2.4

support for Oracle Data Guard, 28.5, 30.5.5

troubleshooting, 30.4

job does not run, 30.4.1

using in RAC, 28.4.5

using job coordinator in CDB, 46.2

using slave processes in CDB, 46.2

Views, new and changed, 46.5

Scheduler agent, 30.1.3

configuration, 30.1.3.2

installation, 30.1.3.2

setup, 30.1.3.2

Scheduler chain condition syntax, 29.6.4

Scheduler job credentials

specifying, 29.2.2.3

Scheduler objects, naming, 29.1

Scheduler privileges reference, 30.6.1

SCHEDULER_BATCH_ERRORS view, 29.2.6.2

schedules

altering, 29.4.3

creating, 29.4.2

creating and managing, to define Scheduler jobs, 29.4

dropping, 29.4.4

overview, 28.2.2

schema objects

analyzing, 18.2

creating multiple objects, 18.1

data dictionary views reference, 18.11.2

defining using DBMS_METADATA package, 18.11.1

dependencies between, 18.7

distributed database naming conventions for, 31.2.9.4

global names, 31.2.9.4

listing by type, 18.11.2.1

name resolution in distributed databases, 31.2.9.4, 31.4.8

name resolution in SQL statements, 18.8

privileges to rename, 18.6

referencing with synonyms, 32.6.2.1

renaming, 18.6, 18.6

validating structure, 18.2.2

viewing information, 18.11, 19.6

schema objects space usage

data dictionary views reference, 19.6.2

SCN

See system change number

SCOPE clause

ALTER SYSTEM SET, 2.6.5.1

script jobs, 28.3.1.7

scripts, authenticating users in, 2.8.3

security

accessing a database, 7.1

administrator of, 7.1

centralized user management in distributed databases, 31.3.2.4

database security, 7.1

distributed databases, 31.3.2

establishing policies, 7

privileges, 7.1

remote objects, 32.6.1

Scheduler, 30.2.4

using synonyms, 32.6.2.2

SEED FILE_NAME_CONVERT clause, 37.4.1.2.1

seed PDB, 36.1.1

Segment Advisor, 19.3.2

configuring Scheduler job, 19.3.2.4

invoking with Oracle Enterprise Manager Cloud Control, 19.3.2.2.1

invoking with PL/SQL, 19.3.2.2.2

running manually, 19.3.2.2

viewing results, 19.3.2.3

views, 19.3.2.5

SEGMENT_FIX_STATUS procedure

DBMS_REPAIR, 25.2.1

segments

available space, 19.6.1

data dictionary views for, 19.6.2

deallocating unused space, 19.3

displaying information on, 19.6.2.1

dropping for empty tables, 19.4

shrinking, 19.3.3

SELECT statement

FOR UPDATE clause and location transparency, 32.7

SEQUENCE_CACHE_ENTRIES parameter, 24.2.4.2.2

sequences

accessing, 24.2.4

altering, 24.2.3

caching sequence numbers, 24.2.4.2

creating, 24.2.2, 24.2.4.2.2, 24.2.4.2.2

CURRVAL, 24.2.4.1.2

data dictionary views reference, 24.4

dropping, 24.2.5

managing, 24.2.1

NEXTVAL, 24.2.4.1.1

Oracle Real Applications Clusters and, 24.2.2

SERVER parameter

net service name, 32.3.3.1

server parameter file

creating, 2.6.3

defined, 2.6.1

exporting, 2.6.7

migrating to, 2.6.2

recovering, 2.6.9

RMAN backup, 2.6.8

setting initialization parameter values, 2.6.5

SPFILE initialization parameter, 2.6.4

STARTUP command behavior, 2.6.1

viewing parameter settings, 2.6.10

server processes

archiver (ARCn), 5.5

background, 5.5

checkpoint (CKPT), 5.5

database writer (DBWn), 5.5

dedicated, 5.1.1

dispatcher (Dnnn), 5.5

dispatchers, 5.3.4.3

log writer (LGWR), 5.5

monitoring locks, 8.2.1

process monitor (PMON), 5.5

recoverer (RECO), 5.5

shared server, 5.1.2

system monitor (SMON), 5.5

trace files for, 8.1.1

server-generated alerts, 8.1.2

servers

role in two-phase commit, 34.2.2

service names

database links and, 32.2.4

services

controlling automatic startup of, 3.1.3

creating with SRVCTL and Oracle Restart, 4.2.10

PDBs, 42.5

role-based, 3.1.3

session trees for distributed transactions

clients, 34.2.1

commit point site, 34.2.5, 34.2.5.2

database servers, 34.2.2

definition, 34.2

global coordinators, 34.2.4

local coordinators, 34.2.3

tracing transactions, 35.3.2

sessions

active, 5.8.2

inactive, 5.8.3

setting advice for transactions, 35.4.3.3

terminating, 5.8

SET TIME_ZONE clause

ALTER SESSION, 2.4.9.1

CREATE DATABASE, 2.4.9.1

SET TRANSACTION statement

naming transactions, 35.2

SGA

See system global area

shared database links

configuring, 32.3.3

creating, 32.3.2

dedicated servers, creating links to, 32.3.3.1

determining whether to use, 32.3.1

example, 31.2.8

shared servers, creating links to, 32.3.3.2

SHARED keyword

CREATE DATABASE LINK statement, 32.3.2

shared server, 5.1.2

configuring dispatchers, 5.3.4

data dictionary views reference, 5.3.6

disabling, 5.3.3.2, 5.3.5

initialization parameters, 5.3.1

interpreting trace output, 8.1.1.4

setting minimum number of servers, 5.3.3.2

trace files for processes, 8.1.1

shared SQL

for remote and distributed statements, 31.4.3

shrinking segments online, 19.3.3

shutdown

default mode, 3.3.1

SHUTDOWN command

closing a PDB, 42.3.2

IMMEDIATE clause, 3.3.2

interrupting, 3.3.5

NORMAL clause, 3.3.1

PDBs, 42.3.2.2

shutting down an instance

CDBs, 40.8

Simple Network Management Protocol (SNMP) support

database management, 31.3.4.3

single-file tablespaces

description, 13.2.2

single-instance

defined, 2.3

single-table hash clusters, 23.3.2

site autonomy

distributed databases, 31.3.1

SKIP_CORRUPT_BLOCKS procedure, 25.3.3.1

DBMS_REPAIR, 25.2.1

example, 25.4.5

skipping chain steps, 29.6.15

SNAPSHOT COPY clause, 38.4.1

snapshot too old error, 16.2.2.1

SORT_AREA_SIZE initialization parameter

index creation and, 21.2.1

SOURCE_FILE_NAME_CONVERT clause, 38.1.2.4

space

deallocating unused, 19.3.4

reclaiming unused, 19.3

space allocation

resumable, 19.2

space management

data types, space requirements, 19.5

deallocating unused space, 19.3

Segment Advisor, 19.3

shrink segment, 19.3

space usage alerts for tablespaces, 19.1.1

SPACE_ERROR_INFO procedure, 19.2.4.1

SPFILE initialization parameter, 2.6.4

specifying from client system, 3.1.2.2

SQL

submitting, 1.3

SQL failure

repairing with SQL Repair Advisor, 9.8

SQL patch

disabling, 9.8.3

removing, 9.8.3

viewing, 9.8.3

SQL Repair Advisor

about, 9.8.1

repairing SQL failure with, 9.8

running, 9.8.2

SQL scripts

CDBs, 40.7

SQL statements

distributed databases and, 31.4.1

SQL test case builder, 9.1.1

SQL*Loader

about, 1.8, 20.4.1

SQL*Plus, 1.3

about, 1.3.1

connecting with, 1.3.2

starting, 3.1.4

starting a database, 3.1.1.1

starting an instance, 3.1.1.1

SQL_TRACE initialization parameter

trace files and, 8.1.1

SRVCTL

add asm command, 4.4

add command, usage description, 4.4

add database command, 4.4

add listener command, 4.4

add ons command, 4.4

adding a disk group with, 4.4

case sensitivity, 4.4, 4.4

case sensitivity of commands, 4.4, 4.4

command reference, 4.4

commands

downgrade database, 4.4

upgrade database, 4.4, 4.4

commands, case sensitivity, 4.4, 4.4

component names, 4.4

config asm command, 4.4

config command, usage description, 4.4

config database command, 4.4

config listener command, 4.4

config ons command, 4.4

config service command, 4.4

creating and deleting databases services with, 4.2.10

disable asm command, 4.4

disable command, usage description, 4.4

disable database command, 4.4

disable diskgroup command, 4.4

disable listener command, 4.4

disable ons command, 4.4

disable service command, 4.4

enable asm command, 4.4

enable command, usage description, 4.4

enable database command, 4.4

enable diskgroup command, 4.4

enable listener command, 4.4

enable ons command, 4.4

enable service command, 4.4

getenv asm command, 4.4

getenv command, usage description, 4.4

getenv database command, 4.4

getenv listener command, 4.4

help for, 4.2.2

modify asm command, 4.4

modify command, usage description, 4.4

modify database command, 4.4

modify listener command, 4.4

modify ons command, 4.4

modify service command, 4.4

preparing to run, 4.2.1

reference, 4.4

remove asm command, 4.4

remove command, usage description, 4.4

remove database command, 4.4

remove diskgroup command, 4.4

remove listener command, 4.4

remove ons command, 4.4

remove service command, 4.4

setenv asm command, 4.4

setenv command, usage description, 4.4

setenv database command, 4.4

setenv listener command, 4.4

start asm command, 4.4

start command, usage description, 4.4

start database command, 4.4

start diskgroup command, 4.4

start home command, 4.4

start listener command, 4.4

start ons command, 4.4

start service command, 4.4

status asm command, 4.4

status command, usage description, 4.4

status database command, 4.4

status diskgroup command, 4.4

status home command, 4.4

status listener command, 4.4

status ons command, 4.4

status service command, 4.4

stop asm command, 4.4

stop command, usage description, 4.4

stop database command, 4.4

stop diskgroup command, 4.4

stop home command, 4.4

stop listener command, 4.4

stop ons command, 4.4

stop service command, 4.4

unsetenv asm command, 4.4

unsetenv command, usage description, 4.4

unsetenv database command, 4.4

unsetenv listener command, 4.4

SRVCTL stop option

default, 3.3.1

STALE status

of redo log members, 11.5.2

stalled chain (Scheduler), 29.6.18

standby database

CDBs, 40.1.2

standby transmission mode

definition of, 12.5.2

STANDBYS clause, 38.1.2.8

starting a database, 3.1

forcing, 3.1.5.5

Oracle Enterprise Manager Cloud Control, 3.1.1.3

recovery and, 3.1.5.6

Recovery Manager, 3.1.1.2

restricted mode, 3.1.5.4

SQL*Plus, 3.1.1.1

when control files unavailable, 3.1.5

when redo logs unavailable, 3.1.5

starting an instance

automatically at system startup, 3.1.5.7

database closed and mounted, 3.1.5.3

database name conflicts and, 2.5.2.1

forcing, 3.1.5.5

mounting and opening the database, 3.1.5.1

normally, 3.1.5.1

Oracle Enterprise Manager Cloud Control, 3.1.1.3

recovery and, 3.1.5.6

Recovery Manager, 3.1.1.2

remote instance startup, 3.1.5.8

restricted mode, 3.1.5.4

SQL*Plus, 3.1.1.1

when control files unavailable, 3.1.5

when redo logs unavailable, 3.1.5

without mounting a database, 3.1.5.2

startup

of database services, controlling, 3.1.3

STARTUP command

default behavior, 2.6.1

NOMOUNT clause, 2.3.8

PDBs, 40.4.5.3, 42.3.2.1

RECOVER clause, 3.1.5.6

starting a database, 3.1.1.1, 3.1.5

starting a PDB, 42.3.2

statement transparency in distributed database

managing, 32.7

statistics

automatically collecting for tables, 20.5

STATISTICS_LEVEL initialization parameter

automatic statistics collection, 20.5

Database Resource Manager, 27.1.1

stderr

for local external jobs, 28.3.1.2.1, 28.3.1.2.2

retrieving, 28.3.1.2.1, 28.3.1.2.2

stdout

for local external jobs, 28.3.1.2.1, 28.3.1.2.2

retrieving, 28.3.1.2.1, 28.3.1.2.2, 29.2.2.10

steps, chain

dropping, 29.6.11

stopping

chain steps, 29.6.13

chains, 29.6.12

jobs, 29.2.5

STORAGE clause, 38.1.2.1

storage parameters

INITIAL, 20.6.2

INITRANS, altering, 20.6.2

MAXTRANS, altering, 20.6.2

MINEXTENTS, 20.6.2

NEXT, 20.6.2

PCTINCREASE, 20.6.2

storage subsystems

mapping files to physical devices, 14.9, 14.9.4.3

stored procedures

managing privileges, 32.6.3.4

remote object security, 32.6.3.4

submitting SQL and commands to the database, 1.3

subqueries

in remote updates, 31.4.1

statement transparency in distributed databases, 32.7

SunSoft SunNet Manager, 31.3.4.3

Support Workbench, 9.1.3.7

for Oracle ASM instance, 9.3

viewing problems with, 9.3

SWITCH LOGFILE clause

ALTER SYSTEM statement, 11.6

synonyms, 24.3.3

creating, 24.3.2, 32.6.2.1

data dictionary views reference, 24.4

definition and creation, 32.6.2.1

displaying dependencies of, 18.11.2.2

dropping, 24.3.4

examples, 32.6.2.1

location transparency in distributed databases, 32.6.2

managing, 24.3.1, 24.3.4

managing privileges in remote database, 32.6.2.2

name resolution in distributed databases, 31.4.9

private, 24.3.1

public, 24.3.1

remote object security, 32.6.2.2

SYS account, 1.5.2

objects owned, 1.5.2.1

specifying password for CREATE DATABASE statement, 2.4.1

SYS_GROUP for Database Resource Manager, 27.7.5

SYSAUX tablespace, 13.2

about, 2.4.3

cannot rename, 13.9

creating at database creation, 2.3.9, 2.4.3

creating for CDBs, 37.4.2

DATAFILE clause, 2.4.3

monitoring occupants, 13.11.1

moving occupants, 13.11.2

SYSBACKUP account, 1.5.2, 1.5.2.3

connecting as, 1.6.1

SYSBACKUP administrative privilege, 1.6.1.1

SYSDBA account

connecting as, 1.6.1

SYSDBA administrative privilege, 1.6.1.1

adding users to the password file, 1.7.3

determining who has privileges, 1.7.3.2

granting and revoking, 1.7.3.1

SYSDG account, 1.5.2, 1.5.2.3

connecting as, 1.6.1

SYSDG administrative privilege, 1.6.1.1

SYSKM account, 1.5.2, 1.5.2.3

connecting as, 1.6.1

SYSKM administrative privilege, 1.6.1.1

SYSOPER account

connecting as, 1.6.1

SYSOPER administrative privilege, 1.6.1.1

adding users to the password file, 1.7.3

determining who has privileges, 1.7.3.2

granting and revoking, 1.7.3.1

SYSTEM account, 1.5.2

objects owned, 1.5.2.2

specifying password for CREATE DATABASE, 2.4.1

system change numbers

coordination in a distributed database system, 34.3.2.2

in-doubt transactions, 35.5.1.2

using V$DATAFILE to view information about, 14.10

when assigned, 11.1.2

system global area

holds sequence number cache

system monitor process (SMON), 5.5

system privileges

ADMINISTER_RESOURCE_MANAGER, 27.1.3

for external tables, 20.13.6

SYSTEM tablespace

cannot rename, 13.9

creating at database creation, 2.3.9

creating for CDBs, 37.4.2

creating locally managed, 2.3.9, 2.4.2, 37.4.2

restrictions on taking offline, 14.4

when created, 13.2

SYSTEM_PLAN for Database Resource Manager, 27.7.5

T

table size

estimating, 19.7.1

tables

about, 20.1

adding columns, 20.6.6

allocating extents, 20.6.4

altering, 20.6.1

altering physical attributes, 20.6.2

analyzing, 18.2

attribute-clustered, 20.2.9

compressed, 20.2.6

creating, 20.3

data dictionary views reference, 20.14

deferred segment creation, 20.2.14

designing before creating, 20.2.1

dropping, 20.10

dropping columns, 20.6.8

estimating size, 20.2.16

estimating space use, 19.7.1

external, 20.13

Flashback Drop, 20.11

Flashback Table, 20.9

guidelines for managing, 20.2

hash clustered

See hash clusters

increasing column length, 20.6.5

index-organized, 20.12

In-Memory Column Store, 6.7.4

invisible columns, 20.2.12

key-preserved, 24.1.5.1

limiting indexes on, 21.2.4

managing, 20

modifying column definition, 20.6.5

moving, 20.6.3

parallelizing creation, 20.2.4, 20.3.3

partitions, 20.2.2

moving online, 20.6.3.2

read-only, 20.6.9

redefining online, 20.7

renaming columns, 20.6.7

researching and reversing erroneous changes to, 20.8

restrictions when creating, 20.2.17

setting storage parameters, 20.2.16

shrinking, 19.3.3

specifying location, 20.2.3

statistics collection, automatic, 20.5

temporary, 20.3.2

truncating, 18.3

unrecoverable (NOLOGGING), 20.2.5

validating structure, 18.2.2

zone maps, 20.2.10

tablespace set, 15.3.3.1

tablespaces

adding data files, 14.2

assigning user quotas, 13.1.2

autoextending, 13.8.1

automatic segment space management, 13.2.1.2

bigfile, 2.4.8, 13.2.2

checking default storage parameters, 13.14.1

compressed, 13.2.3

containing XMLTypes, 15.1.4

creating undo tablespace at database creation, 2.4.4, 2.4.8.2

data dictionary views reference, 13.14

DBMS_SPACE_ADMIN package, 13.12

default temporary tablespace, creating, 2.4.6, 2.4.8.2

detecting and repairing defects, 13.12

diagnosing and repairing problems in locally managed, 13.12

dictionary managed, 13.2.2.2

dropping, 13.10

encrypted, 13.2.4

guidelines for managing, 13.1

increasing size, 13.8.1

In-Memory Column Store, 6.7.5

listing files of, 13.14.2

listing free space in, 13.14.3

locally managed, 13.2.1

locally managed SYSTEM, 2.4.2

locally managed temporary, 13.2.5.1

location, 14.1.3

migrating SYSTEM to locally managed, 13.13

on a WORM device, 13.7.3

Oracle Managed Files, managing, 17.5.1, 17.5.2

overriding default type, 2.4.8.2

quotas, assigning, 13.1.2

read-only, 13.7

renaming, 13.8, 13.9

setting default type, 2.4.8.1

single-file, 2.4.8, 2.4.8.2, 13.2.2, 13.8.3

space usage alerts, 19.1.1

specifying nonstandard block sizes, 13.4

SYSAUX, 13.2, 13.9

SYSAUX creation, 2.4.3

SYSAUX, managing, 13.11

SYSTEM, 13.2, 13.2.1, 13.7.1, 13.13

taking offline normal, 13.6.1

taking offline temporarily, 13.6.1

temp files in locally managed, 13.2.5.1

temporary, 13.2.5, 13.2.6.3

temporary bigfile, 13.2.5.2

temporary for creating large indexes, 21.3.4

undo, 16.1

using multiple, 13.1.1

using Oracle Managed Files, 17.3.3

temp files, 13.2.5.1

creating as Oracle managed, 17.3.4

dropping, 14.6

dropping Oracle managed, 17.4.1

TEMP_UNDO_ENABLED parameter, 16.7

temporary segments

index creation and, 21.2.1

temporary tables

assigning to a tablespace, 20.3.2

creating, 20.3.2

temporary tablespace, default

specifying at database creation, 17.3.2.5

temporary tablespaces

altering, 13.8.4

bigfile, 13.2.5.2

creating, 13.2.5.1

groups, 13.2.6

renaming default, 13.9

shrinking, locally managed, 13.8.5

temporary undo, 16.7

statistics for, 16.8

terminating user sessions

active sessions, 5.8.2

identifying sessions, 5.8.1

inactive session, example, 5.8.3

inactive sessions, 5.8.3

test case

builder, SQL, 9.1.1

threads

online redo log, 11.1.1

threshold based alerts

managing with Oracle Enterprise Manager Cloud Control, 8.1.2.1

threshold-based alerts

server-generated, 8.1.2

thresholds

setting alert, 19.1.1

time zone

files, 2.4.9.2

setting for database, 2.4.9.1

trace files, 9.1.3.3

location of, 8.1.1

log writer process and, 11.2.1.1

using, 8.1.1

when written, 8.1.1.3

trace files, finding, 9.6

traces, 9.1.3.3

tracing

archivelog process, 12.7

transaction control statements

distributed transactions and, 34.1.2

transaction failures

simulating, 35.9

Transaction Guard, 2.8.4

transaction management

overview, 34.3

transaction processing

distributed systems, 31.4

transactions

closing database links, 33.2

distributed and two-phase commit, 31.4.6

in-doubt, 34.3.1.2, 34.4, 34.4.3, 35.4

naming distributed, 35.2, 35.4.3.2

remote, 31.4.4

transmitting archived redo log files, 12.5

Transparent Data Encryption, 2.8.2

CDBs, 40.1.2

columns, 20.2.13

keystore, 13.2.4, 20.2.13

tablespaces, 13.2.4

transporting data, 15

across platforms, 15.1.3

character sets, 15.1.4

compatibility considerations, 15.1.5

full transportable export/import, 15.2

limitations, 15.2.2

when to use, 15.1.2

limitations, 15.1.4

national character sets, 15.1.4

PDBs, 15.2.3, 15.2.4

transferring data files, 15.6

transportable tables, 15.4

limitations, 15.4.2

transportable tablespaces, 15.3

from backup, 15.2.1, 15.3.1

limitations, 15.3.2

tablespace set, 15.3.3.1

transportable set, 15.3.3

when to use, 15.1.2

wizard in Oracle Enterprise Manager Cloud Control, 15.3.1

XMLTypes in, 15.1.4

triggers

disabling, 18.4.2

enabling, 18.4.1

.trm files, 9.1.3.3

TRUNCATE statement

DROP ALL STORAGE, 18.3.3

DROP STORAGE, 18.3.3

DROP STORAGE clause, 18.3.3

REUSE STORAGE, 18.3.3

REUSE STORAGE clause, 18.3.3

vs. dropping table, 20.10

tuning

analyzing tables, 33.4.2.2.2

cost-based optimization, 33.4.2

two-phase commit

case study, 34.5

commit phase, 34.3.2, 34.5.4

described, 31.4.6

discovering problems with, 35.4.1

distributed transactions, 34.3

example, 34.5

forget phase, 34.3.3

in-doubt transactions, 34.4, 34.4.3

phases, 34.3

prepare phase, 34.3.1, 34.3.1.2

recognizing read-only nodes, 34.3.1.1.2

specifying commit point strength, 35.1

steps in commit phase, 34.3.2.1

tracing session tree in distributed transactions, 35.3.2

viewing database links, 35.3.1

U

Undo Advisor, 16.4

undo management

automatic, 16.2

described, 16.1

initialization parameters for, 16.2.1

temporary undo, 16.7

undo retention

automatic tuning of, 16.2.2.1

explained, 16.2.2

guaranteeing, 16.2.2.2

setting, 16.3

undo segments

in-doubt distributed transactions, 35.4.2

undo space

data dictionary views reference, 16.8

undo space management

automatic undo management mode, 16.2

Undo tablespace

specifying at database creation, 17.3.2.4

undo tablespaces

altering, 16.5.2

creating, 16.5.1

data dictionary views reference, 16.8

dropping, 16.5.3

managing, 16.5

managing space threshold alerts, 16.5.6

monitoring, 16.8

PENDING OFFLINE status, 16.5.4

renaming, 13.9

sizing a fixed-size, 16.4

specifying at database creation, 2.3.9, 2.4.4, 2.4.8.2

specifying for CDBs, 37.4.2, 37.4.2

statistics for, 16.8

switching, 16.5.4

user quotas, 16.5.5

UNDO_MANAGEMENT initialization parameter, 2.4.4

UNDO_TABLESPACE initialization parameter

for undo tablespaces, 2.5.8.2

starting an instance using, 16.2.1

UNIQUE key constraints

associated indexes, 21.3.3.1

dropping associated indexes, 21.6

enabling on creation, 21.3.3

foreign key references when dropped, 18.5.3.1

indexes associated with, 21.3.3

unplugging, 38.7

UNRECOVERABLE DATAFILE clause

ALTER DATABASE statement, 11.8

unusable indexes, 21.2.11

updates

location transparency and, 31.5.1.2

upgrading a database, 2.1

user accounts

predefined, 2.8.1, 7.5

USER_DB_LINKS view, 32.5.1, 32.5.1

USER_DUMP_DEST initialization parameter, 9.1.3.1

USER_OBJECT_USAGE view

for monitoring index usage, 21.4.6

USER_RESUMABLE view, 19.2.4.1

USER_TABLESPACES clause, 38.1.2.6

users

assigning tablespace quotas, 13.1.2

in a newly created database, 2.8.1

limiting number of, 2.5.10

predefined, 2.8.1

session, terminating, 5.8.3

SYS, 1.5.2

SYSBACKUP, 1.5.2

SYSDG, 1.5.2

SYSKM, 1.5.2

SYSTEM, 1.5.2

utilities

for the database administrator, 1.8

SQL*Loader, 1.8, 20.4.1

UTLCHAIN.SQL script

listing chained rows, 18.2.3.1

UTLCHN1.SQL script

listing chained rows, 18.2.3.1

UTLLOCKT.SQL script, 8.2.1

V

V$ARCHIVE view, 12.8

V$ARCHIVE_DEST view

obtaining destination status, 12.4.2

V$BLOCKING_QUIESCE view, 3.4.1

V$CLONEDFILE view, 2.9.3

V$CON_SYS_TIME_MODEL view, 43.1.1

V$CON_SYSSTAT view, 43.1.1

V$CON_SYSTEM_EVENT view, 43.1.1

V$CON_SYSTEM_WAIT_CLASS view, 43.1.1

V$CONTAINERS view, 43.4

V$DATABASE view, 12.8.1

V$DBLINK view, 32.5.2

V$DIAG_CRITICAL_ERROR view, 9.1.4

V$DIAG_INFO view, 9.1.4

V$DISPATCHER view

monitoring shared server dispatchers, 5.3.4.4

V$DISPATCHER_RATE view

monitoring shared server dispatchers, 5.3.4.4

V$ENCRYPTED_TABLESPACES view, 13.2.4, 13.14

V$INSTANCE view

for database quiesce state, 3.4.3

V$LOG view, 11.9, 12.8

displaying archiving status, 12.8

V$LOG_HISTORY view, 11.9

V$LOGFILE view, 11.9

log file status, 11.5.2

V$PDBS view, 43.5, 43.6

V$PWFILE_USERS view, 1.7.3.2

V$QUEUE view

monitoring shared server dispatchers, 5.3.4.4

V$ROLLSTAT view

undo segments, 16.8

V$SESSION view, 5.8.3

V$SYSAUX_OCCUPANTS view

occupants of SYSAUX tablespace, 13.11.2

V$TEMPUNDOSTAT view

statistics for temporary undo, 16.8

V$THREAD view, 11.9

V$TIMEZONE_NAMES view

time zone table information, 2.4.9.2

V$TRANSACTION view

undo tablespaces information, 16.8

V$UNDOSTAT view

statistics for undo tablespaces, 16.8

V$VERSION view, 1.4.2

VALIDATE STRUCTURE clause

of ANALYZE statement, 18.2.2

VALIDATE STRUCTURE ONLINE clause

of ANALYZE statement, 18.2.2

verifying blocks

redo log files, 11.7

viewing

alerts, 19.1.2

incident package details, 9.10.3.1

SQL patch, 9.8.3

views

creating, 24.1.2

creating with errors, 24.1.2.3

data dictionary

for archived redo log files, 12.8.1

for clusters, 22.6

for control files, 10.8

for data files, 14.10

for database, 2.11

for database resident connection pooling, 5.4.3

for Database Resource Manager, 27.13.3

for hash clusters, 23.6

for indexes, 21.7

for Oracle Scheduler, 30.6.2

for redo log, 11.9

for schema objects, 18.11.2

for sequences, 24.4

for shared server, 5.3.6

for space usage in schema objects, 19.6.2

for synonyms, 24.4

for tables, 20.14

for tablespaces, 13.14

for undo space, 16.8

for views, 24.4

data dictionary views for, 24.4

DBA_2PC_NEIGHBORS, 35.3.2

DBA_2PC_PENDING, 35.3.1

DBA_DB_LINKS, 32.5.1

DBA_RESUMABLE, 19.2.4.1

displaying dependencies of, 18.11.2.2

dropping, 24.1.7

file mapping views, 14.9.3.3

FOR UPDATE clause and, 24.1.2

invalid, 24.1.4

join

See join views

location transparency in distributed databases, 32.6.1

managing, 24.1, 24.1.3

managing privileges with, 32.6.1

name resolution in distributed databases, 31.4.9

ORDER BY clause and, 24.1.2

remote object security, 32.6.1

restrictions, 24.1.4

USER_OBJECT_USAGE, 21.4.6

USER_RESUMABLE, 19.2.4.1

using, 24.1.4

V$ARCHIVE, 12.8

V$ARCHIVE_DEST, 12.4.2

V$DATABASE, 12.8.1

V$LOG, 12.8

V$LOGFILE, 11.5.2

wildcards in, 24.1.2.2

WITH CHECK OPTION, 24.1.2

virtual columns, 20.1

indexing, 21.2.2

Virtual Private Database

redefining tables online, 20.7.3.2

W

wildcards

in views, 24.1.2.2

window groups

creating, 29.7.4.2

disabling, 29.7.4.7

dropping, 29.7.4.3

dropping a member from, 29.7.4.5

enabling, 29.7.4.6

managing job scheduling and job priorities with, 29.7.4

overview, 28.2.10.2

window logs, 29.7.3

windows (Scheduler)

altering, 29.7.3.3

closing, 29.7.3.5

creating, 29.7.3.2

disabling, 29.7.3.7

dropping, 29.7.3.6

enabling, 29.7.3.8

opening, 29.7.3.4

overlapping, 28.2.9.1

overview, 28.2.9

windows, managing job scheduling and resource allocation with, 29.7.3

workloads

managing with database services, 2.7

WORM devices

and read-only tablespaces, 13.7.3

WRH$_UNDOSTAT view, 16.8

X

XMLTypes

transporting data, 15.1.4

Z

zone maps, 20.2.10