Index
A
- active report
- for Performance Hub data 10.1.2
- adding
- ADDM
- See: Automatic Database Diagnostics Monitor (ADDM)
- administering
- users 7.5
- administrative user accounts 7.3
- advisors
- ALTER SYSTEM statement 5.3
- application PDB
- managing with EM Express 13.5
- application root
- managing with EM Express 13.5
- archived redo log files
- ARCHIVELOG mode 2.3.2.5
- archiving 2.3.2.5
- ARCn processes 5.1.2
- ASM
- See: Oracle ASM
- autobackup
- of control file and server parameter file 9.3.5.3
- autoextend
- data files and tablespaces 6.1.6.4
- Automatic Database Diagnostics Monitor (ADDM)
- automatic memory management 2.3.2.8.1, 5.4.1
- automatic PGA memory management
- modifying settings 5.4.8
- automatic shared memory management 2.3.2.8.1, 5.4.1
- modifying settings 5.4.5
- Automatic SQL Tuning Advisor
- AWR report
- for Performance Hub data 10.1.2
B
- background processes
- and database configuration 2.3.2.8.2
- archiver (ARCn) 5.1.2
- checkpoint 5.1.2
- database writer (DBWn) 5.1.2
- description 1.2, 5.1.2
- listener registration (LREG) 4.1.1
- log writer (LGWR) 5.1.2
- manageability monitor (MMON) 5.1.2
- process monitor (PMON) 5.1.2
- system monitor (SMON) 5.1.2
- use by database instances 5.1
- backup
- available 9.6.1
- backup pieces 9.2.3
- consistent 9.2.5
- cross-checking 9.6.1, 9.6.2
- deleting expired backups 9.6.3
- deleting obsolete backups 9.6.5
- expired 9.6.1
- files 6.1.7
- full backup of data files 9.2.4
- image copies 9.2.3
- inconsistent 9.2.5
- incremental backup of data files 9.2.4
- listing 9.4.3
- making unavailable 9.6.4
- managing 9.6
- obsolete 9.6.1
- overview 9.1
- sets 9.2.3
- settings 9.3.5
- tags 9.4.1.2
- unavailable 9.6.1
- validating 9.4.4
- whole database backup 9.4.2.1
- backup and recovery area
- specifying during database creation 2.3.2.5
- BasicFiles LOBs 8.4.1.4.4
- block size
- configuring for the database 2.3.2.8.2
- Buffer Cache Advisor
- description 10.3.1
C
- CDBs
- cloning a PDB from a remote CDB 13.8.4.1
- cloning a PDB in the same CDB 13.8.2
- closing all the PDBs 13.11.2
- closing a PDB 13.11.1
- configuring Oracle Managed Files 13.7
- creating 2.1, 2.2, 2.3.2.1, 2.3.2.3
- creating a new PDB from the seed 13.8.1
- dropping a PDB 13.9.2
- flashback 9.1.1.4
- managing 3.3
- managing PDBs with EM Express 13.3
- opening all the PDBs 13.10.2
- opening a PDB 13.10.1
- plugging in an unplugged PDB 13.8.3
- point-in-time recovery 9.1.1.3
- refreshing a refreshable PDB on demand 13.8.4.3
- relocating a PDB from a remote CDB 13.8.4.2
- unplugging a PDB 13.9.1
- character sets 2.1.2.7
- checkpoint
- of the database 5.1.2
- checkpoint process 5.1.2
- classes, Java 8.7.1
- CLOB data type 8.4.1.2.1
- code
- database-resident 8.7.1
- columns
- compiling schema objects 8.7.2
- compressed tables 8.4.1.4.4
- configuring
- Automatic SQL Tuning Advisor 10.3.4
- connect descriptors
- connection modes
- configuring 2.3.2.8.4
- connection privileges
- CONNECT role 7.2
- connect strings
- description 4.1.2
- constraints 8.4.1.3
- consumer group 12.1.3
- adding a comment for 12.2.3.4
- adding a new consumer group to a plan 12.2.3.1
- adding an existing group to a plan 12.2.3.2
- removing from a plan 12.2.3.3
- setting CPU directives for 12.2.3.7
- setting mapping rule priorities for 12.2.3.6
- setting mapping rules for 12.2.3.5
- setting parallel server directives for 12.2.3.8
- setting runaway query directives for 12.2.3.9
- setting session directives for 12.2.3.10
- control files
- creating
- customized repairs 9.8
D
- data
- loading 8.4.6
- database
- database administration
- privileges required 7.3
- database checkpoint 5.1.2
- Database Configuration Assistant (DBCA)
- database configuration options 2.1.2.7
- database edition 2.1.2.3
- database links
- description 8.8
- database management
- database objects
- naming 8.1
- database-resident program code 8.7.1
- databases
- advisors
- using 10.3.1
- backup
- description 9.2
- backup and recovery 9.1
- configuring options 2.3.3
- creating with DBCA 2.3
- deleting using DBCA 2.3.4
- diagnosing performance problems 10.2
- duplicating 2.3.5
- managing
- monitoring
- performance 10.1
- overview of creating 2.1
- performance
- recovery
- restoring
- description 9.2
- starting and stopping on Microsoft Windows 5.2.2
- steps for installing and creating 2.2
- storage structure
- tuning 10.1
- upgrading 14.2
- users 7
- using DBCA templates 2.3.5
- advisors
- data blocks
- data dictionary tables
- access to as user SYS 7.3.2
- datafiles
- autoextend 6.3.2.2
- data files
- and the Oracle Suggested Backup Strategy 9.4.2.2.1
- autoextend 6.1.6.4, 6.3.2.1
- autoextend and Oracle Flashback 6.5.2
- backing up 9.2
- backups of only used blocks 9.2.3
- data blocks 6.1.5
- description of 6.1.5
- extents 6.1.5
- full backups 9.2.4
- incremental backups 9.2.4
- media recovery 9.2.6
- missing 9.1
- recovering from the loss of 9.8.4
- recovery without restoration 9.1
- restoring from consistent and inconsistent backups 9.2.5
- segments 6.1.5
- tempfiles 6.1.5
- datafiles for undo tablespaces
- changing to fixed-size 6.5.6
- data integrity 8.4.1.3
- Data Recovery Advisor 9.7
- data types
- DATE data type 8.4.1.2.1
- DBA role 7.2, 8.2
- DBWn processes 5.1.2
- dedicated server mode 2.3.2.8.4
- dedicated server processes 5.1.3
- deinstall tool
- deleting
- directory
- dropping
- duplicating
- databases 2.3.5
E
F
I
L
- language
- used by software 2.1.2.7
- LGWR process 5.1.2
- licensed software options 2.1.2.3
- listener.ora files 4.1.1
- listeners
- See: Oracle listeners
- Load Data wizard
- using 8.4.6
- loading data 8.4.6
- LOB columns 8.4.1.4.1
- LOB storage
- locally managed tablespaces 6.1.6.1
- locking and unlocking users 7.5.7
- log switch
- description 2.3.2.5
- LREG process 4.1.1
M
O
- object privileges 7.2
- offline tablespaces 6.1.6.3, 6.3.2.3
- online redo log files 6.4.2
- online redo log groups
- operating system groups 2.1.2.7
- Optimizer Statistics Advisor
- description 10.3.1
- ORACLE_BASE environment variable 2.2
- ORACLE_HOME environment variable 2.2
- Oracle ASM
- installation 2.1.2.5
- Oracle Automatic Storage Management
- See: Oracle ASM.
- Oracle base directory 2.1.2.4
- Oracle Data Guard
- Oracle Enterprise Manager Cloud Control 3.3
- Oracle Enterprise Manager Database Express
- configuring the HTTPS port 3.5
- configuring the HTTPS port for a CDB 3.5
- configuring the HTTPS port for a non-CDB 3.5
- configuring the HTTPS port for a PDB 3.5
- description 3.3
- features 3.3
- managing databases 3
- managing DBCS database deployments 3.6
- setting the HTTPS port with the DBEXPRESS_HTTPS_PORT variable 2.2
- starting 3.4
- starting for a CDB 3.4.2
- starting for a non-CDB 3.4.1
- starting for a PDB 3.4.3
- Oracle inventory directory 2.1.2.4
- Oracle listeners
- Oracle Managed Files
- configuring for a CDB 13.7
- Oracle Net
- Oracle suggested repair 9.7
- Oracle system identifier 2.1.2.6
P
- parameter file 6.1.7
- partitioned tables 8.4.1.4.2
- password file 6.1.7
- password policies
- passwords
- expiring 7.5.8
- patches 14.1
- patch sets 14.1
- PDBs
- cloning from a PDB in a remote CDB 13.8.4.1
- cloning from a PDB in the same CDB 13.8.2
- closing all the PDBs in a CDB 13.11.2
- closing a PDB in a CDB 13.11.1
- creating 2.1, 2.2, 2.3.2.1, 2.3.2.3
- creating from the seed 13.8.1
- dropping a PDB from a CDB 13.9.2
- flashback 9.1.1.4
- managing 2.3.6, 3.3, 13
- managing with Containers page 13.4
- managing with EM Express 13.3
- opening all the PDBs in a CDB 13.10.2
- opening a PDB in a CDB 13.10.1
- plugging in an unplugged PDB 13.8.3
- point-in-time recovery 9.1.1.3
- refreshing a refreshable PDB on demand 13.8.4.3
- relocating from a remote CDB 13.8.4.2
- unplugging a PDB from a CDB 13.9.1
- Performance Hub
- PGA
- See: Program Global Area
- PGA Advisor
- description 10.3.1
- pluggable databases
- See: PDBs.
- PMON process 5.1.2
- predefined roles 7.2
- privileges
- administrative 7.3
- and synonyms 8.8
- authenticating SYSDBA, SYSOPER, and SYSBACKUP users 6.1.7
- connection 5.1.5.1
- for installation of Oracle Database software 2.2
- granting 7.5.4
- object 7.2
- recommended 7.1
- required for database administration 3.8, 7.3
- schema object management 8.2
- SYSDBA 5.1.5.1
- SYSOPER 5.1.5.1
- system 7.2
- users 7.2
- using roles to manage 7.2
- procedures 8.7.1
- profiles 7.6.1
- Program Global Area (PGA)
R
- read consistency 6.5.1
- read only tablespaces 6.1.6.3
- read write tablespaces 6.1.6.3
- Real-Time ADDM
- recovery
- Recovery Manager (RMAN)
- recycle bins 8.4.7
- redo log files
- See: online redo log files or archived redo log files
- repairs
- Resource Management features
- accessing in EM Express 12.1.8
- Resource Manager
- CDB plans 12.1.7.1
- consumer groups 12.1.3
- directives 12.1.5
- features in EM Express 12.1
- instance caging 12.3.1
- managing CDB and PDB workloads 12.1.7
- non-CDB plans 12.1.6
- PDB plans 12.1.7.2
- plans 12.1.4
- setting instance caging 12.3.2
- solutions for a CDB 12.1.2
- solutions for a non-CDB 12.1.1
- solutions for a PDB 12.1.2
- resource plan
- adding a new consumer group 12.2.3.1
- adding an existing consumer group 12.2.3.2
- allocating shares to PDBs 12.1.7.1.1
- CDB plan 12.1.7.1
- changing the default PDB directive 12.2.3.12
- changing the directives for a PDB 12.2.3.13
- creating 12.2.1.2
- creating plans 12.2.1
- creating using Quick Setup 12.2.1.1
- default directive for PDBs 12.1.7.1.3
- deleting 12.2.3.15
- managing plans 12.2
- modifying 12.2.3
- non-CDB plan 12.1.6
- PDB plan 12.1.7.2
- removing a consumer group 12.2.3.3
- setting a comment for a consumer group 12.2.3.4
- setting a comment for a PDB directive 12.2.3.14
- setting as the currently active plan 12.2.3.11
- setting CPU directives for a consumer group 12.2.3.7
- setting mapping rule priorities for consumer groups 12.2.3.6
- setting parallel server directives for a consumer group 12.2.3.8
- setting runaway query directives for a consumer group 12.2.3.9
- setting session directives for a consumer group 12.2.3.10
- specifying utilization limits to PDBs 12.1.7.1.2
- viewing 12.2.2
- viewing all the plans 12.2.2.1
- viewing a plan 12.2.2.2
- RESOURCE role 7.2, 8.2
- revalidating schema objects 8.7.2
- RMAN
- backup 9.4.2
- roles
- rollback 6.5.1
- rollback segments
- description 6.1.4
S
- sample schemas
- schema objects
- schemas 7.1
- SecureFiles LOBs 8.4.1.4.4
- security options 2.1.2.7
- segments
- description of 6.1.5
- sequences
- description 8.8
- server parameter files 5.1, 5.1.1
- server processes
- description 5.1.3
- services
- on Microsoft Windows 5.2.2
- setting
- password policies 7.6
- SGA
- See: System Global Area
- Shared Pool Advisor
- description 10.3.1
- shared server mode 2.3.2.8.4
- shared server processes 5.1.3
- shutting down databases
- Microsoft Windows 5.2.2
- SID 2.1.2.6
- SMON process 5.1.2
- snapshots 10.1.4
- source code, Java 8.7.1
- SPA Quick Check
- SQL Advisors
- SQL Performance Analyzer
- SQL Performance Analyzer Quick Check
- See: SPA Quick Check
- SQL profile 10.3.3
- SQL statements
- about 3.9.1
- SQL trial
- SQL Tuning Advisor
- SQL tuning set
- standby database
- starting databases
- Microsoft Windows 5.2.2
- startup and shutdown
- storage options
- specifying during database creation 2.3.2.4
- subprograms 8.7.1
- synonyms
- SYSAUX tablespace 6.1.6
- SYSBACKUP privilege
- SYSDBA 2.1.2.7
- SYSDBA system privilege 5.1.5.1, 6.1.7, 7.3.2
- SYSOPER 2.1.2.7
- SYSOPER system privilege 6.1.7, 7.3.2
- System Global Area (SGA)
- system identifier (SID) 2.1.2.6
- system privileges 7.2
- SYSDBA and SYSOPER 7.3.2
- SYSTEM tablespace 6.1.6
- SYSTEM user 5.1.5.1, 7.3.1
- SYS user 5.1.5.1, 7.3.1
T
- tables
- adding columns to 8.4.5.1
- adding constraints 8.4.5.3
- compressed 8.4.1.4.4
- creating 8.4.4
- deleting 8.4.7
- deleting columns 8.4.5.2
- deleting constraints 8.4.5.5
- description 8.4.1
- loading data into 8.4.6
- LOB columns 8.4.1.4.1
- modifying attributes 8.4.5
- modifying constraints 8.4.5.4
- partitions 8.4.1.4.2
- retrieving a dropped table 9.8.2.2
- viewing data in 8.4.3
- viewing information about 8.4.2
- tablespaces
- autoextend 6.1.6.4, 6.3.2.1
- autoextend and Oracle Flashback 6.5.2
- creating 6.3.1
- description 6.1.6
- dropping 6.3.3
- EXAMPLE 6.1.6
- extending undo tablespaces 6.5.2
- locally managed 6.1.6.1
- modifying 6.3.2
- offline 6.1.6.3
- quotas 7.5.5
- read only and read write 6.1.6.3
- Segment Advisor 6.3.2
- SYSAUX 6.1.6
- SYSTEM 6.1.6
- taking offline 6.3.2.3
- TEMP 6.1.6
- temporary tablespaces 6.1.6.2
- types of 6.1.6.2
- undo tablespaces 6.1.6.2, 6.5.1
- UNDOTBS1 6.1.6
- USERS 6.1.6
- viewing information about 6.2.4
- templates
- temporary tablespaces 6.1.6.2
- TEMP tablespace 6.1.6
- test database
- creating 11.2.1
- triggers 8.7.1