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
- Optimizer Statistics Advisor 1
- performance 1
- PGA Advisor 1
- SGA Advisor 1
- SQL Tuning Advisor
  - using 1
- Undo Advisor 1 , 2
ALTER SYSTEM statement 1
application PDB
- managing with EM Express 1
application root
- managing with EM Express 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
- flashback 1
- managing 1
- managing PDBs with EM Express 1
- opening all the PDBs 1
- opening a PDB 1
- plugging in an unplugged PDB 1
- point-in-time recovery 1
- refreshing a refreshable PDB on demand 1
- relocating a PDB from a remote CDB 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
consumer group
- adding a comment for 1
- adding a new consumer group to a plan 1
- adding an existing group to a plan 1
- removing from a plan 1
- setting CPU directives for 1
- setting mapping rule priorities for 1
- setting mapping rules for 1
- setting parallel server directives for 1
- setting runaway query directives for 1
- setting session directives for 1
control files
- description 1
- multiplexing 1
creating
- databases
  - overview 1
  - steps 1
  - using standalone DBCA 1
- indexes 1
- tables 1
- users 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
- users 1
- using DBCA templates 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
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 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
- validating the impact of a change 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
Optimizer Statistics Advisor
- description 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 Data Guard
- tuning SQL statements on a standby 1 , 2
- viewing performance statistics on a standby 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
- flashback 1
- managing 1 , 2 , 3
- managing with Containers page 1
- managing with EM Express 1
- opening all the PDBs in a CDB 1
- opening a PDB in a CDB 1
- plugging in an unplugged PDB 1
- point-in-time recovery 1
- refreshing a refreshable PDB on demand 1
- relocating from a remote CDB 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 Management features
- accessing in EM Express 1
Resource Manager
- CDB plans 1
- consumer groups 1
- directives 1
- features in EM Express 1
- instance caging 1
- managing CDB and PDB workloads 1
- non-CDB plans 1
- PDB plans 1
- plans 1
- setting instance caging 1
- solutions for a CDB 1
- solutions for a non-CDB 1
- solutions for a PDB 1
resource plan
- adding a new consumer group 1
- adding an existing consumer group 1
- allocating shares to PDBs 1
- CDB plan 1
- changing the default PDB directive 1
- changing the directives for a PDB 1
- creating 1
- creating plans 1
- creating using Quick Setup 1
- default directive for PDBs 1
- deleting 1
- managing plans 1
- modifying 1
- non-CDB plan 1
- PDB plan 1
- removing a consumer group 1
- setting a comment for a consumer group 1
- setting a comment for a PDB directive 1
- setting as the currently active plan 1
- setting CPU directives for a consumer group 1
- setting mapping rule priorities for consumer groups 1
- setting parallel server directives for a consumer group 1
- setting runaway query directives for a consumer group 1
- setting session directives for a consumer group 1
- specifying utilization limits to PDBs 1
- viewing 1
- viewing all the plans 1
- viewing a plan 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
SPA Quick Check
- about 1
- configuring 1
- validating the impact of an initialization parameter change 1 , 2
- validating the impact of implementing a SQL profile 1 , 2
- validating the impact of implementing multiple SQL profiles 1 , 2
SQL Advisors
- about 1
- description 1
SQL Performance Analyzer
- about 1
- analysis 1
- comparing two SQL trials 1
- creating a post-change SQL trial 1
- creating a pre-change SQL trial 1
- creating a task 1
- specifying default settings 1
- SQL trial 1
- SQL tuning set 1
- task 1
SQL Performance Analyzer Quick Check
- See: SPA Quick Check
SQL profile
- validating the impact of implementing 1 , 2
- validating the impact of implementing multiple profiles 1 , 2
SQL statements
- about 1
SQL trial
- comparing a pre-change trial and post-change trial 1
- creating a post-change trial 1
- creating a pre-change trial 1
SQL Tuning Advisor
- about 1
- using 1
SQL tuning set
- about 1
- creating 1
- for SPA Quick Check 1
- for SQL Performance Analyzer 1 , 2
- loading 1
- transporting 1
standby database
- tuning SQL statements 1 , 2
- viewing performance statistics 1
starting databases
- Microsoft Windows 1
startup and shutdown
- about 1
- privileges required for 1
storage options
- specifying during database creation 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
test database
- creating 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
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