Index

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

A

adding

columns to a table, 8.3.5.1

disks to Oracle ASM disk groups, A.8

table constraints, 8.3.5.3

ADDM

See Automatic Database Diagnostics Monitor

administering

Oracle ASM, A.1

users, 7.5

administrative user accounts, 7.3

SYS, 5.1.5.1, 7.3.1

SYSTEM, 5.1.5.1

advisors

Automatic Database Diagnostics Monitor (ADDM), 10.3.1

Buffer Cache Advisor, 10.3.1, 10.3.1

description, 10.3.1

Memory Advisor, 10.3.1, 10.3.1

using, 10.3.8.1

performance, 10.3.1

PGA Advisor, 10.3.1, 10.3.1

repairing critical errors, 11.2.6

Segment Advisor, 10.3.1

using, 6.3.4.2

SGA Advisor, 10.3.1

Shared Pool Advisor, 10.3.1, 10.3.1

SQL Access Advisor, 10.3.1

using, 10.3.2

SQL Tuning Advisor, 10.3.1

using, 10.3.6

Undo Advisor, 6.5.4, 10.3.1

alerts

reviewing critical errors, 11.2.2

tablespace space usage, 6.3.2.2

ALTER SYSTEM statement, 5.3

archived redo log files

advantages of using, 2.3.2.6

description of, 2.3.2.6, 6.1.3

viewing, 6.2.3

ARCHIVELOG mode, 2.3.2.6

archiving, 2.3.2.6

ARCn processes, 5.1.2

ASM

See Automatic Storage Management (Oracle ASM)

See Oracle Automatic Storage Management

autoextend

data files and tablespaces, 6.1.6.4

Automatic Database Diagnostics Monitor (ADDM)

description, 10.3.1

findings, 10.1.2

modifying snapshot frequency and retention, 10.2.4

overview, 10.1.2

snapshots, 10.1.2

viewing performance analysis, 10.2.1

Automatic Diagnostic Repository, 11.1

automatic memory management, 2.3.2.8.1, 5.4.1

enabling, 5.4.2

modifying settings, 5.4.3

automatic PGA memory management

modifying settings, 5.4.5

automatic shared memory management, 2.3.2.8.1, 5.4.1

modifying settings, 5.4.4

Automatic SQL Tuning Advisor

about, 10.3.3

configuring, 10.3.4

viewing results, 10.3.5

Automatic Storage Management

See Oracle Automatic Storage Management (Oracle ASM)

Automatic Workload Repository, 10.1.4.1

AWR

See Automatic Workload Repository

B

background processes

and database configuration, 2.3.2.8.2

archiver (ARCn), 5.1.2

checkpoint, 5.1.2

database writer (DBWn), 5.1.2

description, 1.2, 5.1.2

log writer (LGWR), 5.1.2

manageability monitor (MMON), 5.1.2

process monitor (PMON), 4.1.1, 5.1.2

system monitor (SMON), 5.1.2

use by database instances, 5.1

backup

available, 9.6.1

backup pieces, 9.3.5.1

channels, 9.3.5.1

consistent, 9.2.1

cross-checking, 9.6.1, 9.6.2

deleting expired backups, 9.6.3

deleting obsolete backups, 9.6.5

expired, 9.6.1

files, 6.1.7

full backup of data files, 9.4.1.1

image copies, 9.3.5.1

inconsistent, 9.2.1

incremental backup of data files, 9.4.1.2

making unavailable, 9.6.4

managing, 9.6

obsolete, 9.6.1

Oracle suggested backup strategy, 9.4.2.2

overview, 9.1

sets, 9.3.5.1

settings, 9.3.5

tags, 9.4.1.4

unavailable, 9.6.1

validating, 9.4.3

whole database backup, 9.4.2.1

backup and recovery area

specifying during database creation, 2.3.2.6

BasicFiles, 8.3.1.4.1

blackouts

defining time periods, 3.8.2

description, 3.8.1

block size

