Skip Headers
Oracle® Database 2 Day DBA
12c Release 1 (12.1)

E17643-13
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
PDF · Mobi · ePub

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.4.5.1
table constraints, 8.4.5.3
ADDM
responding to findings, 10.2.2
See Automatic Database Diagnostics Monitor
viewing findings, 10.2.1
administering
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.7.1
performance, 10.3.1
PGA Advisor, 10.3.1, 10.3.1
SGA Advisor, 10.3.1
SQL Tuning Advisor, 10.3.1
using, 10.3.6
Undo Advisor, 6.5.4, 10.3.1
ALTER SYSTEM statement, 5.3
archived redo log files
advantages of using, 2.3.2.7
description of, 2.3.2.7, 6.1.3
viewing, 6.2.3
ARCHIVELOG mode, 2.3.2.7
archiving, 2.3.2.7
ARCn processes, 5.1.2
ASM. See Oracle ASM
autobackup
of control file and server parameter file, 9.3.5.3
autoextend
data files and tablespaces, 6.1.6.4
Automatic Database Diagnostics Monitor (ADDM)
description, 10.3.1
findings, 10.1.3
overview, 10.1.3
snapshots, 10.1.3
viewing performance analysis, 10.2
automatic memory management, 2.3.2.9.1, 5.4.1
enabling, 5.4.2
modifying settings, 5.4.3
automatic PGA memory management
modifying settings, 5.4.8
automatic shared memory management, 2.3.2.9.1, 5.4.1
modifying settings, 5.4.5
Automatic SQL Tuning Advisor
about, 10.3.3
configuring, 10.3.4
viewing results, 10.3.5

B

background processes
and database configuration, 2.3.2.9.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.2.3
consistent, 9.2.5
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.2.4
image copies, 9.2.3
inconsistent, 9.2.5
incremental backup of data files, 9.2.4
listing, 9.4.3
making unavailable, 9.6.4
managing, 9.6
obsolete, 9.6.1
overview, 9.1
sets, 9.2.3
settings, 9.3.5
tags, 9.4.1.2
unavailable, 9.6.1
validating, 9.4.4
whole database backup, 9.4.2.1
backup and recovery area
specifying during database creation, 2.3.2.7
BasicFiles LOBs, 8.4.1.4.4
block size
configuring for the database, 2.3.2.9.2
Buffer Cache Advisor
description, 10.3.1

C

CDBs
creating, 2.1, 2.2, 2.3.2.1, 2.3.2.3
managing, 3.3
character sets, 2.1.2.7
defining, 2.3.2.9.3
description, 2.3.2.9.3
checkpoint
of the database, 5.1.2
checkpoint process, 5.1.2
classes, Java, 8.7.1
CLOB data type, 8.4.1.2.1
code
database-resident, 8.7.1
columns
adding, 8.4.5.1
deleting, 8.4.5.2
compiling schema objects, 8.7.2
compressed tables, 8.4.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.9.4
connection privileges
SYSDBA, 5.1.5.1
SYSOPER, 5.1.5.1
constraints, 8.4.1.3
adding, 8.4.5.3
deleting, 8.4.5.5
modifying, 8.4.5.4
control files
description, 6.1.1
multiplexing, 6.1.1
creating
databases
overview, 2.1
steps, 2.2
using standalone DBCA, 2.3
indexes, 8.5.3
tables, 8.4.4
users, 7.5.2
Current ADDM Findings
responding to findings, 10.2.6
viewing findings, 10.2.5
customized repairs, 9.8

D

