Index

administrative user accounts

SYS, 5.1.3.1

SYSTEM, 5.1.3.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.6, 10.3.1

archive log files

description, 6.1.3

ARCHIVELOG mode, 2.3.2.7

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 Workload Repository, 10.1.4.1

background processes

description, 5.1.2

backup

backup sets, 9.2.4.1.1

cataloging, 9.5

cataloging additional backups, 9.5.6

consistent, 9.1.1.1

crosschecking, 9.5, 9.5.2

deleting expired backups, 9.5.3

deleting obsolete backups, 9.5.4

expired, 9.5

full backup of datafiles, 9.3.1.1

image copies, 9.2.4.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, 9.5

Oracle-suggested backup strategy, 9.3.2.2

overview, 9.1

settings

configuring, 9.2.4

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

clusters

description, 8.6

compressed tables, 8.2.3.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.3.1

SYSOPER, 5.1.3.1

constraints, 8.2.3.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 integrity, 8.2.3.3

database

startup and shutdown, 5.2

Database Configuration Assistant

configuring database options, 2.3.4

deleting a database, 2.3.3

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

setting metrics, 10.1.4.2

setting notification rules, 10.1.4.3

viewing metrics, 10.1.4.1

backup

description, 9.1.1

backup and recovery, 9.1

configuring options, 2.3.4

creating with DBCA, 2.3

deleting using DBCA, 2.3.3

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

administering, 7.4

creating, 7.4.1

editing, 7.4.3

using DBCA templates, 2.3.5

datafiles

description, 6.1.6

datatypes

BFILE, 8.2.3.2.1

BLOB, 8.2.3.2.1

CHAR, 8.2.3.2.1

CLOB, 8.2.3.2.1

DATE, 8.2.3.2.1

description, 8.2.3.2.1

INTERVAL DAY TO SECOND, 8.2.3.2.1

INTERVAL YEAR TO MONTH, 8.2.3.2.1

LONG, 8.2.3.2.1

LONG RAW, 8.2.3.2.1

NCHAR, 8.2.3.2.1

NCLOB, 8.2.3.2.1

NUMBER, 8.2.3.2.1

NVARCHAR2, 8.2.3.2.1

overview, 8.2.3.2.1

RAW, 8.2.3.2.1

ROWID, 8.2.3.2.1

TIMESTAMP, 8.2.3.2.1

TIMESTAMP WITH LOCAL TIME ZONE, 8.2.3.2.1

TIMESTAMP WITH TIME ZONE, 8.2.3.2.1

UROWID, 8.2.3.2.1

VARCHAR2, 8.2.3.2.1

DB_UNIQUE_NAME

for backup and recovery, 9.2.5

DBCA

see Database Configuration Assistant

dbconsole process

starting, 3.2

DBID

for backup and recovery, 9.2.5

DBSNMP user, 7.1

DBUA

see Database Upgrade Assistant

dedicated server mode, 2.3.2.9.4

dedicated server process, 5.1.3.2

deleting a database, 2.3.3

DMSYS user, 7.1

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

configuring, 2.3.2.8

flash recovery area, 9.1.1.4

configuring, 9.2.3

planning, 9.2.1.2

retention policy, 9.2.1.1

specifying, 2.3.2.7

Flashback Drop

steps, 9.4.3

flashback drop

description, 9.4.3

Flashback Table

steps, 9.4.2.2

flashback table

description, 9.4.2

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

grid control

configuring, 2.3.2.3

indexes

creating, 8.3.2.2

description, 8.3

global, 8.3.2.1.5

local, 8.3.2.1.5

partitioned, 8.3.2.1.5

initialization parameter file

server parameter file, 5.1.4

initialization parameters

description, 5.1.4

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

description, 5.1

management, 5.1

memory structure, 5.1.1

Oracle instance, 5.1

shutdown, 5.1.3.1.2

startup, 5.1.3.1.1

isqlplus

starting, 3.6.2

listener

starting, 4.4

listener.ora file, 4.1.1

LOB columns, 8.2.3.5

local database management

configuring, 2.3.2.3

local indexes, 8.3.2.1.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

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

object privileges, 8.8

OLAPSYS user, 7.1

Oracle listener

starting, 4.4

Oracle Net

description, 4.1, 5.1.3.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

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

create, 8.5.1

