Skip Headers
Oracle® Database 2 Day DBA
11g Release 2 (11.2)

Part Number E10897-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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
directory
Oracle base, 2.1.2.4
Oracle inventory, 2.1.2.4
disk discovery
in Oracle Automatic Storage Management, A.2
disk groups
adding disks to, A.8
creating, A.6
dropping, A.7
dropping disks from, A.9
monitoring disk space usage, A.5
overview, A.2
dropping
disk groups, A.7
disks from disk groups, A.9
tablespaces, 6.3.3
undoing with Flashback Drop, 9.8.2.1
duplicating
databases, 2.3.5
users, 7.5.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