340/340
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
A
active report
for Performance Hub data
[1]
adding
columns to a table
[1]
table constraints
[1]
ADDM
See:
Automatic Database Diagnostics Monitor (ADDM)
administering
users
[1]
administrative user accounts
SYS
[1]
,
[2]
SYSTEM
[1]
advisors
Automatic Database Diagnostics Monitor (ADDM)
[1]
Buffer Cache Advisor
[1]
description
[1]
Memory Advisor
using
[1]
performance
[1]
PGA Advisor
[1]
SGA Advisor
[1]
SQL Tuning Advisor
using
[1]
Undo Advisor
[1]
,
[2]
ALTER SYSTEM statement
[1]
archived redo log files
advantages of using
[1]
description of
[1]
,
[2]
viewing
[1]
ARCHIVELOG mode
[1]
archiving
[1]
ARCn processes
[1]
ASM
See:
Oracle ASM
autobackup
of control file and server parameter file
[1]
autoextend
data files and tablespaces
[1]
Automatic Database Diagnostics Monitor (ADDM)
description
[1]
findings
[1]
overview
[1]
responding to findings
[1]
snapshots
[1]
viewing findings
[1]
viewing performance analysis
[1]
automatic memory management
enabling
[1]
modifying settings
[1]
automatic PGA memory management
modifying settings
[1]
automatic shared memory management
modifying settings
[1]
Automatic SQL Tuning Advisor
about
[1]
configuring
[1]
viewing results
[1]
AWR report
for Performance Hub data
[1]
B
background processes
and database configuration
[1]
archiver (ARCn)
[1]
checkpoint
[1]
database writer (DBWn)
[1]
description
[1]
,
[2]
listener registration (LREG)
[1]
log writer (LGWR)
[1]
manageability monitor (MMON)
[1]
process monitor (PMON)
[1]
system monitor (SMON)
[1]
use by database instances
[1]
backup
available
[1]
backup pieces
[1]
consistent
[1]
cross-checking
[1]
,
[2]
deleting expired backups
[1]
deleting obsolete backups
[1]
expired
[1]
files
[1]
full backup of data files
[1]
image copies
[1]
inconsistent
[1]
incremental backup of data files
[1]
listing
[1]
making unavailable
[1]
managing
[1]
obsolete
[1]
overview
[1]
sets
[1]
settings
[1]
tags
[1]
unavailable
[1]
validating
[1]
whole database backup
[1]
backup and recovery area
specifying during database creation
[1]
BasicFiles LOBs
[1]
block size
configuring for the database
[1]
Buffer Cache Advisor
description
[1]
C
CDBs
cloning a PDB from a remote CDB
[1]
cloning a PDB in the same CDB
[1]
closing all the PDBs
[1]
closing a PDB
[1]
configuring Oracle Managed Files
[1]
creating
[1]
,
[2]
,
[3]
,
[4]
creating a new PDB from the seed
[1]
dropping a PDB
[1]
managing
[1]
modifying a resource plan
[1]
opening all the PDBs
[1]
opening a PDB
[1]
plugging in an unplugged PDB
[1]
unplugging a PDB
[1]
character sets
defining
[1]
description
[1]
checkpoint
of the database
[1]
checkpoint process
[1]
classes, Java
[1]
CLOB data type
[1]
code
database-resident
[1]
columns
adding
[1]
deleting
[1]
compiling schema objects
[1]
compressed tables
[1]
configuring
Automatic SQL Tuning Advisor
[1]
connect descriptors
description
[1]
example
[1]
connection modes
configuring
[1]
connection privileges
SYSDBA
[1]
SYSOPER
[1]
CONNECT role
[1]
connect strings
description
[1]
constraints
adding
[1]
deleting
[1]
modifying
[1]
control files
description
[1]
multiplexing
[1]
creating
databases
overview
[1]
steps
[1]
using standalone DBCA
[1]
indexes
[1]
tables
[1]
users
[1]
Current ADDM Findings
responding to findings
[1]
viewing findings
[1]
customized repairs
[1]
D
data
loading
[1]
database
domain
[1]
global name
[1]
database administration
privileges required
[1]
database checkpoint
[1]
Database Configuration Assistant (DBCA)
configuring database options
[1]
deleting a databases
[1]
managing database templates
[1]
using to create a database
[1]
database configuration options
[1]
database edition
[1]
database links
description
[1]
database management
configuring Oracle Enterprise Manager Database Express for
[1]
registering with Oracle Enterprise Manager Cloud Control
[1]
database objects
naming
[1]
database-resident program code
[1]
databases
advisors
using
[1]
backup
description
[1]
backup and recovery
[1]
configuring options
[1]
creating with DBCA
[1]
deleting using DBCA
[1]
diagnosing performance problems
[1]
duplicating
[1]
managing
roadmap
[1]
with Oracle Enterprise Manager Database Express
[1]
monitoring
performance
[1]
overview of creating
[1]
performance
advisors
[1]
monitoring
[1]
recovery
description
[1]
point-in-time
[1]
restoring
description
[1]
starting and stopping on Microsoft Windows
[1]
steps for installing and creating
[1]
storage structure
logical structures
[1]
physical structures
[1]
tuning
[1]
upgrading
[1]
,
[2]
users
[1]
using DBCA templates
[1]
Database Upgrade Assistant (DBUA)
overview
[1]
restrictions on releases
[1]
starting
[1]
steps for upgrading
[1]
data blocks
description of
[1]
,
[2]
data dictionary tables
access to as user SYS
[1]
datafiles
autoextend
[1]
data files
and the Oracle Suggested Backup Strategy
[1]
autoextend
[1]
,
[2]
autoextend and Oracle Flashback
[1]
backing up
[1]
backups of only used blocks
[1]
data blocks
[1]
description of
[1]
extents
[1]
full backups
[1]
incremental backups
[1]
media recovery
[1]
missing
[1]
recovering from the loss of
[1]
recovery without restoration
[1]
restoring from consistent and inconsistent backups
[1]
segments
[1]
tempfiles
[1]
datafiles for undo tablespaces
changing to fixed-size
[1]
data integrity
[1]
Data Recovery Advisor
[1]
data types
CLOB
[1]
DATE
[1]
NUMBER
[1]
overview
[1]
user-defined
[1]
VARCHAR2
[1]
DATE data type
[1]
DBA role
[1]
,
[2]
DBUA
See:
Database Upgrade Assistant
DBWn processes
[1]
dedicated server mode
[1]
dedicated server processes
[1]
deinstall tool
location
[1]
syntax and options
[1]
deleting
constraints
[1]
databases
[1]
table columns
[1]
tables
[1]
users
[1]
views
[1]
directory
Oracle base
[1]
Oracle inventory
[1]
dropping
tablespaces
[1]
undoing with Flashback Drop
[1]
duplicating
databases
[1]
E
EM Express
See:
Oracle Enterprise Manager Database Express
enabling
automatic memory management
[1]
Enterprise Edition
[1]
Enterprise Manager
See:
Oracle Enterprise Manager Database Express
EXAMPLE tablespace
configuring
[1]
expiring passwords
reasons for
[1]
extending
datafiles
[1]
tablespaces
[1]
,
[2]
tablespaces and Oracle Flashback
[1]
undo tablespaces
[1]
extents
description of
[1]
F
fast recovery area
configuring
[1]
retention policies
[1]
specifying during database creation
[1]
Flashback Database
[1]
Flashback Drop
[1]
flashback features
Flashback Database
[1]
Flashback Drop
[1]
Flashback Table
[1]
Flashback Table
[1]
,
[2]
functions, PL/SQL
[1]
G
global database name
[1]
global indexes
[1]
granting
privileges
[1]
roles
[1]
H
HTTPS port
determining for a CDB
[1]
determining for a non-CDB
[1]
determining for a PDB
[1]
I
incremental backups
[1]
indexes
creating
[1]
description
[1]
global
[1]
viewing
[1]
initialization parameter file
[1]
initialization parameters
description
[1]
how they are used by the database
[1]
server parameter files
[1]
,
[2]
viewing and modifying
[1]
installation
checking prerequisites
[1]
choices
[1]
overview
[1]
software location
[1]
steps
[1]
storage options
[1]
using DBCA for database
[1]
instances
database instances
[1]
management
[1]
memory structure
[1]
Oracle instances
[1]
PGA
definition
[1]
shutdown
[1]
startup
[1]
invalid schema objects
[1]
J
Java classes
[1]
Java source code
[1]
L
language
used by software
[1]
LGWR process
[1]
licensed software options
[1]
listener.ora files
[1]
listeners
See:
Oracle listeners
Load Data wizard
using
[1]
loading data
[1]
LOB columns
[1]
LOB storage
BasicFiles LOBs
[1]
SecureFiles LOBs
[1]
locally managed tablespaces
[1]
locking and unlocking users
[1]
log switch
description
[1]
LREG process
[1]
M
managing
memory
[1]
manual shared memory management
modifying settings
[1]
media recovery
[1]
memory
configuring
[1]
management
[1]
,
[2]
,
[3]
requirements
[1]
structure of in an Oracle instance
[1]
Memory Advisors
description
[1]
using
[1]
MMON process
[1]
modifying
initialization parameters
[1]
table attributes
[1]
table constraints
[1]
users
[1]
multitenant container databases
See:
CDBs.
N
NETCA
See:
Net Configuration Assistant (NETCA)
Net Configuration Assistant (NETCA)
description
[1]
net service name
[1]
network configuration
connection requests
[1]
description
[1]
NUMBER data type
[1]
O
object privileges
[1]
offline tablespaces
[1]
,
[2]
online redo log files
current
[1]
description of
[1]
,
[2]
multiplexing
[1]
,
[2]
switching
[1]
viewing
[1]
online redo log groups
description of
[1]
inactive
[1]
operating system groups
[1]
ORACLE_BASE environment variable
[1]
ORACLE_HOME environment variable
[1]
Oracle ASM
installation
[1]
Oracle Automatic Storage Management
See:
Oracle ASM.
Oracle base directory
[1]
Oracle Enterprise Manager Cloud Control
[1]
Oracle Enterprise Manager Database Express
configuring the HTTPS port
[1]
configuring the HTTPS port for a CDB
[1]
configuring the HTTPS port for a non-CDB
[1]
configuring the HTTPS port for a PDB
[1]
description
[1]
features
[1]
managing databases
[1]
setting the HTTPS port with the DBEXPRESS_HTTPS_PORT variable
[1]
starting
[1]
starting for a CDB
[1]
starting for a non-CDB
[1]
starting for a PDB
[1]
Oracle inventory directory
[1]
Oracle listeners
listener.ora file
[1]
starting
[1]
Oracle Managed Files
configuring for a CDB
[1]
Oracle Net
description
[1]
listener configuration
[1]
,
[2]
mapping methods
directory naming
[1]
easy connect naming
[1]
local naming
[1]
Oracle suggested repair
[1]
Oracle system identifier
[1]
P
parameter file
[1]
partitioned tables
[1]
password file
[1]
password policies
default
[1]
description of
[1]
setting
[1]
passwords
expiring
[1]
patches
[1]
patch sets
[1]
PDBs
cloning from a PDB in a remote CDB
[1]
cloning from a PDB in the same CDB
[1]
closing all the PDBs in a CDB
[1]
closing a PDB in a CDB
[1]
creating
[1]
,
[2]
,
[3]
,
[4]
creating from the seed
[1]
dropping a PDB from a CDB
[1]
managing
[1]
,
[2]
,
[3]
managing with Containers page
[1]
opening all the PDBs in a CDB
[1]
opening a PDB in a CDB
[1]
plugging in an unplugged PDB
[1]
setting resource limits
[1]
setting storage limits
[1]
unplugging a PDB from a CDB
[1]
Performance Hub
saving AWR data to a report
[1]
saving data to a report
[1]
viewing performance data
[1]
PGA
See:
Program Global Area
PGA Advisor
description
[1]
pluggable databases
See:
PDBs.
PMON process
[1]
predefined roles
[1]
privileges
administrative
[1]
and synonyms
[1]
authenticating SYSDBA, SYSOPER, and SYSBACKUP users
[1]
connection
[1]
for installation of Oracle Database software
[1]
granting
[1]
object
[1]
recommended
[1]
required for database administration
[1]
,
[2]
schema object management
[1]
SYSDBA
[1]
SYSOPER
[1]
system
[1]
users
using roles to manage
[1]
procedures
[1]
profiles
[1]
Program Global Area (PGA)
definition
[1]
description
[1]
target setting
[1]
Q
quotas
assigning for a tablespace
[1]
R
read consistency
[1]
read only tablespaces
[1]
read write tablespaces
[1]
Real-Time ADDM
responding to findings
[1]
viewing findings
[1]
recovery
complete
[1]
configuration
[1]
fast recovery area
[1]
incomplete
[1]
media
[1]
overview
[1]
Recovery Manager (RMAN)
control file use
[1]
overview
[1]
recovery catalog
[1]
repository
[1]
recycle bins
[1]
redo log files
See:
online redo log files or archived redo log files
repairs
customized
[1]
Oracle suggested
[1]
RESOURCE role
[1]
,
[2]
revalidating schema objects
[1]
RMAN
backup
[1]
roles
administering
[1]
CONNECT
[1]
DBA
[1]
,
[2]
granting
[1]
predefined
[1]
RESOURCE
[1]
,
[2]
using to manage user privileges
[1]
viewing
[1]
rollback
[1]
rollback segments
description
[1]
S
sample schemas
configuring
[1]
installation of
[1]
schema objects
compiling
[1]
database links
[1]
description of
[1]
indexes
creating
[1]
viewing
[1]
invalid
[1]
privileges
[1]
sequences
[1]
synonyms
[1]
tables
constraints
[1]
modifying
[1]
validating
[1]
views
[1]
schemas
[1]
SecureFiles LOBs
[1]
security options
[1]
segments
description of
[1]
sequences
description
[1]
server parameter files
[1]
,
[2]
server processes
description
[1]
services
on Microsoft Windows
[1]
setting
password policies
[1]
SGA
See:
System Global Area
Shared Pool Advisor
description
[1]
shared server mode
[1]
shared server processes
[1]
shutting down databases
Microsoft Windows
[1]
SID
[1]
SMON process
[1]
snapshots
[1]
source code, Java
[1]
SQL Advisors
about
[1]
description
[1]
SQL Profile
[1]
SQL statements
about
[1]
SQL Tuning Advisor
about
[1]
using
[1]
Standard Edition
[1]
starting databases
Microsoft Windows
[1]
startup and shutdown
about
[1]
privileges required for
[1]
subprograms
[1]
synonyms
and privileges
[1]
description
[1]
SYSAUX tablespace
[1]
SYSBACKUP privilege
and the password file
[1]
granting
[1]
SYSDBA
[1]
SYSDBA system privilege
[1]
,
[2]
,
[3]
SYSOPER
[1]
SYSOPER system privilege
[1]
,
[2]
System Global Area (SGA)
components
[1]
description
[1]
target setting
[1]
system identifier (SID)
[1]
system privileges
SYSDBA and SYSOPER
[1]
SYSTEM tablespace
[1]
SYSTEM user
[1]
,
[2]
SYS user
[1]
,
[2]
T
tables
adding columns to
[1]
adding constraints
[1]
compressed
[1]
creating
[1]
deleting
[1]
deleting columns
[1]
deleting constraints
[1]
description
[1]
loading data into
[1]
LOB columns
[1]
modifying attributes
[1]
modifying constraints
[1]
partitions
[1]
retrieving a dropped table
[1]
viewing data in
[1]
viewing information about
[1]
tablespaces
autoextend
[1]
,
[2]
autoextend and Oracle Flashback
[1]
creating
[1]
description
[1]
dropping
[1]
EXAMPLE
[1]
extending undo tablespaces
[1]
locally managed
[1]
modifying
[1]
offline
[1]
quotas
[1]
read only and read write
[1]
Segment Advisor
[1]
SYSAUX
[1]
SYSTEM
[1]
taking offline
[1]
TEMP
[1]
temporary tablespaces
[1]
types of
[1]
undo tablespaces
[1]
,
[2]
UNDOTBS1
[1]
USERS
[1]
viewing information about
[1]
templates
creating databases with
[1]
using with DBCA
[1]
temporary tablespaces
[1]
TEMP tablespace
[1]
triggers
[1]
U
undo
about
[1]
advisor
[1]
managing
[1]
,
[2]
tablespaces
[1]
viewing
[1]
Undo Advisor
computing minimum undo tablespace size with
[1]
description
[1]
setting minimum undo retention period with
[1]
undo retention
[1]
undo retention period
setting with Undo Advisor
[1]
undo tablespaces
autoextend
[1]
changing to fixed-size
[1]
computing minimum size for fixed-size tablespace
[1]
default configuration
[1]
description of
[1]
UNDOTBS1 tablespace
[1]
upgrading a database
[1]
user-defined data types
[1]
users
accounts
administrative
[1]
description
[1]
administering
[1]
creating
[1]
deleting
[1]
expiring passwords for
[1]
locking and unlocking
[1]
modifying
[1]
privileges
[1]
viewing
[1]
USERS tablespace
[1]
V
validating schema objects
[1]
VARCHAR2 data type
[1]
viewing
indexes
[1]
initialization parameters
[1]
table data
[1]
table information
[1]
users
[1]
views
[1]
views
deleting
[1]
description
[1]
displaying
[1]
W
wizards
database creation
[1]
Scripting on this page enhances content navigation, but does not change the content in any way.