Skip Headers
Oracle® Database 2 Day DBA
10g Release 2 (10.2)

Part Number B14196-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

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

B

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

C

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

D

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

E

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

F

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

G

global database name, 2.1.2.1
global indexes, 8.3.1.2.5
grid control
configuring, 2.3.2.3

H

host credentials, B.5.1

I

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

L

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

M

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

N

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

O

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

P

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

R

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

S

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

T

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

U

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

V

views
description, 8.4.1