data
loading, 8.4.6
data blocks
description of, 2.3.2.9.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.2.3
data blocks, 6.1.5
description of, 6.1.5
extents, 6.1.5
full backups, 9.2.4
incremental backups, 9.2.4
media recovery, 9.2.6
missing, 9.1
recovering from the loss of, 9.8.4
recovery without restoration, 9.1
restoring from consistent and inconsistent backups, 9.2.5
segments, 6.1.5
tempfiles, 6.1.5
data integrity, 8.4.1.3
Data Recovery Advisor, 9.7
data types
CLOB, 8.4.1.2.1
DATE, 8.4.1.2.1
NUMBER, 8.4.1.2.1
overview, 8.4.1.2.1
user-defined, 8.4.1.4.1
VARCHAR2, 8.4.1.2.1
database
domain, 2.1.2.6
global name, 2.1.2.6
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 edition, 2.1.2.3
database links
description, 8.8
database management
configuring Oracle Enterprise Manager Database Express for, 2.3.2.4
registering with Oracle Enterprise Manager Cloud Control, 2.3.2.4
database objects
naming, 8.1
Database Upgrade Assistant (DBUA)
overview, 11.2.1
restrictions on releases, 11.2.2
starting, 11.2.3
steps for upgrading, 11.2.4
database-resident program code, 8.7.1
databases
advisors
using, 10.3.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 Express, 3
monitoring
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.6
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, 11.2, 11.2.4
users, 7
using DBCA templates, 2.3.5
datafiles
autoextend, 6.3.2.2
datafiles for undo tablespaces
changing to fixed-size, 6.5.6
DATE data type, 8.4.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.9.4
dedicated server processes, 5.1.3
deinstall tool
location, 11.3
syntax and options, 11.3
deleting
constraints, 8.4.5.5
databases, 2.3.4
table columns, 8.4.5.2
tables, 8.4.7
users, 7.5.9
views, 8.6.4
directory
Oracle base, 2.1.2.4
Oracle inventory, 2.1.2.4
dropping
tablespaces, 6.3.3
undoing with Flashback Drop, 9.8.2.1
duplicating
databases, 2.3.5

E

EM Express
See Oracle Enterprise Manager Database Express
enabling
automatic memory management, 5.4.2
Enterprise Edition, 2.1.2.3
Enterprise Manager
See Oracle Enterprise Manager Database Express
EXAMPLE tablespace, 6.1.6
configuring, 2.3.2.8
expiring passwords
reasons for, 7.5.8
extending
datafiles, 6.3.2.2
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

fast recovery area, 9.2.7
configuring, 9.3.4.1
retention policies, 9.3.1.1
specifying during database creation, 2.3.2.7
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.7.1

G

global database name, 2.1.2.6
global indexes, 8.5.1.2
granting
privileges, 7.5.4
roles, 7.5.4

I

inactive, 6.4.2
incremental backups, 9.2.4
indexes
creating, 8.5.3, 8.5.3
description, 8.5.1
global, 8.5.1.2
viewing, 8.5.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.7.1

J

Java classes, 8.7.1
Java source code, 8.7.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.4.6
loading data, 8.4.6
LOB columns, 8.4.1.4.1
LOB storage
BasicFiles LOBs, 8.4.1.4.4
SecureFiles LOBs, 8.4.1.4.4
locally managed tablespaces, 6.1.6.1
locking and unlocking users, 7.5.7
log switch
description, 2.3.2.7

M

managing
memory, 5.4
manual shared memory management
modifying settings, 5.4.7
media recovery, 9.2.6
memory
configuring, 2.3.2.9.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.7.1
MMON process, 5.1.2
modifying
initialization parameters, 5.3
table attributes, 8.4.5
table constraints, 8.4.5.4
users, 7.5.6
multitenant container databases. See CDBs.

N

Net Configuration Assistant (NETCA)
description, 4.1.3
net service name, 4.1.2
NETCA
See Net Configuration Assistant (NETCA)
network configuration
connection requests, 4.1.1
description, 4.1
NUMBER data type, 8.4.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.7, 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.7
operating system groups, 2.1.2.7
Oracle ASM
installation, 2.1.2.5
Oracle Automatic Storage Management. See Oracle ASM.
Oracle base directory, 2.1.2.4
Oracle Enterprise Manager Cloud Control, 3.3
Oracle Enterprise Manager Database Express
configuring the HTTPS port, 3.5
description, 3.3
features, 3.3
managing databases, 3
setting the HTTPS port with the DBEXPRESS_HTTPS_PORT variable, 2.2
starting, 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

