Index

adding

disks to Automatic Storage Management disk group, A.9

administrative user accounts

SYS, 5.1.4.1

SYSTEM, 5.1.4.1

advisors

Automatic Database Diagnostics Monitor (ADDM), 10.3.1

Buffer Cache Advisor, 10.3.1

description, 10.3

Memory Advisor, 10.3.1

using, 10.3.4

performance, 10.3.1

PGA Advisor, 10.3.1

Segment Advisor, 10.3.1

using, 6.2.5

Shared Pool Advisor, 10.3.1

SQL Access Advisor, 10.3.1

using, 10.3.3

SQL Tuning Advisor, 10.3.1

using, 10.3.2

Undo Advisor, 6.3.5, 10.3.1

archive log files

description, 6.1.3

ARCHIVELOG mode, 2.3.2.7

ASM

see Automatic Storage Management

Automatic Database Diagnostics Monitor (ADDM)

description, 10.3.1

modifying behavior, 10.2.3

overview, 10.1.2

viewing performance analysis, 10.2.1

automatic shared memory configuration

enabling, 5.4

Automatic Storage Management, A

accessing the Home page, A.4

administering, A.1

disk discovery, A.2

installing, A.3

monitoring disk group space usage, A.6

starting up and shutting down, A.5

Automatic Workload Repository, 10.1.4.1

background processes

description, 5.1.3

backing up

Automatic Storage Management files, A.11

backup

backup sets, 9.2.5.1.1

consistent, 9.1.1.1

crosschecking, 9.5.1, 9.5.3

deleting expired backups, 9.5.4

deleting obsolete backups, 9.5.6

expired, 9.5.1

full backup of datafiles, 9.3.1.1

image copies, 9.2.5.1.1

inconsistent, 9.1.1.1

incremental backup of datafiles, 9.3.1.2

making unavailable, 9.5.5

managing, 9.5, 9.5.1, 9.5.1

Oracle-suggested backup strategy, 9.3.2.2

overview, 9.1

settings

configuring, 9.2.5

validating, 9.3.3

whole database backup, 9.3.2.1

backup and recovery area

specifying, 2.3.2.7

backup files, 6.1.7.3

blackout time periods

defining, 3.5.1

blackouts, 3.5

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

client machine

configuring network, 4.5

compressed tables, 8.2.1.5

connect descriptor

description, 4.1.2

example, 4.1.2

connect string

description, 4.1.3

example, 4.1.3

connection mode

configuring, 2.3.2.9.4

connection privileges

SYSDBA, 5.1.4.1

SYSOPER, 5.1.4.1

constraints, 8.2.1.3

control file

description, 6.1.1

multiplexing, 6.1.1

creating a database

steps, 2.2

using standalone DBCA, 2.3

credentials

setting preferred, 3.5.2

CTXSYS user, 7.1

data

loading, 8.2.6

data integrity, 8.2.1.3

database

startup and shutdown, 5.2

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 links

description, 8.6

database objects

naming, 8.1.2

database resident program units, 8.5

Database Upgrade Assistant

overview, 2.4.1

restrictions on versions, 2.4.2

starting, 2.4.3

steps for upgrading, 2.4.4

databases

advisors

using, 10.3

alerts, 10.1.1

responding to alerts, 10.1.4.3

setting metrics, 10.1.4.2

setting notification rules, 10.1.4.5

viewing metrics, 10.1.4.1

backup

description, 9.1.1

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

managing with Enterprise Manager Database Control, 3

metrics thresholds, 10.1.1

monitoring

alert-based, 10.1.1

monitoring performance, 10.1

performance

advisors, 10.3.1

recovery

description, 9.1.1

steps for installing/creating, 2.2

storage structure

logical structures, 6.1

physical structures, 6.1

tuning, 10.1

upgrading, 2.4

users, 7

creating, 7.4.1

using DBCA templates, 2.3.5

datafiles

description, 6.1.5

datatypes

CLOB, 8.2.1.2.1

DATE, 8.2.1.2.1

description, 8.2.1.2.1

NUMBER, 8.2.1.2.1

overview, 8.2.1.2.1

VARCHAR2, 8.2.1.2.1

DBCA

see Database Configuration Assistant

dbconsole process