configuring for the database, 2.3.2.8.2

Buffer Cache Advisor

description, 10.3.1

C

central database management

configuring, 2.3.2.3

character sets, 2.1.2.7

defining, 2.3.2.8.3

description, 2.3.2.8.3

checkpoint

of the database, 5.1.2

checkpoint process, 5.1.2

classes, Java, 8.6.1

CLOB data type, 8.3.1.2.1

code

database-resident, 8.6.1

columns

adding, 8.3.5.1

deleting, 8.3.5.2

comments

adding to problem activity logs, 11.2.6

compiling schema objects, 8.6.2

compressed tables, 6.3.4.2.1, 8.3.1.4.4

configuring

Automatic SQL Tuning Advisor, 10.3.4

connect descriptors

description, 4.1.2

example, 4.1.2

CONNECT role, 7.2

connect strings

description, 4.1.2

connection modes

configuring, 2.3.2.8.4

connection privileges

SYSASM, A.1

SYSDBA, 5.1.5.1

SYSOPER, 5.1.5.1

constraints, 8.3.1.3

adding, 8.3.5.3

deleting, 8.3.5.5

modifying, 8.3.5.4

control files

description, 6.1.1

multiplexing, 6.1.1

SQL*Loader, 8.3.6

creating

databases

overview, 2.1

steps, 2.2

using standalone DBCA, 2.3

indexes, 8.4.3

service requests, 11.2.4

tables, 8.3.4

users, 7.5.2

customized repairs, 9.8

D

data

loading, 8.3.6

data blocks

description of, 2.3.2.8.2, 6.1.5

data dictionary tables

access to as user SYS, 7.3.2

data files

and the Oracle Suggested Backup Strategy, 9.4.2.2.1

autoextend, 6.1.6.4, 6.3.2.1

autoextend and Oracle Flashback, 6.5.2

backing up, 9.2

backups of only used blocks, 9.3.5.1

data blocks, 6.1.5

description of, 6.1.5

example of corrupt block detection, 9.7.2

extents, 6.1.5

full backups, 9.4.1.1

image copies of, 9.4.1.1

media recovery, 9.2.2

missing, 9.1

recovering from the loss of, 9.8.4

recovery without restoration, 9.1

restoring from consistent and inconsistent backups, 9.2.1

segments, 6.1.5

SQL*Loader, 8.3.6

tempfiles, 6.1.5

validating backups of, 9.4.3.2

viewing information about, 6.2.4

data integrity, 8.3.1.3

Data Recovery Advisor, 9.7

data types

CLOB, 8.3.1.2.1

DATE, 8.3.1.2.1

NUMBER, 8.3.1.2.1

overview, 8.3.1.2.1

user-defined, 8.3.1.4.1

VARCHAR2, 8.3.1.2.1

database

domain, 2.1.2.6

global name, 2.1.2.6

management options, 2.1.2.7

database administration

privileges required, 7.3

database checkpoint, 5.1.2

Database Configuration Assistant (DBCA)

configuring database options, 2.3.3

deleting a databases, 2.3.4

managing database templates, 2.3.5

using to create a database, 2.3

database configuration options, 2.1.2.7

Database Control

See Oracle Enterprise Manager Database Control

database edition, 2.1.2.3

database links

description, 8.7

database objects

naming, 8.1

Database Upgrade Assistant (DBUA)

overview, 12.4.1

restrictions on versions, 12.4.2

starting, 12.4.3

steps for upgrading, 12.4.4

database-resident program code, 8.6.1

databases

advisors

using, 10.3.1

alerts, 10.1.1

responding to alerts, 10.1.4.3

setting metric thresholds, 10.1.4.2

setting notification rules, 10.1.4.5

viewing metrics, 10.1.4.1

backup

description, 9.2

backup and recovery, 9.1

configuring options, 2.3.3

creating with DBCA, 2.3

deleting using DBCA, 2.3.4

diagnosing performance problems, 10.2

duplicating, 2.3.5

managing

