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
  • administrative user accounts
  • advisors
    • Automatic Database Diagnostics Monitor (ADDM) [1]
    • Buffer Cache Advisor [1]
    • description [1]
    • Memory Advisor
    • performance [1]
    • PGA Advisor [1]
    • SGA Advisor [1]
    • SQL Tuning Advisor
    • Undo Advisor [1] , [2]
  • ALTER SYSTEM statement [1]
  • archived redo log files
    • advantages of using [1]
    • description of [1] , [2]
    • viewing [1]
  • ARCHIVELOG mode [1]
  • archiving [1]
  • ARCn processes [1]
  • ASM
    • See: Oracle ASM
  • autobackup
    • of control file and server parameter file [1]
  • autoextend
    • data files and tablespaces [1]
  • Automatic Database Diagnostics Monitor (ADDM)
    • description [1]
    • findings [1]
    • overview [1]
    • responding to findings [1]
    • snapshots [1]
    • viewing findings [1]
    • viewing performance analysis [1]
  • automatic memory management
    • enabling [1]
    • modifying settings [1]
  • automatic PGA memory management
    • modifying settings [1]
  • automatic shared memory management
    • modifying settings [1]
  • Automatic SQL Tuning Advisor
    • about [1]
    • configuring [1]
    • viewing results [1]
  • AWR report
    • for Performance Hub data [1]

B

  • background processes
    • and database configuration [1]
    • archiver (ARCn) [1]
    • checkpoint [1]
    • database writer (DBWn) [1]
    • description [1] , [2]
    • listener registration (LREG) [1]
    • log writer (LGWR) [1]
    • manageability monitor (MMON) [1]
    • process monitor (PMON) [1]
    • system monitor (SMON) [1]
    • use by database instances [1]
  • backup
    • available [1]
    • backup pieces [1]
    • consistent [1]
    • cross-checking [1] , [2]
    • deleting expired backups [1]
    • deleting obsolete backups [1]
    • expired [1]
    • files [1]
    • full backup of data files [1]
    • image copies [1]
    • inconsistent [1]
    • incremental backup of data files [1]
    • listing [1]
    • making unavailable [1]
    • managing [1]
    • obsolete [1]
    • overview [1]
    • sets [1]
    • settings [1]
    • tags [1]
    • unavailable [1]
    • validating [1]
    • whole database backup [1]
  • backup and recovery area
    • specifying during database creation [1]
  • BasicFiles LOBs [1]
  • block size
    • configuring for the database [1]
  • Buffer Cache Advisor
    • description [1]

C

  • CDBs
    • cloning a PDB from a remote CDB [1]
    • cloning a PDB in the same CDB [1]
    • closing all the PDBs [1]
    • closing a PDB [1]
    • configuring Oracle Managed Files [1]
    • creating [1] , [2] , [3] , [4]
    • creating a new PDB from the seed [1]
    • dropping a PDB [1]
    • managing [1]
    • modifying a resource plan [1]
    • opening all the PDBs [1]
    • opening a PDB [1]
    • plugging in an unplugged PDB [1]
    • unplugging a PDB [1]
  • character sets
    • defining [1]
    • description [1]
  • checkpoint
    • of the database [1]
  • checkpoint process [1]
  • classes, Java [1]
  • CLOB data type [1]
  • code
    • database-resident [1]
  • columns
  • compiling schema objects [1]
  • compressed tables [1]
  • configuring
    • Automatic SQL Tuning Advisor [1]
  • connect descriptors
  • connection modes
    • configuring [1]
  • connection privileges
  • CONNECT role [1]
  • connect strings
    • description [1]
  • constraints
  • control files
    • description [1]
    • multiplexing [1]
  • creating
    • databases
      • overview [1]
      • steps [1]
      • using standalone DBCA [1]
    • indexes [1]
    • tables [1]
    • users [1]
  • Current ADDM Findings
    • responding to findings [1]
    • viewing findings [1]
  • customized repairs [1]

D

  • data
  • database
  • 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
  • database-resident program code [1]
  • databases
    • advisors
    • 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
    • recovery
      • description [1]
      • point-in-time [1]
    • restoring
      • description [1]
    • starting and stopping on Microsoft Windows [1]
    • steps for installing and creating [1]
    • storage structure
      • logical structures [1]
      • physical structures [1]
    • tuning [1]
    • upgrading [1] , [2]
    • users [1]
    • using DBCA templates [1]
  • Database Upgrade Assistant (DBUA)
    • overview [1]
    • restrictions on releases [1]
    • starting [1]
    • steps for upgrading [1]
  • data blocks
  • 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
  • DATE data type [1]
  • DBA role [1] , [2]
  • DBUA
    • See: Database Upgrade Assistant
  • DBWn processes [1]
  • dedicated server mode [1]
  • dedicated server processes [1]
  • deinstall tool
    • location [1]
    • syntax and options [1]
  • deleting
  • directory
    • Oracle base [1]
    • Oracle inventory [1]
  • dropping
    • tablespaces [1]
    • undoing with Flashback Drop [1]
  • duplicating
    • databases [1]

