A
- active report
- for Performance Hub data 10.1.2
- adding
- ADDM
- See: Automatic Database Diagnostics Monitor (ADDM)
- administering
- 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
- autobackup
- of control file and server parameter file 9.3.5.3
- autoextend
- Automatic Database Diagnostics Monitor (ADDM)
- automatic memory management 2.3.2.8.1, 5.4.1
- automatic PGA memory management
- automatic shared memory management 2.3.2.8.1, 5.4.1
- 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
- backup and recovery area
- specifying during database creation 2.3.2.5
- BasicFiles LOBs 8.4.1.4.4
- block size
- Buffer Cache Advisor
C
- CDBs
- character sets 2.1.2.7
- checkpoint
- checkpoint process 5.1.2
- classes, Java 8.7.1
- CLOB data type 8.4.1.2.1
- code
- 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
- connection privileges
- CONNECT role 7.2
- connect strings
- constraints 8.4.1.3
- consumer group 12.1.3
- control files
- creating
- customized repairs 9.8
D
- data
- database
- database administration
- database checkpoint 5.1.2
- Database Configuration Assistant (DBCA)
- configuring database options 2.3.3
- deleting a databases 2.3.4
- managing database templates 2.3.5
- using to create a database 2.3
- database configuration options 2.1.2.7
- database edition 2.1.2.3
- database links
- database management
- configuring Oracle Enterprise Manager Database Express for 2.3.2.9
- registering with Oracle Enterprise Manager Cloud Control 2.3.2.9
- database objects
- database-resident program code 8.7.1
- databases
- advisors
- backup
- 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
- roadmap 3.1
- with Oracle Enterprise Manager Database Express 3
- monitoring
- overview of creating 2.1
- performance
- recovery
- restoring
- starting and stopping on Microsoft Windows 5.2.2
- steps for installing and creating 2.2
- storage structure
- logical structures 6.1
- physical structures 6.1
- tuning 10.1
- upgrading 14.2
- users 7
- using DBCA templates 2.3.5
- data blocks
- data dictionary tables
- access to as user SYS 7.3.2
- datafiles
- data files
- 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
E
- EM Express
- See: Oracle Enterprise Manager Database Express
- enabling
- automatic memory management 5.4.2
- Enterprise Edition 2.1.2.3
- Enterprise Manager
- See: Oracle Enterprise Manager Database Express
- EXAMPLE tablespace 6.1.6
- expiring passwords
- extending
- extents
H
- HTTPS port
- determining for a CDB 3.4.2
- determining for a non-CDB 3.4.1
- determining for a PDB 3.4.3
I
- incremental backups 9.2.4
- indexes
- initialization parameter file 6.1.7
- initialization parameters
- description 5.1
- how they are used by the database 5.1.1
- server parameter files 5.1, 5.1.1
- validating the impact of a change 11.3, 11.3.1
- viewing and modifying 5.3
- installation
- instances
- invalid schema objects 8.7.1
L
- language
- LGWR process 5.1.2
- licensed software options 2.1.2.3
- listener.ora files 4.1.1
- listeners
- Load Data wizard
- 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
- LREG process 4.1.1
M
- managing
- manual shared memory management
- media recovery 9.2.6
- memory
- Memory Advisors
- MMON process 5.1.2
- modifying
- multitenant container databases
N
- NETCA
- See: Net Configuration Assistant (NETCA)
- Net Configuration Assistant (NETCA)
- net service name 4.1.2
- network configuration
- connection requests 4.1.1
- description 4.1
- NUMBER data type 8.4.1.2.1
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
- ORACLE_BASE environment variable 2.2
- ORACLE_HOME environment variable 2.2
- Oracle ASM
- Oracle Automatic Storage Management
- Oracle base directory 2.1.2.4
- Oracle Data Guard
- tuning SQL statements on a standby 10.3.7, 10.3.7.1
- viewing performance statistics on a standby 10.1.3
- 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
- patches 14.1
- patch sets 14.1
- PDBs
- Performance Hub
- saving AWR data to a report 10.1.2
- saving data to a report 10.1.2
- viewing performance data 10.1.2
- PGA
- PGA Advisor
- pluggable databases
- 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)
Q
- quotas
- assigning for a tablespace 7.5.5
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
- customized 9.8
- Oracle suggested 9.7
- Resource Management features
- accessing in EM Express 12.1.8
- Resource Manager
- resource plan
- RESOURCE role 7.2, 8.2
- revalidating schema objects 8.7.2
- RMAN
- roles
- rollback 6.5.1
- rollback segments
S
- sample schemas
- schema objects
- schemas 7.1
- SecureFiles LOBs 8.4.1.4.4
- security options 2.1.2.7
- segments
- sequences
- server parameter files 5.1, 5.1.1
- server processes
- services
- on Microsoft Windows 5.2.2
- setting
- SGA
- Shared Pool Advisor
- shared server mode 2.3.2.8.4
- shared server processes 5.1.3
- shutting down databases
- SID 2.1.2.6
- SMON process 5.1.2
- snapshots 10.1.4
- source code, Java 8.7.1
- SPA Quick Check
- about 11.1
- configuring 11.2
- validating the impact of an initialization parameter change 11.3, 11.3.1
- validating the impact of implementing a SQL profile 11.4, 11.4.1
- validating the impact of implementing multiple SQL profiles 11.4.2, 11.4.3
- SQL Advisors
- SQL Performance Analyzer
- SQL Performance Analyzer Quick Check
- SQL profile 10.3.3
- validating the impact of implementing 11.4, 11.4.1
- validating the impact of implementing multiple profiles 11.4.2, 11.4.3
- SQL statements
- SQL trial
- comparing a pre-change trial and post-change trial 11.6.4
- creating a post-change trial 11.6.3
- creating a pre-change trial 11.6.2
- SQL Tuning Advisor
- SQL tuning set
- standby database
- starting databases
- startup and shutdown
- storage options
- specifying during database creation 2.3.2.4
- subprograms 8.7.1
- synonyms
- and privileges 8.8
- description 8.8
- 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
- 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
- tablespaces
- templates
- temporary tablespaces 6.1.6.2
- TEMP tablespace 6.1.6
- test database
- triggers 8.7.1
U
- undo
- Undo Advisor
- computing minimum undo tablespace size with 6.5.4
- description 10.3.1
- setting minimum undo retention period with 6.5.4
- undo retention 6.5.1
- undo retention period
- setting with Undo Advisor 6.5.4
- undo tablespaces
- autoextend 6.5.2
- changing to fixed-size 6.5.5
- computing minimum size for fixed-size tablespace 6.5.4
- default configuration 6.5.1
- description of 6.5.1
- UNDOTBS1 tablespace 6.1.6
- user-defined data types 8.4.1.4.1
- users
- USERS tablespace 6.1.6
V
- validating schema objects 8.7.2
- VARCHAR2 data type 8.4.1.2.1
- viewing
- views
Back to main content