roadmap, 3.1

with Oracle Enterprise Manager Database Control, 3

metric thresholds, 10.1.1

monitoring

alert-based, 10.1.1

performance, 10.1

overview of creating, 2.1

performance

advisors, 10.3.1

monitoring, 10.1

recovery

description, 9.2, 9.2

point-in-time, 9.2.2

restoring

description, 9.2

starting and stopping on Microsoft Windows, 5.2.2

steps for installing and creating, 2.2

storage structure

logical structures, 6.1

physical structures, 6.1

tuning, 10.1

upgrading, 12.4, 12.4.4

users, 7

using DBCA templates, 2.3.5

DATE data type, 8.3.1.2.1

DBA role, 7.2, 8.2

DBUA

See Database Upgrade Assistant

DBWn processes, 5.1.2

dedicated server mode, 2.3.2.8.4

dedicated server processes, 5.1.3

deleting

constraints, 8.3.5.5

databases, 2.3.4

table columns, 8.3.5.2

tables, 8.3.7

users, 7.5.9

views, 8.5.4

deployment procedures, 12.2.3

E

emctl, 3.4

enabling

automatic memory management, 5.4.2

Enterprise Edition, 2.1.2.3

Enterprise Manager

See Oracle Enterprise Manager Database Control

EXAMPLE tablespace, 6.1.6

configuring, 2.3.2.7

expiring passwords

reasons for, 7.5.8

extending

tablespaces, 6.1.6.4, 6.3.2.1

tablespaces and Oracle Flashback, 6.5.2

undo tablespaces, 6.5.2

extents

description of, 6.1.5

F

failure groups, A.2

fast recovery area, 9.2.3

configuring, 9.3.3

retention policies, 9.3.2.1

specifying during database creation, 2.3.2.6

Flashback Database, 9.8.3

Flashback Drop, 9.8.2

flashback features

Flashback Database, 9.8.3

Flashback Drop, 9.8.2

Flashback Table, 9.8.1

Flashback Table, 9.8.1, 9.8.1.2

functions, PL/SQL, 8.6.1

G

global database name, 2.1.2.6

global indexes, 8.4.1.2

granting

privileges, 7.5.4

roles, 7.5.4

grid control

configuring, 2.3.2.3

I

inactive, 6.4.2

incidents

about, 11.1

closed, viewing, 11.3

closing, 11.2.7

tracking, 11.1

indexes

creating, 8.4.3, 8.4.3

description, 8.4.1

global, 8.4.1.2

viewing, 8.4.2

initialization parameter file, 6.1.7

initialization parameters

description, 5.1

how they are used by the database, 5.1.1

server parameter files, 5.1, 5.1.1

viewing and modifying, 5.3

installation

checking prerequisites, 2.1.1

choices, 2.1.2

overview, 2.1

software location, 2.1.2.4

steps, 2.2

storage options, 2.1.2.5

using DBCA for database, 2.3

instances

database instances, 5.1

management, 5.1

memory structure, 5.1.4

Oracle instances, 5.1

PGA

definition, 5.1.4.2

shutdown, 5.1.5.3

startup, 5.1.5.2

invalid schema objects, 8.6.1

J

Java classes, 8.6.1

Java source code, 8.6.1

L

language

used by software, 2.1.2.7

LGWR process, 5.1.2

licensed software options, 2.1.2.3

listener.ora files, 4.1.1

listeners

See Oracle listeners

Load Data wizard

using, 8.3.6

loading data, 8.3.6

LOB columns, 8.3.1.4.1

local database management

configuring, 2.3.2.3

locally managed tablespaces, 6.1.6.1

locking and unlocking users, 7.5.7

log switch

description, 2.3.2.6

M

managing

memory, 5.4

media recovery, 9.2.2

memory

configuring, 2.3.2.8.1

management, 5.1.4, 5.4, 5.4.1

requirements, 2.1.1

structure of in an Oracle instance, 5.1.4

Memory Advisors

