Index
A B C D E F G I J L M N O P Q R S T U V W
A
- adding
-
- columns to a table, 8.3.5.1
- disks to ASM disk groups, A.8
- table constraints, 8.3.5.3
- ADDM
-
- See Automatic Database Diagnostics Monitor
- administering
-
- ASM, A.1
- users, 7.5
- administrative user accounts, 7.3
-
- SYS, 5.1.5.1, 7.3.1
- SYSTEM, 5.1.5.1
- advisors
-
- Automatic Database Diagnostics Monitor (ADDM), 10.3.1
- Buffer Cache Advisor, 10.3.1, 10.3.1
- description, 10.3.1
- Memory Advisor, 10.3.1, 10.3.1
-
- using, 10.3.8
- performance, 10.3.1
- PGA Advisor, 10.3.1, 10.3.1
- repairing critical errors, 11.2.6
- Segment Advisor, 10.3.1
-
- using, 6.3.4.1
- SGA Advisor, 10.3.1
- Shared Pool Advisor, 10.3.1, 10.3.1
- SQL Access Advisor, 10.3.1
-
- using, 10.3.2
- SQL Tuning Advisor, 10.3.1
-
- using, 10.3.6
- Undo Advisor, 6.5.4, 10.3.1
- alerts
-
- reviewing critical errors, 11.2.2
- ALTER SYSTEM statement, 5.3
- archived redo log files
-
- advantages of using, 2.3.2.7
- description, 2.3.2.7, 6.1.3
- ARCHIVELOG mode, 2.3.2.7
- archiving, 2.3.2.7
- ARCn processes, 5.1.2
- ASM
-
- See Automatic Storage Management
- Automatic Database Diagnostics Monitor (ADDM)
-
- description, 10.3.1
- findings, 10.1.2
- modifying snapshot frequency and retention, 10.2.4
- overview, 10.1.2
- snapshots, 10.1.2
- viewing performance analysis, 10.2.1
- Automatic Diagnostic Repository, 11.1
- automatic memory management, 2.3.2.9.1, 5.4.1
-
- enabling, 5.4.2
- modifying settings, 5.4.3
- automatic PGA memory management
-
- modifying settings, 5.4.5
- automatic shared memory management, 2.3.2.9.1, 5.4.1
-
- modifying settings, 5.4.4
- Automatic SQL Tuning Advisor
-
- about, 10.3.3
- configuring, 10.3.4
- viewing results, 10.3.5
- Automatic Storage Management (ASM), 2.1.2.2, 2.1.2.2, A
-
- accessing the Home page, A.4
- administering, A.1
- backing up files, A.10
- definition, A.1
- disk discovery, A.2
- failure groups, A.2
- installing, A.3
- mirroring, A.1
- monitoring disk group space usage, A.5
- rebalancing, A.1
- Automatic Workload Repository, 10.1.4.1
- AWR
-
- See Automatic Workload Repository
B
- background processes
-
- and database configuration, 2.3.2.9.2
- archiver (ARCn), 5.1.2
- checkpoint, 5.1.2
- database writer (DBWn), 5.1.2
- description, 1.2, 5.1.2
- log writer (LGWR), 5.1.2
- manageability monitor (MMON), 5.1.2
- process monitor (PMON), 4.1.1, 5.1.2
- system monitor (SMON), 5.1.2
- use by database instances, 5.1
- backup
-
- available, 9.6.1
- backup pieces, 9.3.5.1
- channels, 9.3.5.1
- consistent, 9.2.1
- 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.3
- for Automatic Storage Management files, A.10
- full backup of datafiles, 9.4.1.1
- image copies, 9.3.5.1
- inconsistent, 9.2.1
- incremental backup of datafiles, 9.4.1.2
- making unavailable, 9.6.4
- managing, 9.6
- obsolete, 9.6.1
- Oracle suggested backup strategy, 9.4.2.2
- overview, 9.1
- sets, 9.3.5.1
- settings, 9.3.5
- tags, 9.4.1.4
- unavailable, 9.6.1
- validating, 9.4.3
- whole database backup, 9.4.2.1
- backup and recovery area
-
- specifying during database creation, 2.3.2.7
- BasicFiles, 8.3.1.5.1
- blackouts
-
- defining time periods, 3.7.2
- description, 3.7.1
- block size
-
- configuring for the database, 2.3.2.9.2
- Buffer Cache Advisor
-
- description, 10.3.1
C
- central database management
-
- configuring, 2.3.2.3
- character sets
-
- defining, 2.3.2.9.3
- description, 2.3.2.9.3
- checkpoint
-
- of the database, 5.1.2
- checkpoint process, 5.1.2
- classes, Java, 8.6.1
- CLOB data type, 8.3.1.2.1
- code
-
- database-resident, 8.6.1
- columns
-
- adding, 8.3.5.1
- deleting, 8.3.5.2
- comments
-
- adding to problem activity logs, 11.2.6
- compiling schema objects, 8.6.2
- compressed tables, 8.3.1.5.3
- configuring
-
- Automatic SQL Tuning Advisor, 10.3.4
- connect descriptors
-
- description, 4.1.2
- example, 4.1.2
- CONNECT role, 7.2
- connect strings
-
- description, 4.1.3
- connection modes
-
- configuring, 2.3.2.9.4
- connection privileges
-
- SYSASM, A.1
- SYSDBA, 5.1.5.1
- SYSOPER, 5.1.5.1
- constraints, 8.3.1.3
-
- adding, 8.3.5.3
- deleting, 8.3.5.5
- modifying, 8.3.5.4
- control files
-
- description, 6.1.1
- multiplexing, 6.1.1
- SQL*Loader, 8.3.6
- creating
-
- databases
-
- overview, 2.1
- steps, 2.2
- using standalone DBCA, 2.3
- indexes, 8.4.3
- service requests, 11.2.4
- tables, 8.3.4
- users, 7.5.2
- customized repairs, 9.8
D
- data
-
- loading, 8.3.6
- data blocks
-
- description of, 2.3.2.9.2, 6.1.5
- data dictionary tables
-
- access to as user SYS, 7.3.2
- data integrity, 8.3.1.3
- Data Recovery Advisor, 9.7
- data types
-
- CLOB, 8.3.1.2.1
- DATE, 8.3.1.2.1
- NUMBER, 8.3.1.2.1
- overview, 8.3.1.2.1
- user-defined, 8.3.1.5.1
- VARCHAR2, 8.3.1.2.1
- database administration
-
- privileges required, 7.3
- 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 Control
-
- See Oracle Enterprise Manager Database Control
- database links
-
- description, 8.7
- database objects
-
- naming, 8.1
- Database Upgrade Assistant (DBUA)
-
- overview, 12.4.1
- restrictions on versions, 12.4.2
- starting, 12.4.3
- steps for upgrading, 12.4.4
- database-resident program code, 8.6.1
- databases
-
- advisors
-
- using, 10.3.1
- alerts, 10.1.1
-
- responding to alerts, 10.1.4.3
- setting metric thresholds, 10.1.4.2
- setting notification rules, 10.1.4.5
- viewing metrics, 10.1.4.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
-
- roadmap, 3.1
- with Oracle Enterprise Manager Database Control, 3
- metric thresholds, 10.1.1
- monitoring
-
- alert-based, 10.1.1
- performance, 10.1
- overview of creating, 2.1
- performance
-
- advisors, 10.3.1
- monitoring, 10.1
- recovery
-
- description, 9.2, 9.2
- point-in-time, 9.2.2
- restoring
-
- description, 9.2
- 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, 12.4, 12.4.4
- users, 7
- using DBCA templates, 2.3.5
- datafiles
-
- 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.3.5.1
- data blocks, 6.1.5
- description of, 6.1.5
- example of corrupt block detection, 9.7.2
- extents, 6.1.5
- full backups, 9.4.1.1
- image copies of, 9.4.1.1
- media recovery, 9.2.2
- missing, 9.1
- recovering from the loss of, 9.8.4
- recovery without restoration, 9.1
- restoring from consistent and inconsistent backups, 9.2.1
- segments, 6.1.5
- SQL*Loader, 8.3.6
- tempfiles, 6.1.5
- validating backups of, 9.4.3.2
- DATE data type, 8.3.1.2.1
- DBA role, 7.2, 8.2
- DBCA
-
- See Database Configuration Assistant
- DBUA
-
- See Database Upgrade Assistant
- DBWn processes, 5.1.2
- dedicated server mode, 2.3.2.9.4
- dedicated server processes, 5.1.3
- deleting
-
- constraints, 8.3.5.5
- databases, 2.3.4
- table columns, 8.3.5.2
- tables, 8.3.7
- users, 7.5.9
- views, 8.5.4
- disk discovery
-
- in Automatic Storage Management, A.2
- disk groups
-
- adding disks to, A.8
- creating, A.6
- dropping, A.7
- dropping disks from, A.9
- monitoring disk space usage, A.5
- overview, A.2
- dropping
-
- disk groups, A.7
- disks from disk groups, A.9
- tablespaces, 6.3.3
- undoing with Flashback Drop, 9.8.2.1
- duplicating
-
- databases, 2.3.5
- users, 7.5.3
E
- emctl, 3.3
- enabling
-
- automatic memory management, 5.4.2
- Enterprise Manager
-
- See Oracle Enterprise Manager Database Control
- EXAMPLE tablespace, 6.1.6
-
- configuring, 2.3.2.8
- expiring passwords
-
- reasons for, 7.5.8
- extending
-
- tablespaces, 6.1.6.4, 6.3.2.1
- tablespaces and Oracle Flashback, 6.5.2
- undo tablespaces, 6.5.1, 6.5.2
- extents
-
- description of, 6.1.5
F
- failure groups, A.2
- flash recovery area, 9.2.3
-
- configuring, 9.3.3
- retention policies, 9.3.2.1
- specifying during database creation, 2.3.2.7
- Flashback Database, 9.8.3
- Flashback Drop, 9.8.2
- flashback features
-
- Flashback Database, 9.8.3
- Flashback Drop, 9.8.2
- Flashback Table, 9.8.1
- Flashback Table, 9.8.1, 9.8.1.2
- functions, PL/SQL, 8.6.1
G
- global database names, 2.1.2.1
- global indexes, 8.4.1.2.5
- granting
-
- privileges, 7.5.4
- roles, 7.5.4
- grid control
-
- configuring, 2.3.2.3
I
- incidents
-
- about, 11.1
- closed, viewing, 11.3
- closing, 11.2.7
- tracking, 11.1
- indexes
-
- creating, 8.4.3, 8.4.3
- description, 8.4.1
- global, 8.4.1.2.5
- partitioned, 8.4.1.2.5
- viewing, 8.4.2
- initialization parameters
-
- description, 5.1.1
- server parameter files, 5.1.1
- viewing and modifying, 5.3
- installation
-
- checking prerequisites, 2.1.1
- choices, 2.1.2
- of ASM, A.3
- overview, 2.1
- steps, 2.2
- storage options, 2.1.2.2
- using DBCA for database, 2.3
- instances
-
- database instances, 5.1
- management, 5.1
- memory structure, 5.1.4
- Oracle instances, 5.1
- PGA
-
- definition, 5.1.4.2
- shutdown, 5.1.5.3
- startup, 5.1.5.2
- invalid schema objects, 8.6.1
J
- Java classes, 8.6.1
- Java source code, 8.6.1
L
- LGWR process, 5.1.2
- listener.ora files, 4.1.1
- listeners
-
- See Oracle listeners
- Load Data wizard
-
- using, 8.3.6
- loading data, 8.3.6
- LOB columns, 8.3.1.5.1
- local database management
-
- configuring, 2.3.2.3
- locking and unlocking users, 7.5.7
- log switch
-
- description, 2.3.2.7
M
- managing
-
- memory, 5.4
- media recovery, 9.2.2
- memory
-
- configuring, 2.3.2.9.1
- management, 5.1.4, 5.4, 5.4.1
- requirements, 2.1.1
- structure of in an Oracle instance, 5.1.4
- Memory Advisors
-
- description, 10.3.1, 10.3.1
- using, 10.3.8
- mirroring, A.1
- MMON process, 5.1.2
- modifying
-
- initialization parameters, 5.3
- table attributes, 8.3.5
- table constraints, 8.3.5.4
- users, 7.5.6
N
- Net Configuration Assistant (NETCA)
-
- description, 4.1.5.1
- NETCA
-
- See Net Configuration Assistant (NETCA)
- network configuration
-
- connection requests, 4.1.1
- description, 4.1
- notification of alerts
-
- alert notification, 3.7.1
- NUMBER data type, 8.3.1.2.1
O
- object privileges, 7.2
- offline tablespaces, 6.3.2.3
- Oracle Enterprise Manager Database Control
-
- accessing the ASM Home page, A.4
- backup, 9.4.2
- backup and recovery, 9.3.1
- configuration information, 2.2
- description, 3.2
- features, 3.2.1
- granting administrative privileges to use, 3.6
- managing databases, 3
- online help, 3.2.3
- starting and stopping, 3.3
- Oracle listeners
-
- listener.ora file, 4.1.1
- starting
- Oracle Net
-
- description, 4.1
- listener configuration, 4.1.1, 4.2
- mapping methods, 4.1.4
-
- directory naming, 4.1.4.3
- easy connect naming, 4.1.4.1
- local naming, 4.1.4.2
- Oracle suggested repair, 9.7
- Oracle system identifier, 2.1.2.1
- ORACLE_BASE environment variable, 2.2, 2.2
- ORACLE_HOME environment variable, 2.2
P
- partitioned indexes, 8.4.1.2.5
- partitioned tables, 8.3.1.5.2
- password files, 6.1.7.2
- password policies
-
- default, 7.6.1
- description of, 7.6.1
- setting, 7.6
- passwords
-
- expiring, 7.5.8
- patch sets, 12.1
- patches, 12.1
- Patching wizard, 12.2.3
- PGA
-
- See Program Global Area
- PGA Advisor
-
- description, 10.3.1
- PMON process, 4.1.1, 5.1.2
- predefined roles, 7.2
- privileges
-
- administrative, 7.3
- and synonyms, 8.7
- authenticating SYSDBA and SYSOPER users, 6.1.7.2
- connection, 5.1.5.1
- for installation of Oracle Database sofware, 2.2
- granting, 7.5.4
- granting to a Database Control administrative user, 3.6
- object, 7.2
- recommended, 7.1
- required for database administration, 3.5, 7.3
- revoking a system, 7.5.4
- schema object management, 8.2
- SYSASM, A.1
- SYSDBA, 5.1.5.1, 9.3.1
- SYSOPER, 5.1.5.1
- system, 7.2
- taking tablespaces offline, 6.3.2.3
- users, 7.2
-
- using roles to manage, 7.2
- problem activity logs
-
- adding comments to, 11.2.6
- problems
-
- about, 11.1
- adding comments to activity logs, 11.2.6
- problem key, 11.1
- viewing, 11.3
- viewing detail, 11.2.3
- procedures, 8.6.1
- profiles, 7.6.1
- Program Global Area (PGA)
-
- components, 5.1.4.2
- definition, 5.1.4.2
- description, 5.1.4.2
- target setting, 10.3.8
Q
- quotas
-
- assigning for a tablespace, 7.5.5
R
- raw devices, 2.1.2.2
- rebalancing, A.1
- recovery
-
- complete, 9.2.2
- configuration, 2.3.2.7
- flash recovery area, 9.2.3
- incomplete, 9.2.2
- media, 9.2.2
- overview, 9.1
- whole database recovery, 9.8.3, 9.8.3
- Recovery Manager (RMAN)
-
- channels, 9.3.5.1
- control file use, 9.2.4
- overview, 9.1
- parallelism, 9.3.5.1
- recovery catalog, 9.2.4
- repository, 9.2.4
- recycle bins, 8.3.7
- redo log files
-
- description, 2.3.2.7, 6.1.2
- multiplexing, 6.1.2, 6.4.1
- redo log groups
-
- description, 2.3.2.7
- reference collection, 10.1.3
- repairs
-
- customized, 9.8
- Oracle suggested, 9.7
- RESOURCE role, 7.2, 8.2
- revalidating schema objects, 8.6.2
- revoking
-
- roles, 7.5.4
- system privileges, 7.5.4
- roles
-
- administering, 7.4
- CONNECT, 7.2
- DBA, 7.2, 8.2
- granting, 7.5.4
- predefined, 7.2
- RESOURCE, 7.2, 8.2
- revoking, 7.5.4
- using to manage user privileges, 7.2
- viewing, 7.4.1
- rollback segments
-
- description, 6.1.4
S
- sample schemas
-
- configuring, 2.3.2.8
- installation of, 2.1.2.2
- schema objects
-
- compiling, 8.6.2
- database links, 8.7
- description of, 8.1
- indexes, 8.4.1
-
- creating, 8.4.3
- viewing, 8.4.2
- invalid, 8.6.1
- privileges, 8.2
- sequences, 8.7
- synonyms, 8.7
- tables, 8.3.1
-
- constraints, 8.3.1.3
- modifying, 8.3.5
- validating, 8.6.2
- views, 8.5.1
- schemas, 7.1
- SecureFiles, 8.3.1.5.1
- Segment Advisor
-
- description, 10.3.1
- using, 6.3.4.1
- segments
-
- description of, 6.1.5
- sequences
-
- description, 8.7
- server parameter files, 5.1.1
- server processes
-
- description, 5.1.3
- service requests
-
- creating, 11.2.4
- tracking, 11.2.6
- services
-
- on Microsoft Windows, 5.2.2
- session
-
- description of, 5.1.4.2
- setting
-
- password policies, 7.6
- SGA
-
- See System Global Area
- Shared Pool Advisor
-
- description, 10.3.1
- shared server mode, 2.3.2.9.4
- shared server processes, 5.1.3
- shutting down databases
-
- Microsoft Windows, 5.2.2
- SID, 2.1.2.1, 2.1.2.1
- SMON process, 5.1.2
- snapshots, 10.1.2
- source code, Java, 8.6.1
- SQL Access Advisor
-
- using, 10.3.2
- SQL Advisors
-
- about, 10.3.2
- description, 10.3.1
- SQL Profile, 10.3.3
- SQL Response Time, 10.1.3
- SQL statements
-
- about, 3.8
- SQL Tuning Advisor
-
- about, 10.3.2
- using, 10.3.6
- SQL Tuning Set, 10.1.3
- SQL*Loader
-
- control file, 8.3.6
- starting databases
-
- Microsoft Windows, 5.2.2
- startup and shutdown
-
- about, 5.1.5
- privileges required for, 5.1.5.1
- subprograms, 8.6.1
- Support Workbench
-
- about, 11
- Custom Packaging process, 11.2.5
- home page, 11.2.1
- Quick Packaging process, 11.2.5
- viewing problems, 11.3
- synonyms
-
- and privileges, 8.7
- description, 8.7
- SYS user, 5.1.5.1, 7.3.1
- SYSASM system privilege, A.1
- SYSAUX tablespace, 6.1.6
- SYSDBA system privilege, 5.1.5.1, 7.3.2
-
- authentication, 6.1.7.2
- SYSOPER system privilege, 7.3.2
-
- authentication, 6.1.7.2
- System Global Area (SGA)
-
- components, 5.1.4.1
- description, 5.1.4.1
- target setting, 10.3.8
- system identifier (SID), 2.1.2.1
- system privileges, 7.2
-
- SYSASM, A.1
- SYSDBA and SYSOPER, 7.3.2
- SYSTEM tablespace, 6.1.6
- SYSTEM user, 5.1.5.1, 7.3.1
T
- tables
-
- adding columns to, 8.3.5.1
- adding constraints, 8.3.5.3
- compressed, 8.3.1.5.3
- creating, 8.3.4
- deleting, 8.3.7
- deleting columns, 8.3.5.2
- deleting constraints, 8.3.5.5
- description, 8.3.1
- loading data into, 8.3.6
- LOB columns, 8.3.1.5.1
- modifying attributes, 8.3.5
- modifying constraints, 8.3.5.4
- partitions, 8.3.1.5.2
- retrieving a dropped table, 9.8.2.2
- viewing data in, 8.3.3
- viewing information about, 8.3.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
- dictionary-managed, 6.1.6.1
- dropping, 6.3.3
- EXAMPLE, 6.1.6
- extending undo tablespaces, 6.5.1, 6.5.2
- locally managed, 6.1.6.1
- modifying, 6.3.2
- offline, 6.1.6.3, 6.3.2.3
- quotas, 7.5.5
- read only, 6.1.6.3
- read write, 6.1.6.3
- Segment Advisor, 6.3.2
- SYSAUX, 6.1.6
- SYSTEM, 6.1.6
- TEMP, 6.1.6
- temporary, 6.1.6.2
- types of, 6.1.6.2
- UNDOTBS1, 6.1.6
- USERS, 6.1.6
- TEMP tablespace, 6.1.6
- templates
-
- creating databases with, 2.3.2.1
- using with DBCA, 2.3.5
- triggers, 8.6.1
U
- undo
-
- about, 6.5.1
- advisor, 6.5.4
- managing, 6.5, 6.5.2
- tablespaces, 6.1.6.2
- viewing, 6.5.3
- 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 period
-
- setting with Undo Advisor, 6.5.4
- undo tablespaces
-
- autoextend, 6.5.1, 6.5.2
- changing to fixed-size, 6.5.5
- computing minimum size for fixed-size tablespace, 6.5.4
- description of, 6.1.6.2, 6.5.1
- UNDOTBS1 tablespace, 6.1.6
- Unicode
-
- description, 2.3.2.9.3
- upgrading a database, 12.4.4
- user-defined data types, 8.3.1.5.1
- users
-
- accounts
-
- administrative, 7.3
- description, 7
- administering, 7.5
- creating, 7.5.2
- creating by duplication, 7.5.3
- deleting, 7.5.9
- duplicating, 7.5.3
- expiring passwords for, 7.5.8
- locking and unlocking, 7.5.7
- modifying, 7.5.6
- privileges, 7.2
- SYSASM, A.1
- viewing, 7.5.1
- USERS tablespace, 6.1.6
V
- validating schema objects, 8.6.2
- VARCHAR2 data type, 8.3.1.2.1
- viewing
-
- indexes, 8.4.2
- initialization parameters, 5.3
- table data, 8.3.3
- table information, 8.3.2
- users, 7.5.1
- views, 8.5.2
- views
-
- deleting, 8.5.4
- description, 8.5.1
- displaying, 8.5.2
W
- wizards
-
- ASM migration, A.1
- Create Blackout, 3.7.2
- database creation, 2.3.2
- incident reporting, 11.2.1, 11.2.5
- Load Data wizard, 8.3.6
- Patching, 12.2.3
- Quick Packaging, 11.2.5
- Recovery, 9.2.2, 9.8, 9.8.3
- Schedule Customized Backup, 9.4.2.3
- SQL Access Advisor, 10.3.7