Index
A B C D E F G H I J K L M N O P Q R S T U V W X
A
- abort response, 32.3.1.1.3
-
- two-phase commit, 32.3.1.1.3
- accounts
-
- DBA operating system account, 1.5.1
- users SYS and SYSTEM, 1.5.2
- ADD LOGFILE clause
-
- ALTER DATABASE statement, 10.3.1
- ADD LOGFILE MEMBER clause
-
- ALTER DATABASE statement, 10.3.2
- adding
-
- columns, 18.6.6
- columns in compressed tables, 18.6.6.1
- ADMIN_TABLES procedure
-
- creating admin table, 23.3.1.1
- DBMS_REPAIR package, 23.2.1
- example, 23.4.1.1, 23.4.1.2
- ADMINISTER_RESOURCE_MANAGER system privilege, 25.1.5
- administering
-
- the Scheduler, 28
- administration
-
- distributed databases, 30
- ADR
-
- See automatic diagnostic repository
- ADR base, 8.1.4
- ADR home, 8.1.4
- ADRCI utility, 8.1.3.6
- Advisor
-
- Data Repair, 8.1.1
- Undo, 14.4
- AFTER SUSPEND system event, 17.2.4.1
- AFTER SUSPEND trigger, 17.2.4.1
-
- example of registering, 17.2.6
- agent
-
- Heterogeneous Services, definition of, 29.1.2
- aggregate functions
-
- statement transparency in distributed databases, 30.7
- alert log, 8.1.3.2
-
- about, 7.1.1
- size of, 7.1.1.1
- using, 7.1.1
- when written, 7.1.1.2
- alert thresholds
-
- setting for locally managed tablespaces, 17.1.1
- alerts
-
- server-generated, 7.1.2
- threshold-based, 7.1.2
- viewing, 17.1.2
- ALL_DB_LINKS view, 30.5.1, 30.5.1
- allocation
-
- extents, 18.6.4
- ALTER CLUSTER statement
-
- ALLOCATE EXTENT clause, 20.4
- using for hash clusters, 21.4
- using for index clusters, 20.4
- ALTER DATABASE ADD LOGFILE statement
-
- using Oracle-managed files, 15.3.6.1
- ALTER DATABASE statement
-
- ADD LOGFILE clause, 10.3.1
- ADD LOGFILE MEMBER clause, 10.3.2
- ARCHIVELOG clause, 11.3.2
- CLEAR LOGFILE clause, 10.8
- CLEAR UNARCHIVED LOGFILE clause, 10.2.1.1
- database partially available to users, 3.2.1
- DATAFILE...OFFLINE DROP clause, 13.4.2
- datafiles online or offline, 13.4.3
- DROP LOGFILE clause, 10.5.1
- DROP LOGFILE MEMBER clause, 10.5.2
- MOUNT clause, 3.2.1
- NOARCHIVELOG clause, 11.3.2
- OPEN clause, 3.2.2
- READ ONLY clause, 3.2.3
- RENAME FILE clause, 13.5.2
- tempfiles online or offline, 13.4.3
- UNRECOVERABLE DATAFILE clause, 10.8
- ALTER INDEX statement
-
- COALESCE clause, 19.2.10
- MONITORING USAGE clause, 19.4.5
- ALTER SEQUENCE statement, 22.2.3
- ALTER SESSION
-
- Enabling resumable space allocation, 17.2.2.2
- ALTER SESSION statement
-
- ADVISE clause, 33.4.3.3
- CLOSE DATABASE LINK clause, 31.2
- SET SQL_TRACE initialization parameter, 7.1.1.2
- setting time zone, 2.4.9.1
- ALTER SYSTEM statement
-
- ARCHIVE LOG ALL clause, 11.3.3
- DISABLE DISTRIBUTED RECOVERY clause, 33.9.2
- ENABLE DISTRIBUTED RECOVERY clause, 33.9.2
- ENABLE RESTRICTED SESSION clause, 3.2.4
- enabling Database Resource Manager, 25.5
- QUIESCE RESTRICTED, 3.4.1
- RESUME clause, 3.5
- SCOPE clause for SET, 2.6.6.1
- SET RESOURCE_MANAGER_PLAN, 25.5
- SET SHARED_SERVERS initialization parameter, 4.3.2.2
- setting initialization parameters, 2.6.6
- SUSPEND clause, 3.5
- SWITCH LOGFILE clause, 10.6
- UNQUIESCE, 3.4.2
- ALTER TABLE ADD COLUMN command, Preface
- ALTER TABLE statement
-
- ADD (column) clause, 18.6.6
- ALLOCATE EXTENT clause, 18.6.4
- DEALLOCATE UNUSED clause, 18.6.4
- DISABLE ALL TRIGGERS clause, 16.4.2
- DISABLE integrity constraint clause, 16.5.3.1
- DROP COLUMN clause, 18.6.8.1
- DROP integrity constraint clause, 16.5.3.3
- DROP UNUSED COLUMNS clause, 18.6.8.2
- ENABLE ALL TRIGGERS clause, 16.4.1
- ENABLE integrity constraint clause, 16.5.3.1, 16.5.3.1
- external tables, 18.13.2
- MODIFY (column) clause, 18.6.5
- modifying index-organized table attributes, 18.12.3.1
- MOVE clause, 18.6.3, 18.6.3, 18.12.3.2
- reasons for use, 18.6.1
- RENAME COLUMN clause, 18.6.7
- SET UNUSED clause, 18.6.8.2
- ALTER TABLESPACE statement
-
- adding an Oracle-managed datafile, example, 15.3.3.3
- adding an Oracle-managed tempfile, example, 15.3.4.2
- ONLINE clause, example, 12.5.2
- READ ONLY clause, 12.6.1
- READ WRITE clause, 12.6.2
- RENAME DATAFILE clause, 13.5.1.1
- RENAME TO clause, 12.8
- taking datafiles/tempfiles online/offline, 13.4.3
- ALTER TRIGGER statement
-
- DISABLE clause, 16.4.2
- ENABLE clause, 16.4.1
- altering
-
- (Scheduler) windows, 27.6.3
- event schedule, 27.8.3.4
- event-based job, 27.8.3.2
- job classes, 27.5.3
- jobs, 27.2.3
- programs, 27.3.3
- schedules, 27.4.3
- altering indexes, 19.4, 19.4.2
- ANALYZE statement
-
- CASCADE clause, 16.2.2
- CASCADE clause, FAST option, 16.2.2
- corruption reporting, 23.3.1.3
- listing chained rows, 16.2.3
- remote tables, 31.4.2.2.2
- validating structure, 16.2.2, 23.3.1
- analyzing schema objects, 16.2
- analyzing tables
-
- distributed processing, 31.4.2.2.2
- application development
-
- distributed databases, 29.5, 31, 31.5
- application development for distributed databases, 31
-
- analyzing execution plan, 31.4.4
- database links, controlling connections, 31.2
- handling errors, 31.3, 31.5
- handling remote procedure errors, 31.5
- managing distribution of data, 31.1
- managing referential integrity constraints, 31.3
- terminating remote connections, 31.2
- tuning distributed queries, 31.4
- tuning using collocated inline views, 31.4.1
- using cost-based optimization, 31.4.2
- using hints to tune queries, 31.4.3
- application services
-
- configuring, 2.7.2
- defining, 2.7
- deploying, 2.7.1
- using, 2.7.3
- using, client side, 2.7.3.1
- using, server side, 2.7.3.2
- ARCHIVE_LAG_TARGET initialization parameter, 10.2.5.1
- archived redo logs
-
- archiving modes, 11.3.2
- data dictionary views, 11.8.1
- destination availability state, controlling, 11.4.2
- destination status, 11.4.2
- destinations, specifying, 11.4
- failed destinations and, 11.6
- mandatory destinations, 11.6.1.1
- minimum number of destinations, 11.6.1
- multiplexing, 11.4.1
- normal transmission of, 11.5
- re-archiving to failed destination, 11.6.2
- sample destination scenarios, 11.6.1.2
- standby transmission of, 11.5
- status information, 11.8.1
- transmitting, 11.5
- ARCHIVELOG mode, 11.2.2
-
- advantages, 11.2.2
- archiving, 11.2
- automatic archiving in, 11.2.2
- definition of, 11.2.2
- distributed databases, 11.2.2
- enabling, 11.3.2
- manual archiving in, 11.2.2
- running in, 11.2.2
- switching to, 11.3.2
- taking datafiles offline and online in, 13.4.1
- archiver process
-
- trace output (controlling), 11.7
- archiver process (ARCn), 4.5
- archiving
-
- changing archiving mode, 11.3.2
- controlling number of processes, 11.3.4
- destination availability state, controlling, 11.4.2
- destination failure, 11.6
- destination status, 11.4.2
- manual, 11.3.3, 11.3.3
- NOARCHIVELOG vs. ARCHIVELOG mode, 11.2
- setting initial mode, 11.3.1
- to failed destinations, 11.6.2
- trace output, controlling, 11.7
- viewing information on, 11.8.1
- auditing
-
- database links, 29.3.3
- authentication
-
- database links, 29.3.2.1
- operating system, 1.6.3.2
- selecting a method, 1.6.2
- using password file, 1.6.4.1
- AUTO_TASK_CONSUMER_GROUP
-
- of Resource Manager, 24.5
- AUTOEXTEND clause
-
- for bigfile tablespaces, 12.7.2
- automatic diagnostic repository, 8.1.1, 8.1.3.1
-
- structure, contents and location of, 8.1.4
- Automatic Maintenance Tasks
-
- assigning to maintenance windows, 24.3.2
- definition, 24.1
- enabling and disabling, 24.3.1
- predefined, 24.1
- resource allocation, 24.5.1
- Automatic maintenance tasks
-
- Scheduler job names, 24.2
- automatic memory management, 5.1
-
- about, 5.3.1
- enabling, 5.3.2
- supported platforms, 5.5.1
- automatic segment space management, 12.2.1.2
- Automatic Storage Management
-
- initialization files and, 3.1.2
- automatic undo management, 2.4.4, 14.2, 14.2
-
- migrating to, 14.6
B
- background processes, 4.5
-
- FMON, 13.9.2.1.1
- BACKGROUND_DUMP_DEST initialization parameter, 8.1.3.1
- backups
-
- after creating new databases, 2.3.13
- effects of archiving on, 11.2.1
- batch jobs, authenticating users in, 2.8.3
- bigfile tablespaces
-
- creating, 12.2.2.1
- creating temporary, 12.2.4.2
- description, 12.2.2
- setting database default, 2.4.8.1
- BLANK_TRIMMING initialization parameter, 18.6.5
- BLOB datatype, 18.3.1
- BLOCKSIZE clause
-
- of CREATE TABLESPACE, 12.3
- buffer caches
-
- extended buffer cache (32-bit), 5.4.2.8.3
- multiple buffer pools, 5.4.2.2.2
- buffer pools, 5.4.2.2.2
- BUFFER_POOL_KEEP initialization parameter, 5.4.2.2.2
- BUFFER_POOL_RECYCLE initialization parameter, 5.4.2.2.2
- buffers
-
- buffer cache in SGA, 5.4.2.2
C
- CACHE option
-
- CREATE SEQUENCE statement, 22.2.4.2.2
- caches
-
- buffer
-
- multiple buffer pools, 5.4.2.2.2
- sequence numbers, 22.2.4.2
- calendaring expressions, 27.4.5.1
- calls
-
- remote procedure, 29.5.2
- capacity planning
-
- space management
-
- capacity planning, 17.6
- CASCADE clause
-
- when dropping unique or primary keys, 16.5.3.1
- CATBLOCK.SQL script, 7.2.1
- centralized user management
-
- distributed systems, 29.3.2.4
- chain rules, 27.9.4
- chain steps
-
- defining, 27.9.3
- chained rows
-
- eliminating from table, procedure, 16.2.3.2
- CHAINED_ROWS table
-
- used by ANALYZE statement, 16.2.3.1
- chains
-
- creating, 27.9.2
- creating jobs for, 27.9.6
- disabling, 27.9.10
- dropping, 27.9.7
- dropping rules from, 27.9.9
- enabling, 27.9.5
- handling stalled, 27.9.18
- monitoring running, 27.9.17
- overview, 26.5
- pausing, 27.9.14
- running, 27.9.8
- setting privileges, 28.1
- steps
-
- pausing, 27.9.14
- skipping, 27.9.15
- stopping, 27.9.12
- stopping individual steps, 27.9.13
- using, 27.9
- change vectors, 10.1.2
- CHAR datatype
-
- increasing column length, 18.6.5
- character set
-
- choosing, 2.1.1.1
- CHECK_OBJECT procedure
-
- DBMS_REPAIR package, 23.2.1
- example, 23.4.2
- finding extent of corruption, 23.3.2
- checkpoint process (CKPT), 4.5
- checksums
-
- for data blocks, 13.7
- redo log blocks, 10.7, 10.7
- CLEAR LOGFILE clause
-
- ALTER DATABASE statement, 10.8, 10.8
- clearing redo log files, 10.2.1.1, 10.8
- client/server architectures
-
- distributed databases, 29.1.3, 29.1.3
- globalization support, 29.6.1
- cloning
-
- a database, 1.2.11
- an Oracle home, 1.2.11
- CLOSE DATABASE LINK clause
-
- ALTER SESSION statement, 31.2
- closing database links, 30.4.1
- closing windows, 27.6.5
- clusters
-
- about, 20.1
- allocating extents, 20.4
- altering, 20.4
- analyzing, 16.2
- cluster indexes, 20.5
- cluster keys, 20.1, 20.2.2, 20.2.3
- clustered tables, 20.1, 20.2.1, 20.3.1, 20.4.1, 20.5.1
- columns for cluster key, 20.2.2
- creating, 20.3
- data dictionary views reference, 20.6
- deallocating extents, 20.4
- dropping, 20.5
- estimating space, 20.2.3, 20.2.5
- guidelines for managing, 20.2
- hash clusters, 21
- location, 20.2.4
- privileges, 20.3, 20.4, 20.5.1
- selecting tables, 20.2.1
- single-table hash clusters, 21.3.2
- sorted hash, 21.3.1
- truncating, 16.3
- validating structure, 16.2.2
- coalescing indexes
-
- costs, 19.2.10
- cold backup
-
- performing with a detached Oracle Scheduler job, 27.2.2.6
- collocated inline views
-
- tuning distributed queries, 31.4.1
- column encryption, 2.8.2
- columns
-
- adding, 18.6.6
- adding to compressed table, 18.6.6.1
- displaying information about, 18.14
- dropping, 18.6.8, 18.6.8.3
- dropping in compressed tables, 18.6.8.4
- encrypted, 18.2.7, 18.6.3
- increasing length, 18.6.5
- modifying definition, 18.6.5
- renaming, 18.6.7
- virtual, 18.1
- virtual, indexing, 19.2.2
- commands
-
- submitting, 1.3
- COMMENT statement, 18.14
- comments
-
- adding to problem activity log, 8.2.7
- COMMIT COMMENT statement
-
- used with distributed transactions, 33.2, 33.4.3.2
- commit phase, 32.3.1, 32.5.4
-
- in two-phase commit, 32.3.2, 32.3.2.2
- commit point site, 32.2.5
-
- commit point strength, 32.2.5.2, 33.1
- determining, 32.2.5.2
- distributed transactions, 32.2.5, 32.2.5.2
- how the database determines, 32.2.5.2
- commit point strength
-
- definition, 32.2.5.2
- specifying, 33.1
- COMMIT statement
-
- FORCE clause, 33.5, 33.5.1.1, 33.5.2
- forcing, 33.4.2
- two-phase commit and, 29.4.6
- COMMIT_POINT_STRENGTH initialization parameter, 32.2.5.2, 33.1
- committing transactions
-
- commit point site for distributed transactions, 32.2.5
- compressed tables
-
- adding a column, 18.6.6.1
- dropping columns in, 18.6.8.4
- compression, table, 18.2.6
- configuring
-
- Oracle Scheduler, 28.1
- CONNECT command
-
- starting an instance, 3.1.3
- CONNECT INTERNAL
-
- desupported, 1.6.2
- connected user database links, 30.2.3.2
-
- advantages and disadvantages, 29.2.7.1
- definition, 29.2.7
- example, 29.2.8
- REMOTE_OS_AUTHENT initialization parameter, 29.2.7.1
- connecting
-
- with SQL*Plus, 1.3.2
- connection qualifiers
-
- database links and, 30.2.4
- connections
-
- terminating remote, 31.2
- constraints
-
- See also integrity constraints
- disabling at table creation, 16.5.2.1
- distributed system application development issues, 31.3
- dropping integrity constraints, 16.5.3.3
- enable novalidate state, 16.5.1.3
- enabling example, 16.5.2.2
- enabling when violations exist, 16.5.1.3
- exceptions, 16.5.1.2, 16.5.5
- exceptions to integrity constraints, 16.5.5
- integrity constraint states, 16.5.1
- keeping index when disabling, 16.5.3
- keeping index when dropping, 16.5.3
- ORA-02055 constraint violation, 31.3
- renaming, 16.5.3.2
- setting at table creation, 16.5.2
- when to disable, 16.5.1.1
- control files
-
- adding, 9.3.2
- changing size, 9.3.1
- conflicts with data dictionary, 9.4.1
- creating, 9.1, 9.3, 9.3.3.2
- creating as Oracle-managed files, 15.3.5
- creating as Oracle-managed files, examples, 15.5.1
- data dictionary views reference, 9.8
- default name, 2.5.4, 9.3.1
- dropping, 9.7
- errors during creation, 9.4.2
- guidelines for, 9.2
- importance of multiplexed, 9.2.2
- initial creation, 9.3.1
- location of, 9.2.2
- log sequence numbers, 10.1.3.2
- mirroring, 2.5.4, 9.2.2
- moving, 9.3.2
- multiplexed, 9.2.2
- names, 9.2.1
- number of, 9.2.2
- overwriting existing, 2.5.4
- relocating, 9.3.2
- renaming, 9.3.2
- requirement of one, 9.1
- size of, 9.2.4
- specifying names before database creation, 2.5.4
- troubleshooting, 9.4
- unavailable during startup, 3.1.4
- CONTROL_FILES initialization parameter
-
- overwriting existing control files, 2.5.4
- specifying file names, 9.2.1
- when creating a database, 2.5.4, 9.3.1
- CONTROLFILE REUSE clause, 2.5.4
- copying jobs, 27.2.9
- coraenv and oraenv, 1.3.2.2
- core files, 8.1.3.3
- corruption
-
- repairing data block, 23.1
- cost-based optimization, 31.4.2
-
- distributed databases, 29.5.3
- hints, 31.4.3
- using for distributed queries, 31.4.2
- CREATE BIGFILE TABLESPACE statement, 12.2.2.1
- CREATE BIGFILE TEMPORARY TABLESPACE statement, 12.2.4.2
- CREATE CLUSTER statement
-
- creating clusters, 20.3
- example, 20.3
- for hash clusters, 21.3
- HASH IS clause, 21.3, 21.3.3.2
- HASHKEYS clause, 21.3, 21.3.3.4
- SIZE clause, 21.3.3.3
- CREATE CONTROLFILE statement
-
- about, 9.3.3.2
- checking for inconsistencies, 9.4.1
- creating as Oracle-managed files, examples, 15.3.5, 15.5.1
- NORESETLOGS clause, 9.3.3.3
- Oracle-managed files, using, 15.3.5
- RESETLOGS clause, 9.3.3.3
- CREATE DATABASE LINK statement, 30.2.2.1
- CREATE DATABASE statement
-
- CONTROLFILE REUSE clause, 9.3.1
- DEFAULT TEMPORARY TABLESPACE clause, 2.3.9, 2.4.6
- example of database creation, 2.3.9
- EXTENT MANAGEMENT LOCAL clause, 2.4.2
- MAXLOGFILES parameter, 10.2.4
- MAXLOGMEMBERS parameter, 10.2.4, 10.2.4
- password for SYS, 2.4.1
- password for SYSTEM, 2.4.1
- setting time zone, 2.4.9.1
- specifying FORCE LOGGING, 2.4.10
- SYSAUX DATAFILE clause, 2.3.9
- UNDO TABLESPACE clause, 2.3.9, 2.4.4
- used to create an undo tablespace, 14.5.1.1
- using Oracle-managed files, 15.3.2
- using Oracle-managed files, examples, 15.3.2.6, 15.5.1, 15.5.2
- CREATE INDEX statement
-
- NOLOGGING, 19.2.9
- ON CLUSTER clause, 20.3.2
- using, 19.3.1
- with a constraint, 19.3.3.1
- CREATE PFILE FROM MEMORY command, 2.6.8
- CREATE SCHEMA statement
-
- multiple tables and views, 16.1
- CREATE SEQUENCE statement, 22.2.2
-
- CACHE option, 22.2.4.2.2
- examples, 22.2.4.2.2
- NOCACHE option, 22.2.4.2.2
- CREATE SPFILE statement, 2.6.3
- CREATE SYNONYM statement, 22.3.2
- CREATE TABLE statement
-
- AS SELECT clause, 18.2.4, 18.3.3
- CLUSTER clause, 20.3.1
- COMPRESS clause, 18.12.2.7
- creating temporary table, 18.3.2
- example of, 18.3.1
- INCLUDING clause, 18.12.2.5
- index-organized tables, 18.12.2
- MONITORING clause, 18.5
- NOLOGGING clause, 18.2.5
- ORGANIZATION EXTERNAL clause, 18.13.1
- parallelizing, 18.3.3
- PCTTHRESHOLD clause, 18.12.2.4
- TABLESPACE clause, specifying, 18.2.3
- CREATE TABLESPACE statement
-
- BLOCKSIZE CLAUSE, using, 12.3
- FORCE LOGGING clause, using, 12.4
- using Oracle-managed files, 15.3.3
- using Oracle-managed files, examples, 15.3.3.1
- CREATE TEMPORARY TABLESPACE statement, 12.2.4.1
-
- using Oracle-managed files, 15.3.4
- using Oracle-managed files, example, 15.3.4.1
- CREATE UNDO TABLESPACE statement
-
- using Oracle-managed files, 15.3.3
- using Oracle-Managed files, example, 15.3.3.2
- using to create an undo tablespace, 14.5.1.2
- CREATE UNIQUE INDEX statement
-
- using, 19.3.2
- CREATE VIEW statement
-
- about, 22.1.2
- OR REPLACE clause, 22.1.3
- WITH CHECK OPTION, 22.1.2, 22.1.4
- CREATE_SIMPLE_PLAN procedure
-
- Database Resource Manager, 25.2
- creating
-
- chains, 27.9.2
- control files, 9.3
- databases, 2.1
- event schedule, 27.8.3.3
- event-based job, 27.8.3.1
- indexes, 19.3
-
- after inserting table data, 19.2.1
- associated with integrity constraints, 19.3.3
- NOLOGGING, 19.2.9
- online, 19.3.6
- USING INDEX clause, 19.3.3.1
- job classes, 27.5.2
- jobs, 27.2.2
- programs, 27.3.2
- Scheduler windows, 27.6.2
- schedules, 27.4.2
- sequences, 22.2.4.2.2, 22.2.4.2.2
- window groups, 27.7.2
- creating database links, 30.2
-
- connected user, 30.2.3.2.1
- connected user scenarios, 30.8.3
- current user, 30.2.3.2.2
- current user scenario, 30.8.5
- examples, 29.2.8
- fixed user, 30.2.3.1
- fixed user scenario, 30.8.1, 30.8.2
- obtaining necessary privileges, 30.2.1
- private, 30.2.2.1
- public, 30.2.2.2
- service names within link names, 30.2.4
- shared, 30.3
- shared connected user scenario, 30.8.4
- specifying types, 30.2.2
- creating databases, 2
-
- backing up the new database, 2.3.13
- default temporary tablespace, specifying, 2.4.6
- example, 2.3.9
- manually from a script, 2.1
- overriding default tablespace type, 2.4.8.2
- planning, 2.1.1
- preparing to, 2.1.1
- prerequisites for, 2.1.1.2
- setting default tablespace type, 2.4.8.1
- specifying bigfile tablespaces, 2.4.8, 2.4.8.2
- UNDO TABLESPACE clause, 2.4.4
- upgrading to a new release, 2.1
- using Oracle-managed files, 2.4.7, 15.3.2
- with DBCA, 2.2
- with locally managed tablespaces, 2.4.2
- creating datafiles, 13.2
- creating sequences, 22.2.2
- creating synonyms, 22.3.2
- creating views, 22.1.2
- credentials
-
- creating, 26.4.4.3.1
- granting privileges on, 26.4.4.3.1
- credentials, for remote external jobs, 26.4.4.3.1
- critical errors
-
- diagnosing, 8.1.1
- current user database links
-
- advantages and disadvantages, 29.2.7.3
- cannot access in shared schema, 29.3.2.4.2
- definition, 29.2.7
- example, 29.2.8
- schema independence, 29.3.2.4.2
- CURRVAL pseudo-column, 22.2.4.1
-
- restrictions, 22.2.4.1.3
- cursors
-
- and closing database links, 31.2
- customize package page, accessing, 8.10.3.2
- customizing an incident package, 8.10.3, 8.10.3.2
D
- data
-
- loading using external tables, 18.13.1
- data block corruption
-
- repairing, 23.1
- data blocks
-
- altering size of, 2.5.5.1
- nonstandard block size, 2.5.5.2
- shared in clusters, 20.1
- specifying size of, 2.5.5
- standard block size, 2.5.5
- verifying, 13.7
- data dictionary
-
- conflicts with control files, 9.4.1
- purging pending rows from, 33.6, 33.6.2
- See also views, data dictionary
- data encryption
-
- distributed systems, 29.3.2.5
- data manipulation language
-
- statements allowed in distributed transactions, 29.4.1
- Data Recovery Advisor, repairing data corruptions with, 8.9
- Data Repair Advisor, 8.1.1
- database
-
- cloning, 1.2.11
- creating, 2.1
- creating with DBCA, 2.2
- data dictionary views reference, 2.10
- starting up, 3.1
- database administrators
-
- DBA role, 1.5.2.3
- operating system account, 1.5.1
- password files for, 1.6.2.1
- responsibilities of, 1.1.1
- security and privileges of, 1.5
- security officer versus, 6.1
- SYS and SYSTEM accounts, 1.5.2
- task definitions, 1.2
- utilities for, 1.8
- database buffers
-
- multiple buffer pools, 5.4.2.2.2
- Database Configuration Assistant, 2.1
-
- shared server configuration, 4.3.3
- database links
-
- advantages, 29.2.3
- auditing, 29.3.3
- authentication, 29.3.2.1
- authentication without passwords, 29.3.2.2
- closing, 30.4.1, 31.2
- connected user, 29.2.7, 29.2.7.1, 30.2.3.2, 30.8.3
- connections, determining open, 30.5.2
- controlling connections, 31.2
- creating, 30.2, 30.8.1, 30.8.3, 30.8.4, 30.8.5
- creating shared, 30.3.2
- creating, examples, 29.2.8
- creating, scenarios, 30.8
- current user, 29.2.7, 29.2.7.3, 30.2.3.2
- data dictionary USER views, 30.5.1
- definition, 29.2.1
- distributed queries, 29.4.2
- distributed transactions, 29.4.5
- dropping, 30.4.2, 30.4.2
- enforcing global naming, 30.1.2
- enterprise users and, 29.3.2.4.2
- fixed user, 29.2.7, 29.2.7.2, 30.8.1
- global, 29.2.6
- global names, 29.2.4
- global object names, 29.4.7
- handling errors, 31.3
- limiting number of connections, 30.4.3
- listing, 30.5.1, 33.3.1, 33.3.2
- managing, 30.4
- minimizing network connections, 30.3
- name resolution, 29.4.7
- names for, 29.2.5
- private, 29.2.6
- public, 29.2.6
- referential integrity in, 31.3
- remote transactions, 29.4.1, 29.4.4
- resolution, 29.4.7
- restrictions, 29.2.10
- roles on remote database, 29.2.10
- schema objects and, 29.2.9
- service names used within link names, 30.2.4
- shared, 29.2.2, 30.3.1, 30.3.3, 30.3.3.1, 30.3.3.2
- shared SQL, 29.4.3
- synonyms for schema objects, 29.2.9.3
- tuning distributed queries, 31.4
- tuning queries with hints, 31.4.3
- tuning using collocated inline views, 31.4.1
- types of links, 29.2.6
- types of users, 29.2.7
- users, specifying, 30.2.3
- using cost-based optimization, 31.4.2
- viewing, 30.5, 30.5.1
- database objects
-
- obtaining growth trends for, 17.6.3
- database resident connection pooling, 4.2
-
- advantages, 4.2
- configuration parameters, 4.4.2
- configuring the connection pool, 4.4.2
- data dictionary views reference, 4.4.3
- disabling, 4.4.1
- enabling, 4.4.1
- restrictions, 4.2.2
- Database Resource Manager
-
- active session pool with queuing, 25.1.4.2
- administering system privilege, 25.1.5
- and operating system control, 25.10
- automatic consumer group switching, 25.1.4.4
- CREATE_SIMPLE_PLAN procedure, 25.2
- data dictionary views reference, 25.11.3
- description, 25.1
- enabling, 25.5
- execution time limit, 25.1.4.6
- resource allocation methods, 25.3.3, 25.3.4, 25.3.4, 25.3.4, 25.3.4, 25.3.4, 25.3.4, 25.3.4, 25.3.4
- resource consumer groups, 25.1.3, 25.3.3, 25.4
- resource plan directives, 25.1.3, 25.3.5, 25.3.6
- resource plans, 25.1.3, 25.1.3.6, 25.1.4.1, 25.2, 25.5, 25.5, 25.6, 25.6.3
- undo pool, 25.1.4.7
- used for quiescing a database, 3.4
- validating plan schema changes, 25.3.6
- database writer process
-
- calculating checksums for data blocks, 13.7
- database writer process (DBWn), 4.5
- DATABASE_PROPERTIES view
-
- rename of default temporary tablespace, 12.8
- databases
-
- administering, 1
- administration of distributed, 30
- altering availability, 3.2
- backing up, 2.3.13
- control files of, 9.2
- default temporary tablespace, specifying, 2.4.6
- dropping, 2.9
- global database names in distributed systems, 2.5.2.2
- mounting a database, 3.1.4.3
- mounting to an instance, 3.2.1
- names, about, 2.5.2.1
- names, conflicts in, 2.5.2.1
- opening a closed database, 3.2.2
- planning, 1.2.3
- planning creation, 2.1.1
- quiescing, 3.4
- read-only, opening, 3.2.3
- recovery, 3.1.4.6
- renaming, 9.3.3.1, 9.3.3.2, 9.3.3.3
- restricting access, 3.2.4
- resuming, 3.5
- shutting down, 3.3
- specifying control files, 2.5.4
- suspending, 3.5
- undo management, 2.4.4
- upgrading, 2.1
- with locally managed tablespaces, 2.4.2
- datafile headers
-
- when renaming tablespaces, 12.8
- datafiles
-
- adding to a tablespace, 13.2
- bringing online and offline, 13.4
- checking associated tablespaces, 12.14.2
- copying using database, 13.8
- creating, 13.2
- creating Oracle-managed files, 15.3, 15.3.6.2
- data dictionary views reference, 13.10
- database administrators access, 1.5.1
- default directory, 13.2
- definition, 13.1
- deleting, 12.9
- dropping, 13.4.2, 13.6
- dropping Oracle-managed files, 15.4.1
- file numbers, 13.1
- fully specifying filenames, 13.2
- guidelines for managing, 13.1
- headers when renaming tablespaces, 12.8
- identifying OS filenames, 13.5.1.2
- location, 13.1.3
- mapping files to physical devices, 13.9
- minimum number of, 13.1.1
- MISSING, 9.4.1
- online, 13.4.2
- Oracle-managed, 15
- relocating, 13.5
- renaming, 13.5
- reusing, 13.2
- size of, 13.1.2
- statements to create, 13.2
- storing separately from redo log files, 13.1.4
- unavailable when database is opened, 3.1.4
- verifying data blocks, 13.7
- DB_BLOCK_CHECKING initialization parameter, 23.3.1, 23.3.1.4
- DB_BLOCK_CHECKSUM initialization parameter, 13.7
-
- enabling redo block checking with, 10.7
- DB_BLOCK_SIZE initialization parameter, 5.4.2.2
-
- and nonstandard block sizes, 12.3
- setting, 2.5.5
- DB_CACHE_SIZE initialization parameter, 5.4.2.2.1
-
- specifying multiple block sizes, 12.3
- DB_CREATE_FILE_DEST initialization parameter, 15.2
-
- setting, 15.2.1
- DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 15.2
-
- setting, 15.2.3
- DB_DOMAIN initialization parameter
-
- setting for database creation, 2.5.2, 2.5.2.2
- DB_FILES initialization parameter
-
- determining value for, 13.1.1.1
- DB_KEEP_CACHE_SIZE initialization parameter, 5.4.2.2.2
- DB_NAME initialization parameter
-
- setting before database creation, 2.5.2
- DB_nK_CACHE_SIZE initialization parameter, 5.4.2.2.1
-
- specifying multiple block sizes, 12.3
- using with transportable tablespaces, 12.13.5.5
- DB_RECOVERY_FILE_DEST initialization parameter, 15.2
-
- setting, 15.2.2
- DB_RECYCLY_CACHE_SIZE initialization parameter, 5.4.2.2.2
- DBA role, 1.5.2.3
- DBA. See database administrators.
- DBA_2PC_NEIGHBORS view, 33.3.2
-
- using to trace session tree, 33.3.2
- DBA_2PC_PENDING view, 33.3.1, 33.6, 33.7.6
-
- using to list in-doubt transactions, 33.3.1
- DBA_DB_LINKS view, 30.5.1, 30.5.1, 30.5.1
- DBA_RESUMABLE view, 17.2.4.1
- DBA_UNDO_EXTENTS view
-
- undo tablespace extents, 14.7
- DBCA. See Database Configuration Assistant
- DBMS_FILE_TRANSFER package
-
- copying datafiles, 13.7
- DBMS_JOB
-
- about, A.1
- moving jobs to Oracle Scheduler, A.4
- DBMS_METADATA package
-
- GET_DDL function, 16.10.1
- using for object definition, 16.10.1
- DBMS_REDEFINITION package
-
- performing online redefinition with, 18.7.2
- required privileges, 18.7.9
- DBMS_REPAIR
-
- logical corruptions, 23.3.2
- DBMS_REPAIR package
-
- examples, 23.4
- limitations, 23.2.2
- procedures, 23.2.1
- using, 23.3, 23.4.5
- DBMS_RESOURCE_MANAGER package, 25.1.3, 25.1.5, 25.4.3
-
- procedures (table of), 25.1.5
- DBMS_RESOURCE_MANAGER_PRIVS package, 25.1.5
-
- procedures (table of), 25.1.5
- DBMS_RESUMABLE package, 17.2.4.3
- DBMS_SCHEDULER.GET_FILE, retrieving external job stdout with, 27.2.2.5
- DBMS_SERVER_ALERT package
-
- setting alert thresholds, 17.1
- DBMS_SPACE package, 17.3.4
-
- example for unused space, 17.5.1
- FREE_BLOCK procedure, 17.5.1
- SPACE_USAGE procedure, 17.5.1
- UNUSED_SPACE procedure, 17.5.1
- DBMS_STATS package, 16.2.1
-
- MONITORING clause of CREATE TABLE, 18.5
- DBMS_STORAGE_MAP package
-
- invoking for file mapping, 13.9.3.1
- views detailing mapping information, 13.9.3.3
- DBMS_TRANSACTION package
-
- PURGE_LOST_DB_ENTRY procedure, 33.6.1
- DBVERIFY utility, 23.3.1, 23.3.1.2
- DDL lock timeout, 2.5.7
- DDL_LOCK_TIMEOUT initialization parameter, 2.5.7
- DEALLOCATE UNUSED clause, 17.3.4
- deallocating unused space, 17.3
-
- DBMS_SPACE package, 17.3.4
- DEALLOCATE UNUSED clause, 17.3.4
- declarative referential integrity constraints, 31.3
- dedicated server processes, 4.1.1
-
- trace files for, 7.1.1
- default temporary tablespace
-
- renaming, 12.8
- default temporary tablespaces
-
- specifying at database creation, 2.3.9, 2.4.6
- specifying bigfile tempfile, 2.4.8.2
- DEFAULT_CONSUMER_GROUP
-
- for Database Resource Manager, 25.1.3.1
- DEFAULT_CONSUMER_GROUP for Database Resource Manager, 25.4.7, 25.4.7.2, 25.7.2
- defining
-
- chain steps, 27.9.3
- dependencies
-
- between schema objects, 16.7
- displaying, 16.10.2.2
- detached jobs, 26.4.4.4
- DIAGNOSTIC_DEST, 7.1.1
- DIAGNOSTIC_DEST initialization parameter, 8.1.4
- dictionary-managed tablespaces
-
- migrating SYSTEM to locally managed, 12.12
- Digital POLYCENTER Manager on NetView, 29.3.4.3
- direct-path INSERT
-
- benefits, 18.4.2.1
- how it works, 18.4.2.3
- index maintenance, 18.4.2.5.2
- locking considerations, 18.4.2.5.4
- logging mode, 18.4.2.4
- parallel INSERT, 18.4.2.2
- parallel load compared with parallel INSERT, 18.4.2.1, 18.4.2.1
- serial INSERT, 18.4.2.2
- space considerations, 18.4.2.5.3
- disabling
-
- chains, 27.9.10
- jobs, 27.2.7
- programs, 27.3.5
- SQL patch, 8.8.3
- window groups, 27.7.7
- windows, 27.6.7
- disabling recoverer process, 33.9.2
- dispatcher process (Dnnn), 4.5
- dispatcher processes, 4.3.3.3, 4.3.4
- DISPATCHERS initialization parameter
-
- setting attributes of, 4.3.3.1
- setting initially, 4.3.3.3
- distributed applications
-
- distributing data, 31.1
- distributed databases
-
- administration overview, 29.3
- application development, 29.5, 31, 31.5
- client/server architectures, 29.1.3
- commit point strength, 32.2.5.2
- cost-based optimization, 29.5.3
- direct and indirect connections, 29.1.3
- distributed processing, 29.1.1.1
- distributed queries, 29.4.2
- distributed updates, 29.4.2, 29.4.2
- forming global database names, 30.1.1
- global object names, 29.2.9.4, 30.1
- globalization support, 29.6
- location transparency, 29.5.1.1, 30.6
- management tools, 29.3.4
- managing read consistency, 33.10
- nodes of, 29.1.3
- overview, 29.1.1
- remote object security, 30.6.1
- remote queries and updates, 29.4.1
- replicated databases and, 29.1.1.2
- resumable space allocation, 17.2.1.4
- running in ARCHIVELOG mode, 11.2.2
- running in NOARCHIVELOG mode, 11.2.2
- scenarios, 30.8
- schema object name resolution, 29.4.8
- schema-dependent global users, 29.3.2.4.1
- schema-independent global users, 29.3.2.4.2
- security, 29.3.2
- site autonomy of, 29.3.1
- SQL transparency, 29.5.1.2
- starting a remote instance, 3.1.4.8
- transaction processing, 29.4
- transparency, 29.5.1
- distributed processing
-
- distributed databases, 29.1.1.1
- distributed queries, 29.4.2
-
- analyzing tables, 31.4.2.2.2
- application development issues, 31.4
- cost-based optimization, 31.4.2
- optimizing, 29.5.3
- distributed systems
-
- data encryption, 29.3.2.5
- distributed transactions, 29.4.5
-
- case study, 32.5
- commit point site, 32.2.5
- commit point strength, 32.2.5.2, 33.1
- committing, 32.2.5.1
- database server role, 32.2.2
- defined, 32.1
- DML and DDL, 32.1.1
- failure during, 33.8.1
- global coordinator, 32.2.4
- local coordinator, 32.2.3
- lock timeout interval, 33.8
- locked resources, 33.8
- locks for in-doubt, 33.8.2
- manually overriding in-doubt, 33.4.2
- naming, 33.2, 33.4.3.2
- session trees, 32.2, 32.2.2, 32.2.3, 32.2.4, 32.2.5, 33.3.2
- setting advice, 33.4.3.3
- transaction control statements, 32.1.2
- transaction timeouts, 33.8.1
- two-phase commit, 32.5, 33.4.1
- viewing database links, 33.3.1
- distributed updates, 29.4.2
- DML error logging, inserting data with, 18.4.1
- DML. See data manipulation language
- DRIVING_SITE hint, 31.4.3.2
- DROP CLUSTER statement
-
- CASCADE CONSTRAINTS clause, 20.5
- dropping cluster, 20.5
- dropping cluster index, 20.5
- dropping hash cluster, 21.5
- INCLUDING TABLES clause, 20.5
- DROP DATABASE statement, 2.9
- DROP LOGFILE clause
-
- ALTER DATABASE statement, 10.5.1
- DROP LOGFILE MEMBER clause
-
- ALTER DATABASE statement, 10.5.2
- DROP SYNONYM statement, 22.3.4
- DROP TABLE statement
-
- about, 18.10
- CASCADE CONSTRAINTS clause, 18.10
- for clustered tables, 20.5.1
- DROP TABLESPACE statement, 12.9
- dropping
-
- chain steps, 27.9.11
- chains, 27.9.7
- columns
-
- marking unused, 18.6.8.2
- remove unused columns, 18.6.8.2
- columns in compressed tables, 18.6.8.4
- datafiles, 13.6
- job classes, 27.5.4
- jobs, 27.2.6
- programs, 27.3.4
- rules from chains, 27.9.9
- schedules, 27.4.4
- SQL patch, 8.8.3
- tempfiles, 13.6
- window groups, 27.7.3
- windows, 27.6.6
- dropping database links, 30.4.2, 30.4.2
- dropping datafiles
-
- Oracle-managed, 15.4.1
- dropping tables
-
- CASCADE clause, 18.10
- consequences of, 18.10
- dropping tempfiles
-
- Oracle-managed, 15.4.1
- DUMP_ORPHAN_KEYS procedure, 23.3.2
-
- checking sync, 23.3.2
- DBMS_REPAIR package, 23.2.1
- example, 23.4.4
- recovering data, 23.3.4.1
- dumps, 8.1.3.3
E
- EMPHASIS resource allocation method, 25.3.4
- enabling
-
- chains, 27.9.5
- jobs, 27.2.8
- programs, 27.3.6
- window groups, 27.7.6
- windows, 27.6.8
- enabling recoverer process
-
- distributed transactions, 33.9.2
- encryption
-
- column, 18.2.7
- tablespace, 12.2.3
- encryption, transparent data, 2.8.2
- enterprise users
-
- definition, 29.3.2.4.2
- environment variables
-
- ORACLE_SID, 2.3.1
- error logging, DML
-
- inserting data with, 18.4.1
- errors
-
- alert log and, 7.1.1
- assigning names with PRAGMA_EXCEPTION_INIT, 31.5
- critical, 8.1.1
- exception handler, 31.5
- integrity constrain violation, 31.3
- ORA-00028, 4.8.2
- ORA-01090, 3.3
- ORA-01173, 9.4.2
- ORA-01176, 9.4.2
- ORA-01177, 9.4.2
- ORA-01578, 13.7
- ORA-01591, 33.8.2
- ORA-02049, 33.8.1
- ORA-02050, 33.4.1
- ORA-02051, 33.4.1
- ORA-02054, 33.4.1
- ORA-1215, 9.4.2
- ORA-1216, 9.4.2
- RAISE_APPLICATION_ERROR() procedure, 31.5
- remote procedure, 31.5
- rollback required, 31.3
- trace files and, 7.1.1
- when creating control file, 9.4.2
- while starting a database, 3.1.4.5
- while starting an instance, 3.1.4.5
- event message
-
- passing to event-based job, 27.8.3.5
- event schedule
-
- altering, 27.8.3.4
- creating, 27.8.3.3
- event-based job
-
- altering, 27.8.3.2
- creating, 27.8.3.1
- passing event messages to, 27.8.3.5
- events (Scheduler)
-
- overview, 27.8.1
- using, 27.8
- exception handler, 31.5
- EXCEPTION keyword, 31.5
- exceptions
-
- assigning names with PRAGMA_EXCEPTION_INIT, 31.5
- integrity constraints, 16.5.5
- user-defined, 31.5
- executing
-
- remote external jobs, 28.3
- execution plans
-
- analyzing for distributed queries, 31.4.4
- export operations
-
- restricted mode and, 3.1.4.4
- expressions, calendaring, 27.4.5.1
- EXTENT MANAGEMENT LOCAL clause
-
- CREATE DATABASE, 2.4.2
- extents
-
- allocating cluster extents, 20.4
- allocating for tables, 18.6.4
- data dictionary views for, 17.5.2
- deallocating cluster extents, 20.4
- displaying free extents, 17.5.2.3
- external jobs, 26.4.4.3
-
- creating, 27.2.2.5, 27.2.2.5
- retrieving stdout and stderr, 26.4.4.3.2, 26.4.4.3.3, 27.2.2.5, 27.2.11
- external procedures
-
- managing processes for, 4.7
- external tables
-
- altering, 18.13.2
- creating, 18.13.1
- defined, 18.13
- dropping, 18.13.3
- privileges required, 18.13.4
- uploading data example, 18.13.1
F
- fault diagnosability infrastructure, 8.1.1
- features
-
- new, Preface
- features, new, Preface
- file mapping
-
- examples, 13.9.4
- how it works, 13.9.2
- how to use, 13.9.3
- overview, 13.9.1
- structures, 13.9.2.2
- views, 13.9.3.3
- file system
-
- used for Oracle-managed files, 15.1.1.2
- FILE_MAPPING initialization parameter, 13.9.3.1
- filenames
-
- Oracle-managed files, 15.3.1
- files
-
- creating Oracle-managed files, 15.3, 15.3.6.2
- finalizing
-
- an incident package, definition, 8.10.1.1
- FIX_CORRUPT_BLOCKS procedure
-
- DBMS_REPAIR, 23.2.1
- example, 23.4.3
- marking blocks corrupt, 23.3.3.1
- fixed user database links
-
- advantages and disadvantages, 29.2.7.2
- creating, 30.2.3.1
- definition, 29.2.7
- example, 29.2.8
- flash recovery area
-
- initialization parameters to specify, 2.5.3
- with Oracle managed files, 15.2
- Flashback Drop
-
- about, 18.11
- purging recycle bin, 18.11.4
- querying recycle bin, 18.11.3
- recycle bin, 18.11.1
- restoring objects, 18.11.5
- Flashback Table
-
- overview, 18.9
- flood-controlled incidents
-
- defined, 8.1.2
- viewing, 8.3
- FMON background process, 13.9.2.1.1
- FMPUTL external process
-
- used for file mapping, 13.9.2.1.2
- FORCE clause
-
- COMMIT statement, 33.5
- ROLLBACK statement, 33.5
- FORCE LOGGING clause
-
- CREATE CONTROLFILE, 2.4.10.1
- CREATE DATABASE, 2.4.10
- CREATE TABLESPACE, 12.4
- performance considerations, 2.4.10.2
- FORCE LOGGING mode, 18.4.2.4
- forcing
-
- COMMIT or ROLLBACK, 33.3.1, 33.4.2
- forcing a log switch, 10.6
-
- using ARCHIVE_LAG_TARGET, 10.2.5
- with the ALTER SYSTEM statement, 10.6
- forget phase
-
- in two-phase commit, 32.3.3
- free space
-
- listing free extents, 17.5.2.3
- tablespaces and, 12.14.3
- function-based indexes, 19.3.7
G
- generic connectivity
-
- definition, 29.1.2.3
- global cache service (LMS), 4.5
- global coordinators, 32.2.4
-
- distributed transactions, 32.2.4
- global database consistency
-
- distributed databases and, 32.3.2.2
- global database links, 29.2.6
-
- creating, 30.2.2.3
- global database names
-
- changing the domain, 30.1.4
- database links, 29.2.4
- enforcing for database links, 29.2.5
- enforcing global naming, 30.1.2
- forming distributed database names, 30.1.1
- impact of changing, 29.4.9.1
- querying, 30.1.3
- global object names
-
- database links, 29.4.7
- distributed databases, 30.1
- global users, 30.8.5
-
- schema-dependent in distributed systems, 29.3.2.4.1
- schema-independent in distributed systems, 29.3.2.4.2
- GLOBAL_NAME view
-
- using to determine global database name, 30.1.3
- GLOBAL_NAMES initialization parameter
-
- database links, 29.2.5
- globalization support
-
- client/server architectures, 29.6.1
- distributed databases, 29.6
- GRANT statement
-
- SYSOPER/SYSDBA privileges, 1.7.3.1
- granting privileges and roles
-
- SYSOPER/SYSDBA privileges, 1.7.3.1
- growth trends
-
- of database objects, 17.6.3
- GV$DBLINK view, 30.5.2
H
- hash clusters
-
- advantages and disadvantages, 21.1
- altering, 21.4
- choosing key, 21.3.3.1
- contrasted with index clusters, 21.1
- controlling space use of, 21.3.3
- creating, 21.3
- data dictionary views reference, 21.6
- dropping, 21.5
- estimating storage, 21.3.4
- examples, 21.3.3.5.1
- hash function, 21.1, 21.2.2, 21.3, 21.3.3.1, 21.3.3.2, 21.3.3.3
- HASH IS clause, 21.3, 21.3.3.2
- HASHKEYS clause, 21.3, 21.3.3.4
- single-table, 21.3.2
- SIZE clause, 21.3.3.3
- sorted, 21.3.1
- hash functions
-
- for hash cluster, 21.1
- health checks, 8.1.1
- Health Monitor, 8.7
-
- checks, 8.7.1.1
-
- generating reports, 8.7.3
- running, 8.7.2
- viewing reports, 8.7.3
- viewing reports using ADRCI, 8.7.3.3
- heterogeneous distributed systems
-
- definition, 29.1.2
- Heterogeneous Services
-
- overview, 29.1.2
- HI_SHARED_MEMORY_ADDRESS parameter, 5.4.2.8.2
- hints, 31.4.3
-
- DRIVING_SITE, 31.4.3.2
- NO_MERGE, 31.4.3.1
- using to tune distributed queries, 31.4.3
- HP OpenView, 29.3.4.3
I
- IBM NetView/6000, 29.3.4.3
- import operations
-
- restricted mode and, 3.1.4.4
- incident package
-
- creating, editing and uploading custom, 8.10
- customizing, 8.10.3, 8.10.3.2
- defined, 8.1.1
- viewing, 8.10.3.1
- incident packaging service, 8.1.1
- incidents
-
- about, 8.1.2
- flood-controlled, 8.1.2
-
- viewing, 8.3
- index clusters. See clusters.
- indexes
-
- altering, 19.4
- analyzing, 16.2
- choosing columns to index, 19.2.2
- cluster indexes, 20.3.2, 20.4.1, 20.5
- coalescing, 19.2.10, 19.4.2
- column order for performance, 19.2.3
- creating, 19.3
- data dictionary views reference, 19.7
- disabling and dropping constraints cost, 19.2.11
- dropping, 19.2.5, 19.6, 19.6
- estimating size, 19.2.6
- estimating space use, 17.6.2
- explicitly creating a unique index, 19.3.2
- function-based, 19.3.7
- guidelines for managing, 19.1
- invisible, 19.3.9, 19.4.3
- keeping when disabling constraint, 16.5.3
- keeping when dropping constraint, 16.5.3
- key compression, 19.3.8
- limiting for a table, 19.2.4
- monitoring space use of, 19.5
- monitoring usage, 19.4.5
- parallelizing index creation, 19.2.8
- rebuilding, 19.2.10, 19.4.2, 19.4.2
- rebuilt after direct-path INSERT, 18.4.2.5.2
- renaming, 19.4.4
- setting storage parameters for, 19.2.6
- shrinking, 17.3.3
- space used by, 19.5
- statement for creating, 19.3.1
- tablespace for, 19.2.7
- temporary segments and, 19.2.1
- validating structure, 16.2.2
- when to create, 19.2.2
- index-organized tables
-
- analyzing, 18.12.5
- AS subquery, 18.12.2.6
- converting to heap, 18.12.7
- creating, 18.12.2
- described, 18.12.1
- INCLUDING clause, 18.12.2.5
- key compression, 18.12.2.7
- maintaining, 18.12.3
- ORDER BY clause, using, 18.12.6
- parallel creation, 18.12.2.6
- rebuilding with MOVE clause, 18.12.3.2
- storing nested tables, 18.12.2.3
- storing object types, 18.12.2.3
- threshold value, 18.12.2.4
- in-doubt transactions, 32.4
-
- after a system failure, 33.4.1
- automatic resolution, 32.4.1, 32.4.1.1
- deciding how to handle, 33.4
- deciding whether to perform manual override, 33.4.2
- defined, 32.3.1.2
- manual resolution, 32.4.2
- manually committing, 33.5.1
- manually committing, example, 33.7
- manually overriding, 33.4.2, 33.5
- manually overriding, scenario, 33.7
- manually rolling back, 33.5.2
- overview, 32.4
- pending transactions table, 33.7.6
- purging rows from data dictionary, 33.6, 33.6.2
- recoverer process and, 33.9.2
- rolling back, 33.5, 33.5.1.1, 33.5.2, 33.5.2
- SCNs and, 32.4.3
- simulating, 33.9
- tracing session tree, 33.3.2
- viewing database links, 33.3.1
- INITIAL parameter
-
- cannot alter, 18.6.2
- initialization parameter file
-
- about, 2.5.1
- and Automatic Storage Management, 3.1.2
- creating, 2.3.4
- creating by copying and pasting from alert log, 2.6.10
- creating for database creation, 2.3.4
- editing before database creation, 2.5
- individual parameter names, 2.5.2
- sample, 2.5.1.2
- server parameter file, 2.6
- initialization parameter files
-
- default locations, 3.1.2
- search order, 3.1.2
- initialization parameters
-
- about, 2.5.1
- and database startup, 3.1.2
- ARCHIVE_LAG_TARGET, 10.2.5.1
- BUFFER_POOL_KEEP, 5.4.2.2.2
- BUFFER_POOL_RECYCLE, 5.4.2.2.2
- changing, 2.6.6.1
- clearing, 2.6.7
- COMMIT_POINT_STRENGTH, 32.2.5.2, 33.1
- CONTROL_FILES, 2.5.4, 2.5.4, 9.2.1, 9.3.1
- DB_BLOCK_CHECKING, 23.3.1.4
- DB_BLOCK_CHECKSUM, 10.7, 13.7
- DB_BLOCK_SIZE, 2.5.5, 12.3
- DB_CACHE_SIZE, 12.3
- DB_DOMA, 2.5.2
- DB_DOMAIN, 2.5.2.2
- DB_FILES, 13.1.1.1
- DB_NAME, 2.5.2
- DB_nK_CACHE_SIZE, 12.3, 12.13.5.5
- DISPATCHERS, 4.3.3.3
- FILE_MAPPING, 13.9.3.1
- for buffer cache, 5.4.2.2
- GLOBAL_NAMES, 29.2.5
- HI_SHARED_MEMORY_ADDRESS, 5.4.2.8.2
- LOCK_SGA, 5.4.2.8.1
- LOG_ARCHIVE_DEST, 11.4.1
- LOG_ARCHIVE_DEST_n, 11.4.1, 11.6.2
- LOG_ARCHIVE_DEST_STATE_n, 11.4.2
- LOG_ARCHIVE_MAX_PROCESSES, 11.3.4
- LOG_ARCHIVE_MIN_SUCCEED_DEST, 11.6.1
- LOG_ARCHIVE_TRACE, 11.7
- MAX_DUMP_FILE_SIZE, 7.1.1.1
- OPEN_LINKS, 30.4.3
- PROCESSES, 2.5.6
- REMOTE_LOGIN_PASSWORDFILE, 1.7.2
- REMOTE_OS_AUTHENT, 29.2.7.1
- resetting, 2.6.7
- RESOURCE_MANAGER_PLAN, 25.5, 25.5
- server parameter file and, 2.6, 2.6.11
- SET SQL_TRACE, 7.1.1.2
- setting, 2.6.6.1
- shared server and, 4.3.1
- SHARED_MEMORY_ADDRESS, 5.4.2.8.2
- SHARED_SERVERS, 4.3.2.2
- SORT_AREA_SIZE, 19.2.1
- SPFILE, 2.6.5, 3.1.2
- SQL_TRACE, 7.1.1
- STATISTICS_LEVEL, 18.5
- UNDO_MANAGEMENT, 2.4.4
- UNDO_TABLESPACE, 2.5.8.2, 14.2.1
- USE_INDIRECT_DATA_BUFFERS, 5.4.2.8.3
- INITRANS parameter
-
- altering, 18.6.2
- INSERT statement
-
- with DML error logging, 18.4.1
- installing
-
- patches, 1.2.10
- instances
-
- aborting, 3.3.4
- shutting down immediately, 3.3.2
- shutting down normally, 3.3.1
- transactional shutdown, 3.3.3
- integrity constraints
-
- See also constraints
- cost of disabling, 19.2.11
- cost of dropping, 19.2.11
- creating indexes associated with, 19.3.3
- dropping tablespaces and, 12.9
- ORA-02055 constraint violation, 31.3
- INTERNAL username
-
- connecting for shutdown, 3.3
- invisible indexes, 19.3.9, 19.4.3
- IOT. See index-organized tables.
- IPS, 8.1.1
J
- job classes
-
- altering, 27.5.3
- creating, 27.5.2
- dropping, 27.5.4
- overview, 26.6
- using, 27.5
- job coordinator, 26.9.2
- job recovery (Scheduler), 28.5.2
- job scheduling
-
- dependency, 26.1.1
- event-based, 26.1.1
- time-based, 26.1.1
- JOB_QUEUE_PROCESSES initialization parameter, A.3
- jobs
-
- altering, 27.2.3
- copying, 27.2.9
- creating, 27.2.2
- creating for chains, 27.9.6
- detached, 26.4.4.4
- disabling, 27.2.7
- dropping, 27.2.6
- enabling, 27.2.8
- external, 26.4.4.3
-
- creating, 27.2.2.5
- failed Scheduler, 28.5.1
- lightweight, 26.4.4.5
- lightweight, example of creating, 27.2.2.2.1
- overview, 26.4
- priorities, 28.2.4
- remote external
-
- about, 26.4.4.3.3
- running, 27.2.2.5
- running, 27.2.4
- stopping, 27.2.5
- using, 27.2
- viewing information on running, 28.2.2
- viewing stdout and stderr for, 27.2.11
- join views
-
- definition, 22.1.2.1
- DELETE statements, 22.1.5.2.2
- key-preserved tables in, 22.1.5.1
- modifying, 22.1.5
- rules for modifying, 22.1.5.2
- updating, 22.1.5
- joins
-
- statement transparency in distributed databases, 30.7
K
- key compression, 18.12.2.7
-
- indexes, 19.3.8
- key-preserved tables
-
- in join views, 22.1.5.1
- in outer joins, 22.1.5.3
- keys
-
- cluster, 20.1, 20.2.3
L
- large objects, 18.3.1
- lightweight jobs, 26.4.4.5
-
- example, 27.2.2.2.1
- example of creating, 27.2.2.2.1
- examples, 28.6.1
- links
-
- See database links
- LIST CHAINED ROWS clause
-
- of ANALYZE statement, 16.2.3.1
- listing database links, 30.5.1, 33.3.1, 33.3.2
- loading data
-
- using external tables, 18.13.1
- LOBs, 18.3.1
- local coordinators, 32.2.3
-
- distributed transactions, 32.2.3
- locally managed tablepsaces
-
- shrinking, temporary, 12.7.4
- locally managed tablespaces, 12.2.1
-
- automatic segment space management in, 12.2.1.2
- DBMS_SPACE_ADMIN package, 12.11
- detecting and repairing defects, 12.11
- migrating SYSTEM from dictionary-managed, 12.12
- tempfiles, 12.2.4.1
- temporary, creating, 12.2.4.1
- location transparency in distributed databases
-
- creating using synonyms, 30.6.2
- creating using views, 30.6.1
- restrictions, 30.7
- using procedures, 30.6.3.3
- lock timeout interval
-
- distributed transactions, 33.8
- LOCK_SGA parameter, 5.4.2.8.1
- locks
-
- in-doubt distributed transactions, 33.8, 33.8.2
- monitoring, 7.2.1
- log
-
- window (Scheduler), 27.6
- log sequence number
-
- control files, 10.1.3.2
- log switches
-
- description, 10.1.3.2
- forcing, 10.6, 10.6
- log sequence numbers, 10.1.3.2
- multiplexed redo log files and, 10.2.1.1
- privileges, 10.6
- using ARCHIVE_LAG_TARGET, 10.2.5
- waiting for archiving to complete, 10.2.1.1
- log writer process (LGWR), 4.5
-
- multiplexed redo log files and, 10.2.1.1
- online redo logs available for use, 10.1.3
- trace files and, 10.2.1.1
- writing to online redo log files, 10.1.3
- LOG_ARCHIVE_DEST initialization parameter
-
- specifying destinations using, 11.4.1
- LOG_ARCHIVE_DEST_n initialization parameter, 11.4.1
-
- REOPEN attribute, 11.6.2
- LOG_ARCHIVE_DEST_STATE_n initialization parameter, 11.4.2
- LOG_ARCHIVE_DUPLEX_DEST initialization parameter
-
- specifying destinations using, 11.4.1
- LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 11.3.4
- LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 11.6.1
- LOG_ARCHIVE_TRACE initialization parameter, 11.7
- LOGGING clause
-
- CREATE TABLESPACE, 12.4
- logging mode
-
- direct-path INSERT, 18.4.2.4
- NOARCHIVELOG mode and, 18.4.2.4.1
- logical corruptions from DBMS_REPAIR, 23.3.2
- logical volume managers
-
- mapping files to physical devices, 13.9, 13.9.4.3
- used for Oracle-managed files, 15.1.1.1
- LOGON trigger
-
- setting resumable mode, 17.2.3
- logs
-
- job, 28.2.3
- window (Scheduler), 27.6, 28.2.3
- LONG columns, 30.7
- LONG RAW columns, 30.7
M
- maintenance window
-
- creating, 24.4.2
- definition, 24.1
- MAINTENANCE_WINDOW_GROUP, 24.2
- modifying, 24.4.1
- predefined, 24.6.1
- removing, 24.4.3
- maintenance windows
-
- Scheduler, 24.2
- managing
-
- memory, 5
- space threshold alerts for the undo tablespace, 14.5.6
- managing datafiles, 13
- managing sequences, 22.2.1
- managing synonyms, 22.3.1
- managing tables, 18
- managing views, 22.1
- manual archiving
-
- in ARCHIVELOG mode, 11.3.3
- manual overrides
-
- in-doubt transactions, 33.5
- MAX_DUMP_FILE_SIZE initialization parameter, 7.1.1.1
- MAXDATAFILES parameter
-
- changing, 9.3.3.2
- MAXINSTANCES, 9.3.3.2
- MAXLOGFILES parameter
-
- changing, 9.3.3.2
- CREATE DATABASE statement, 10.2.4
- MAXLOGHISTORY parameter
-
- changing, 9.3.3.2
- MAXLOGMEMBERS parameter
-
- changing, 9.3.3.2
- CREATE DATABASE statement, 10.2.4, 10.2.4
- MAXTRANS parameter
-
- altering, 18.6.2
- media recovery
-
- effects of archiving on, 11.2.1
- memory
-
- extended buffer cache (32-bit), 5.4.2.8.3
- managing, 5
- overview of architecture of, 5.2
- system global area (SGA)
-
- initialization parameters, 5.4.2.8
- locking into physical memory, 5.4.2.8.1
- starting address, 5.4.2.8.2
- memory management
-
- about, 5.1
- automatic, 5.1, 5.3.2
- data dictionary views reference, 5.5.2
- MEMORY_MAX_TARGET parameter, 5.3.1
- MEMORY_TARGET parameter, 5.3.1
- migrated rows
-
- eliminating from table, procedure, 16.2.3.2
- MINEXTENTS parameter
-
- cannot alter, 18.6.2
- mirrored files
-
- control files, 2.5.4, 9.2.2
- online redo log, 10.2.1.1
- online redo log location, 10.2.2
- online redo log size, 10.2.3
- MISSING datafiles, 9.4.1
- monitoring
-
- performance, 7.2
- running chains, 27.9.17
- MONITORING clause
-
- CREATE TABLE, 18.5
- MONITORING USAGE clause
-
- of ALTER INDEX statement, 19.4.5
- mounting a database, 3.1.4.3
- moving control files, 9.3.2
- multiple temporary tablespaces, 12.2.5, 12.2.5.3
- multiplexed control files
-
- importance of, 9.2.2
- multiplexing
-
- archived redo logs, 11.4.1
- control files, 9.2.2
- redo log file groups, 10.2.1
- redo log files, 10.2.1, 10.2.1
N
- name resolution in distributed databases
-
- database links, 29.4.7
- impact of global name changes, 29.4.9.1
- procedures, 29.4.9
- schema objects, 29.2.9.4, 29.4.8
- synonyms, 29.4.9
- views, 29.4.9
- when global database name is complete, 29.4.7.1
- when global database name is partial, 29.4.7.2
- when no global database name is specified, 29.4.7.3
- named user limits
-
- setting initially, 2.5.10
- networks
-
- connections, minimizing, 30.3
- distributed databases use of, 29.1.1
- new features, Preface
- NEXT parameter
-
- altering, 18.6.2
- NEXTVAL pseudo-column, 22.2.4.1, 22.2.4.1.1
-
- restrictions, 22.2.4.1.3
- NO_DATA_FOUND keyword, 31.5
- NO_MERGE hint, 31.4.3.1
- NOARCHIVELOG mode
-
- archiving, 11.2
- definition, 11.2.1
- dropping datafiles, 13.4.2
- LOGGING mode and, 18.4.2.4.1
- media failure, 11.2.1
- no hot backups, 11.2.1
- running in, 11.2.1
- switching to, 11.3.2
- taking datafiles offline in, 13.4.2
- NOCACHE option
-
- CREATE SEQUENCE statement, 22.2.4.2.2
- NOLOGGING clause
-
- CREATE TABLESPACE, 12.4
- NOLOGGING mode
-
- direct-path INSERT, 18.4.2.4
- NOMOUNT clause
-
- STARTUP command, 3.1.4.2
- normal transmission mode
-
- definition, 11.5.1
- Novell NetWare Management System, 29.3.4.3
O
- object privileges
-
- for external tables, 18.13.4
- objects
-
- See also schema objects
- offline tablespaces
-
- priorities, 12.5.1
- taking offline, 12.5.1
- online redefinition of tables, 18.7
-
- abort and cleanup, 18.7.5
- examples, 18.7.8
- features of, 18.7.1
- intermediate synchronization, 18.7.4
- redefining a single partition, 18.7.7
-
- rules for, 18.7.7.1
- restrictions, 18.7.6
- with DBMS_REDEFINITION, 18.7.2
- online redo log files
-
- See also online redo logs
- online redo logs
-
- See also redo log files
- creating groups, 10.3
- creating members, 10.3.2
- data dictionary views reference, 10.9
- dropping groups, 10.5
- dropping members, 10.5
- forcing a log switch, 10.6
- guidelines for configuring, 10.2
- INVALID members, 10.5.2
- location of, 10.2.2
- managing, 10
- moving files, 10.4
- number of files in the, 10.2.4
- optimum configuration for the, 10.2.4
- renaming files, 10.4
- renaming members, 10.4
- specifying ARCHIVE_LAG_TARGET, 10.2.5
- STALE members, 10.5.2
- online segment shrink, 17.3.3
- OPEN_LINKS initialization parameter, 30.4.3
- opening windows, 27.6.4
- operating system authentication, 1.6.3.2
- operating systems
-
- database administrators requirements for, 1.5.1
- renaming and relocating files, 13.5
- ORA_TZFILE environment variable
-
- specifying time zone file for database, 2.4.9.2
- ORA-01013 error message, 3.3.5
- ORA-02055 error
-
- integrity constraint violation, 31.3
- ORA-02067 error
-
- rollback required, 31.3
- Oracle Call Interface. See OCI
- Oracle Data Guard
-
- support by the Scheduler, 26.10, 28.6.9
- Oracle Database
-
- release numbers, 1.4.1
- Oracle Database users
-
- types of, 1.1
- Oracle Enterprise Manager, 3.1.1.3, 3.1.1.3
- Oracle home
-
- cloning, 1.2.11
- Oracle Managed Files feature
-
- See also Oracle-managed files
- Oracle Net
-
- service names in, 11.5.2
- transmitting archived logs via, 11.5.2
- Oracle Scheduler
-
- See Scheduler
- Oracle Universal Installer, 2.1
- Oracle wallet, 12.2.3, 18.2.7
- ORACLE_SID environment variable, 2.3.1
- Oracle-managed files
-
- adding to an existing database, 15.5.3
- behavior, 15.4
- benefits, 15.1.2
- CREATE DATABASE statement, 15.3.2
- creating, 15.3
- creating control files, 15.3.5
- creating datafiles, 15.3.3
- creating online redo log files, 15.3.6
- creating tempfiles, 15.3.4
- described, 15.1
- dropping datafile, 15.4.1
- dropping online redo log files, 15.4.2
- dropping tempfile, 15.4.1
- initialization parameters, 15.2
- introduction, 2.4.7
- naming, 15.3.1
- renaming, 15.4.3
- scenarios for using, 15.5
- oraenv and coraenv, 1.3.2.2
- ORAPWD utility, 1.7.1
- ORGANIZATION EXTERNAL clause
-
- of CREATE TABLE, 18.13.1
- orphan key table
-
- example of building, 23.4.1.2
- OSDBA group, 1.6.3.1
- OSOPER group, 1.6.3.1
- OTHER_GROUPS
-
- for Database Resource Manager, 25.1.3.1
- OTHER_GROUPS for Database Resource Manager, 25.3.5, 25.3.6, 25.6.3
- outer joins, 22.1.5.3
-
- key-preserved tables in, 22.1.5.3
- overlapping windows, 27.6.9
P
- package
-
- See also incident package
- package, incident
-
- defined, 8.1.1
- packages
-
- DBMS_FILE_TRANSFER, 13.7
- DBMS_METADATA, 16.10.1
- DBMS_REDEFINITION, 18.7.2, 18.7.9
- DBMS_REPAIR, 23.2
- DBMS_RESOURCE_MANAGER, 25.1.3, 25.1.5, 25.1.5, 25.4.3
- DBMS_RESOURCE_MANAGER_PRIVS, 25.1.5, 25.1.5
- DBMS_RESUMABLE, 17.2.4.3
- DBMS_SPACE, 17.3.4, 17.5.1
- DBMS_STATS, 16.2.1, 18.5
- DBMS_STORAGE_MAP, 13.9.3.2, 13.9.3.3
- packaging and uploading problems, 8.10.2
- parallel execution
-
- managing, 4.6
- parallel hints, 4.6, 4.6
- parallelizing index creation, 19.2.8
- resumable space allocation, 17.2.1.5
- parallel hints, 4.6, 4.6
- PARALLEL_DEGREE_LIMIT_ABSOLUTE resource allocation method, 25.3.4
- parallelizing table creation, 18.2.4, 18.3.3
- parameter files
-
- See also initialization parameter file.
- partitioned tables
-
- redefining partitions online, 18.7.7
-
- rules for, 18.7.7.1
- password
-
- setting for SYSTEM account in CREATE DATABASE statement, 2.4.1
- setting SYS in CREATE DATABASE statement, 2.4.1
- password file
-
- adding users, 1.7.3
- creating, 1.7.1
- ORAPWD utility, 1.7.1
- removing, 1.7.4.2
- setting REMOTE_LOGIN_PASSWORD, 1.7.2
- viewing members, 1.7.3.2
- password file authentication, 1.6.4.1
- passwords
-
- case sensitivity of, 1.6.2, 1.6.4.1, 1.6.4.2
- default for SYS and SYSTEM, 1.5.2
- password file, 1.7.3
- setting REMOTE_LOGIN_PASSWORD parameter, 1.7.2
- patches, installing, 1.2.10
- pausing chains and chain steps, 27.9.14
- PCTINCREASE parameter, 18.6.2
- pending area for Database Resource Manager plans, 25.3.8
-
- validating plan schema changes, 25.3.6
- pending transaction tables, 33.7.6
- performance
-
- index column order, 19.2.3
- location of datafiles and, 13.1.3
- monitoring, 7.2
- PGA_AGGREGATE_TARGET initialization parameter, 5.4.3
- plan schemas for Database Resource Manager, 25.1.4.1, 25.5, 25.7.4
-
- validating plan changes, 25.3.6
- plans for Database Resource Manager
-
- examples, 25.6
- PL/SQL
-
- replaced views and program units, 22.1.3
- PRAGMA_EXCEPTION_INIT procedure
-
- assigning exception names, 31.5
- predefined user accounts, 2.8.1
- prepare phase
-
- abort response, 32.3.1.1.3
- in two-phase commit, 32.3.1
- prepared response, 32.3.1.1.1
- read-only response, 32.3.1.1.2
- recognizing read-only nodes, 32.3.1.1.2
- steps, 32.3.1.2
- prepare/commit phases
-
- effects of failure, 33.8.1
- failures during, 33.4.1
- locked resources, 33.8
- pending transaction table, 33.7.6
- prepared response
-
- two-phase commit, 32.3.1.1.1
- prerequisites
-
- for creating a database, 2.1.1.2
- PRIMARY KEY constraints
-
- associated indexes, 19.3.3.1
- dropping associated indexes, 19.6
- enabling on creation, 19.3.3
- foreign key references when dropped, 16.5.3.1
- indexes associated with, 19.3.3
- priorities
-
- job, 28.2.4
- private database links, 29.2.6
- private synonyms, 22.3.1
- privileges
-
- adding redo log groups, 10.3
- altering indexes, 19.4
- altering tables, 18.6
- closing a database link, 31.2
- creating database links, 30.2.1
- creating tables, 18.3
- creating tablespaces, 12.2
- database administrator, 1.5
- dropping indexes, 19.6
- dropping online redo log members, 10.5.2
- dropping redo log groups, 10.5.1
- dropping tables, 18.10
- enabling and disabling triggers, 16.4
- for external tables, 18.13.4
- forcing a log switch, 10.6
- managing with procedures, 30.6.3.4
- managing with synonyms, 30.6.2.2
- managing with views, 30.6.1
- manually archiving, 11.3.3
- renaming objects, 16.6
- renaming redo log members, 10.4
- RESTRICTED SESSION system privilege, 3.1.4.4
- Scheduler, 28.1
- sequences, 22.2.2, 22.2.2, 22.2.5
- setting chain (Scheduler), 28.1
- synonyms, 22.3.2, 22.3.4
- taking tablespaces offline, 12.5.1
- truncating, 16.3.3
- using a view, 22.1.4
- using sequences, 22.2.4
- views, 22.1.2, 22.1.3, 22.1.7
- privileges, Scheduler, 28.7.1
- problem activity log
-
- adding comments to, 8.2.7
- problems
-
- about, 8.1.2
- adding comments to activity log, 8.2.7
- problems (critical errors)
-
- packaging and uploading, 8.10.2
- procedures
-
- external, 4.7
- location transparency in distributed databases, 30.6.3
- name resolution in distributed databases, 29.4.9
- remote calls, 29.5.2
- process monitor (PMON), 4.5
- processes
-
- See also server processes
- PROCESSES initialization parameter
-
- setting before database creation, 2.5.6
- PRODUCT_COMPONENT_VERSION view, 1.4.2
- program global area (PGA), 5.2
- program global areas, 5.2
- programs
-
- altering, 27.3.3
- creating, 27.3.2
- disabling, 27.3.5
- dropping, 27.3.4
- enabling, 27.3.6
- overview, 26.2
- using, 27.3
- public database links, 29.2.6
-
- connected user, 30.8.3
- fixed user, 30.8.1
- public fixed user database links, 30.8.1
- public synonyms, 22.3.1
- PURGE_LOST_DB_ENTRY procedure
-
- DBMS_TRANSACTION package, 33.6.1
Q
- queries
-
- distributed, 29.4.2
- distributed application development issues, 31.4
- location transparency and, 29.5.1.2
- remote, 29.4.1
- quiescing a database, 3.4
- quotas
-
- tablespace, 12.1.2
R
- RAISE_APPLICATION_ERROR() procedure, 31.5
- read consistency
-
- managing in distributed databases, 33.10
- read-only database
-
- opening, 3.2.3
- read-only response
-
- two-phase commit, 32.3.1.1.2
- read-only tables, 18.6.9
- read-only tablespaces
-
- datafile headers when rename, 12.8
- delaying opening of datafiles, 12.6.4
- making read-only, 12.6.1
- making writable, 12.6.2
- WORM devices, 12.6.3
- Real Application Clusters
-
- allocating extents for cluster, 20.4
- sequence numbers and, 22.2.2
- threads of online redo log, 10.1.1
- rebuilding indexes, 19.4.2
-
- costs, 19.2.10
- online, 19.4.2
- reclaiming unused space, 17.3
- RECOVER clause
-
- STARTUP command, 3.1.4.6
- recoverer process
-
- disabling, 33.9.2
- distributed transaction recovery, 33.9.2
- enabling, 33.9.2
- pending transaction table, 33.9.2
- recoverer process (RECO), 4.5
- recovering
-
- Scheduler jobs, 28.5.2
- recovery
-
- creating new control files, 9.3.3.2
- Recovery Manager
-
- starting a database, 3.1.1.2
- starting an instance, 3.1.1.2
- recycle bin
-
- about, 18.11.1
- purging, 18.11.4
- renamed objects, 18.11.1
- restoring objects from, 18.11.5
- viewing, 18.11.3
- redefining tables online
-
- See online redefinition of tables
- redo log files
-
- See also online redo logs
- active (current), 10.1.3.1
- archiving, 11.2
- available for use, 10.1.3
- circular use of, 10.1.3
- clearing, 10.2.1.1, 10.8
- contents of, 10.1.2
- creating as Oracle-managed files, 15.3.6
- creating as Oracle-managed files, example, 15.5.1
- creating groups, 10.3
- creating members, 10.3, 10.3.2
- distributed transaction information in, 10.1.3
- dropping groups, 10.5
- dropping members, 10.5
- group members, 10.2.1
- groups, defined, 10.2.1
- how many in redo log, 10.2.4
- inactive, 10.1.3.1, 10.1.3.1
- instance recovery use of, 10.1
- legal and illegal configurations, 10.2.1.2
- LGWR and the, 10.1.3
- log switches, 10.1.3.2
- maximum number of members, 10.2.4
- members, 10.2.1
- mirrored, log switches and, 10.2.1.1
- multiplexed, 10.2.1, 10.2.1, 10.2.1.1
- online, defined, 10.1
- planning the, 10.2, 10.2.4
- redo entries, 10.1.2
- requirements, 10.2.1.2
- specifying at database creation, 15.3.2.2
- storing separately from datafiles, 13.1.4
- threads, 10.1.1
- unavailable when database is opened, 3.1.4
- verifying blocks, 10.7
- redo logs
-
- See also online redo log
- redo records, 10.1.2
-
- LOGGING and NOLOGGING, 12.4
- referential integrity
-
- distributed database application development, 31.3
- release number format, 1.4.1
- releases, 1.4.1
-
- checking the Oracle Database release number, 1.4.2
- relocating control files, 9.3.2
- remote connections
-
- connecting as SYSOPER/SYSDBA, 1.6.1
- password files, 1.7.2
- remote data
-
- querying, 30.7
- updating, 30.7
- remote external jobs
-
- about, 26.4.4.3.3
- credentials, 26.4.4.3.1
- executing, 28.3
- running, 27.2.2.5
- scheduler agent setup, 28.3.2
- remote procedure calls, 29.5.2, 29.5.2
-
- distributed databases and, 29.5.2
- remote queries
-
- distributed databases and, 29.4.1
- remote transactions, 29.4.4
-
- defined, 29.4.4
- REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.7.2
- REMOTE_OS_AUTHENT initialization parameter
-
- connected user database links, 29.2.7.1
- RENAME statement, 16.6
- renaming control files, 9.3.2
- renaming files
-
- Oracle-managed files, 15.4.3
- renaming indexes, 19.4.4
- REOPEN attribute
-
- LOG_ARCHIVE_DEST_n initialization parameter, 11.6.2
- repair table
-
- example of building, 23.4.1.1
- repairing data block corruption
-
- DBMS_REPAIR, 23.1
- repeat interval, schedule, 27.4.5
- RESIZE clause
-
- for single-file tablespace, 12.7.2
- resource allocation methods
-
- active session pool, 25.3.4
- ACTIVE_SESS_POOL_MTH, 25.3.4
- CPU resource, 25.3.4, 25.3.4
- EMPHASIS, 25.3.4
- limit on degree of parallelism, 25.3.4
- PARALLEL_DEGREE_LIMIT_ABSOLUTE, 25.3.4
- PARALLEL_DEGREE_LIMIT_MTH, 25.3.4
- QUEUEING_MTH, 25.3.4
- queuing resource allocation method, 25.3.4
- ROUND-ROBIN, 25.3.3
- resource consumer groups, 25.1.3
-
- changing, 25.4.3
- creating, 25.3.3
- DEFAULT_CONSUMER_GROUP, 25.1.3.1, 25.4.7, 25.4.7.2, 25.7.2
- deleting, 25.7.2
- granting the switch privilege, 25.4.7
- managing, 25.4, 25.4.6
- OTHER_GROUPS, 25.1.3.1, 25.3.5, 25.3.6, 25.6.3
- parameters, 25.3.3
- revoking the switch privilege, 25.4.7.2
- setting initial, 25.4.2
- switching a session, 25.4.3.1
- switching sessions for a user, 25.4.3.2
- SYS_GROUP, 25.6.3
- updating, 25.7.1
- Resource Manager
-
- AUTO_TASK_CONSUMER_GROUP consumer group, 24.5
- resource plan directives, 25.1.3, 25.3.6
-
- deleting, 25.7.6
- specifying, 25.3.5
- updating, 25.7.5
- resource plans, 25.1.3, 25.1.3.6
-
- creating, 25.2
- DEFAULT_MAINTENANCE_PLAN, 24.5.1
- DELETE_PLAN_CASCADE, 25.7.4
- deleting, 25.7.4
- examples, 25.6
- parameters, 25.3.4
- plan schemas, 25.1.4.1, 25.5, 25.7.4
- SYSTEM_PLAN, 25.6.3
- top plan, 25.3.6, 25.5
- updating, 25.7.3
- validating, 25.3.6
- RESOURCE_MANAGER_PLAN initialization parameter, 25.5, 25.5
- RESTRICTED SESSION system privilege
-
- restricted mode and, 3.1.4.4
- result cache
-
- and the shared pool size, 5.4.2.3.1
- setting size of, 5.4.2.7
- RESULT_CACHE_SIZE initialization parameter, 5.4.2.7
- resumable space allocation
-
- correctable errors, 17.2.1.3
- detecting suspended statements, 17.2.4
- disabling, 17.2.2
- distributed databases, 17.2.1.4
- enabling, 17.2.2
- example, 17.2.6
- how resumable statements work, 17.2.1.1
- naming statements, 17.2.2.2.2
- parallel execution and, 17.2.1.5
- resumable operations, 17.2.1.2
- setting as default for session, 17.2.3
- timeout interval, 17.2.2.2.1, 17.2.4.1
- RESUMABLE_TIMEOUT Initialization Parameter
-
- setting, 17.2.2.1
- RESUMABLE_TIMEOUT initialization parameter, 17.2.1.1
- retention guarantee (for undo), 14.2.2.2
- reversing table changes, 18.8
- RMAN. See Recovery Manager.
- roles
-
- DBA role, 1.5.2.3
- obtained through database links, 29.2.10
- ROLLBACK statement
-
- FORCE clause, 33.5, 33.5.1.1, 33.5.2
- forcing, 33.4.2
- rollbacks
-
- ORA-02, 31.3
- ROUND-ROBIN resource allocation method, 25.3.3
- rows
-
- listing chained or migrated, 16.2.3
- rules
-
- adding to a chain, 27.9.4
- dropping from chains, 27.9.9
- running
-
- chains, 27.9.8
- jobs, 27.2.4
- SQL Repair Advisor, 8.8.2
S
- Sample Schemas
-
- description, 2.8.4
- savepoints
-
- in-doubt transactions, 33.5, 33.5.2
- Scheduler
-
- administering, 28
- architecture, 26.9
- configuring, 28.1
- credentials for remote external jobs, 26.4.4.3.1
- data dictionary views reference, 28.7.2
- examples of using, 28.6
- import and export, 28.4
- maintenance windows, 24.2
- monitoring and managing, 28.2
- objects, 26.1.2
- overview, 26.1
- scheduling tasks with, 27
- security, 28.2.5
- support for Oracle Data Guard, 26.10, 28.6.9
- using in RAC, 26.9.5
- Scheduler agent
-
- defined, 26.4.4.3.3
- scheduler agent
-
- setup, 28.3.2
- Scheduler objects, naming, 27.1
- Scheduler privileges reference, 28.7.1
- Scheduler privileges, setting, 28.1
- schedules
-
- altering, 27.4.3
- creating, 27.4.2
- dropping, 27.4.4
- overview, 26.3
- using, 27.4
- scheduling database tasks, 27
- schema objects
-
- analyzing, 16.2
- creating multiple objects, 16.1
- data dictionary views reference, 16.10.2
- defining using DBMS_METADATA package, 16.10.1
- dependencies between, 16.7
- distributed database naming conventions for, 29.2.9.4
- global names, 29.2.9.4
- listing by type, 16.10.2.1
- name resolution in distributed databases, 29.2.9.4, 29.4.8
- name resolution in SQL statements, 16.8
- privileges to rename, 16.6
- referencing with synonyms, 30.6.2.1
- renaming, 16.6, 16.6
- validating structure, 16.2.2
- viewing information, 16.10, 17.5
- schema objects space usage
-
- data dictionary views reference, 17.5.2
- SCN. See system change number.
- SCOPE clause
-
- ALTER SYSTEM SET, 2.6.6.1
- scripts, authenticating users in, 2.8.3
- SEC_CASE_SENSITIVE_LOGON initialization parameter, 1.6.2, 1.6.4.1
- security
-
- accessing a database, 6.1
- administrator of, 6.1
- centralized user management in distributed databases, 29.3.2.4
- database security, 6.1
- distributed databases, 29.3.2
- establishing policies, 6
- privileges, 6.1
- remote objects, 30.6.1
- Scheduler, 28.2.5
- using synonyms, 30.6.2.2
- Segment Advisor, 17.3.2
-
- configuring Scheduler job, 17.3.2.4
- invoking with Enterprise Manager, 17.3.2.2.1
- invoking with PL/SQL, 17.3.2.2.2
- running manually, 17.3.2.2
- viewing results, 17.3.2.3
- views, 17.3.2.5
- SEGMENT_FIX_STATUS procedure
-
- DBMS_REPAIR, 23.2.1
- segments
-
- available space, 17.5.1
- data dictionary views for, 17.5.2
- deallocating unused space, 17.3
- displaying information on, 17.5.2.1
- shrinking, 17.3.3
- SELECT statement
-
- FOR UPDATE clause and location transparency, 30.7
- SEQUENCE_CACHE_ENTRIES parameter, 22.2.4.2.2
- sequences
-
- accessing, 22.2.4
- altering, 22.2.3
- caching sequence numbers, 22.2.4.2
- creating, 22.2.2, 22.2.4.2.2, 22.2.4.2.2
- CURRVAL, 22.2.4.1.2
- data dictionary views reference, 22.4
- dropping, 22.2.5
- managing, 22.2.1
- NEXTVAL, 22.2.4.1.1
- Oracle Real Applications Clusters and, 22.2.2
- SERVER parameter
-
- net service name, 30.3.3.1
- server parameter file
-
- and Automatic Storage Management, 3.1.2
- creating, 2.6.3
- defined, 2.6.1
- exporting, 2.6.8
- migrating to, 2.6.2
- recovering, 2.6.10
- RMAN backup, 2.6.9
- setting initialization parameter values, 2.6.6
- SPFILE initialization parameter, 2.6.5
- STARTUP command behavior, 2.6.1
- viewing parameter settings, 2.6.11
- server processes
-
- archiver (ARCn), 4.5
- background, 4.5
- checkpoint (CKPT), 4.5
- database writer (DBWn), 4.5
- dedicated, 4.1.1
- dispatcher (Dnnn), 4.5
- dispatchers, 4.3.3.3
- global cache service (LMS), 4.5
- log writer (LGWR), 4.5
- monitoring locks, 7.2.1
- process monitor (PMON), 4.5
- recoverer (RECO), 4.5
- shared server, 4.1.2
- system monitor (SMON), 4.5
- trace files for, 7.1.1
- server-generated alerts, 7.1.2
- servers
-
- role in two-phase commit, 32.2.2
- service names
-
- database links and, 30.2.4
- services
-
- application, 2.7
- application, configuring, 2.7.2
- application, deploying, 2.7.1
- application, using, 2.7.3
- session trees for distributed transactions
-
- clients, 32.2.1
- commit point site, 32.2.5, 32.2.5.2
- database servers, 32.2.2
- definition, 32.2
- global coordinators, 32.2.4
- local coordinators, 32.2.3
- tracing transactions, 33.3.2
- sessions
-
- active, 4.8.2
- inactive, 4.8.3
- setting advice for transactions, 33.4.3.3
- terminating, 4.8
- SET TIME_ZONE clause
-
- ALTER SESSION, 2.4.9.1
- CREATE DATABASE, 2.4.9.1
- SET TRANSACTION statement
-
- naming transactions, 33.2
- setting
-
- Scheduler privileges, 28.1
- SGA
-
- See Also system global area
- SGA_MAX_SIZE initialization parameter, 5.4.1.3
- SGA_TARGET initialization parameter, 5.4.1.4
- shared database links
-
- configuring, 30.3.3
- creating, 30.3.2
- dedicated servers, creating links to, 30.3.3.1
- determining whether to use, 30.3.1
- example, 29.2.8
- shared servers, creating links to, 30.3.3.2
- SHARED keyword
-
- CREATE DATABASE LINK statement, 30.3.2
- shared server, 4.1.2
-
- configuring dispatchers, 4.3.3
- data dictionary views reference, 4.3.4
- disabling, 4.3.2.2, 4.3.3.6
- initialization parameters, 4.3.1
- interpreting trace output, 7.1.1.3
- setting minimum number of servers, 4.3.2.2
- trace files for processes, 7.1.1
- shared SQL
-
- for remote and distributed statements, 29.4.3
- SHARED_MEMORY_ADDRESS parameter, 5.4.2.8.2
- shrinking segments online, 17.3.3
- SHUTDOWN command
-
- ABORT clause, 3.3.4
- IMMEDIATE clause, 3.3.2
- interrupting, 3.3.5
- NORMAL clause, 3.3.1
- TRANSACTIONAL clause, 3.3.3
- silent mode
-
- creating a database with DBCA in, 2.2.2
- Simple Network Management Protocol (SNMP) support
-
- database management, 29.3.4.3
- single-file tablespaces
-
- description, 12.2.2
- single-instance
-
- defined, 2.3
- single-table hash clusters, 21.3.2
- site autonomy
-
- distributed databases, 29.3.1
- SKIP_CORRUPT_BLOCKS procedure, 23.3.3.1
-
- DBMS_REPAIR, 23.2.1
- example, 23.4.5
- skipping chain steps, 27.9.15
- snapshot too old error, 14.2.2.1
- SORT_AREA_SIZE initialization parameter
-
- index creation and, 19.2.1
- space
-
- deallocating unused, 17.3.4
- reclaiming unused, 17.3
- space allocation
-
- resumable, 17.2
- space management
-
- datatypes, space requirements, 17.4
- deallocating unused space, 17.3
- Segment Advisor, 17.3
- shrink segment, 17.3
- SPACE_ERROR_INFO procedure, 17.2.4.1
- SPFILE initialization parameter, 2.6.5
-
- specifying from client machine, 3.1.2
- SQL
-
- submitting, 1.3
- SQL failure
-
- repairing with SQL Repair Advisor, 8.8
- SQL patch
-
- disabling, 8.8.3
- removing, 8.8.3
- viewing, 8.8.3
- SQL Repair Advisor
-
- about, 8.8.1
- repairing SQL failure with, 8.8
- running, 8.8.2
- SQL statements
-
- distributed databases and, 29.4.1
- SQL test case builder, 8.1.1
- SQL*Loader
-
- about, 1.8
- SQL*Plus, 1.3
-
- about, 1.3.1
- connecting with, 1.3.2
- starting, 3.1.3
- starting a database, 3.1.1.1
- starting an instance, 3.1.1.1
- SQL_TRACE initialization parameter
-
- trace files and, 7.1.1
- STALE status
-
- of redo log members, 10.5.2
- stalled chain (Scheduler), 27.9.18
- standby transmission mode
-
- definition of, 11.5.2
- Oracle Net and, 11.5.2
- RFS processes and, 11.5.2
- starting a database, 3.1
-
- forcing, 3.1.4.5
- Oracle Enterprise Manager, 3.1.1.3
- recovery and, 3.1.4.6
- Recovery Manager, 3.1.1.2
- restricted mode, 3.1.4.4
- SQL*Plus, 3.1.1.1
- when control files unavailable, 3.1.4
- when redo logs unavailable, 3.1.4
- starting an instance
-
- automatically at system startup, 3.1.4.7
- database closed and mounted, 3.1.4.3
- database name conflicts and, 2.5.2.1
- forcing, 3.1.4.5
- mounting and opening the database, 3.1.4.1
- normally, 3.1.4.1
- Oracle Enterprise Manager, 3.1.1.3
- recovery and, 3.1.4.6
- Recovery Manager, 3.1.1.2
- remote instance startup, 3.1.4.8
- restricted mode, 3.1.4.4
- SQL*Plus, 3.1.1.1
- when control files unavailable, 3.1.4
- when redo logs unavailable, 3.1.4
- without mounting a database, 3.1.4.2
- startup
-
- allocation of the SGA
-
- starting a, 5.4.2.8.2
- STARTUP command
-
- default behavior, 2.6.1
- NOMOUNT clause, 2.3.8, 3.1.4.2
- RECOVER clause, 3.1.4.6
- starting a database, 3.1.1.1, 3.1.4
- statement transparency in distributed database
-
- managing, 30.7
- statistics
-
- automatically collecting for tables, 18.5
- STATISTICS_LEVEL initialization parameter
-
- automatic statistics collection, 18.5
- stderr
-
- for local external jobs, 26.4.4.3.2, 26.4.4.3.3, 27.2.11
-
- retrieving, 26.4.4.3.2, 26.4.4.3.3, 27.2.11
- stdout
-
- for local external jobs, 26.4.4.3.2, 26.4.4.3.3, 27.2.11
-
- retrieving, 26.4.4.3.2, 26.4.4.3.3, 27.2.2.5, 27.2.11
- steps, chain
-
- dropping, 27.9.11
- stopping
-
- chain steps, 27.9.13
- chains, 27.9.12
- jobs, 27.2.5
- storage parameters
-
- INITIAL, 18.6.2
- INITRANS, altering, 18.6.2
- MAXTRANS, altering, 18.6.2
- MINEXTENTS, 18.6.2
- NEXT, 18.6.2
- PCTINCREASE, 18.6.2
- storage subsystems
-
- mapping files to physical devices, 13.9, 13.9.4.3
- stored procedures
-
- managing privileges, 30.6.3.4
- remote object security, 30.6.3.4
- submitting SQL and commands to the database, 1.3
- subqueries
-
- in remote updates, 29.4.1
- statement transparency in distributed databases, 30.7
- SunSoft SunNet Manager, 29.3.4.3
- Support Workbench, 8.1.3.5
- SWITCH LOGFILE clause
-
- ALTER SYSTEM statement, 10.6
- synonyms, 22.3.3
-
- creating, 22.3.2, 30.6.2.1
- data dictionary views reference, 22.4
- definition and creation, 30.6.2.1
- displaying dependencies of, 16.10.2.2
- dropping, 22.3.4
- examples, 30.6.2.1
- location transparency in distributed databases, 30.6.2
- managing, 22.3.1, 22.3.4
- managing privileges in remote database, 30.6.2.2
- name resolution in distributed databases, 29.4.9
- private, 22.3.1
- public, 22.3.1
- remote object security, 30.6.2.2
- SYS account
-
- default password, 1.5.2
- objects owned, 1.5.2.1
- privileges, 1.5.2.1
- specifying password for CREATE DATABASE statement, 2.4.1
- SYS_GROUP for Database Resource Manager, 25.6.3
- SYSAUX tablespace, 12.2
-
- about, 2.4.3
- cannot rename, 12.8
- creating at database creation, 2.3.9, 2.4.3
- DATAFILE clause, 2.4.3
- monitoring occupants, 12.10.1
- moving occupants, 12.10.2
- SYSDBA system privilege
-
- adding users to the password file, 1.7.3
- connecting to database, 1.6.1.1
- determining who has privileges, 1.7.3.2
- granting and revoking, 1.7.3.1
- SYSOPER system privilege
-
- adding users to the password file, 1.7.3
- connecting to database, 1.6.1.1
- determining who has privileges, 1.7.3.2
- granting and revoking, 1.7.3.1
- SYSTEM account
-
- default password, 1.5.2
- objects owned, 1.5.2.2
- specifying password for CREATE DATABASE, 2.4.1
- system change numbers
-
- coordination in a distributed database system, 32.3.2.2
- in-doubt transactions, 33.5.1.2
- using V$DATAFILE to view information about, 13.10
- when assigned, 10.1.2
- system global area, 5.2
-
- holds sequence number cache
- specifying buffer cache sizes, 5.4.2.2
- system monitor process (SMON), 4.5
- system privileges
-
- ADMINISTER_RESOURCE_MANAGER, 25.1.5
- for external tables, 18.13.4
- SYSTEM tablespace
-
- cannot rename, 12.8
- creating at database creation, 2.3.9
- creating locally managed, 2.3.9, 2.4.2
- restrictions on taking offline, 13.4
- when created, 12.2
- SYSTEM_PLAN for Database Resource Manager, 25.6.3
T
- tables
-
- about, 18.1
- adding columns, Preface, 18.6.6
- allocating extents, 18.6.4
- altering, 18.6.1
- altering physical attributes, 18.6.2
- analyzing, 16.2
- clustered (hash). See hash clusters
- compressed, 18.2.6
- creating, 18.3
- data dictionary views reference, 18.14
- designing before creating, 18.2.1
- dropping, 18.10
- dropping columns, 18.6.8
- estimating size, 18.2.8
- estimating space use, 17.6.1
- external, 18.13
- Flashback Drop, 18.11
- Flashback Table, 18.9
- guidelines for managing, 18.2
- hash clustered. See hash clusters
- increasing column length, 18.6.5
- index-organized, 18.12
- key-preserved, 22.1.5.1
- limiting indexes on, 19.2.4
- managing, 18
- modifying column definition, 18.6.5
- moving, 18.6.3
- parallelizing creation, 18.2.4, 18.3.3
- read-only, 18.6.9
- redefining online, 18.7
- renaming columns, 18.6.7
- researching and reversing erroneous changes to, 18.8
- restrictions when creating, 18.2.9
- setting storage parameters, 18.2.8
- shrinking, 17.3.3
- specifying location, 18.2.3
- statistics collection, automatic, 18.5
- temporary, 18.3.2
- truncating, 16.3
- unrecoverable (NOLOGGING), 18.2.5
- validating structure, 16.2.2
- tablespace set, 12.13.5.2
- tablespaces
-
- adding datafiles, 13.2
- assigning user quotas, 12.1.2
- automatic segment space management, 12.2.1.2
- bigfile, 2.4.8, 12.2.2
- checking default storage parameters, 12.14.1
- containing XMLTypes, 12.13.3
- creating undo tablespace at database creation, 2.4.4, 2.4.8.2
- data dictionary views reference, 12.14
- DBMS_SPACE_ADMIN package, 12.11
- default temporary tablespace, creating, 2.4.6, 2.4.8.2
- detecting and repairing defects, 12.11
- diagnosing and repairing problems in locally managed, 12.11
- dictionary managed, 12.2.2.2
- dropping, 12.9
- guidelines for managing, 12.1
- listing files of, 12.14.2
- listing free space in, 12.14.3
- locally managed, 12.2.1
- locally managed SYSTEM, 2.4.2
- locally managed temporary, 12.2.4.1
- location, 13.1.3
- migrating SYSTEM to locally managed, 12.12
- multiple block sizes, 12.13.5.5
- on a WORM device, 12.6.3
- Oracle-managed files, managing, 15.5.1, 15.5.2
- overriding default type, 2.4.8.2
- quotas, assigning, 12.1.2
- read-only, 12.6
- renaming, 12.8
- setting default type, 2.4.8.1
- single-file, 2.4.8, 2.4.8.2, 12.2.2, 12.7.2
- specifying nonstandard block sizes, 12.3
- SYSAUX, 12.2, 12.8
- SYSAUX creation, 2.4.3
- SYSAUX, managing, 12.10
- SYSTEM, 12.2, 12.2.1, 12.6.1, 12.12
- taking offline normal, 12.5.1
- taking offline temporarily, 12.5.1
- tempfiles in locally managed, 12.2.4.1
- temporary, 12.2.4, 12.2.5.3
- temporary bigfile, 12.2.4.2
- temporary for creating large indexes, 19.3.5
- transportable
-
- see transportable tablespaces
- undo, 14.1
- using multiple, 12.1.1
- using Oracle-managed files, 15.3.3
- tablespaces, encrypted, 12.2.3
- tempfiles, 12.2.4.1
-
- creating as Oracle-managed, 15.3.4
- dropping, 13.6
- dropping Oracle-managed tempfiles, 15.4.1
- temporary segments
-
- index creation and, 19.2.1
- temporary tables
-
- assigning to a tablespace, 18.3.2
- creating, 18.3.2
- temporary tablespace, default
-
- specifying at database creation, 15.3.2.5
- temporary tablespaces
-
- altering, 12.7.3
- bigfile, 12.2.4.2
- creating, 12.2.4.1
- groups, 12.2.5
- renaming default, 12.8
- shrinking, locally managed, 12.7.4
- terminating user sessions
-
- active sessions, 4.8.2
- identifying sessions, 4.8.1
- inactive session, example, 4.8.3
- inactive sessions, 4.8.3
- test case
-
- builder, SQL, 8.1.1
- threads
-
- online redo log, 10.1.1
- threshold based alerts
-
- managing with Oracle Enterprise Manager, 7.1.2.1
- threshold-based alerts
-
- server-generated, 7.1.2
- thresholds
-
- setting alert, 17.1.1
- time zone
-
- files, 2.4.9.2
- setting for database, 2.4.9.1
- TNSNAMES.ORA file, 11.4.1.1
- trace files, 8.1.3.3
-
- location of, 7.1.1
- log writer process and, 10.2.1.1
- size of, 7.1.1.1
- using, 7.1.1
- when written, 7.1.1.2
- trace files, finding, 8.6
- traces, 8.1.3.3
- tracing
-
- archivelog process, 11.7
- transaction control statements
-
- distributed transactions and, 32.1.2
- transaction failures
-
- simulating, 33.9
- transaction management
-
- overview, 32.3
- transaction processing
-
- distributed systems, 29.4
- transactions
-
- closing database links, 31.2
- distributed and two-phase commit, 29.4.6
- in-doubt, 32.3.1.2, 32.4, 32.4.3, 33.4
- naming distributed, 33.2, 33.4.3.2
- remote, 29.4.4
- transmitting archived redo logs, 11.5
- transparent data encryption, 2.8.2, 12.2.3, 18.2.7
- transportable set
-
- See transportable tablespace set
- transportable tablespace set
-
- defined, 12.13.5
- transportable tablespaces, 12.13
-
- compatibility considerations, 12.13.4
- from backup, 12.13.1
- introduction, 12.13.1
- limitations, 12.13.3
- multiple block sizes, 12.13.5.5
- procedure, 12.13.5
- when to use, 12.13.6
- wizard in Enterprise Manager, 12.13.1
- XMLTypes in, 12.13.3
- transporting tablespaces between databases
-
- See transportable tablespaces
- triggers
-
- disabling, 16.4.2
- enabling, 16.4.1
- .trm files, 8.1.3.3
- TRUNCATE statement, 16.3.3
-
- DROP STORAGE clause, 16.3.3
- REUSE STORAGE clause, 16.3.3
- vs. dropping table, 18.10
- tuning
-
- analyzing tables, 31.4.2.2.2
- cost-based optimization, 31.4.2
- two-phase commit
-
- case study, 32.5
- commit phase, 32.3.2, 32.5.4
- described, 29.4.6
- discovering problems with, 33.4.1
- distributed transactions, 32.3
- example, 32.5
- forget phase, 32.3.3
- in-doubt transactions, 32.4, 32.4.3
- phases, 32.3
- prepare phase, 32.3.1, 32.3.1.2
- recognizing read-only nodes, 32.3.1.1.2
- specifying commit point strength, 33.1
- steps in commit phase, 32.3.2.1
- tracing session tree in distributed transactions, 33.3.2
- viewing database links, 33.3.1
U
- Undo Advisor, 14.4
- undo management
-
- automatic, 14.2
- described, 14.1
- initialization parameters for, 14.2.1
- undo retention
-
- automatic tuning of, 14.2.2.1
- explained, 14.2.2
- guaranteeing, 14.2.2.2
- setting, 14.3
- undo segments
-
- in-doubt distributed transactions, 33.4.2
- undo space
-
- data dictionary views reference, 14.7
- undo space management
-
- automatic undo management mode, 14.2
- Undo tablespace
-
- specifying at database creation, 15.3.2.4
- undo tablespace
-
- managing, 14.5
- managing space threshold alerts, 14.5.6
- sizing a fixed-size, 14.4
- undo tablespaces
-
- altering, 14.5.2
- creating, 14.5.1
- data dictionary views reference, 14.7
- dropping, 14.5.3
- monitoring, 14.7
- PENDING OFFLINE status, 14.5.4
- renaming, 12.8
- specifying at database creation, 2.3.9, 2.4.4, 2.4.8.2
- statistics for, 14.7
- switching, 14.5.4
- user quotas, 14.5.5
- UNDO_MANAGEMENT initialization parameter, 2.4.4
- UNDO_TABLESPACE initialization parameter
-
- for undo tablespaces, 2.5.8.2
- starting an instance using, 14.2.1
- UNIQUE key constraints
-
- associated indexes, 19.3.3.1
- dropping associated indexes, 19.6
- enabling on creation, 19.3.3
- foreign key references when dropped, 16.5.3.1
- indexes associated with, 19.3.3
- UNRECOVERABLE DATAFILE clause
-
- ALTER DATABASE statement, 10.8
- updates
-
- location transparency and, 29.5.1.2
- upgrading a database, 2.1
- USE_INDIRECT_DATA_BUFFERS parameter, 5.4.2.8.3
- user accounts
-
- predefined, 2.8.1, 6.5
- USER_DB_LINKS view, 30.5.1, 30.5.1
- USER_DUMP_DEST initialization parameter, 8.1.3.1
- USER_RESUMABLE view, 17.2.4.1
- usernames
-
- SYS and SYSTEM, 1.5.2
- users
-
- assigning tablespace quotas, 12.1.2
- in a newly created database, 2.8.1
- limiting number of, 2.5.10
- predefined, 2.8.1
- session, terminating, 4.8.3
- utilities
-
- for the database administrator, 1.8
- SQL*Loader, 1.8
- UTLCHAIN.SQL script
-
- listing chained rows, 16.2.3.1
- UTLCHN1.SQL script
-
- listing chained rows, 16.2.3.1
- UTLLOCKT.SQL script, 7.2.1
V
- V$ARCHIVE view, 11.8
- V$ARCHIVE_DEST view
-
- obtaining destination status, 11.4.2
- V$BLOCKING_QUIESCE view, 3.4.1
- V$BUFFER_POOL view, 5.4.2.2.1
- V$DATABASE view, 11.8.1
- V$DBLINK view, 30.5.2
- V$DIAG_INFO view, 8.1.4
- V$DISPATCHER view
-
- monitoring shared server dispatchers, 4.3.3.4
- V$DISPATCHER_RATE view
-
- monitoring shared server dispatchers, 4.3.3.4
- V$ENCRYPTED_TABLESPACES view, 12.2.3, 12.14
- V$INSTANCE view
-
- for database quiesce state, 3.4.3
- V$LOG view, 10.9, 11.8
-
- displaying archiving status, 11.8
- V$LOG_HISTORY view, 10.9
- V$LOGFILE view, 10.9
-
- log file status, 10.5.2
- V$OBJECT_USAGE view
-
- for monitoring index usage, 19.4.5
- V$PWFILE_USERS view, 1.7.3.2
- V$QUEUE view
-
- monitoring shared server dispatchers, 4.3.3.4
- V$RESULT_CACHE_STATISTICS view, 5.4.2.7, 5.4.2.7
- V$ROLLSTAT view
-
- undo segments, 14.7
- V$SESSION view, 4.8.3
- V$SYSAUX_OCCUPANTS view
-
- occupants of SYSAUX tablespace, 12.10.2
- V$THREAD view, 10.9
- V$TIMEZONE_NAMES view
-
- time zone table information, 2.4.9.2
- V$TRANSACTION view
-
- undo tablespaces information, 14.7
- V$UNDOSTAT view
-
- statistics for undo tablespaces, 14.7
- V$VERSION view, 1.4.2
- VALIDATE STRUCTURE clause
-
- of ANALYZE statement, 16.2.2
- VALIDATE STRUCTURE ONLINE clause
-
- of ANALYZE statement, 16.2.2
- verifying blocks
-
- redo log files, 10.7
- viewing
-
- alerts, 17.1.2
- incident package details, 8.10.3.1
- SQL patch, 8.8.3
- views
-
- creating, 22.1.2
- creating with errors, 22.1.2.3
- data dictionary
-
- for archived redo logs, 11.8.1
- for clusters, 20.6
- for control files, 9.8
- for database, 2.10
- for database resident connection pooling, 4.4.3
- for Database Resource Manager, 25.11.3
- for datafiles, 13.10
- for hash clusters, 21.6
- for indexes, 19.7
- for memory management, 5.5.2
- for Oracle Scheduler, 28.7.2
- for redo log, 10.9
- for schema objects, 16.10.2
- for sequences, 22.4
- for shared server, 4.3.4
- for space usage in schema objects, 17.5.2
- for synonyms, 22.4
- for tables, 18.14
- for tablespaces, 12.14
- for undo space, 14.7
- for views, 22.4
- data dictionary views for, 22.4
- DBA_2PC_NEIGHBORS, 33.3.2
- DBA_2PC_PENDING, 33.3.1
- DBA_DB_LINKS, 30.5.1
- DBA_RESUMABLE, 17.2.4.1
- displaying dependencies of, 16.10.2.2
- dropping, 22.1.7
- file mapping views, 13.9.3.3
- FOR UPDATE clause and, 22.1.2
- invalid, 22.1.4
- join. See join views.
- location transparency in distributed databases, 30.6.1
- managing, 22.1, 22.1.3
- managing privileges with, 30.6.1
- name resolution in distributed databases, 29.4.9
- ORDER BY clause and, 22.1.2
- remote object security, 30.6.1
- restrictions, 22.1.4
- USER_RESUMABLE, 17.2.4.1
- using, 22.1.4
- V$ARCHIVE, 11.8
- V$ARCHIVE_DEST, 11.4.2
- V$DATABASE, 11.8.1
- V$LOG, 11.8
- V$LOGFILE, 10.5.2
- V$OBJECT_USAGE, 19.4.5
- wildcards in, 22.1.2.2
- WITH CHECK OPTION, 22.1.2
- virtual columns, 18.1
-
- indexing, 19.2.2
W
- wallet, Oracle, 12.2.3, 18.2.7
- wildcards
-
- in views, 22.1.2.2
- window groups
-
- creating, 27.7.2
- disabling, 27.7.7
- dropping, 27.7.3
- dropping a member from, 27.7.5
- enabling, 27.7.6
- overview, 26.8
- using, 27.7
- window logs, 27.6
- windows (Scheduler)
-
- altering, 27.6.3
- closing, 27.6.5
- creating, 27.6.2
- disabling, 27.6.7
- dropping, 27.6.6
- enabling, 27.6.8
- opening, 27.6.4
- overlapping, 27.6.9
- overview, 26.7
- using, 27.6
- WORM devices
-
- and read-only tablespaces, 12.6.3
- WRH$_UNDOSTAT view, 14.7
X
- XMLTypes
-
- in transportable tablespaces, 12.13.3