description, 10.3.1, 10.3.1

using, 10.3.8.1

mirroring, A.1

MMON process, 5.1.2

modifying

initialization parameters, 5.3

table attributes, 8.3.5

table constraints, 8.3.5.4

users, 7.5.6

N

Net Configuration Assistant (NETCA)

description, 4.1.3

NETCA

See Net Configuration Assistant (NETCA)

network configuration

connection requests, 4.1.1

description, 4.1

notification of alerts

alert notification, 3.8.1

NUMBER data type, 8.3.1.2.1

O

object privileges, 7.2

offline tablespaces, 6.1.6.3, 6.3.2.3

online redo log files, 6.4.2

current, 6.4.2

description of, 2.3.2.6, 6.1.2

multiplexing, 6.1.2, 6.4.1

switching, 6.4.2

viewing, 6.2.2

online redo log groups

description of, 2.3.2.6

online table redefinition, 6.3.4.1

operating system groups, 2.1.2.7

Oracle Automatic Storage Management (Oracle ASM), A

administering, A.1

definition, A.1

disk discovery, A.2

failure groups, A.2

installation, 2.1.2.5

mirroring, A.1

monitoring disk group space usage, A.5

rebalancing, A.1

Oracle base directory, 2.1.2.4

Oracle Enterprise Manager

Software Library concepts and configuration, 12.2.3

Oracle Enterprise Manager Database Control

backup, 9.4.2

backup and recovery, 9.3.1

configuration information, 2.2

description, 3.2

features, 3.2

installing, 2.1.2.7

managing databases, 3

online help, 3.2

starting and stopping, 3.4

Oracle inventory directory, 2.1.2.4

Oracle listeners

listener.ora file, 4.1.1

starting

Oracle Net

description, 4.1

listener configuration, 4.1.1, 4.2

mapping methods, 4.1.2

directory naming, 4.1.2

easy connect naming, 4.1.2

local naming, 4.1.2

Oracle suggested repair, 9.7

Oracle system identifier, 2.1.2.6

ORACLE_BASE environment variable, 2.2, 2.2, 2.2

ORACLE_HOME environment variable, 2.2, 2.2

P

PAR files, 12.2.3

parameter file, 6.1.7

partitioned tables, 8.3.1.4.2

password file, 6.1.7

password policies

default, 7.6.1

description of, 7.6.1

setting, 7.6

passwords

expiring, 7.5.8

patch sets, 12.1

patches, 12.1

Patching wizard, 12.2.4

PGA

See Program Global Area

PGA Advisor

description, 10.3.1

PMON process, 4.1.1, 5.1.2

predefined roles, 7.2

privileges

administrative, 7.3

and synonyms, 8.7

authenticating SYSDBA and SYSOPER users, 6.1.7

connection, 5.1.5.1

for installation of Oracle Database software, 2.2

granting, 7.5.4

granting to a Database Control administrative user, 3.7

object, 7.2

recommended, 7.1

required for database administration, 3.6, 7.3

revoking a system, 7.5.4

schema object management, 8.2

SYSASM, A.1

SYSDBA, 5.1.5.1, 9.3.1

SYSOPER, 5.1.5.1

system, 7.2

users, 7.2

using roles to manage, 7.2

problem activity logs

adding comments to, 11.2.6

problems

about, 11.1

adding comments to activity logs, 11.2.6

problem key, 11.1

viewing, 11.3

viewing detail, 11.2.3

procedures, 8.6.1

profiles, 7.6.1

Program Global Area (PGA)

components, 5.1.4.2

definition, 5.1.4.2

description, 5.1.4.2

target setting, 10.3.8.1

Provisioning procedures, 12.2.3

Q

quotas

assigning for a tablespace, 7.5.5

R

read consistency, 6.5.1

read only tablespaces, 6.1.6.3

read write tablespaces, 6.1.6.3

rebalancing, A.1

reclaiming space, 6.3.4.1

recovery

complete, 9.2.2

configuration, 2.3.2.6

