Skip Headers

Oracle® Database 2 Day DBA
10g Release 1 (10.1)

Part Number B10742-03
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
Feedback

Go to previous page
Previous
View PDF

Index

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

A

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

B

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

C

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

D

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

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.5.2
configuring, 2.3.2.8

F

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

G

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

I

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

L

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

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

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

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

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

R

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

S

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

T

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

U

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

V

views
description, 8.4