starting, 3.2

DBSNMP user, 7.1

dedicated server mode, 2.3.2.9.4

dedicated server process, 5.1.4.2

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

creating, A.7

dropping, A.8

dropping disks from, A.10

monitoring disk space usage, A.6

DMSYS user, 7.1

dropping

disks from Automatic Storage Management disk group, A.10

emctl

starting, 3.2

Enterprise Manager

backup, 9.3.2

backup and recovery, 9.2.2

Enterprise Manager Console

starting, 3.2

Enterprise Manager Database Control

description, 3.1

features, 3.1.1

granting administrative privileges to use, 3.4

online help, 3.1.2

starting, 3.3

EXAMPLE tablespace, 6.1.6.5

configuring, 2.3.2.8

failure group, Automatic Storage Management, A.2

file

loading, 8.2.6

flash recovery area, 9.1.1.3

configuring, 9.2.3

planning, 9.2.1.2

retention policy, 9.2.1.1

specifying, 2.3.2.7

flashback drop

description, 9.4.4

Flashback Table

steps, 9.4.3.2

flashback table

description, 9.4.3

functions

compile, 8.5.3

create, 8.5.3

definition, 8.5.3

delete, 8.5.3

execute, 8.5.3

modify, 8.5.3

global database name, 2.1.2.1

global indexes, 8.3.1.2.5

grid control

configuring, 2.3.2.3

host credentials, B.5.1

indexes

creating, 8.3.3

description, 8.3.1

global, 8.3.1.2.5

local, 8.3.1.2.5

partitioned, 8.3.1.2.5

initialization parameter file

server parameter file, 5.1.1

initialization parameters

description, 5.1.1

memory parameters, 5.4

viewing, 5.3

installation

checking prerequisites, 2.1.1

choices, 2.1.2

steps, 2.2

using DBCA for database, 2.3

instance

database instance, 5.1

management, 5.1

memory structure, 5.1.2

Oracle instance, 5.1

shutdown, 5.1.4.1.2

startup, 5.1.4.1.1

isqlplus

starting, 3.6.2

listener

starting, 4.4

listener.ora file, 4.1.1

loading data, 8.2.6

LOB columns, 8.2.1.5

local database management

configuring, 2.3.2.3

local indexes, 8.3.1.2.5

MDDATA user, 7.1

MDSYS user, 7.1

media recovery, 9.1.1.2

memory

auto tuning, 5.4

configuring, 2.3.2.9.1

managing, 5.4

Memory Advisor

description, 10.3.1

using, 10.3.4

mirroring, Automatic Storage Management, A.1

Net Manager tool, 4.5

network

configuring client, 4.5

network configuration

connection requests, 4.1.1

description, 4.1

notification of alerts

alert notification, 3.5

OLAPSYS user, 7.1

Oracle listener

starting, 4.4

Oracle Net

description, 4.1, 5.1.4.3

listener configuration, 4.1.1

mapping methods, 4.1.4

directory naming, 4.1.4.2

easy connect naming, 4.1.4.3

external naming, 4.1.4.4

local naming, 4.1.4.1

Oracle Net Configuration Assistant

description, 4.2.1

oracle system identifier, 2.1.2.1

ORDPLUGINS user, 7.1

ORDSYS user, 7.1

OSDBA, B.5.1

OUTLN user, 7.1

package bodies

compile, 8.5.2

create, 8.5.2

definition, 8.5.2

delete, 8.5.2

modify, 8.5.2

packages

compile, 8.5.1.3

definition, 8.5.1.1, 8.5.2.1

modify, 8.5.1.3

partitioned indexes, 8.3.1.2.5

password files, 6.1.7.2

PGA Advisor

description, 10.3.1

PGA target

setting, 10.3.4

preferred credentials, 3.5

setting, 3.5.2

privileges

connection, 5.1.4.1

object, 7.2.1

SYSDBA, 9.2.2

system, 7.2.1

procedures

compile, 8.5.3

create, 8.5.3

definition, 8.5.3

delete, 8.5.3

execute, 8.5.3

modify, 8.5.3

profiles

administering, 7.3

program global area (PGA)

components, 5.1.2.2

description, 5.1.2.2

rebalancing, Automatic Storage Management, A.1

