Index

adding

columns to a table, 8.3.5.1

disks to Automatic Storage Management disk group, A.8

table constraint, 8.3.5.3

ADDM

See Automatic Database Diagnostics Monitor

administering

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

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.1

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

ALTER SYSTEM statement, 5.3

archive log files

advantages of using, 2.3.2.7

description, 6.1.3

archived log files

description, 2.3.2.7

ARCHIVELOG mode, 2.3.2.7

archiving, 2.3.2.7

ASM

See Automatic Storage Management

Automatic Database Diagnostics Monitor (ADDM)

description, 10.3.1

modifying behavior, 10.2.4

overview, 10.1.2

viewing performance analysis, 10.2.1

Automatic Diagnostic Repository, 11.1

automatic memory management, 2.3.2.9.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.9.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, 2.1.2.2, 2.1.2.2, A

accessing the Home page, A.4

administering, A.1

definition, A.1

disk discovery, A.2

installing, A.3

monitoring disk group space usage, A.5

Automatic Workload Repository, 10.1.4.1

background processes

description, 5.1.2

backing up

Automatic Storage Management files, A.10

backup

backup sets, 9.3.5.1

consistent, 9.2.1

crosschecking, 9.6.1, 9.6.2

deleting expired backups, 9.6.3

deleting obsolete backups, 9.6.5

expired, 9.6.1

full backup of datafiles, 9.4.1.1

image copies, 9.3.5.1

inconsistent, 9.2.1

incremental backup of datafiles, 9.4.1.2

making unavailable, 9.6.4

managing, 9.6, 9.6.1, 9.6.1

Oracle suggested backup strategy, 9.4.2.2

overview, 9.1

settings

configuring, 9.3.5

validating, 9.4.3

whole database backup, 9.4.2.1

backup and recovery area

specifying during database creation, 2.3.2.7

backup files, 6.1.7.3

BasicFiles, 8.3.1.5.1

blackout time periods

defining, 3.7.2

blackouts, 3.7.1

block size

configuring, 2.3.2.9.2

Buffer Cache Advisor

description, 10.3.1

central database management

configuring, 2.3.2.3

character sets

defining, 2.3.2.9.3

description, 2.3.2.9.3

checkpoint, 5.1.2

classes, Java, 8.6.1

CLOB datatype, 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 log, 11.2.6

compiling schema objects, 8.6.2

compressed tables

tables

compressed, 8.3.1.5.3

configuring

Automatic SQL Tuning Advisor, 10.3.4

connect descriptor

description, 4.1.2

example, 4.1.2

CONNECT role, 7.2

connect string

example, 4.1.3

connection mode

configuring, 2.3.2.9.4

connection privileges

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 file

description, 6.1.1

multiplexing, 6.1.1

SQL*Loader, 8.3.6

creating

indexes, 8.4.3

table, 8.3.4

user, 7.5.2

creating a database

overview, 2.1

steps, 2.2

using standalone DBCA, 2.3

creating a service request

service requests

creating, 11.2.4

customized repair, 9.8

data

loading, 8.3.6

data block

description, 2.3.2.9.2

data dictionary tables

access to as user SYS, 7.3.2

data file

SQL*Loader, 8.3.6

data integrity, 8.3.1.3

Data Recovery Advisor, 9.7

database

overview of creating, 2.1

database administration

privileges required, 7.3

Database Configuration Assistant

configuring database options, 2.3.3

deleting a database, 2.3.4

managing database templates, 2.3.5

using to create a database, 2.3

Database Control

starting and stopping, 3.3

database links

description, 8.7

database objects

naming, 8.1

Database Upgrade Assistant

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

managing

roadmap, 3.1

managing with Oracle Enterprise Manager Database Control, 3

metric thresholds, 10.1.1

monitoring

alert-based, 10.1.1

monitoring performance, 10.1

performance

advisors, 10.3.1

recovery

description, 9.2

steps for installing/creating, 2.2

storage structure

logical structures, 6.1

physical structures, 6.1

tuning, 10.1

upgrading, 12.4

users, 7

using DBCA templates, 2.3.5

datafiles

description, 6.1.5

datatypes

CLOB, 8.3.1.2.1

DATE, 8.3.1.2.1

description, 8.3.1.2.1

NUMBER, 8.3.1.2.1

user-defined, 8.3.1.5.1

VARCHAR2, 8.3.1.2.1

DATE datatype, 8.3.1.2.1

DBA role, 7.2, 8.2

DBCA

see Database Configuration Assistant

dedicated server mode, 2.3.2.9.4

dedicated server process, 5.1.3

deleting

constraints, 8.3.5.5

table, 8.3.7

table columns, 8.3.5.2

users, 7.5.9

views, 8.5.4