definition, 8.5.1

delete, 8.5.1

modify, 8.5.1

partitioned indexes, 8.3.2.1.5

password files, 6.1.7.2

password management

installation, 2.2

PGA Advisor

description, 10.3.1

preferred credentials, 3.5

setting, 3.5.2

privileges

connection, 5.1.3.1

object, 7.2

schema objects, 8.8

SYSDBA, 9.2.2

system, 7.2

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

description, 5.1.1.2

recovery

complete, 9.1.1.2

configuring, 2.3.2.7

flash recovery area, 9.1.1.4

incomplete, 9.1.1.2

media, 9.1.1.2

overview, 9.1

whole database recovery, 9.4.1

Recovery Manager (RMAN)

description, 9.1

repository, 9.1.1.3

with Enterprise Manager, 9.1

redo log files

description, 6.1.2

multiplexing, 6.1.2, 6.1.2.1

roles

administering, 7.2

description, 7.2

granting, 7.4.3.2

viewing, 7.2.1

rollback segments

description, 6.1.4

sample schemas, 8.9.3

configuring, 2.3.2.8

schema objects

accessing, 8.1.1

clusters, 8.6

database links, 8.6

description, 8.1

indexes, 8.3

creating, 8.3.2.2

managing access to, 8.8

sequences, 8.6

synonyms, 8.6

tables, 8.2

constraints, 8.2.3.3

loading data, 8.7

modifying, 8.2.4

viewing, 8.2.1

views, 8.4

schemas

sample schemas, 8.9.3

SYS, 8.9.1

SYSTEM, 8.9.2

Segment Advisor

description, 10.3.1

using, 6.2.5

sequences

description, 8.6

server parameter file, 5.1.4

server processes

description, 5.1.3.2

services

on Windows, 5.2.1

Shared Pool Advisor

description, 10.3.1

shared server mode, 2.3.2.9.4

shared server process, 5.1.3.2

shut down database

Windows, 5.2.1

shutdown

database, 5.2

SI_INFORMTN_SCHEMA user, 7.1

SID, 2.1.2.1

defining during installation, 2.2

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

SQL*Loader, 8.7

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 schema, 8.9.1

SYS user, 5.1.3.1, 7.1

setting passwords, 2.2

SYSAUX tablespace, 6.1.5.2

SYSMAN user, 7.1

system global area (SGA)

components, 5.1.1.1

description, 5.1.1.1

SYSTEM schema, 8.9.2

SYSTEM tablespace, 6.1.5.2

SYSTEM user, 5.1.3.1, 7.1

setting passwords, 2.2

table partitions, 8.2.3.5

tables

compressed, 8.2.3.5

creating, 8.2.3

description, 8.2

estimating size, 8.2.3.6

loading data, 8.7

LOB columns, 8.2.3.5

modifying, 8.2.4

partitioned, 8.2.3.5

tablespaces

creating, 6.2.2

data block, 6.1.5

description, 6.1.5

EXAMPLE, 6.1.5.2

modifying, 6.2.3

Segment Advisor, 6.2.3

segments

extents, 6.1.5

SYSAUX, 6.1.5.2

SYSTEM, 6.1.5.2

TEMP, 6.1.5.2

UNDOTBS1, 6.1.5.2

USERS, 6.1.5.2

TEMP tablespace, 6.1.5.2

templates

creating databases with, 2.3.2.1

using with DBCA, 2.3.5

temporary tablespace groups, 6.1.5.3

tnsnames.ora file

configuring, 4.5

triggers

compile, 8.5.4

create, 8.5.4

definition, 8.5.4

delete, 8.5.4

modify, 8.5.4

undo

advisor, 6.3.6

automatic undo management, 6.3.2

description, 6.3.1

managing, 6.3

recommendations, 6.3.5

with Enterprise Manager, 6.3.4

Undo Advisor

description, 10.3.1

undo tablespace, 6.3.2

extending, 6.3.5.1

UNDOTBS1 tablespace, 6.1.5.2

upgrading a database, 2.4.4

steps, 2.4.4

user accounts

description, 7

unlocking, 7.4.3.1

users

administering, 7.4

creating, 7.4.1

CTXSYS, 7.1

DBSNMP, 7.1

DMSYS, 7.1

editing, 7.4.3

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

views

description, 8.4