fast recovery area, 9.2.3

incomplete, 9.2.2

media, 9.2.2

overview, 9.1

whole database recovery, 9.8.3, 9.8.3

Recovery Manager (RMAN)

channels, 9.3.5.1

control file use, 9.2.4

overview, 9.1

parallelism, 9.3.5.1

recovery catalog, 9.2.4

repository, 9.2.4

recycle bins, 8.3.7

redo log files

See online redo log files or archived redo log files

reference collection, 10.1.3

reorganizing tables, 6.3.4.1

repairs

customized, 9.8

Oracle suggested, 9.7

RESOURCE role, 7.2, 8.2

revalidating schema objects, 8.6.2

revoking

roles, 7.5.4

system privileges, 7.5.4

roles

administering, 7.4

CONNECT, 7.2

DBA, 7.2, 8.2

granting, 7.5.4

predefined, 7.2

RESOURCE, 7.2, 8.2

revoking, 7.5.4

using to manage user privileges, 7.2

viewing, 7.4.1

rollback, 6.5.1

rollback segments

description, 6.1.4

S

sample schemas

configuring, 2.3.2.7

installation of, 2.1.2.7

schema objects

compiling, 8.6.2

database links, 8.7

description of, 8.1

indexes, 8.4.1

creating, 8.4.3

viewing, 8.4.2

invalid, 8.6.1

privileges, 8.2

sequences, 8.7

synonyms, 8.7

tables, 8.3.1

constraints, 8.3.1.3

modifying, 8.3.5

validating, 8.6.2

views, 8.5.1

schemas, 7.1

SecureFiles, 8.3.1.4.1

security options, 2.1.2.7

Segment Advisor

description, 10.3.1

description of, 6.3.4.2

manual operation, 6.3.4.4

recommendations, 6.3.4.2.1

viewing recommendations, 6.3.4.3

segments

description of, 6.1.5

sequences

description, 8.7

server parameter files, 5.1, 5.1.1

server processes

description, 5.1.3

service requests

creating, 11.2.4

tracking, 11.2.6

services

on Microsoft Windows, 5.2.2

session

description of, 5.1.4.2

setting

password policies, 7.6

SGA

See System Global Area

Shared Pool Advisor

description, 10.3.1

shared server mode, 2.3.2.8.4

shared server processes, 5.1.3

shrinking segments, 6.3.4.1

shutting down databases

Microsoft Windows, 5.2.2

SID, 2.1.2.6

SMON process, 5.1.2

snapshots, 10.1.2

Software Library

configuring, 12.2.3

software library

configuring, 12.2.3

source code, Java, 8.6.1

space usage alerts for tablespaces, 6.3.2.2

SQL Access Advisor

using, 10.3.2

SQL Advisors

about, 10.3.2

description, 10.3.1

SQL Profile, 10.3.3

SQL Response Time, 10.1.3

SQL statements

about, 3.9.1

SQL Tuning Advisor

about, 10.3.2

using, 10.3.6

SQL Tuning Set, 10.1.3

SQL*Loader

control file, 8.3.6

Standard Edition, 2.1.2.3

starting databases

Microsoft Windows, 5.2.2

startup and shutdown

about, 5.1.5

privileges required for, 5.1.5.1

subprograms, 8.6.1

Support Workbench

about, 11

Custom Packaging process, 11.2.5

home page, 11.2.1

Quick Packaging process, 11.2.5

viewing problems, 11.3

synonyms

and privileges, 8.7

description, 8.7

SYS user, 3.7, 3.7, 5.1.5.1, 7.3.1

SYSASM system privilege, A.1

SYSAUX tablespace, 6.1.6

SYSDBA, 2.1.2.7

SYSDBA system privilege, 5.1.5.1, 6.1.7, 7.3.2

SYSMAN user, 3.7, 3.7

SYSOPER, 2.1.2.7

SYSOPER system privilege, 6.1.7, 7.3.2

System Global Area (SGA)