deleting a database, 2.3.4

disk discovery

in Automatic Storage Management, A.2

disk group

overview, A.2

disk group, Automatic Storage Management

adding disks to, A.8

creating, A.6

dropping, A.7

dropping disks from, A.9

monitoring disk space usage, A.5

dropping

disks from Automatic Storage Management disk group, A.9

duplicating a user, 7.5.3

emctl, 3.3

enabling

automatic memory management, 5.4.2

Enterprise Manager

starting and stopping, 3.3

EXAMPLE tablespace, 6.1.6

configuring, 2.3.2.8

expiring passwords

reasons for, 7.5.8

failure group, Automatic Storage Management, A.2

file

loading, 8.3.6

flash recovery area, 9.2.3

configuring, 9.3.3

retention policy, 9.3.2.1

specifying during database creation, 2.3.2.7

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, 8.6.1

global database name, 2.1.2.1

global indexes, 8.4.1.2.5

granting

privileges, 7.5.4

roles, 7.5.4

grid control

configuring, 2.3.2.3

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.5

viewing, 8.4.2

initialization parameter file

server parameter file, 5.1.1

initialization parameters

description, 5.1.1

viewing and modifying, 5.3

installation

checking prerequisites, 2.1.1

choices, 2.1.2

overview, 2.1

steps, 2.2

storage options, 2.1.2.2

using DBCA for database, 2.3

instance

database instance, 5.1

management, 5.1

memory structure, 5.1.4

Oracle instance, 5.1

shutdown, 5.1.5.3

startup, 5.1.5.2

instance PGA

definition, 5.1.4.2

invalid schema objects, 8.6.1

Java classes, 8.6.1

Java source code, 8.6.1

listener

starting, 4.3

listener.ora file, 4.1.1

Load Data wizard, 8.3.6

using, 8.3.6

loading data, 8.3.6

LOB columns, 8.3.1.5.1

local database management

configuring, 2.3.2.3

locking and unlocking users, 7.5.7

log switch

description, 2.3.2.7

managing

memory, 5.4

media recovery, 9.2.2

memory

configuring, 2.3.2.9.1

requirements, 2.1.1

structure of in an Oracle instance, 5.1.4

Memory Advisor

description, 10.3.1

using, 10.3.8

Memory Advisors

description, 10.3.1

memory management

about, 5.4.1

automatic, 5.4.1

automatic shared, 5.4.1

modes, 5.4.1

memory, managing, 5.4

mirroring, Automatic Storage Management, A.1

modifying

initialization parameters, 5.3

table attributes, 8.3.5

table constraints, 8.3.5.4

users, 7.5.6

Net Configuration Assistant (NETCA)

description, 4.1.5.1

NETCA

See Net Configuration Assistant (NETCA)

network configuration

connection requests, 4.1.1

description, 4.1

notification of alerts

alert notification, 3.7.1

NUMBER datatype, 8.3.1.2.1

object privileges, 7.2

offline tablespaces

priorities, 6.3.2.3

taking offline, 6.3.2.3

Oracle Enterprise Manager Database Control

backup, 9.4.2

backup and recovery, 9.3.1

description, 3.2

features, 3.2.1

granting administrative privileges to use, 3.6

online help, 3.2.3

Oracle listener

starting, 4.3

Oracle Net

description, 4.1

listener configuration, 4.1.1

mapping methods, 4.1.4

directory naming, 4.1.4.3

easy connect naming, 4.1.4.1

local naming, 4.1.4.2

Oracle suggested repair, 9.7

oracle system identifier, 2.1.2.1

ORACLE_BASE

default value, 2.2

partitioned

indexes, 8.4.1.2.5

partitioned tables

tables

partitions, 8.3.1.5.2

password files, 6.1.7.2

password policy

about, 7.6.1

default, 7.6.1

setting, 7.6

passwords

expiring, 7.5.8

patch

about, 12.1

patch set

about, 12.1

PGA Advisor

description, 10.3.1

PGA target

setting, 10.3.8

PGA, instance

definition, 5.1.4.2

predefined roles, 7.2

privilege

SYSDBA, 5.1.5.1

privileges

administrative, 7.3

connection, 5.1.5.1

granting, 7.5.4

object, 7.2

required for database administration, 7.3

revoking a system, 7.5.4

schema object management, 8.2

SYSDBA, 9.3.1

system, 7.2

taking tablespaces offline, 6.3.2.3

user, 7.2

using roles to manage, 7.2

privileges required for, 5.1.5.1

problem activity log

adding comments to, 11.2.6

problems

about, 11.1

adding comments to activity log, 11.2.6

problem key, 11.1

viewing

Support Workbench, 11.3

viewing detail, 11.2.3

