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]