recovery

complete, 9.1.1.2

configuring, 2.3.2.7

flash recovery area, 9.1.1.3

incomplete, 9.1.1.2

media, 9.1.1.2

overview, 9.1

whole database recovery, 9.4.1, 9.4.1

Recovery Manager (RMAN)

repository, 9.1.1.4

redo log files

description, 6.1.2

multiplexing, 6.1.2, 6.1.2.2

roles

administering, 7.2

description, 7.2.1

granting, 7.4.3.3

viewing, 7.2.3

rollback segments

description, 6.1.4

sample schemas

configuring, 2.3.2.8

schema objects

accessing, 8.1.1

database links, 8.6

description, 8.1

indexes, 8.3.1

creating, 8.3.3

sequences, 8.6

synonyms, 8.6

tables, 8.2.1

constraints, 8.2.1.3

modifying, 8.2.5

views, 8.4.1

Segment Advisor

description, 10.3.1

using, 6.2.5

sequences

description, 8.6

server parameter file, 5.1.1

server processes

description, 5.1.4.2

services

on Windows, 5.2.1

SGA target

setting, 10.3.4

Shared Pool Advisor

description, 10.3.1

shared server mode, 2.3.2.9.4

shared server process, 5.1.4.2

shut down database

Windows, 5.2.1

shutdown

database, 5.2

SI_INFORMTN_SCHEMA user, 7.1

SID, 2.1.2.1

software

steps for installing, 2.2

source types

description, 8.5

managing, 8.5

SQL Access Advisor

description, 10.3.1

using, 10.3.3

SQL statements

about, 3.6

SQL Tuning Advisor

description, 10.3.1

using, 10.3.2

sqlplus

starting, 3.6.1

standalone subprograms

compile, 8.5.3

create, 8.5.3

definition, 8.5.3

delete, 8.5.3

execute, 8.5.3

modify, 8.5.3

starting database

Windows, 5.2.1

startup

database, 5.2

synonyms

description, 8.6

SYS user, 5.1.4.1, 7.1

SYSAUX tablespace, 6.1.6.5

SYSMAN user, 7.1

system global area (SGA)

components, 5.1.2.1

description, 5.1.2.1

SYSTEM tablespace, 6.1.6.5

SYSTEM user, 5.1.4.1, 7.1

table partitions, 8.2.1.5

tables

compressed, 8.2.1.5

creating, 8.2.4

description, 8.2.1

estimating size, 8.2.4.1

LOB columns, 8.2.1.5

modifying, 8.2.5

partitioned, 8.2.1.5

tablespaces

creating, 6.2.2

data block, 6.1.6

description, 6.1.6

EXAMPLE, 6.1.6.5

modifying, 6.2.3

Segment Advisor, 6.2.3

segments

extents, 6.1.6

SYSAUX, 6.1.6.5

SYSTEM, 6.1.6.5

TEMP, 6.1.6.5

UNDOTBS1, 6.1.6.5

USERS, 6.1.6.5

TEMP tablespace, 6.1.6.5

templates

creating databases with, 2.3.2.1

using with DBCA, 2.3.5

tnsnames.ora file

configuring, 4.5

triggers

compile, 8.5.4

create, 8.5.4

definition, 8.5.4

modify, 8.5.4

undo

advisor, 6.3.5

automatic undo management, 6.3.2

managing, 6.3

with Enterprise Manager, 6.3.4

Undo Advisor

description, 10.3.1

undo tablespace, 6.3.2

extending, 6.3.5.2

UNDOTBS1 tablespace, 6.1.6.5

upgrading a database, 2.4.4

steps, 2.4.4

user accounts

description, 7

unlocking, 7.4.3.2

users

creating, 7.4.1

CTXSYS, 7.1

DBSNMP, 7.1

DMSYS, 7.1

MDDATA, 7.1

MDSYS, 7.1

OLAPSYS, 7.1

ORDPLUGINS, 7.1

ORDSYS, 7.1

OUTLN, 7.1

provided by Oracle, 7.1

SI_INFORMTN_SCHEMA, 7.1

SYS, 7.1

SYSMAN, 7.1

SYSTEM, 7.1

USERS tablespace, 6.1.6.5

views

description, 8.4.1