Index
A B C D E F G H I L M N O P R S T U V
A
- adding
-
- disks to Automatic Storage Management disk group, A.9
- administrative user accounts
-
- SYS, 5.1.4.1
- SYSTEM, 5.1.4.1
- advisors
-
- Automatic Database Diagnostics Monitor (ADDM), 10.3.1
- Buffer Cache Advisor, 10.3.1
- description, 10.3
- Memory Advisor, 10.3.1
-
- using, 10.3.4
- performance, 10.3.1
- PGA Advisor, 10.3.1
- Segment Advisor, 10.3.1
-
- using, 6.2.5
- Shared Pool Advisor, 10.3.1
- SQL Access Advisor, 10.3.1
-
- using, 10.3.3
- SQL Tuning Advisor, 10.3.1
-
- using, 10.3.2
- Undo Advisor, 6.3.5, 10.3.1
- archive log files
-
- description, 6.1.3
- ARCHIVELOG mode, 2.3.2.7
- ASM
-
- see Automatic Storage Management
- Automatic Database Diagnostics Monitor (ADDM)
-
- description, 10.3.1
- modifying behavior, 10.2.3
- overview, 10.1.2
- viewing performance analysis, 10.2.1
- automatic shared memory configuration
-
- enabling, 5.4
- Automatic Storage Management, A
-
- accessing the Home page, A.4
- administering, A.1
- disk discovery, A.2
- installing, A.3
- monitoring disk group space usage, A.6
- starting up and shutting down, A.5
- Automatic Workload Repository, 10.1.4.1
B
- background processes
-
- description, 5.1.3
- backing up
-
- Automatic Storage Management files, A.11
- backup
-
- backup sets, 9.2.5.1.1
- consistent, 9.1.1.1
- crosschecking, 9.5.1, 9.5.3
- deleting expired backups, 9.5.4
- deleting obsolete backups, 9.5.6
- expired, 9.5.1
- full backup of datafiles, 9.3.1.1
- image copies, 9.2.5.1.1
- inconsistent, 9.1.1.1
- incremental backup of datafiles, 9.3.1.2
- making unavailable, 9.5.5
- managing, 9.5, 9.5.1, 9.5.1
- Oracle-suggested backup strategy, 9.3.2.2
- overview, 9.1
- settings
-
- configuring, 9.2.5
- validating, 9.3.3
- whole database backup, 9.3.2.1
- backup and recovery area
-
- specifying, 2.3.2.7
- backup files, 6.1.7.3
- blackout time periods
-
- defining, 3.5.1
- blackouts, 3.5
- block size
-
- configuring, 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
- client machine
-
- configuring network, 4.5
- compressed tables, 8.2.3.4
- connect descriptor
-
- description, 4.1.2
- example, 4.1.2
- connect string
-
- description, 4.1.3
- example, 4.1.3
- connection mode
-
- configuring, 2.3.2.9.4
- connection privileges
-
- SYSDBA, 5.1.4.1
- SYSOPER, 5.1.4.1
- constraints, 8.2.3.3
- control file
-
- description, 6.1.1
- multiplexing, 6.1.1
- creating a database
-
- steps, 2.2
- using standalone DBCA, 2.3
- credentials
-
- setting preferred, 3.5.2
- CTXSYS user, 7.1
D
- data
-
- loading, 8.7
- data integrity, 8.2.3.3
- database
-
- startup and shutdown, 5.2
- Database Configuration Assistant
-
- configuring database options, 2.3.3
- deleting a database, 2.3.4
- managing database templates, 2.3.5
- using to create a database, 2.3
- database objects
-
- naming, 8.1.2
- database resident program units, 8.5
- Database Upgrade Assistant
-
- overview, 2.4.1
- restrictions on versions, 2.4.2
- starting, 2.4.3
- steps for upgrading, 2.4.4
- databases
-
- advisors
-
- using, 10.3
- alerts, 10.1.1
-
- responding to alerts, 10.1.4.3
- setting metrics, 10.1.4.2
- setting notification rules, 10.1.4.5
- viewing metrics, 10.1.4.1
- backup
-
- description, 9.1.1
- 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
- managing
-
- roadmap, 3.7
- managing with Enterprise Manager Database Control, 3
- metrics thresholds, 10.1.1
- monitoring
-
- alert-based, 10.1.1
- monitoring performance, 10.1
- performance
-
- advisors, 10.3.1
- recovery
-
- description, 9.1.1
- steps for installing/creating, 2.2
- storage structure
-
- logical structures, 6.1
- physical structures, 6.1
- tuning, 10.1
- upgrading, 2.4
- users, 7
-
- creating, 7.4.1
- using DBCA templates, 2.3.5
- datafiles
-
- description, 6.1.6
- DBCA
-
- see Database Configuration Assistant
- dbconsole process
-
- starting, 3.2
- DBSNMP user, 7.1
- DBUA
-
- see Database Upgrade Assistant
- dedicated server mode, 2.3.2.9.4
- dedicated server process, 5.1.4.2
- deleting a database, 2.3.4
- disk discovery
-
- in Automatic Storage Management, A.2
- disk group
-
- overview, A.2
- disk group, Automatic Storage Management
-
- adding disks to, A.9
- creating, A.7
- dropping, A.8
- dropping disks from, A.10
- monitoring disk space usage, A.6
- DMSYS user, 7.1
- dropping
-
- disks from Automatic Storage Management disk group, A.10
E
- emctl
-
- starting, 3.2
- Enterprise Manager
-
- backup, 9.3.2
- backup and recovery, 9.2.2
- Enterprise Manager Console
-
- starting, 3.2
- Enterprise Manager Database Control
-
- description, 3.1
- features, 3.1.1
- granting administrative privileges to use, 3.4
- online help, 3.1.2
- starting, 3.3
- EXAMPLE tablespace, 6.1.5.1
-
- configuring, 2.3.2.8
F
- failure group, Automatic Storage Management, A.2
- file
-
- loading, 8.7
- flash recovery area, 9.1.1.3
-
- configuring, 9.2.3
- planning, 9.2.1.2
- retention policy, 9.2.1.1
- specifying, 2.3.2.7
- flashback drop
-
- description, 9.4.4
- Flashback Table
-
- steps, 9.4.3.2
- flashback table
-
- description, 9.4.3
- functions
-
- compile, 8.5.3
- create, 8.5.3
- definition, 8.5.3
- delete, 8.5.3
- execute, 8.5.3
- modify, 8.5.3
G
- global database name, 2.1.2.1
- global indexes, 8.3.2.1.5
- grid control
-
- configuring, 2.3.2.3
H
- host credentials, B.5.1
I
- indexes
-
- creating, 8.3.2.2
- description, 8.3
- global, 8.3.2.1.5
- local, 8.3.2.1.5
- partitioned, 8.3.2.1.5
- initialization parameter file
-
- server parameter file, 5.1.1
- initialization parameters
-
- description, 5.1.1
- memory parameters, 5.4
- viewing, 5.3
- installation
-
- checking prerequisites, 2.1.1
- choices, 2.1.2
- steps, 2.2
- using DBCA for database, 2.3
- instance
-
- database instance, 5.1
- description, 5.1
- management, 5.1
- memory structure, 5.1.2
- Oracle instance, 5.1
- shutdown, 5.1.4.1.2
- startup, 5.1.4.1.1
- isqlplus
-
- starting, 3.6.2
L
- listener
-
- starting, 4.4
- listener.ora file, 4.1.1
- loading data, 8.7
- LOB columns, 8.2.3.4
- local database management
-
- configuring, 2.3.2.3
- local indexes, 8.3.2.1.5
M
- MDDATA user, 7.1
- MDSYS user, 7.1
- media recovery, 9.1.1.2
- memory
-
- auto tuning, 5.4
- configuring, 2.3.2.9.1
- managing, 5.4
- Memory Advisor
-
- description, 10.3.1
- using, 10.3.4
- mirroring, Automatic Storage Management, A.1
N
- Net Manager tool, 4.5
- network
-
- configuring client, 4.5
- network configuration
-
- connection requests, 4.1.1
- description, 4.1
- notification of alerts
-
- alert notification, 3.5
O
- OLAPSYS user, 7.1
- Oracle listener
-
- starting, 4.4
- Oracle Net
-
- description, 4.1, 5.1.4.3
- listener configuration, 4.1.1
- mapping methods, 4.1.4
-
- directory naming, 4.1.4.2
- easy connect naming, 4.1.4.3
- external naming, 4.1.4.4
- local naming, 4.1.4.1
- Oracle Net Configuration Assistant
-
- description, 4.2.1
- oracle system identifier, 2.1.2.1
- ORDPLUGINS user, 7.1
- ORDSYS user, 7.1
- OSDBA, B.5.1
- OUTLN user, 7.1
P
- package bodies
-
- compile, 8.5.2
- create, 8.5.2
- definition, 8.5.2
- delete, 8.5.2
- modify, 8.5.2
- packages
-
- compile, 8.5.1.3
- definition, 8.5.1.1, 8.5.2.1
- modify, 8.5.1.3
- partitioned indexes, 8.3.2.1.5
- password files, 6.1.7.2
- PGA Advisor
-
- description, 10.3.1
- PGA target
-
- setting, 10.3.4
- preferred credentials, 3.5
-
- setting, 3.5.2
- privileges
-
- connection, 5.1.4.1
- object, 7.2.1
- SYSDBA, 9.2.2
- system, 7.2.1
- procedures
-
- compile, 8.5.3
- create, 8.5.3
- definition, 8.5.3
- delete, 8.5.3
- execute, 8.5.3
- modify, 8.5.3
- profiles
-
- administering, 7.3
- program global area (PGA)
-
- components, 5.1.2.2
- description, 5.1.2.2
R
- rebalancing, Automatic Storage Management, A.1
- recovery
-
- complete, 9.1.1.2
- configuring, 2.3.2.7
- flash recovery area, 9.1.1.3
- incomplete, 9.1.1.2
- media, 9.1.1.2
- overview, 9.1
- whole database recovery, 9.4.1, 9.4.1
- Recovery Manager (RMAN)
-
- repository, 9.1.1.4
- redo log files
-
- description, 6.1.2
- multiplexing, 6.1.2, 6.1.2.2
- roles
-
- administering, 7.2
- description, 7.2.1
- granting, 7.4.3.3
- viewing, 7.2.2
- rollback segments
-
- description, 6.1.4
S
- sample schemas
-
- configuring, 2.3.2.8
- schema objects
-
- accessing, 8.1.1
- description, 8.1
- indexes, 8.3
-
- creating, 8.3.2.2
- sequences, 8.6
- synonyms, 8.6
- tables, 8.2
-
- constraints, 8.2.3.3
- modifying, 8.2.4
- views, 8.4
- Segment Advisor
-
- description, 10.3.1
- using, 6.2.5
- sequences
-
- description, 8.6
- server parameter file, 5.1.1
- server processes
-
- description, 5.1.4.2
- services
-
- on Windows, 5.2.1
- SGA target
-
- setting, 10.3.4
- Shared Pool Advisor
-
- description, 10.3.1
- shared server mode, 2.3.2.9.4
- shared server process, 5.1.4.2
- shut down database
-
- Windows, 5.2.1
- shutdown
-
- database, 5.2
- SI_INFORMTN_SCHEMA user, 7.1
- SID, 2.1.2.1
- software
-
- steps for installing, 2.2
- source types
-
- description, 8.5
- managing, 8.5
- SQL Access Advisor
-
- description, 10.3.1
- using, 10.3.3
- SQL statements
-
- about, 3.6
- SQL Tuning Advisor
-
- description, 10.3.1
- using, 10.3.2
- sqlplus
-
- starting, 3.6.1
- standalone subprograms
-
- compile, 8.5.3
- create, 8.5.3
- definition, 8.5.3
- delete, 8.5.3
- execute, 8.5.3
- modify, 8.5.3
- starting database
-
- Windows, 5.2.1
- startup
-
- database, 5.2
- synonyms
-
- description, 8.6
- SYS user, 5.1.4.1, 7.1
- SYSAUX tablespace, 6.1.5.1
- SYSMAN user, 7.1
- system global area (SGA)
-
- components, 5.1.2.1
- description, 5.1.2.1
- SYSTEM tablespace, 6.1.5.1
- SYSTEM user, 5.1.4.1, 7.1
T
- table partitions, 8.2.3.4
- tables
-
- compressed, 8.2.3.4
- creating, 8.2.3
- description, 8.2
- estimating size, 8.2.3.5
- LOB columns, 8.2.3.4
- modifying, 8.2.4
- partitioned, 8.2.3.4
- tablespaces
-
- creating, 6.2.2
- data block, 6.1.5
- description, 6.1.5
- EXAMPLE, 6.1.5.1
- modifying, 6.2.3
- Segment Advisor, 6.2.3
- segments
-
- extents, 6.1.5
- SYSAUX, 6.1.5.1
- SYSTEM, 6.1.5.1
- TEMP, 6.1.5.1
- UNDOTBS1, 6.1.5.1
- USERS, 6.1.5.1
- TEMP tablespace, 6.1.5.1
- templates
-
- creating databases with, 2.3.2.1
- using with DBCA, 2.3.5
- temporary tablespace groups, 6.1.5.2
- tnsnames.ora file
-
- configuring, 4.5
- triggers
-
- compile, 8.5.4
- create, 8.5.4
- definition, 8.5.4
- modify, 8.5.4
U
- undo
-
- advisor, 6.3.5
- automatic undo management, 6.3.2
- managing, 6.3
-
- with Enterprise Manager, 6.3.4
- Undo Advisor
-
- description, 10.3.1
- undo tablespace, 6.3.2
-
- extending, 6.3.5.2
- UNDOTBS1 tablespace, 6.1.5.1
- upgrading a database, 2.4.4
-
- steps, 2.4.4
- user accounts
-
- description, 7
- unlocking, 7.4.3.2
- users
-
- creating, 7.4.1
- CTXSYS, 7.1
- DBSNMP, 7.1
- DMSYS, 7.1
- MDDATA, 7.1
- MDSYS, 7.1
- OLAPSYS, 7.1
- ORDPLUGINS, 7.1
- ORDSYS, 7.1
- OUTLN, 7.1
- provided by Oracle, 7.1
- SI_INFORMTN_SCHEMA, 7.1
- SYS, 7.1
- SYSMAN, 7.1
- SYSTEM, 7.1
- USERS tablespace, 6.1.5.1
V
- views
-
- description, 8.4