components, 5.1.4.1

description, 5.1.4.1

target setting, 10.3.8.1

system identifier (SID), 2.1.2.6

system privileges, 7.2

SYSASM, A.1

SYSDBA and SYSOPER, 7.3.2

SYSTEM tablespace, 6.1.6

SYSTEM user, 3.7, 3.7, 5.1.5.1, 7.3.1

T

tables

adding columns to, 8.3.5.1

adding constraints, 8.3.5.3

compressed, 6.3.4.2.1, 8.3.1.4.4

creating, 8.3.4

deleting, 8.3.7

deleting columns, 8.3.5.2

deleting constraints, 8.3.5.5

description, 8.3.1

loading data into, 8.3.6

LOB columns, 8.3.1.4.1

modifying attributes, 8.3.5

modifying constraints, 8.3.5.4

partitions, 8.3.1.4.2

retrieving a dropped table, 9.8.2.2

viewing data in, 8.3.3

viewing information about, 8.3.2

tablespaces

autoextend, 6.1.6.4, 6.3.2.1

autoextend and Oracle Flashback, 6.5.2

creating, 6.3.1

description, 6.1.6

dropping, 6.3.3

EXAMPLE, 6.1.6

extending undo tablespaces, 6.5.2

locally managed, 6.1.6.1

modifying, 6.3.2

offline, 6.1.6.3

quotas, 7.5.5

read only and read write, 6.1.6.3

Segment Advisor, 6.3.2

space usage alerts, 6.3.2.2

SYSAUX, 6.1.6

SYSTEM, 6.1.6

taking offline, 6.3.2.3

TEMP, 6.1.6

temporary tablespaces, 6.1.6.2

types of, 6.1.6.2

undo tablespaces, 6.1.6.2, 6.5.1

UNDOTBS1, 6.1.6

USERS, 6.1.6

viewing information about, 6.2.5

TEMP tablespace, 6.1.6

templates

creating databases with, 2.3.2.1

using with DBCA, 2.3.5

temporary tablespaces, 6.1.6.2

triggers, 8.6.1

U

undo

about, 6.5.1

advisor, 6.5.4

managing, 6.5, 6.5.2

tablespaces, 6.1.6.2

viewing, 6.5.3

Undo Advisor

computing minimum undo tablespace size with, 6.5.4

description, 10.3.1

setting minimum undo retention period with, 6.5.4

undo retention, 6.5.1

undo retention period

setting with Undo Advisor, 6.5.4

undo tablespaces

autoextend, 6.5.2

changing to fixed-size, 6.5.5

computing minimum size for fixed-size tablespace, 6.5.4

default configuration, 6.5.1

description of, 6.5.1

UNDOTBS1 tablespace, 6.1.6

upgrading a database, 12.4.4

user-defined data types, 8.3.1.4.1

users

accounts

administrative, 7.3

description, 7

administering, 7.5

creating, 7.5.2

creating by duplication, 7.5.3

deleting, 7.5.9

duplicating, 7.5.3

expiring passwords for, 7.5.8

locking and unlocking, 7.5.7

modifying, 7.5.6

privileges, 7.2

SYSASM, A.1

viewing, 7.5.1

USERS tablespace, 6.1.6

V

validating schema objects, 8.6.2

VARCHAR2 data type, 8.3.1.2.1

viewing

indexes, 8.4.2

initialization parameters, 5.3

table data, 8.3.3

table information, 8.3.2

users, 7.5.1

views, 8.5.2

views

deleting, 8.5.4

description, 8.5.1

displaying, 8.5.2

W

wizards

Create Blackout, 3.8.2

database creation, 2.3.2

incident reporting, 11.2.1, 11.2.5

Load Data wizard, 8.3.6

Oracle ASM migration, A.1

Patching, 12.2.4

Quick Packaging, 11.2.5

Recovery, 9.2.2, 9.8, 9.8.3

Schedule Customized Backup, 9.4.2.3

SQL Access Advisor, 10.3.7