E

  • EM Express
    • See: Oracle Enterprise Manager Database Express
  • enabling
    • automatic memory management [1]
  • Enterprise Edition [1]
  • Enterprise Manager
    • See: Oracle Enterprise Manager Database Express
  • EXAMPLE tablespace
    • configuring [1]
  • expiring passwords
    • reasons for [1]
  • extending
    • datafiles [1]
    • tablespaces [1] , [2]
    • tablespaces and Oracle Flashback [1]
    • undo tablespaces [1]
  • extents
    • description of [1]

F

  • fast recovery area
    • configuring [1]
    • retention policies [1]
    • specifying during database creation [1]
  • Flashback Database [1]
  • Flashback Drop [1]
  • flashback features
    • Flashback Database [1]
    • Flashback Drop [1]
    • Flashback Table [1]
  • Flashback Table [1] , [2]
  • functions, PL/SQL [1]

G

  • global database name [1]
  • global indexes [1]
  • granting

H

  • HTTPS port
    • determining for a CDB [1]
    • determining for a non-CDB [1]
    • determining for a PDB [1]

I

  • incremental backups [1]
  • indexes
  • initialization parameter file [1]
  • initialization parameters
    • description [1]
    • how they are used by the database [1]
    • server parameter files [1] , [2]
    • viewing and modifying [1]
  • installation
    • checking prerequisites [1]
    • choices [1]
    • overview [1]
    • software location [1]
    • steps [1]
    • storage options [1]
    • using DBCA for database [1]
  • instances
    • database instances [1]
    • management [1]
    • memory structure [1]
    • Oracle instances [1]
    • PGA
      • definition [1]
    • shutdown [1]
    • startup [1]
  • invalid schema objects [1]

J

  • Java classes [1]
  • Java source code [1]

L

  • language
    • used by software [1]
  • LGWR process [1]
  • licensed software options [1]
  • listener.ora files [1]
  • listeners
    • See: Oracle listeners
  • Load Data wizard
  • 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
  • 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
  • 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
  • online redo log groups
    • description of [1]
    • inactive [1]
  • operating system groups [1]
  • ORACLE_BASE environment variable [1]
  • ORACLE_HOME environment variable [1]
  • Oracle ASM
    • installation [1]
  • Oracle Automatic Storage Management
    • See: Oracle ASM.
  • Oracle base directory [1]
  • Oracle Enterprise Manager Cloud Control [1]
  • Oracle Enterprise Manager Database Express
    • configuring the HTTPS port [1]
    • configuring the HTTPS port for a CDB [1]
    • configuring the HTTPS port for a non-CDB [1]
    • configuring the HTTPS port for a PDB [1]
    • description [1]
    • features [1]
    • managing databases [1]
    • setting the HTTPS port with the DBEXPRESS_HTTPS_PORT variable [1]
    • starting [1]
    • starting for a CDB [1]
    • starting for a non-CDB [1]
    • starting for a PDB [1]
  • Oracle inventory directory [1]
  • Oracle listeners
    • listener.ora file [1]
    • starting [1]
  • Oracle Managed Files
    • configuring for a CDB [1]
  • Oracle Net
    • description [1]
    • listener configuration [1] , [2]
    • mapping methods
      • directory naming [1]
      • easy connect naming [1]
      • local naming [1]
  • Oracle suggested repair [1]
  • Oracle system identifier [1]

P

  • parameter file [1]
  • partitioned tables [1]
  • password file [1]
  • password policies
  • passwords
  • patches [1]
  • patch sets [1]
  • PDBs
    • cloning from a PDB in a remote CDB [1]
    • cloning from a PDB in the same CDB [1]
    • closing all the PDBs in a CDB [1]
    • closing a PDB in a CDB [1]
    • creating [1] , [2] , [3] , [4]
    • creating from the seed [1]
    • dropping a PDB from a CDB [1]
    • managing [1] , [2] , [3]
    • managing with Containers page [1]
    • opening all the PDBs in a CDB [1]
    • opening a PDB in a CDB [1]
    • plugging in an unplugged PDB [1]
    • setting resource limits [1]
    • setting storage limits [1]
    • unplugging a PDB from a CDB [1]
  • Performance Hub
    • saving AWR data to a report [1]
    • saving data to a report [1]
    • viewing performance data [1]
  • PGA
    • See: Program Global Area
  • PGA Advisor
    • description [1]
  • pluggable databases
    • See: PDBs.
  • PMON process [1]
  • predefined roles [1]
  • privileges
    • administrative [1]
    • and synonyms [1]
    • authenticating SYSDBA, SYSOPER, and SYSBACKUP users [1]
    • connection [1]
    • for installation of Oracle Database software [1]
    • granting [1]
    • object [1]
    • recommended [1]
    • required for database administration [1] , [2]
    • schema object management [1]
    • SYSDBA [1]
    • SYSOPER [1]
    • system [1]
    • users
      • using roles to manage [1]
  • procedures [1]
  • profiles [1]
  • Program Global Area (PGA)
    • definition [1]
    • description [1]
    • target setting [1]