procedures, 8.6.1

profile database object, 7.6.1

program global area (PGA)

components, 5.1.4.2

description, 5.1.4.2

quota, tablespace

assigning, 7.5.5

raw devices, 2.1.2.2

rebalancing, Automatic Storage Management, A.1

recovery

complete, 9.2.2

configuration, 2.3.2.7

flash 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)

overview, 9.1

repository, 9.2.4

recycle bin, 8.3.7

redo log files

description, 2.3.2.7, 6.1.2

multiplexing, 6.1.2, 6.4.1

redo log groups

description, 2.3.2.7

repair

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

role

DBA, 8.2

RESOURCE, 8.2

roles

administering, 7.4

granting, 7.5.4

predefined, 7.2

revoking, 7.5.4

using to manage user privileges, 7.2

viewing, 7.4.1

rollback segments

description, 6.1.4

sample schemas

configuring, 2.3.2.8

installation of, 2.1.2.2

schema

object management privileges, 8.2

schema objects

compiling, 8.6.2

database links, 8.7

description, 8.1

indexes, 8.4.1

creating, 8.4.3

viewing, 8.4.2

invalid, 8.6.1

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.5.1

Segment Advisor

description, 10.3.1

using, 6.3.4.1

sequences

description, 8.7

server parameter file, 5.1.1

server processes

description, 5.1.3

service requests

tracking, 11.2.6

services

on Windows, 5.2.2

setting

password policy, 7.6

SGA target

setting, 10.3.8

Shared Pool Advisor

description, 10.3.1

shared server mode, 2.3.2.9.4

shared server process, 5.1.3

shut down database

Windows, 5.2.2

SID, 2.1.2.1

software

steps for installing, 2.2

source code, Java, 8.6.1

SQL Access Advisor

using, 10.3.2

SQL Advisors

about, 10.3.2

description, 10.3.1

SQL statements

about, 3.8

SQL Tuning Advisor

about, 10.3.2

using, 10.3.6

SQL*Loader

control file, 8.3.6

starting database

Windows, 5.2.2

startup and shutdown, 5.1.5.1

about, 5.1.5

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

synonyms

description, 8.7

SYS user, 5.1.5.1, 7.3.1

SYSAUX tablespace, 6.1.6

SYSDBA privilege, 5.1.5.1

SYSDBA system privilege, 7.3.2

SYSOPER system privilege, 7.3.2

system global area (SGA)

components, 5.1.4.1

description, 5.1.4.1

system privileges, 7.2

SYSDBA and SYSOPER, 7.3.2

SYSTEM tablespace, 6.1.6

SYSTEM user, 5.1.5.1, 7.3.1

tables

adding columns to, 8.3.5.1

adding constraints, 8.3.5.3

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.5.1

modifying attributes, 8.3.5

modifying constraints, 8.3.5.4

viewing, 8.3.2

viewing data in, 8.3.3

tablespace quota

assigning, 7.5.5

tablespaces

creating, 6.3.1

data block, 6.1.6

description, 6.1.6

EXAMPLE, 6.1.6

modifying, 6.3.2

Segment Advisor, 6.3.2

segments

extents, 6.1.6

SYSAUX, 6.1.6

SYSTEM, 6.1.6

taking offline normal, 6.3.2.3

TEMP, 6.1.6

UNDOTBS1, 6.1.6

USERS, 6.1.6

TEMP tablespace, 6.1.6

templates

creating databases with, 2.3.2.1

using with DBCA, 2.3.5

triggers, 8.6.1

undo

about, 6.5.1

advisor, 6.5.4

managing, 6.5, 6.5.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 period

setting with Undo Advisor, 6.5.4

undo tablespace, 6.5.1

changing to fixed-size, 6.5.5

computing minimum size for fixed-size tablespace, 6.5.4

UNDOTBS1 tablespace, 6.1.6

Unicode

description, 2.3.2.9.3

upgrading a database, 12.4.4

steps, 12.4.4

user

creating, 7.5.2

creating by duplication, 7.5.3

duplicating, 7.5.3

viewing, 7.5.1

user accounts

administrative, 7.3

description, 7

user-defined datatypes, 8.3.1.5.1

users

administering, 7.5

deleting, 7.5.9

expiring passwords for, 7.5.8

locking and unlocking, 7.5.7

modifying, 7.5.6

USERS tablespace, 6.1.6

validating schema objects, 8.6.2

VARCHAR2 datatype, 8.3.1.2.1

viewing

indexes, 8.4.2

initialization parameters, 5.3

table data, 8.3.3

tables, 8.3.2

users, 7.5.1

views, 8.5.2

views

deleting, 8.5.4

description, 8.5.1

displaying, 8.5.2

wizard, 8.3.6