INDEX
SYMBOLS
@ symbol, Oracle Net sessions
A
abort shutdown mode
automatic recovery after
overview of
ABP0 background process
abstraction
directories providing layer of
of logical and physical storage
programs providing layer of
ACCEPT commands, DBCA creation scripts
accountability, auditing for
ACCOUNT_STATUS column, users
ACID (Atomicity, Consistency, Isolation, and Durability) test
database transactions
defined
undo generation
actions, unified auditing
Active Session History (ASH)
active session pool
method
self-test Q & A
using job classes
active undo data
can never be overwritten
configuring UNDO_RETENTION for keeping
error conditions
restricting generation of
tablespace
transactions using
adaptive executions
ADDM (Automatic Database Diagnostic Monitor)
database maintenance with
defined
generating reports
launched every hour by MMON
admin role, OS/password file authentication
Adobe Flash plug-in, Database Express logon
ADR (Automatic Diagnostic Repository)
ADRCI
Advanced Compression
Advanced Encryption Standard (AES)
Advanced Mode, DBCA
creating database
creation mode
using template
advanced row compression
Advanced Security Option
advancing the incremental checkpoint position. See incremental checkpoints
ADVISE FAILURE command, DRA
advisory framework
ADDM
automatic Undo Advisor
database maintenance with
DRA
memory advisors
MTTR
Segment Advisor
SQL Access Advisor
SQL Repair Advisor
SQL Tuning Advisor
AES (Advanced Encryption Standard)
AFTER SUSPEND ON DATABASE trigger
AL16UTF16
alert log
calculating location of
overview of
retrieving deadlock information
self-test Q & A
using
alert system
monitoring SYSAUX tablespace size
monitoring tablespace usage
setting thresholds
aliases
local naming name resolution
resolving in directory naming
allocation unit (AU), GI install
ALTER DATABASE
alert log
configuring ARCHIVELOG mode
resizing tablespace
system privileges
ALTER object privilege
ALTER SESSION command
ALTER SYSTEM command
active session pool method
alert log recording
enabling Resource Manager plan
protecting online redo logfiles
SET commands
solving lock contention
system privilege
ALTER SYSTEM UNQUIESCE
ALTER TABLESPACE command
changing default tablespace
marking tablespace as read-only
renaming tablespace and its datafiles
taking tablespace online or offline
uncompressing table before shrinking
ALTER USER commands
account status
altering account attributes
changing temporary tablespace
setting account quotas
American National Standards Institute (ANSI)
American Standard Code for Information Interchange (ASCII)
defined
finding SQL in library cache
pfile as
AMM (Automatic Memory Management)
defined
exercise
managing performance
overview of
PGA
self-test Q & A
SGA
using memory advisor
ANALYZE TABLE command
AND DATAFILES keyword, DROP TABLESPACE
anonymous PL/SQL
ANSI (American National Standards Institute)
ANY system privileges
APEX (Application Express)
API (application programming interface). See also PL/SQL
APIs
defined
Fine Grained Auditing
Oracle Call Interface
Scheduler
setting thresholds
Tuning Advisor
application development life cycle, performance tuning
architecture
ASM
background processes. See background processes
components
Data Pump
Grid Infrastructure
memory. See memory structures
physical and logical storage structures
Resource Manager
Scheduler
self-test Q & A
ARCHIVE LOG LIST command
archive redo log files
archiver processes in
ARCn process in
configuring
defined
enabling
setting location for
writing to fast recovery area
ARCHIVELOG mode
archiver process(es) and
configuring
database backup without shutdown
database created in NOARCHIVELOG mode
enabling
RMAN back up for
self-test Q & A
transitioning database to
ARCn (Archiver) background process
archive redo log files
online redo log files
as optional
overview of
reading online log files
arguments
CREATE_JOB in Scheduler
gathering statistics manually
ASCII (American Standard Code for Information Interchange)
defined
finding SQL in library cache
pfile as
ASH (Active Session History)
ASM (Automatic Storage Management)
architecture
configuring storage with GI
creating disk group during GI install
creating disks
defined
disks
GI architecture
lab exercise
self-test Q & A
storage locations
storage model
ASM_DISKSTRING parameter, ASM disks
ASMLib kernel library, ASM disks
ASMM (Automatic Shared Memory Management)
asmtool.exe utility
ASSM (Automatic Segment Space Management)
atomicity principle, transactions
attributes, user account
AU (allocation unit), GI install
AUDIT command
AUDIT_ADMIN role, unified auditing
auditing
DBA responsibilities for
Fine Grained Auditing
mandatory
overview of
reasons for
self-test Q & A
standard
unified
value-based
AUDIT_TRAIL parameter
AUDIT_VIEWER role, unified auditing
AUDSYS schema, unified auditing
authentication
Automatic Storage Management
creating accounts
database startup
external
OS or password file
overview of
password
techniques
authorization
Auto Segment, tablespaces
“Autocommit,” executing SQL
autoextend
configuring undo retention
creating undo tablespace
sizing undo tablespace
tablespaces
automatic database backups
Automatic Database Diagnostic Monitor. See ADDM (Automatic Database Diagnostic Monitor)
Automatic Diagnostic Repository (ADR)
automatic extensions, tablespaces
automatic locks
Automatic Memory Management. See AMM (Automatic Memory Management)
automatic segment space management
Automatic Segment Space Management (ASSM)
Automatic Shared Memory Management (ASMM)
automatic space management
Automatic Storage Management. See ASM (Automatic Storage Management)
automatic Undo Advisor
automatic undo management
autotask job
overview of
Segment Advisor running as
AWR (Automatic Workload Repository)
alert thresholds stored in
defined
exercise
gathering AWR statistics
managing
overview of
Segment Advisor using data in
SQL plan directives saved to
storing history of tablespace usage
AWR snapshots
defined
frequency of
generating ADDM to run automatically
managing
monitoring AWR
overview of
B
background processes
ARCn (Archiver)
CKPT (checkpoint process)
DBWn (database writer)
defined
exercise
generating trace files
implementing AMM
LGWR (log writer)
LREG (listener registration process)
MMAN (memory manager)
MMNL (manageability monitor light)
MMON (manageability monitor)
other
overview of
PGA in all
PMON (process monitor)
present in single instance
RECO (recover process)
self-test Q & A
shared server architecture
in single-instance database architecture
SMON (system monitor)
BACKGROUND_DUMP_DEST parameter
backup and recovery
archivelog mode and archiver process
archivelog mode configuration
archivelog mode, enabling
checkpointing
complete recovery
configuration
Data Recovery Advisor
defining recovery
fast recovery area configuration
impossibility of database corruption
instance recovery
protecting online redo logfiles
RDBMS backups
read-only tablespace for backup
self-test Q & A
backup and recovery operations
automating database backups
consistent database backups
database backup without shutdown
determining need for recovery
incremental backups
managing backups
overview of
RMAN and Data Recovery Advisor for
self-test Q & A
BACKUP DATABASE PLUS ARCHIVELOG, RMAN
backup sets, RMAN
basic parameters
batch processes
BFILE
bigfile databases
binary large object (BLOB)
bind variable
defined
using SQL*Loader
bitmaps in datafiles, local extents
BLOB (binary large object)
blocking sessions, lock contention
BLOCKING_SESSION column
blocks
automatic segment space management
datafiles in fixed-size
defined
executing SELECT statement
executing SQL statements
executing UPDATE statement
extents as consecutively numbered
operating system
Oracle data storage model
saving space with compression
storing table row data. See storage structures, table row data in blocks
BMR (Block Media Recovery)
buffer busy wait event, SQL statements
business needs, performance tuning for
C
cache. See database buffer cache
cardinality estimates, optimizer
CASCADE argument, DBMS_STATS
CASCADE keyword, SHRINK SPACE
case sensitivity
database identification
user account username
“cat” prefix
CATALOG command, RMAN backups
CATALOG.SQL
database creation scripts
making database usable
running after database creation
CATPROC.SQL
catuppst.sql
CBO (Cost Based Optimizer)
exercise
gathering statistics manually
how optimizer uses statistics
object statistics
overview of
self-test Q & A
SQL tuning with
central processing unit (CPU)
Change Tracking Writer (CTWR)
change vectors
executing COMMIT
executing INSERT
in log buffer
recovering files
single-instance databases
channels, RMAN
character large object (CLOB)
character sets
AL16UTF16
data migration advantages
defined
password best practices
specifying database
transporting tablespaces
Character Sets tab, DBCA
check constraint
checkpoints
backup and recovery
defined
DWBn background process for
CJQ0 background process, Scheduler
CKPT (Checkpoint Process)
clean (or consistent) shutdowns
client
configuring shared server for
shared server architecture
client-server architecture
defined
Oracle Net and
self-test Q & A
client-side files, SQL*Loader
client-side network, configuring
configuring Oracle Net
directory naming and external naming
Easy Connect name resolution
local naming name resolution
overview of
self-test Q & A
testing Oracle Net connectivity
CLOB (character large object)
closed (cold) backups
Cloud Control
cluster segment
clusters
columns
defined
FGA on certain
SQL Loader in express mode
statistics in DBA_TAB_COLUMNS
comma delimited fields, SQL Loader import/export
command-line utilities, Data Pump export/import
COMMIT
autocommit
background processes when user issues
causing LGWR to flush log buffer
database buffer cache and
defined
executing DML on rows
executing SQL
log buffer processing
RECO background process
releasing locks on rows in DML automatically
common queue, shared server architecture
communication between databases
COMPACT keyword, SHRINK SPACE
complete recovery
compliance issues, auditing
components, determining release number of
compressed backups, RMAN
compression
of exported data with Data Pump
saving space with
self-test Q & A
uncompressing before shrinking
configuration files, Oracle Net
Configure Database Options, DBCA
CONNECT command
connect identifier
CONNECT role
creating Resource Manager plan
defined
enabling
connect string
client-side network configuration
defined
Oracle Net connectivity test
Oracle Net sessions
Connection Mode tab, DBCA
connection pool
consistency principle, transactions
consistent backups
creating
defined
self-test Q & A
consistent (clean) shutdowns
constraints
AMM working with memory
check
data dictionary integrity
defined
enforced during direct path loads
external tables cannot have
consumer groups, Resource Manager
dividing resources between. See Resource Manager plans
monitoring Resource Manager
overview of
prioritizing jobs
switching
context switches, dedicated server limitations
control table, Data Pump
controlfile
Data Recovery Advisor repairing
defined
determining need for recovery
in nomount mode or complete shutdown
overview of
physical structure of database
pointers to other files within
querying dynamic performance views from
restricting online redo logfile groups
RMAN back up for
single-instance database architecture
SQL*Loader
transitioning instance to MOUNT mode
V$ views populated from
CONTROL_FILES parameter
CONVERT command, tablespaces
Coordinated Universal Time (UTC)
corruption, impossibility of database
cost-based optimization
Cost Based Optimizer. See CBO (Cost Based Optimizer)
CPU (central processing unit)
CPU cycles
CPU method, Resource Manager plans
“Create a database with default configuration” option, DBCA dialog
CREATE ANY TABLE system privilege
Create Database button, DBCA dialog
CREATE DATABASE command
creating database
files created by
restricting online redo logfile groups
Create Database, DBCA
generating database creation scripts
launching creation
using template
CREATE DIRECTORY command
CREATE PROFILE command
CREATE ROLE command
CREATE SESSION privilege
CREATE TABLE command
with basic/advanced compression
creating external table
permission for
system privilege
CREATE TABLESPACE command
Create Tablespace window, Database Express
CREATE USER command
CreateDB.sql
CREATE_FILE procedure, SQL Access Advisor
CREATE_JOB procedure, Scheduler
CREATE_JOB_CLASS procedure, Scheduler
CREATE_PROGRAM procedure, Scheduler
CREATE_SCHEDULE procedure, Scheduler
CREATE_WINDOW procedure, Scheduler
Creation Mode, DBCA dialog
Creation Options, DBCA dialog
creation scripts. See scripts, database creation
CROSSCHECK command, RMAN backups
alert log recording
checkpointing and
configuring ARCHIVELOG mode
consistent backups and
controlfile operations
database backup without
defined
dynamic performance views dropped at
exercise
OS/password file authentication for
overview of
self-test Q & A
crsctl utility, GI
architecture
confirming installation
controlling Oracle Restart manually
srvctl utility vs.
CTWR (Change Tracking Writer)
D
DAS (directly attached storage) devices, as ASM disks
data blocks
database buffer cache and
defined
DML and undo data generation
recovering corrupted
single-instance databases
writing change vectors to log buffer from
data concurrency
locking mechanism
monitoring/resolving locking conflicts
self-test Q & A
Data Definition Language. See DDL (Data Definition Language)
data dictionary views
adding
DBA views. See DBA views
defined
dynamic performance views vs.
querying tablespace information
recursive problem of
SGA memory structure
stored PL/SQL in
within SYSTEM tablespace
Data Guard
Data Manipulation Language. See DML (Data Manipulation Language)
data migration
Data Pump
architecture
capabilities
command-line utilities
defined
migrating data
resumable space allocation
self-test Q & A
tablespace export and import
Data Recovery Advisor. See DRA (Data Recovery Advisor)
Data Vault
Data Warehouse template, DBCA
database
creating database server with
data dictionary within
defined
determining release number
impossibility of corruption
database buffer cache
Data Pump using
defined
how transactions use undo segments
INSERT and DELETE statements
SELECT statement
SGA memory allocation to
SQL*Loader
UPDATE statement
Database Credentials, DBCA
Database Express
contacting with HTTP and HTTPS
creating tablespaces
detecting lock contention
inability to automate backups
initialization parameters
management options
managing initialization parameters
monitoring activity
overview of
performance pages
post-database upgrade tasks
undo configuration
Database Identification, DBCA
database identifier (DBID)
database links
defined
distributed transactions using
impact of domains on
implementing communication between databases
migrating data using Data Pump
moving data using
database listeners
Database Express
defined
dynamic service registration
establishing session in Oracle Net
preparing new Oracle Home prior to upgrade
GI architecture
self-test Q & A
shared server architecture
starting
database management system (DBMS)
database management tools
Database Express
exercise
logon as normal or privileged user
overview of
self-test Q & A
SQL Developer
SQL*Plus
Database Operation, DBCA
Database Options, DBCA
Database Resident Connection Pool. See DRCP (Database Resident Connection Pool)
Database Resource Manager. See Resource Manager
Database Template, DBCA
database transactions, ACID principles of
database upgrade. See upgrade process, database. See upgrade, database software
Database Upgrade Assistant. See DBUA (Database Upgrade Assistant)
Database Writer. See DBWn (Database Writer) background process
datafiles
assigning space to tablespaces
controlfile pointing to
corruption detected by alert log
Data Pump’s direct access to
Data Recovery Advisor repairing
defined
determining need for recovery
executing SELECT statement
executing UPDATE statement
formatted into fixed-size blocks
making consistent
online or offline
Oracle data storage model
physical structure of database
renaming
resizing tablespace with
RMAN back up for
SQL Loader in express mode and
SQL*Loader
tempfiles vs.
DATAPUMP_EXP_FULL_DATABASE role
DATAPUMP_IMP_FULL_DATABASE role
db file scattered read
DBA (database administrator)
defined
dictionary views. See DBA views
predefined role
responsibilities for auditing and security
role
DBA views
DBA_ALERT_HISTORY
DBA_AUTOTASK_CLIENT
DBA_DATA_FILES
DBA_DIRECTORIES
DBA_FREE_SPACE
DBA_HIST_TBSPC_SPACE_USAGE
DBA_INDEXES
DBA_OUTSTANDING_ALERTS
DBA_REGISTRY
DBA_RESUMABLE
DBA_RSRC_CONSUMER_ GROUPS
DBA_RSRC_PLAN_DIRECTIVES
DBA_RSRC_PLANS
DBA_SCHEDULER_JOB_LOG
DBA_SCHEDULER_JOB_RUN_ DETAILS
DBA_SCHEDULER_JOBS
DBA_SEGMENTS
DBA_TAB_COLUMNS
DBA_TABLES
DBA_TABLESPACES
DBA_TEMP_FILES
DBA_USERS
DB_BLOCK_SIZE parameter, DBCA
DBCA (Database Configuration Assistant)
configuring database options
creating database scripts
creating database templates
Database Express installation
defined
instance, database, and data dictionary
self-test Q & A
standard database auditing in
steps in creating database with
two-minute drill
DBCA (Database Configuration Assistant) dialog
Creation Mode
Creation Options
Database Credentials
Database Identification
Database Operation
Database Options
Database Template
exercise
Initialization Parameters
Management Options
Prerequisite Checks
Progress Page
Storage Locations
Summary
DB_CREATE_FILE_DEST parameter, OMF
DB_CREATE_ONLINE_LOG_DEST_n parameters
DB_DOMAIN parameter
DB_FILE_MULTIBLOCK_READ_COUNT parameter
DBID (database identifier)
DBMS (database management system)
DBMS_ RESOURCE_MANAGER.SWITCH_PLAN procedure
DBMS_ADVISOR package
DBMS_AUTO_TASK_ADMIN package
DBMS_FGA package
DBMS_RESOURCE_MANAGER package
DBMS_RESOURCE_MANAGER.CREATE_PLAN DIRECTIVE procedure
DBMS_RESOURCE_MANAGER_PRIVS package
DBMS_SCHEDULER API
DBMS_SCHEDULER package
CREATE_JOB procedure
CREATE_JOB_CLASS procedure
CREATE_PROGRAM procedure
CREATE_SCHEDULE procedure
CREATE_WINDOW procedure
defined
prioritizing jobs using job classes
DBMS_SPACE.ASA_RECOMMENDATIONS, Segment Advisor
DBMS_SQLDIAG package
DBMS_SQLTUNE, Tuning Advisor API
DBMS_STATS package
DB_NAME parameter
DB_RECOVERY_FILE_DEST parameter
DB_TIME parameter
DBUA (Database Upgrade Assistant)
functionality of
database upgrade to 12c
DBWn (Database Writer) background process
CKPT process and
clean shutdowns
defined
executing COMMIT
overview of
signaling LGWR to flush log buffer
writing blocks to datafiles
DDL (Data Definition Language)
auditing
autocommit
automatic locks
defined
logging
requiring exclusive lock on object
segment shrink
transaction control
usefulness of quiese
deadlocks
defined
exercise
overview of
Decision Support System (DSS)
dedicated server architecture
batch processing
configuring dedicated server for client
Database Resident Connection Pool and
limitations of
shared server vs.
DEFAULT profile, password limits
default roles, changing
default shared servers, configuring
default tablespace and quotas, user accounts
DEFAULT_CONSUMER_GROUP
DEFAULT_MAINTENANCE_PLAN directive
DEFAULT_PLAN directives
deferred segment creation
DEGREE argument, DBMS_STATS
DELETE
executing SQL
object privilege
reclaiming wasted space with segment shrink
rollback of
DELETE ANY TABLE system privilege
Delete Database, DBCA
DELETE EXPIRED, RMAN backups
DELETE OBSOLETE, RMAN backups
delimiter (/), Oracle Net sessions
demonstration groups, Resource Manager
DHCP (Dynamic Host Configuration Protocol)
DIAG, defined
DIAGNOSTIC_DEST parameter
alert log
Automatic Diagnostic Repository
location of background process trace files
dictionary extent management
dictionary-managed tablespaces
direct path
Data Pump export
defined
SQL*Loader loads
directives
Resource Manager plans
SQL plan
directly attached storage (DAS) devices, ASM disks
directories
naming in client-side networks
planning installation
directory objects
creating/using
defined
self-test Q & A
dirty buffers
CKPT instructing DBWn to write
DBWn writing to disk
defined
LGWR flushing log buffer
disk group, ASM
disk I/O, DWBn for
disks
ASM architecture
DBWn writing buffers to
planning installation
DISPATCHER process
dispatchers parameter
DISPLAY environment variable, DBCA on Linux
distributed systems architectures
distributed transactions, RECO
DML (Data Manipulation Language)
automatic row locks
change vectors
defined
executing UPDATE statement
reversing effects of. See undo data generation, and DML
running out of undo space
shared/exclusive locks
temporary undo segments
transaction control
value-base auditing
DMnn Data Pump Master process
DNS (Domain Name Service)
domain
Domain Name Service (DNS)
double quotes (“.””)
DRA (Data Recovery Advisor)
exercise
Health Monitor and ADR
overview of
self-test Q & A
using
DRCP (Database Resident Connection Pool)
self-test Q & A
understanding
when to use
DROP ANY TABLE system privilege
DROP TABLESPACE command
DROP USER commands
dropping tablespaces
dropping user accounts
DSS (Decision Support System)
dump files, Data Pump
architecture
export/import
migrating data
DWnn Data Pump worker processes
Dynamic Host Configuration Protocol (DHCP)
dynamic parameter file. See spfile (dynamic parameter file)
dynamic performance views
accessing
referenced in this book. See V$ views (dynamic performance)
self-test Q & A
using
dynamic sampling
dynamic service registration, Oracle Net
E
e-mail, resumable space allocation
easy connect
configuring client-side network
defined
using Database Resident Connection Pool
EBCDIC (Extended Binary Coded Decimal Interchange Code)
encryption, Data Pump exported data
end users
CREATE ANY DIRECTORY privilege
directory permissions for
END_DATE, CREATE_SCHEDULE procedure
endian format, exporting/importing tablespaces
Enterprise Manager
Database Express. See Database Express
invoking SQL Access Advisor in
management options
monitoring data
performance tuning methodology
reading alerts
scheduling database backups
self-test Q & A
entity-relationship diagram
environment variables
defined
launching DBCA on Linux
post-database upgrade tasks
equijoins
error conditions
alert condition monitoring and notifications
Health Monitor running during
trace files detecting
undo data
estimate facility, Data Pump
ESTIMATE_PERCENT argument, DBMS_STATS
event-based jobs, Scheduler
exclusive locks
executable code, unified auditing
EXECUTE object privilege
execution plans, optimizer statistics
execution time, Resource Manager plan
EXIT command, autocommit
expdp process, Data Pump jobs
EXPIRED status, user accounts
expired undo
exporting, data with Data Pump
express mode, SQL*Loader
Extended Binary Coded Decimal Interchange Code (EBCDIC)
Extensible Markup Language. See XML (Extensible Markup Language)
extents
adding
defined
describing
management of
Oracle data storage model
physical location of
external authentication, user accounts
external naming, client-side networks
external tables
Data Pump using path of
exercise
moving data via platform-independent files
overview of
querying
self-test Q & A
F
fact table
fast recovery area
configuring
configuring ARCHIVELOG mode
defined
self-test Q & A
using
FGA (Fine Grained Auditing)
files
Data Pump
directory
moving data via platform-independent
stored by ASM disk group
structuring datafiles and blocks on OS
Fix and Check Again button (Linux)
flagging tablespaces
flash recovery area
flashback logs
flashback query
flushing audit trail, unified auditing
flushing log buffer
foreground processes, accessing PGA memory
FORMAT keyword, RMAN backup
forward recovery process
FQDNs (fully qualified domain names)
fraud, deterring with auditing
free buffer wait event
free buffers
free space
full backups
full checkpoints
fully qualified domain names (FQDNs)
G
General-Purpose template, DBCA
Generate Database Creation Scripts, DBCA
GI (Grid Infrastructure)
configuring storage for ASM. See ASM (Automatic Storage Management)
installation exercise
installing for standalone server
Oracle Restart service. See Oracle Restart overview of
self-test Q & A
global authentication
Global Database Name
global temporary tables
GLTABS tablespace
GMT (Greenwich Mean Time)
GRANT ANY OBJECT PRIVILEGE
GRANT command, privileges
GRANULARITY argument, DBMS_STATS
graphical user interface (GUI)
Greenwich Mean Time (GMT)
grid computing
Grid Infrastructure. See GI (Grid Infrastructure)
groups
online log
OS authentication
Resource Manager consumer
temporary tablespace
guaranteed undo retention
GUI (graphical user interface)
H
HAS (High Availability Service)
GI architecture
GI installation for standalone server
in Oracle Restart
hash joins
HCC (Hybrid Columnar Compression)
header area, blocks
Health Monitor
hot (open) backups
HTTP (Hypertext Transfer Protocol)/HPPS
Database Express
defined
Hub page, Database Express
HWM (high water mark)
Data Pump
defined
direct path insert shifting
in segment shrink
using SQL*Loader
Hybrid Columnar Compression (HCC)
I
I/O, defined
IBM (International Business Machines)
idle time, Resource Manager
image copy
IMMEDIATE offline tablespace
immediate shutdown
checkpointing and
consistent backups after
exercise
no recovery required for
overview of
impdp process, Data Pump jobs
imperfect, object statistics as
implicit commit
importing data, Data Pump
INCLUDING CONTENTS keywords, dropping tablespaces
inconsistent backups
inconsistent shutdown, abort mode
incremental backups
incremental checkpoints
CKPT keeping track of position
defined
writing position to controlfile
writing to controlfile
incremental level 0 backup
Index Organized Table (IOT)
index partitions, segments
index statistics
how optimizer uses
overview of
SQL Access Advisor
indexes, reclaiming wasted space from
init file (static parameter file)
changing and querying
and initialization parameter file
working with
initialization parameter files
basic parameters
changing parameters
configuring shared server
database creation scripts
exercise
self-test Q & A
static and dynamic
understanding
Initialization Parameters, DBCA
init.ohasd daemon, Oracle Restart
INSERT ANY TABLE system privilege
INSERT statement
executing SQL
segment shrink
SQL*Loader
installation, Oracle Database software
Linux installation
OUI dialog, interactive install
OUI inventory
self-test Q & A
silent install and response files
Windows and Linux variations
Windows installation
installation planning, Oracle Database software
disk space and directories
obtaining software
prerequisite checks
self-test Q & A
supported platforms
user accounts
instance parameters
database identification with DB_NAME
defining instances
fast recovery area
inability to change DB_BLOCK_SIZE
PGA memory management
SGA memory management
instance recovery
defined
overview of
self-test Q & A
instance(s)
ASM and RDBMS
background processes
creating database server
database creation scripts. See scripts, database creation
defined
grouping in distributed systems
instance parameter file defining
processes occurring multiple times
sessions in Oracle Net against
single-instance database architecture
V$ views populated from
instance(s), managing database
alert log/dynamic performance views
initialization parameter files. See initialization parameter files
overview of
self-test Q & A
starting database listener
startup and shutdown
tools. See database management tools
two-minute drill
Inter-Process Communication (IPC) protocol
INTERNAL_PLAN directive
INTERNAL_QUIESCE plan directive
International Business Machines (IBM)
International Standards Organization (ISO)
Internet Protocol (IP)
INVALID STATUS, online redo logfiles
inventory, OUI
IOT (Index Organized Table)
IP (Internet Protocol)
IPC (Inter-Process Communication) protocol
iSCSI volumes, using as ASM disks
ISO (International Standards Organization)
isolation principle, database transactions
J
J2EE (Java 2 Enterprise Edition)
Java
caching code in shared pool
OUI written in
Java pool, SGA memory
Jnnn background processes, Scheduler
job chains, Scheduler
job classes, Scheduler
job queue coordinator, Scheduler
JOB_ACTION, Scheduler
JOB_CLASS attribute, job classes
JOB_NAME, Scheduler
JOB_QUEUE_PROCESSES parameter, Scheduler
jobs, Resource Manager
jobs, Scheduler
creating
prioritizing
programs
on remote systems
scheduling
self-contained
JOB_TYPE, Scheduler
joins
JVM (Java Virtual Machine)
K
Kerberos server
L
large object (LOB)
large pool
defined
SGA memory allocation to
SGA memory structure
SGA storing UGAs in
LDAP (Lightweight Directory Access Protocol)
defined
directory naming
global authentication of user accounts
Least Recently Used (LRU)
LGWR (Log Writer) background process
clean shutdowns
defined
executing COMMIT
flushing log buffer to online redo log on COMMIT
impossibility of database corruption
overview of
protecting online redo logfiles
library cache
licensing
DBCA Database Options
obtaining Oracle Database software
links. See database links
Linux
assigning resources
confirming log on to new database
creating ASM disks
external authentication for user account
GI install for standalone server
GI install on
launching DBCA
launching OUI interactively
mandatory auditing
Oracle database software installation
Oracle Restart database configuration
Oracle Restart processes
pointer file location
post-database upgrade tasks
prerequisite installation checks
static and dynamic parameter files
upgrading database to 12c with DBUA
LIST command, RMAN backups
LIST FAILURE command, DRA
listener. See also database listeners
Listener Control utility, Oracle Net
Listener Registration. See LREG (Listener Registration) background process
listener.ora file
configuring Oracle Net
creating database listener
example
self-test Q & A
storing with TNS_ADMIN
Listeners branch, Net Manager
listening port, HTTP(S), Database Express
LOB (large object)
lobindex segment
lobpartition segment
lobsegment
local extent management
local naming name resolution
LOCKED status, user accounts
locks
automatic and manual
data concurrency and
enqueue mechanism
self-test Q & A
shared and exclusive
two-minute drill
locks, monitoring/resolving conflicts
causes of contention
deadlocks
detecting contention
exercise
overview of
self-test Q & A
solving contention
two-minute drill
log archives, in alert log
log buffer
cannot be automatically managed
fixed in size at start time
flushing to disk on COMMIT
LGWR flushing
SGA memory allocation
log files
archive. See archive redo log files
Data Pump
online redo. See online redo log files
principle of transaction durability
SQL*Loader
SQL*Loader in express mode
log switches
defined
no full checkpoint on
recorded in alert log
Log Writer. See LGWR (Log Writer) background process
LOG_ARCHIVE_DEST_1 parameter, ARCHIVELOG mode
LOG_BUFFER parameter
logging levels
logical storage structures
Oracle data storage model
overview of
single-instance database architecture
Logical Volume Manager (LVM)
login prompt, launching SQL*Plus without
logon
adjusting session parameters for users
Database Express
normal or privileged user
long-running transactions
LREG (Listener Registration) background process
defined
Oracle Net
overview of
LRU (Least Recently Used)
lsnrctl status command
lsnrctl utility
Database Express
example
Oracle Net
starting database listener
LUNs, using as ASM disks
LVM (Logical Volume Manager)
M
maintenance, database
with advisory framework
determining release number
self-test Q & A
setting alert thresholds
two-minute drill
using ADDM
using automated tasks
using AWR
Manage Pluggable Databases, DBCA
Manage Templates, DBCA
Manageability Monitor. See MMON (Manageability Monitor) background process
Manageability Monitor Light (MMNL) background process
Management Options
DBCA
DBUA upgrade
mandatory auditing
manual database upgrade
overview of
process of
self-test Q & A
manual locks
manual segment space management
many-to-many relationships, tablespaces
materialized views, SQL Access Advisor
MAX_EST_EXEC_TIME argument
Maximum Size, tablespaces
MAXLOGFILES directive, online redo logfile groups
Mean Time Between Failure (MTBF)
Mean Time To Recover (MTTR)
Media Management Layer (MML)
members, multiple online log group
memory. See also AMM (Automatic Memory Management)
dedicated server limitations
Oracle server instance composed of
memory advisors
overview of
sizing memory buffers
memory broker, AMM
Memory Manager (MMAN) background process
memory structures
as component of database server
data dictionary cache
database buffer cache
exercise
Java pool
large pool
library cache
log buffer
overview of
PL/SQL area
self-test Q & A
shared pool components
single-instance database architecture
sizing SGA
sizing shared pool
SQL query and PL/SQL function result cache
stored in SGA for shared server
stored outside SGA for shared server
Streams pool
Memory tab, DBCA Initialization Parameters
MEMORY_MAX_TARGET parameter, AMM
MEMORY_TARGET parameter, AMM
MERGE, Fine Grained Auditing
METHOD_OPT argument, DBMS_STATS
metrics, performance monitoring
migrating data. See data migration
MIXED_WORKLOAD_PLAN directive
MMAN (Memory Manager) background process
MML (Media Management Layer)
MMNL (Manageability Monitor Light) background process
MMON (Manageability Monitor) background process
defined
implementing AMM
raising alerts
saving AWR statistics as AWR snapshot
monitoring
lock conflicts. See locks, monitoring/resolving conflicts
performance. See Enterprise Manager
Resource Manager
undo data. See undo data, monitoring
MOUNT mode
configuring ARCHIVELOG mode
consistent backups
defined
exercise
files required
Health Monitor checks
startup database
mounted database
MOVE operation
moving data
for bulk transfers of data
DBUA upgrade option
creating/using directory objects
Data Pump, export/import
Data Pump, general architecture
exercise
overview of
self-test Q & A
SQL*Loader from non-Oracle database
SQL*Loader in express mode
using external tables via platform-independent files
MTBF (Mean Time Between Failure)
MTS (Multi-Threaded Server)
MTTR (Mean Time To Recover)
Multi-Threaded Server (MTS)
multipass memory allocation, PGA
multiplexing
N
name resolution
configuring client-side network
establishing session in Oracle Net
testing Oracle Net
Named Pipes
namespace
naming conventions
ASM disks
Data Pump export/import
database design templates
database domain
global database name
logfiles not enforcing
Oracle Base directory
Oracle Home database
tablespace and its datafiles
undo segments vs. rollback segments
NAS (network-attached storage) devices, as ASM disks
national character large object (NCLOB)
National Language Support (NLS)
NCLOB (national character large object)
nested loop joins, adaptive execution plans
nested tables, segments
Net Configuration Assistant (netca), Oracle Net
Net Manager, Oracle Net
network-attached storage (NAS) devices, as ASM disks
Network Mode, Data Pump
export job
migrating data
network configuration
client-side
communication between databases
database resident connection pooling
DBUA upgrade option
Oracle Net. See Oracle Net, configuring services
self-test Q & A
tools
NFS files, using as ASM disks
NLS (National Language Support)
NOARCHIVELOG mode, database created in
NOAUDIT command
node, defined
NO_INVALIDATE argument, DBMS_STATS
NOLOG switch, SQL*Plus
NOMOUNT mode
ASM always in
controlfile operations
creating database
database creation scripts
defined
Health Monitor checks
querying views
startup database
nondefault roles
NORMAL offline tablespace
NORMAL shutdown option
checkpointing and
consistent backups after
hanging in
overview of
normal user logon
NOWAIT clause, SELECT.FOR UPDATE
null
NULL columns
NUMBER_OF_ARGUMENTS parameter, JOB_ACTION
O
object statistics
how optimizer uses
refreshing for execution plans
SQL tuning and
as static
objects
creating/using directory
Data Pump export/import
deferred segment creation
privileges
Scheduler
storing definitions in data dictionary cache
OC4J (Oracle Containers for J2EE)
OCA (Oracle Certified Associate)
OCI (Oracle Call Interface)
OCP (Oracle Certified Professional)
ODBC (Open Database Connectivity)
OEM (Oracle Enterprise Manager)
OFA (Optimal Flexible Architecture)
offline backups
offline tablespace or datafile
OHASD (High Availability Services daemon), GI architecture
oinstall group, planning installation
OLAP (Online Analytical Processing)
OLR (Oracle Local Registry) file, GI
OLS (Oracle Label Security)
OLTP (Online Transaction Processing)
OMF (Oracle Managed Files)
one-pass memory allocation, PGA
one-third full, LGWR flushing log buffer
one-to-many relationship, Oracle/OS blocks
Online Analytical Processing (OLAP)
online backups
online redo log files
ARCn background process and
controlfile pointing to
defined
determining need for recovery
forward recovery process
guaranteeing data will not be lost
impossibility of database corruption
instance recovery
LGWR background process and
overwriting when inactive
physical structure of Oracle database
protecting
RAC database and
RMAN never backing up
online tablespace or datafile
Online Transaction Processing (OLTP)
Opatch, OUI inventory
Open Database Connectivity (ODBC)
OPEN database mode
defined
exercise
files required
Health Monitor checks in
self-test Q & A
with SMON
startup database
open (hot) backups
OPEN status, user accounts
operating system. See OS (operating system)
operating system authentication
as external authentication
logon as privileged user
logon to startup and shutdown
user accounts
Optimal Flexible Architecture (OFA)
optimal memory allocation, PGA
optimizer statistics
exercise
gathering for autotask
gathering manually
object statistics
overview of
self-test Q & A
using
OPTIMIZER_MODE parameter
changing and querying
initialization parameter files
options, adding database. See Configure Database Options, DBCA
OPTIONS argument, DBMS_STATS
“ORA-1555: snapshot too old” error
ORA-600 error message
ORA$APPQOS_0 through ORA$APPQOS_7 groups, Resource Manager
ORA$AUTOTASK, Resource Manager
ORA$AUTOTASK_PLAN directive, Resource Manager
Oracle account
Oracle ASM. See ASM (Automatic Storage Management)
Oracle Base directory
Oracle Call Interface (OCI)
Oracle Certified Associate (OCA)
Oracle Certified Professional (OCP)
Oracle Containers for J2EE (OC4J)
Oracle Data Pump. See Data Pump
Oracle Enterprise Manager (OEM)
Oracle Grid Infrastructure. See GI (Grid Infrastructure)
Oracle Home
overview of
manual database upgrade
OUI directory
preparing for database upgrade
self-test Q & A
upgrading database to 12c with DBUA
Oracle Label Security (OLS)
Oracle Local Registry (OLR) file, GI
Oracle Managed Files (OMF)
Oracle Net
Oracle Net, configuring services
client-server paradigm and
creating database listener
dynamic service registration
establishing session
self-test Q & A
shared server
Oracle Restart
administering processes
administering registered resources
capability of
database configuration
defined
managing components
self-test Q & A
Oracle Scheduler. See Scheduler
Oracle Software Delivery Cloud
Oracle Streams
“Oracle Suggested Backup,” Enterprise Manager
Oracle Technology Network (OTN)
Oracle Universal Installer. See OUI (Oracle Universal Installer)
Oracle Warehouse Builder (OWB)
ORACLE_BASE
database creation scripts using DBCA
database storage options
defined
launching DBCA on Linux
ORACLE_HOME
creating data dictionary
database creation scripts using DBCA
defined
launching DBCA on Linux
software upgrades
troubleshooting SQL*Plus launch
$ORACLE_HOME/bin directory
OracleOHService
ORACLE_SID
ORA_DBA group, installing software in Windows
oradim utility
orapwd utility
ORA$QOS_PLAN directive, Resource Manager
ORA$ROOT_PLAN directive, Resource Manager
orclz alias, local naming name resolution
ORGANIZATION EXTERNAL, CREATE TABLE
OS (operating system)
block
defined
GI install for standalone server
groups, Oracle software installation
no way to adjust priority of resources
Scheduler jobs as commands of
OSASM group, GI administrator
OS_AUTHENT_PREFIX instance parameter
OTHER_GROUPS, Resource Manager
OTN (Oracle Technology Network)
OUI (Oracle Universal Installer)
defined
generating response files
GI install
GI install for standalone server
interactive install
inventory
Oracle software installation, Windows vs. Linux
prerequisite checks for running
software upgrade using
using latest version of
overlapping windows, avoiding
overwriting online redo logfiles
OWB (Oracle Warehouse Builder)
owners, directory
P
packages, Resource Manager
parallelism
Data Pump operations
DBUA upgrade option
manual database upgrade
Resource Manager limiting
parameter files
controlling undo
enabling standard auditing
initialization. See initialization parameter files
parse
partial checkpoints
partitioning strategies, SQL Access Advisor
password authentication
logon as privileged user
logon to startup and shutdown
user accounts
password file authentication
passwords
database creation scripts using DBCA
database credentials
Database Express logon
enforcing with profiles
forcing user to change account
normal user logon
Oracle Net sessions
OS authentication
post-database upgrade tasks
user account authentication
patchsets, software upgrades
PATH environment variable
launching DBCA on Linux
software upgrades
troubleshooting SQL*Plus launch
paths, directory
PCTFREE (percent free) setting, segments
PDF copy of this book
percent free (PCTFREE) setting, segments
performance, effects of compression
Performance Hub, Database Express
performance management
AMM. See AMM (Automatic Memory Management)
Enterprise Manager
overview of
self-test Q & A
SQL tuning. See SQL tuning
using memory advisor
performance monitoring, Enterprise Manager
performance tuning
Enterprise Manager
upgraded database
permissions, directory
pfile or init file (static parameter file)
changing and querying
and initialization parameter file
working with
PGA (Program Global Area) memory
AMM transferring memory
automatic management of
database buffer cache
DBCA Initialization Parameters
dedicated server limitations
defined
nonshareable for user sessions
single-instance database architecture
using memory advisor
PGA_AGGREGATE_LIMIT
PGA_AGGREGATE_TARGET
physical database structures
abstraction of logical from
controlfile
as database server component
datafiles
entity-relationship diagram
investigating in your database
online redo log files
other database files
overview of
single-instance database architecture
PL/SQL
alert thresholds
defined
Resource Manager configuration
SGA memory structure
SQL query result cache
statistics not relevant to
PL/SQL APIs
accessing SQL advisors with
adjusting AWR snapshot frequency/retention
Resource Manager configuration
SQL Tuning Advisor
planning
installation. See installation planning, Oracle Database software
Resource Manager. See Resource Manager plans
platform-independent files, moving data via
platforms
data migration on different
Data Pump export/import
database upgrades on same
determining release number
Oracle Database supported
PMON (Process Monitor) background process
in clean shutdowns
defined
overview of
pointer file, OUI inventory stored in
policies
Fine Grained Auditing
unified auditing
Post-Upgrade Status Tool
post-upgrade tasks
postupgrade_fixups.sql script
predefined roles
prerequisite checks
controlling autotasks
Database Express
failure of
GI install
planning Oracle software installation
upgrading database to 12c with DBUA
Prerequisite Checks, DBCA dialog
Pre-Upgrade Information Tool
manual database upgrade
post-upgrade tasks
database upgrade using DBUA
using before upgrade
self-test Q & A
preupgrade_fixups.sql script
preupgrade.log script
primary key
constraint
defined
enforced during direct path loads
executing UPDATE statement
segment shrink functionality
primary storage
prioritizing jobs, Scheduler
exercise
overview of
self-test Q & A
using job classes
using windows
priority of resources. See Resource Manager
Privilege Analysis mechanism
privileges
auditing
granting/revoking
using Oracle Data Vault
Oracle Restart
OS/password file authentication
roles solving problems of
unified auditing of
user accounts granted
user logon
procedures, DBMS_FGA package
Process Monitor. See PMON (Process Monitor) background process
processes
administering Oracle Restart
confirming automatic startup of GI
GI architecture
structure of
PROCESSES parameter
DBCA Sizing tab
querying and setting initialization parameters
production database, database upgrades
Profile branch, Net Manager
profiles
creating and assigning
defined
enforcing password
exercise
password limits
storing results of tuning
programs, Scheduler
Progress Page, DBCA
protocols, Oracle Net
PUBLIC role
PURGE_LOG job, job classes
Q
queries, supporting long-running
queues
Data Pump jobs
defined
shared server architecture
QUICK_TUNE, DBMS_ADVISOR, SQL Access Advisor
quiese
quotas
temporary tablespaces and
user account settings
R
RAC (Real Application Clusters)
database server component
defined
Grid Infrastructure required for
redo limitations and
undo tablespace in
RADIUS server
RAID (Redundant Array of Inexpensive Disks)
RAM (random access memory)
ratio CPU method, Resource Manager
raw devices
creating simulated
for databases, but not Oracle Home
defined
no longer supported for datafile storage
RDBMS (relational database management system)
read-only tablespace
Real Application Clusters. See RAC (Real Application Clusters)
RECO (Recover) background process
recompile option, DBUA upgrade
record- and table-locking mechanisms
records, audit
Fine Grained Auditing
mandatory auditing
standard auditing
unified auditing
Recover Writer (RVWR) background process
Recovery Manager. See RMAN (Recovery Manager)
Recovery Related Files section
redo data
INSERT vs. DELETE statements
rollback generating more
undo data vs.
UPDATE statement
redo log files
executing COMMIT
transactional integrity
Redundancy setting, ASM disk group in GI install
Redundant Array of Inexpensive Disks (RAID)
referential integrity
defined
dropping constraints in SQL*Loader
registered resources, GI
administering Oracle Restart
configuring database for Oracle Restart
defined
for Oracle Restart
overview of
regulations, auditing
relation
relational database management system (RDBMS)
release number, database
remapping facilities, Data Pump
remote external jobs, Scheduler
remote systems, Scheduler jobs on
renice command, Unix
REPAIR FAILURE command, DRA
repeatable reads, lock contention
REPEAT_INTERVAL, CREATE_SCHEDULE procedure
REPORT command, RMAN backups
reports
ADDM
RMAN
repository
ADR
RMAN
Resource Manager
limiting resources
monitoring
normalized view of objects
overview of
Scheduler integration with
Scheduler prioritizing jobs with
self-test Q & A
Resource Manager configuration
architecture
need for resource management
overview of
self-test Q & A
working with
Resource Manager plans
activating using Scheduler
active session pool method
controlling jobs by execution time
CPU method
directives
enabling
exercise
limiting degree of parallelism
prioritizing jobs in Scheduler
ratio CPU method
restricting generation of undo data
self-test Q & A
terminating sessions by idle time
understanding
RESOURCE role, predefined
resource usage. See Resource Manager
RESOURCE_LIMITS instance parameter
RESOURCE_MANAGER_PLAN instance parameter
resources, GI
administering Oracle Restart
GI registry of
Oracle Restart
response files, OUI
restore operations
RESTRICTED SESSION system privilege
result cache, SQL query and PL/SQL
Results screen, DBUA upgrade
resumable space allocation
reusable code
REVOKE command
defined
exercise
object privilege
system privilege
rman
RMAN (Recovery Manager)
administering backups
backup types
Data Pump export/import
Data Recovery Advisor using
database backup without shutdown
defined
exercise
incremental backups
location for backup files
managing backups
post-database upgrade tasks
reports on backups
repository
script for offline full backup
self-test Q & A
writing backups to fast recovery area
roles
creating/granting
Data Vault and
enabling
grouping privileges into
OS/password file authentication
predefined
Privilege Analysis mechanism for
privileges. See privileges
unified auditing
roll forward, instance recovery
ROLLBACK command
backing out uncommitted DML statements
executing DML on rows
executing SQL
monitoring/resolving locking conflicts
releasing locks on rows in DML automatically
rollback data
rollback segments
as outdated
overview of
transactions using undo segments
undo generation and
undo segments vs.
root scripts (Linux)
round-robin time slicing, Resource Manager
row chaining
ROW EXCLUSIVE lock
row migration
ROW SHARE lock
rowid
ROWID, indexes
rows
automatic segment space management
compression of
enabling segment shrink
filtering access with Oracle Label Security
Fine Grained Auditing on certain
shared and exclusive locked
SQL*Loader inserting
$RSRC_CONSUMER_GROUP view
runInstaller.sh shell script (Linux)
RVWR (Recover Writer) background process
S
Sample Schemas tab, DBCA Database Options
SAN (storage area network) devices, as ASM disks
SBT (System Backup to Tape), RMAN
scalability, shared server for
schedule, creating Scheduler
Scheduler
API
architecture
exercise
job chains
jobs
jobs on remote systems
overview of
prioritizing jobs
programs
Resource Manager integration with
schedules
self-contained jobs
self-test Q & A
SCHEDULER_ADMIN role
schema
Data Pump export/import
defined
user accounts associated with
SCN (System Change Number)
SCOPE keyword, changing/querying parameters
scripts, creating/assigning profiles
scripts, database creation
exercise
generating
initialization parameter file
overview of
working with
SCSI disks, DAS devices as
SDP (Sockets Direct Protocol), Oracle Net support
secondary storage
Secure Sockets Layer (SSL)
security
auditing. See auditing
authentication. See authentication
logon as normal or privileged user
overview of
user accounts. See user accounts
Segment Advisor
overview of
reclaiming space with
running
self-test Q & A
SEGMENT CREATION DEFERRED clause, CREATE TABLE
segments
ASSM
deferred creation of
defined
describing
extents and
Oracle data storage model
shrinking wasted space in table/index
space management
types of
SELECT ANY TABLE system privilege
SELECT FOR UPDATE statement
SELECT object privilege
SELECT statement
SELECT_CATALOG_ROLE
SELECT.FOR UPDATE command
self-container jobs, Scheduler
sequence
server, GI install for standalone
server process(es)
connection between user and database
creating large pool for shared
Data Pump jobs
dedicated server limitations
dedicated server vs. shared server architecture
establishing session by launching
executing SELECT statement
executing SQL
monitoring with PMON
Oracle Net and client-server architecture
PGA memory management
shared server architecture
single-instance database architecture
SERVER=DEDICATED
SERVER=SHARED
service name
Service Naming branch, Net Manager
services
sessions
components
deadlock
dedicated server limitations
defined
enabling resumable space
establishing
locked rows and
managing with shared server
shared server
terminating by idle time
SESSIONS parameter
SET AUTOCOMMIT ON command
SET TRANSACTION READ ONLY statement
SET_ATTRIBUTE procedure, job classes
setup.exe file (Windows)
SGA (System Global Area) memory
AMM transferring memory between PGA and
of ASM instance
automatic management of
automating management with MMAN
as block of shared memory
configuring shared server
Data Pump’s direct access to
data structures. See memory structures
DBCA Initialization Parameters
defined
gathering AWR statistics
log buffer fixed in size at start time
memory structures required in
MMON capturing statistics from
shared server sessions storing data in
single-instance database architecture
SQL statements using
using memory advisor to size memory buffers
SGA_MAX_SIZE parameter
SGA_TARGET_PARAMETER
shadow processes
SHARE lock
SHARE ROW EXCLUSIVE lock
shared locks
shared pool
data dictionary (or row) cache
library cache
overview of
PL/SQL area
SGA memory allocation to
sizing
SQL query and PL/SQL function result cache
shared server architecture
configuring
dedicated server limitations
dedicated server vs.
default configuration
overview of
when to use
shared_servers parameter
SHOW command
SHOW SGA command
SHOW SQL button, Database Express
SHRINK SPACE command
shutdown
database backup without
startup and. See startup and shutdown
SHUTDOWN ABORT command
SHUTDOWN command
SHUTDOWN state
SIDs (system identifiers)
database identification
defined
detecting lock contention
solving lock contention
silent install, launching OUI
single-instance database architecture
sizing
database buffer cache
library cache
log buffer
operating system blocks
Oracle blocks
shared pool
Streams pool
tablespaces
undo tablespace
Sizing tab parameters, DBCA
SKIP LOCKED keyword, SELECT FOR UPDATE statement
SMON (System Monitor) background process
defined
mounting and opening database
overview of
protecting online redo logfiles
spfile read by
Sockets Direct Protocol (SDP), Oracle Net support
software upgrades
space management
ASSM
automatic Oracle database
defined
migrating data using Data Pump
Oracle data storage model for
overview of
proactively monitoring tablespaces
reclaiming wasted space with segment shrink
self-test Q & A
using compression
using resumable space allocation
using Segment Advisor
spfile (dynamic parameter file)
changing and querying
and initialization parameter file
RMAN back up for
working with
SQL Access Advisor
defined
overview of
self-test Q & A
tuning workload with
SQL Developer
SQL Repair Advisor
SQL scripts
SQL statements
execution plan critical to performance
INSERT and DELETE statements
overview of
SELECT statement
so-called “Autocommit,”
transaction control, COMMIT statement
transaction control, DDL and
transaction control, ROLLBACK statement
UPDATE statement
using memory in SGA and PGA
wait events
SQL (Structured Query Language)
advisors. See SQL Access Advisor; SQL Tuning Advisor
defined
executing with database buffer cache
files generated by Data Pump
moving data using database links
Oracle Net and client-server architecture
plan directives, CBO
query and PL/SQL function result cache
server processes executing
user processes generating
SQL tuning
Cost Based Optimizer
optimizer statistics. See statistics, optimizer
self-test Q & A
SQL Advisor workload
SQL Tuning Advisor
workload with SQL Access Advisor
SQL Tuning Advisor
API, DBMS_SQLTUNE package
capabilities of
defined
functionality of
overview of
running
self-test Q & A
SQLAccess Advisor
sql.bsq script
SQL*Loader
exercise
loading data with external tables vs.
moving data from non-Oracle database
moving data in express mode
self-test Q & A
sqlnet.ora file
SQL*Plus
changing and querying parameters
creating database
exercise
gathering statistics
log on to newly created database
logon as normal or privileged user
managing directories
managing initialization parameters
manual database upgrade
Oracle Net and client-server architecture
startup and shutdown
tablespace creation and verification
troubleshooting launch
undo configuration
working with
sqlplus (Unix)
srvctl utility
SSL (Secure Sockets Layer)
stale, object statistics as
standalone server, installing GI for
standard auditing
enabling
technique
unified auditing vs.
START_DATE, CREATE_SCHEDULE procedure
startup and shutdown
connect with appropriate privilege
exercise
impossible with shared servers
self-test Q & A
shutdown with NORMAL, TRANSACTIONAL, IMMEDIATE, and ABORT
starting database listener
startup with NOMOUNT, MOUNT and OPEN
STARTUP command
database
dynamic performance views at
exercise
invoking instance recovery
OS/password file authentication
recorded in alert log
STARTUP FORCE command
stateful alerts
stateless alerts
static, object statistics as
STATISTIC_LEVEL instance parameter, AWR
statistics
AWR
cost-based optimization based on
DBMS_STATS
DBUA upgrade option
memory advisor
MMON
not relevant to PL/SQL
object
optimizer. See optimizer statistics
performance monitoring
STATISTICS_LEVEL parameter=ALL
STATISTICS_LEVEL=ALL
STATISTICS_LEVEL=BASIC
STATISTICS_LEVEL=TYPICAL
status
creating tablespaces
user account settings
STATUS column, online redo log files
storage area network (SAN) devices, as ASM disks
storage, fast recovery area
Storage Locations, DBCA
storage model, ASM
storage structures
Oracle data storage model
overview of
storage structures, logical and physical
investigating in your database
logical database structures
overview of
physical database structures
self-test Q & A
storage structures, table row data in blocks
exercise
Oracle data storage model
segments, extents, blocks and rows
self-test Q & A
storage structures, tablespaces
creating
dropping
extent management
flagging as read-write or read-only
Oracle Managed Files
overview of
renaming
resizing
segment space management
self-test Q & A
taking online and offline
stored PL/SQL
Streams pool, SGA memory
Structured Query Language. See SQL (Structured Query Language)
Summary window, DBCA
suspended sessions
SWITCH_ CONSUMER_GROUP_FOR_SESS procedure
SWITCH_ CONSUMER_GROUP_FOR_USER procedure
SWITCH_CURRENT_CONSUMER_GROUP procedure
SWITCH_ELAPSED_TIME argument
SWITCH_GROUP argument
SWITCH_TIME argument
synonym
SYS
directories always owned by
login, RMAN back up
schema
SYSASM role
SYS.AUD$ table
SYSAUX tablespace
AWR as set of tables in
database creation scripts
managing AWR
monitoring AWR
SYSBACKUP role
SYSDBA privilege
defined
external authentication for user account
logon as privileged user
logon to shutdown
logon to startup
OS/password file authentication
setting initialization parameters
SYSDG role
SYS.FET$
SYS_GROUP, Resource Manager
SYSKM role
SYSOPER privilege
defined
external authentication for user account
OS/password file authentication
shutdown
startup
System Backup to Tape (SBT), RMAN
System Change Number (SCN)
system, defined
System Global Area. See SGA (System Global Area) memory
system identifiers. See SIDs (system identifiers)
System Monitor. See SMON (System Monitor) background process
system privileges
SYSTEM schema
SYSTEM tablespace
changing default tablespace from
data dictionary within
database creation scripts using DBCA
DB_BLOCK_SIZE parameter for
SYS.UET$, dictionary extent management
T
tables
compression of
within database
DBA_TABLES view of
defined
moving data using external
partitions
permissions
reclaiming wasted space
segments
tablespaces
active undo
changing default
Data Pump export/import
defined
mappings within datafiles to
post-database upgrade tasks
space management
undo data residing in
tablespaces, managing
creating
dropping
extent management
flagging as read-write or read-only
Oracle Managed Files (OMF)
overview of
renaming
resizing
segment space management
self-test Q & A
taking online and offline
tasks, automating. See Scheduler
TCP/IP, Oracle Net supporting
TCP (Transmission Control Protocol)
TCP with SSL (TCPS)
TCPS (TCP with SSL)
TEMP tablespace
tempfiles
defined
RMAN never backing up
temporary tablespace
templates
creating database
database design
response file
self-test Q & A
TEMPORARY offline tablespace
temporary tablespaces
temporary undo segments
TEMP_UNDO_ENABLED parameter
terminating sessions by idle time, Resource Manager plan
tertiary storage
test alias, local naming name resolution
testing
database upgrade process
Oracle Net connectivity
third-party systems
external authentication for user account
external naming
lock contention
SQL*Loader loading data from
user passing object privilege to
three-second timeout
causing DWBn to write
causing LGWR to write
thresholds, tablespace usage
time-based jobs, Scheduler
time-slicing (or time-sharing) algorithm, CPU cycles
TIMEOUT option, ALTER SESSION
timezone data, DBUA upgrade option
TNS (Transparent Network Substrate)
TNS_ADMIN environment variable
tnsping utility, Oracle Net
tools, Oracle Network
top down, tuning methodology
Total Tester
trace files, from background processes
TRANSACTIONAL shutdown option
checkpointing and
consistent backups after
overview of
transactions
controlling
defined
using undo segments
Transmission Control Protocol (TCP)
Transparent Network Substrate (TNS)
“trickle down model,” Resource Manager
troubleshooting
database links
SQL*Plus launch
tsnames.ora file
configuring client-side network
configuring Oracle Net
example
limitations of
local naming name resolution using
self-test Q & A
storing with TNS_ADMIN
Tuning Pack
tuples
two-phase commit, distributed transactions
type 2 undo segments
Type icon, tablespaces
U
udev facility, creating ASM disks
UGA (User Global Area)
UI (user interface)
undo data
configuring undo retention
DML statements and. See storage structures, table row data in blocks
exercise
overview of
redo data vs.
restricting generation of
self-test Q & A
undo data generation, and DML
database transactions
executing SQL. See SQL statements
exercise
how transactions use undo segments
INSERT vs. DELETE statements
overview of
self-test Q & A
undo generation
undo data, monitoring
creating undo tablespaces
error conditions related to
exercise
overview of
parameters for undo management
self-test Q & A
sizing undo tablespaces
temporary undo
UNDO keyword, undo tablespace
undo retention
creating/managing undo tablespaces
exercise
flashback query and
overview of
self-test Q & A
to support long-running queries
undo segments
automatic undo management
ensuring transactional integrity
executing UPDATE statement
how transactions use
temporary
undo generation and
undo tablespace
undo tablespace
creating/managing
database creation scripts
error conditions related to undo data
exercise
restricting generation of undo data
sizing/monitoring
undo segments existing only in
UNDO_MANAGEMENT parameter
UNDO_RETENTION parameter
UNDO_TABLESPACE parameter
unified auditing
configuring and enabling
enabling
technique
Uniform Resource Locator (URL)
uniform size, local extent management
unit of I/O
UPDATE ANY TABLE system privilege
UPDATE object privilege
UPDATE statements
automatic segment space management
database buffer cache
executing SQL
rollback of
updates
dynamic performance views
GI install
GI install for standalone server
upgrade, database software
data migration methods
data migration using Data Pump
data migration vs.
database
GI install for standalone server
overview of
process for
restrictions
self-test Q & A
software
upgrade process, database
manually using scripts and tools
using DBUA
installing new Oracle Home prior to
migration to unified auditing
overview of
post-upgrade tasks
Pre-Upgrade Information Tool
requirements for certain features/options
self-test Q & A
URL (Uniform Resource Locator)
Used (%), creating tablespaces
user accounts
attributes at creation time
authentication
creating
logon
obtaining Oracle Database software
overview of
planning installation
privileges
profiles
roles
self-test Q & A
user, defined
user-defined procedure, FGA
User Global Area (UGA)
user ID, Windows vs. Linux software install
user interface (UI)
user process(es)
Data Pump
database buffer cache
establishing session
generating SQL
issuing PL/SQL
nonshareable memory or PGA for
Oracle Net and client-server architecture
overview of
PGA memory management
reading pfile
single-instance database architecture
SQL*Loader as
user sessions, PGA memory
user SYS, as most powerful user in database
USER_DUMP_DEST parameter, alert log
username
CREATE USER command
establishing password file sessions
establishing session in Oracle Net
logon to Database Express
normal user logon
password authentication for user account
switching consumer group
user accounts
UTC (Coordinated Universal Time)
UTL_MAIL package
V
V$ views (dynamic performance)
data dictionary views vs.
overview of
for performance monitoring data
V$ARCHIVE_DEST
V$DATAFILE
V$EVENT_NAME
V$INSTANCE
V$INSTANCE_RECOVERY view (MTTR Advisor)
V$LOG
V$LOGFILE
V$MEMORY_DYNAMIC_COMPONENTS
V$MEMORY_RESIZE_OPS
V$MYSTAT
V$OPTION
V$PARAMETER
V$PROCESS
V$RECOVERY_AREA_USAGE
V$RECOVERY_FILE_DEST
V$RSRC_CONSUMER_GROUP
V$RSRC_PLAN
V$SESSION_EVENT
V$SESSTAT
V$SPPARAMETER
V$STATNAME
V$SYSAUX_OCCUPANTS
V$SYSSTAT
V$SYSTEM_EVENT
V$TABLESPACE
V$TEMPFILE
V$TRANSACTION
V$UNDOSTAT view (undo advisor)
V$VERSION
value-based auditing
VALUES clause, INSERT statement, SQL*Loader
VARCHAR2 data type, ASSM
“Vee dollar” views. See V$ views (dynamic performance)
views
data dictionary. See data dictionary views
dynamic performance. See V$ views (dynamic performance)
Resource Manager consumer groups
virtual memory, all Oracle memory usage as
V$SESSION view
detecting lock contention
monitoring active session pool
monitoring Resource Manager
querying in NOMOUNT mode
W
WAIT clause, SELECT.FOR UPDATE
wait events, SQL statements
Windows
assigning resources
creating ASM disks
database listener
database server components
database software installation
database software installation in Linux vs.
database upgrade to 12c with DBUA
dropping tablespaces
external authentication for user account
GI install
installing Oracle software in admin account
launching DBCA
launching OUI interactively
log on to new database
mandatory auditing
Oracle Restart database configuration
Oracle Restart processes
pointer file location
post-database upgrade tasks
prerequisite installation checks
static and dynamic parameter files
windows, Scheduler
avoiding overlapping
controlling Resource Manager
defined
prioritizing jobs
WITH ADMIN OPTION
WITH GRANT OPTION
WORKAREA_SIZE_POLICY
workloads, tuning. See SQL Access Advisor
X
X-Windows
XML (Extensible Markup Language)
alert log copied as
DDL log recorded in
defined
OUI inventory as