Q

  • quotas
    • assigning for a tablespace [1]

R

  • read consistency [1]
  • read only tablespaces [1]
  • read write tablespaces [1]
  • Real-Time ADDM
    • responding to findings [1]
    • viewing findings [1]
  • recovery
    • complete [1]
    • configuration [1]
    • fast recovery area [1]
    • incomplete [1]
    • media [1]
    • overview [1]
  • Recovery Manager (RMAN)
    • control file use [1]
    • overview [1]
    • recovery catalog [1]
    • repository [1]
  • recycle bins [1]
  • redo log files
    • See: online redo log files or archived redo log files
  • repairs
    • customized [1]
    • Oracle suggested [1]
  • RESOURCE role [1] , [2]
  • revalidating schema objects [1]
  • RMAN
  • roles
  • 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
    • invalid [1]
    • privileges [1]
    • sequences [1]
    • synonyms [1]
    • tables
      • constraints [1]
      • modifying [1]
    • validating [1]
    • views [1]
  • schemas [1]
  • SecureFiles LOBs [1]
  • security options [1]
  • segments
    • description of [1]
  • sequences
    • description [1]
  • server parameter files [1] , [2]
  • server processes
    • description [1]
  • services
    • on Microsoft Windows [1]
  • setting
    • password policies [1]
  • SGA
    • See: System Global Area
  • Shared Pool Advisor
    • description [1]
  • shared server mode [1]
  • shared server processes [1]
  • shutting down databases
    • Microsoft Windows [1]
  • SID [1]
  • SMON process [1]
  • snapshots [1]
  • source code, Java [1]
  • SQL Advisors
  • SQL Profile [1]
  • SQL statements
  • SQL Tuning Advisor
  • Standard Edition [1]
  • starting databases
    • Microsoft Windows [1]
  • startup and shutdown
    • about [1]
    • privileges required for [1]
  • subprograms [1]
  • synonyms
    • and privileges [1]
    • description [1]
  • SYSAUX tablespace [1]
  • SYSBACKUP privilege
    • and the password file [1]
    • granting [1]
  • SYSDBA [1]
  • SYSDBA system privilege [1] , [2] , [3]
  • SYSOPER [1]
  • SYSOPER system privilege [1] , [2]
  • System Global Area (SGA)
    • components [1]
    • description [1]
    • target setting [1]
  • system identifier (SID) [1]
  • system privileges
    • SYSDBA and SYSOPER [1]
  • SYSTEM tablespace [1]
  • SYSTEM user [1] , [2]
  • SYS user [1] , [2]

T

  • tables
    • adding columns to [1]
    • adding constraints [1]
    • compressed [1]
    • creating [1]
    • deleting [1]
    • deleting columns [1]
    • deleting constraints [1]
    • description [1]
    • loading data into [1]
    • LOB columns [1]
    • modifying attributes [1]
    • modifying constraints [1]
    • partitions [1]
    • retrieving a dropped table [1]
    • viewing data in [1]
    • viewing information about [1]
  • tablespaces
    • autoextend [1] , [2]
    • autoextend and Oracle Flashback [1]
    • creating [1]
    • description [1]
    • dropping [1]
    • EXAMPLE [1]
    • extending undo tablespaces [1]
    • locally managed [1]
    • modifying [1]
    • offline [1]
    • quotas [1]
    • read only and read write [1]
    • Segment Advisor [1]
    • SYSAUX [1]
    • SYSTEM [1]
    • taking offline [1]
    • TEMP [1]
    • temporary tablespaces [1]
    • types of [1]
    • undo tablespaces [1] , [2]
    • UNDOTBS1 [1]
    • USERS [1]
    • viewing information about [1]
  • templates
    • creating databases with [1]
    • using with DBCA [1]
  • temporary tablespaces [1]
  • TEMP tablespace [1]
  • triggers [1]

U

  • undo
  • Undo Advisor
    • computing minimum undo tablespace size with [1]
    • description [1]
    • setting minimum undo retention period with [1]
  • undo retention [1]
  • undo retention period
    • setting with Undo Advisor [1]
  • undo tablespaces
    • autoextend [1]
    • changing to fixed-size [1]
    • computing minimum size for fixed-size tablespace [1]
    • default configuration [1]
    • description of [1]
  • UNDOTBS1 tablespace [1]
  • upgrading a database [1]
  • user-defined data types [1]
  • users
    • accounts
      • administrative [1]
      • description [1]
    • administering [1]
    • creating [1]
    • deleting [1]
    • expiring passwords for [1]
    • locking and unlocking [1]
    • modifying [1]
    • privileges [1]
    • viewing [1]
  • USERS tablespace [1]

V

  • validating schema objects [1]
  • VARCHAR2 data type [1]
  • viewing
    • indexes [1]
    • initialization parameters [1]
    • table data [1]
    • table information [1]
    • users [1]
    • views [1]
  • views
    • deleting [1]
    • description [1]
    • displaying [1]

W

  • wizards
    • database creation [1]