parameter file, 6.1.7
partitioned tables, 8.4.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, 11.1
patches, 11.1
PDBs
creating, 2.1, 2.2, 2.3.2.1, 2.3.2.3
managing, 2.3.6, 3.3
PGA
See Program Global Area
PGA Advisor
description, 10.3.1
pluggable databases. See PDBs.
PMON process, 4.1.1, 5.1.2
predefined roles, 7.2
privileges
administrative, 7.3
and synonyms, 8.8
authenticating SYSDBA, SYSOPER, and SYSBACKUP users, 6.1.7
connection, 5.1.5.1
for installation of Oracle Database software, 2.2
granting, 7.5.4
object, 7.2
recommended, 7.1
required for database administration, 3.7, 7.3
schema object management, 8.2
SYSDBA, 5.1.5.1
SYSOPER, 5.1.5.1
system, 7.2
users, 7.2
using roles to manage, 7.2
procedures, 8.7.1
profiles, 7.6.1
Program Global Area (PGA)
definition, 5.1.4.2
description, 5.1.4.2
target setting, 10.3.7.1

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
Real-Time ADDM
responding to findings, 10.2.4
viewing findings, 10.2.3
recovery
complete, 9.2.6
configuration, 2.3.2.7
fast recovery area, 9.2.7
incomplete, 9.2.6
media, 9.2.6
overview, 9.1
Recovery Manager (RMAN)
control file use, 9.2.2
overview, 9.1
recovery catalog, 9.2.2
repository, 9.2.2
recycle bins, 8.4.7
redo log files
See online redo log files or archived redo log files
repairs
customized, 9.8
Oracle suggested, 9.7
RESOURCE role, 7.2, 8.2
revalidating schema objects, 8.7.2
RMAN
backup, 9.4.2
roles
administering, 7.4
CONNECT, 7.2
DBA, 7.2, 8.2
granting, 7.5.4
predefined, 7.2
RESOURCE, 7.2, 8.2
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.8
installation of, 2.1.2.7
schema objects
compiling, 8.7.2
database links, 8.8
description of, 8.1
indexes, 8.5.1
creating, 8.5.3
viewing, 8.5.2
invalid, 8.7.1
privileges, 8.2
sequences, 8.8
synonyms, 8.8
tables, 8.4.1
constraints, 8.4.1.3
modifying, 8.4.5
validating, 8.7.2
views, 8.6.1
schemas, 7.1
SecureFiles LOBs, 8.4.1.4.4
security options, 2.1.2.7
segments
description of, 6.1.5
sequences
description, 8.8
server parameter files, 5.1, 5.1.1
server processes
description, 5.1.3
services
on Microsoft Windows, 5.2.2
setting
password policies, 7.6
SGA
See System Global Area
Shared Pool Advisor
description, 10.3.1
shared server mode, 2.3.2.9.4
shared server processes, 5.1.3
shutting down databases
Microsoft Windows, 5.2.2
SID, 2.1.2.6
SMON process, 5.1.2
snapshots, 10.1.3
source code, Java, 8.7.1
SQL Advisors
about, 10.3.2
description, 10.3.1
SQL Profile, 10.3.3
SQL statements
about, 3.8.1
SQL Tuning Advisor
about, 10.3.2
using, 10.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.7.1
synonyms
and privileges, 8.8
description, 8.8
SYS user, 5.1.5.1, 7.3.1
SYSAUX tablespace, 6.1.6
SYSBACKUP privilege
and the password file, 6.1.7
granting, 9.3.2.2
SYSDBA, 2.1.2.7
SYSDBA system privilege, 5.1.5.1, 6.1.7, 7.3.2
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.7.1
system identifier (SID), 2.1.2.6
system privileges, 7.2
SYSDBA and SYSOPER, 7.3.2
SYSTEM tablespace, 6.1.6
SYSTEM user, 5.1.5.1, 7.3.1

T

tables
adding columns to, 8.4.5.1
adding constraints, 8.4.5.3
compressed, 8.4.1.4.4
creating, 8.4.4
deleting, 8.4.7
deleting columns, 8.4.5.2
deleting constraints, 8.4.5.5
description, 8.4.1
loading data into, 8.4.6
LOB columns, 8.4.1.4.1
modifying attributes, 8.4.5
modifying constraints, 8.4.5.4
partitions, 8.4.1.4.2
retrieving a dropped table, 9.8.2.2
viewing data in, 8.4.3
viewing information about, 8.4.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
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.4
TEMP tablespace, 6.1.6
templates
creating databases with, 2.3.2.2
using with DBCA, 2.3.5
temporary tablespaces, 6.1.6.2
triggers, 8.7.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, 11.2.4
user-defined data types, 8.4.1.4.1
users
accounts
administrative, 7.3
description, 7
administering, 7.5
creating, 7.5.2
deleting, 7.5.9
expiring passwords for, 7.5.8
locking and unlocking, 7.5.7
modifying, 7.5.6
privileges, 7.2
viewing, 7.5.1
USERS tablespace, 6.1.6

V

validating schema objects, 8.7.2
VARCHAR2 data type, 8.4.1.2.1
viewing
indexes, 8.5.2
initialization parameters, 5.3
table data, 8.4.3
table information, 8.4.2
users, 7.5.1
views, 8.6.2
views
deleting, 8.6.4
description, 8.6.1
displaying, 8.6.2

W

wizards
database creation, 2.3.2