Index

ALL_TAB_COLUMNS view

ALL_TABLES view

extents for clusters, 17-9

allocation

extents, 14-11

minimizing extents for rollback segments, 21-13

temporary space, 14-6

alphanumeric datatypes, 12-17

ALTER CLUSTER command

ALLOCATE EXTENT option, 17-9

MAXTRANS option, 12-9

using for hash clusters, 18-8

using for index clusters, 17-9

ALTER DATABASE command

ADD LOGFILE MEMBER option, 6-12

ADD LOGFILE option, 6-11

ARCHIVELOG option, 7-7

CLEAR LOGFILE option, 6-17

CLEAR UNARCHIVED LOGFILE option, 6-7

database partially available to users, 3-7

DATAFILE...OFFLINE DROP option, 10-8

DROP LOGFILE MEMBER option, 6-15

DROP LOGFILE option, 6-14

MOUNT option, 3-7

NOARCHIVELOG option, 7-7

OPEN option, 3-7

RENAME FILE option

datafiles for multiple tablespaces, 10-10

UNRECOVERABLE DATAFILE option, 6-17

ALTER FUNCTION command

ALTER INDEX COALESCE, 16-7

ALTER INDEX command, 13-18

about, 16-13

MAXTRANS option, 12-9

MOVE PARTITION clause, 13-11

REBUILD PARTITION clause, 13-11, 13-20

ALTER PACKAGE command

ALTER PROCEDURE command

altering resource limits, 23-19

ALTER PROFILE command

COMPOSITE_LIMIT option, 23-19

ALTER RESOURCE COST command, 23-20

ALTER ROLE command

changing authorization method, 24-8

ALTER ROLLBACK SEGMENT command

changing storage parameters, 21-9

OFFLINE option, 21-12

ONLINE option, 21-11, 21-12

PUBLIC option, 21-9

STORAGE clause, 21-9

ALTER SEQUENCE command, 15-11

ALTER SESSION command

SET SQL_TRACE parameter, 4-10

ALTER SYSTEM command

ARCHIVE LOG ALL option, 7-10

ARCHIVE LOG option, 7-10

ENABLE RESTRICTED SESSION option, 3-9

SET LICENSE_MAX_SESSIONS option, 23-4

SET LICENSE_MAX_USERS option, 23-6

SET LICENSE_SESSIONS_WARNING option, 23-4

SET MTS_DISPATCHERS option, 4-7

SET MTS_SERVERS option, 4-6

SET RESOURCE_LIMIT option, 23-21

SWITCH LOGFILE option, 6-16

ALTER SYSTEM RESUME, 3-13

ALTER SYSTEM SUSPEND, 3-8

ALTER TABLE command

ADD PARTITION clause, 13-11

ALLOCATE EXTENT option, 14-11

DISABLE ALL TRIGGERS option, 20-13

DISABLE integrity constraint option, 20-20

DROP integrity constraint option, 20-21

DROP PARTITION clause, 13-12

ENABLE ALL TRIGGERS option, 20-12

ENABLE integrity constraint option, 20-20

example, 14-11

MAXTRANS option, 12-9

MODIFY PARTITION clause, 13-10

SPLIT PARTITION clause, 13-11, 13-17

TRUNCATE PARTITION clause, 13-15

ALTER TABLESPACE command

ADD DATAFILE parameter, 10-5

ONLINE option

example, 9-10

READ ONLY option, 9-12

READ WRITE option, 9-14

RENAME DATA FILE option, 10-10

ALTER TRIGGER command

DISABLE option, 20-13

ENABLE option, 20-12

ALTER USER privilege, 23-15

ALTER VIEW command

public rollback segments, 21-9

altering

cluster indexes, 17-9

clustered tables, 17-9

rollback segment storage parameters, 21-9

sequences, 15-10

storage parameters, 14-10

tables, 14-10, 14-11

tablespace storage, 9-8

users, 23-15

ANALYZE command

CASCADE option, 20-8

COMPUTE STATISTICS option, 20-7

ESTIMATE STATISTICS SAMPLE option, 20-7

LIST CHAINED ROWS option, 20-9

shared SQL and, 20-8

STATISTICS option, 20-4

VALIDATE STRUCTURE option, 20-8

ANALYZE TABLE VALIDATE STRUCTURE, 19-3

analyzing archived redo logs, 7-25

analyzing objects

about, 20-3

privileges, 20-3

application administrator, 1-3

database administrator versus, 22-11

application developers

privileges for, 22-9

roles for, 22-10

application development

security for, 22-10

applications

quiescing during maintenance operations, 13-21

ARCH process

specifying multiple processes, 7-20

archive buffer parameters, 7-22

ARCHIVE LOG command

LIST option, 6-14

ARCHIVE LOG option

ALTER SYSTEM command, 7-10

archived redo logs, 7-2

ARCHIVELOG mode, 7-4, 7-6

advantages, 7-5

archiving, 7-4

automatic archiving in, 7-5

definition of, 7-4

distributed databases, 7-6

enabling, 7-7

manual archiving in, 7-5

running in, 7-4

switching to, 7-7

taking datafiles offline and online in, 10-8

archiving

AUDIT command, 25-9

schema objects, 25-11

statement auditing, 25-10

system privileges, 25-10

audit trail, 25-14

archiving, 25-15

auditing changes to, 25-16

controlling size of, 25-14

creating and deleting, 25-4

deleting views, 25-5

interpreting, 25-17

maximum size of, 25-14

protecting integrity of, 25-16

purging records from, 25-15

recording changes to, 25-16

records in, 25-7

reducing size of, 25-16

table that holds, 25-2

views on, 25-4

AUDIT_TRAIL parameter

setting, 25-13

auditing, 25-2

AUDIT command, 25-9

audit option levels, 25-8

audit trail records, 25-5

default options, 25-11

disabling default options, 25-13

disabling options, 25-11, 25-12, 25-13

disabling options versus auditing, 25-12

enabling options, 25-9, 25-13

enabling options versus auditing, 25-10

guidelines, 25-2

historical information, 25-4

keeping information manageable, 25-2

managing the audit trail, 25-4

operating-system audit trails, 25-7

policies for, 22-18

privilege audit options, 25-9

privileges required for object, 25-11

privileges required for system, 25-10

schema objects, 25-11

session level, 25-8

shortcuts for object, 25-9

shortcuts for system, 25-8

statement, 25-10

statement level, 25-8

suspicious activity, 25-3

system privileges, 25-10

triggers and, 25-20

using the database, 25-2

viewing

active object options, 25-19

active privilege options, 25-18

active statement options, 25-18

defauly object options, 25-19

views, 25-4

authentication

database managed, 23-8

operating system, 1-7

password file, 1-9

password policy, 22-4

specifying when creating a user, 23-12

users, 22-2, 23-7, 23-9

authorization

changing for roles, 24-8

omitting for roles, 24-8

operating-system role management and, 24-7

roles

about, 24-6

multi-threaded server and, 24-7

automatic archiving

archive log destination, 7-8

background processes

Oracle8i processes, 4-9

BACKGROUND_DUMP_DEST parameter, 4-11

backups

after creating new databases

full backups, 2-7

guidelines, 1-20

before database creation, 2-4

effects of archiving on, 7-4

bad param destination state, 7-14

bitmapped tablespaces, 9-5

bringing online

broken jobs

buffers

buffer cache in SGA, 2-11

bug fixes, 1-21

CASCADE option

integrity constraints, 17-11

when dropping unique or primary keys, 20-20

cascading revokes, 24-14

CATAUDIT.SQL

running, 25-4

CATBLOCK.SQL script, 4-8

CATNOAUD.SQL

running, 25-5

change vectors, 6-2

CHAR datatype

increasing column length, 14-10

space use of, 12-17

character sets

multi-byte characters

in role names, 24-5

in role passwords, 24-7

user passwords and, 23-12

parameter file and, 3-14

specifying when creating a database, 2-2

supported by Oracle, 12-17

CHECK constraint, 20-19

check_object procedure, 19-3, 19-7

checkpoint process (CKPT)

starting, 4-12

CHECKPOINT_PROCESS parameter

setting, 4-12

checksums

for data blocks, 10-12

redo log blocks, 6-16

CKPT, 4-12

CLEAR LOGFILE option

ALTER DATABASE command, 6-17

clearing redo log files, 6-7, 6-17

restrictions, 6-17

cluster keys

columns for, 17-4

SIZE parameter, 17-5

clustered tables, 17-10

clusters

columns

displaying information about, 20-31

granting privileges for selected, 24-10

granting privileges on, 24-11

increasing length, 14-10

INSERT privilege and, 24-11

listing users granted to, 24-21

privileges, 24-11

revoking privileges on, 24-13

commands, SQL

CREATE DATABASE, 6-10

commands, SQL*Plus

ARCHIVE LOG, 6-14

HOST, 6-13

committing transactions

writing redo log buffer and, 6-2

composite limits, 23-19

costs and, 23-20

service units, 23-19

COMPUTE STATISTICS option, 20-7

configuring an instance

with dedicated server processes, 4-2

CONNECT role, 24-5

connecting

administrator privileges, 3-10

connections

auditing, 25-8

dedicated servers, 4-2

during shutdown, 3-9

control files

CONTROL_FILES parameter

overwriting existing control files, 2-10

setting

before database creation, 2-10, 5-4

names for, 5-2

costs

resource limits and, 23-20

CREATE CLUSTER command

example, 17-7

for hash clusters, 18-4

HASH IS option, 18-6

HASHKEYS option, 18-7

SIZE option, 18-6

CREATE CONTROLFILE command

about, 5-5

checking for inconsistencies, 5-8

NORESETLOGS option, 5-7

RESETLOGS option, 5-7

CREATE DATABASE command

CONTROLFILE REUSE option, 5-4

example, 2-7

MAXLOGFILES option, 6-10

MAXLOGMEMBERS option, 6-10

CREATE INDEX command

explicitly, 16-8

ON CLUSTER option, 17-8

UNRECOVERABLE, 16-5

with a constraint, 16-8

CREATE PROFILE command

about, 23-18

COMPOSITE_LIMIT option, 23-19

CREATE ROLE command

IDENTIFIED BY option, 24-7

IDENTIFIED EXTERNALLY option, 24-7

CREATE ROLLBACK SEGMENT command

about, 21-8

tuning guidelines, 2-15

CREATE SCHEMA command

multiple tables and views, 20-2

privileges required, 20-2

CREATE SEQUENCE command, 15-10

CREATE SYNONYM command, 15-12

CREATE TABLE command

about, 14-9

CLUSTER option, 17-7

PARTITION clause, 13-9

UNRECOVERABLE, 14-4

CREATE TABLESPACE command

datafile names in, 9-4

example, 9-4

CREATE USER command

IDENTIFIED BY option, 23-12

IDENTIFIED EXTERNALLY option, 23-12

CREATE VIEW command

about, 15-2

OR REPLACE option, 15-9

WITH CHECK OPTION, 15-3

creating

audit trail, 25-4

cluster index, 17-6

clustered tables, 17-6

clusters, 17-6

control files, 5-3

database, 1-19, 2-1

backing up the new database, 2-7

during installation, 2-3

executing CREATE DATABASE, 2-6

migration from different versions, 2-3

preparing to, 2-2

prerequisites for, 2-3

problems encountered while, 2-8

databases, 7-7

datafiles, 9-3, 10-5

hash clustered tables, 18-4

hash clusters, 18-4

indexes

explicitly, 16-8

multiple objects, 20-2

online redo log groups, 6-11

parameter file, 2-4

partitioned objects, 13-9

partitioned tables, 13-9

profiles, 23-18

redo log members, 6-11

rollback segments

about, 21-8

specifying storage parameters, 21-8

rollback segments required, 9-5

views, 15-2

data

security of, 22-3

data blocks

altering size of, 2-11

managing space usage of, 12-2

managing space use of, 12-2

operating system blocks versus, 2-11

PCTFREE storage parameter, 12-3

PCTUSED storage parameter, 12-5

shared in clusters, 17-2

size of, 2-11

verifying, 10-12

data dictionary

changing storage parameters, 20-29

conflicts with control files, 5-8

schema object views, 20-29

segments in the, 20-27

setting storage parameters of, 20-26

V$DBFILE view, 2-8

V$DISPATCHER view, 4-7

V$LOGFILE view, 2-8

V$QUEUE view, 4-7

data integrity, 20-19

integrity constraints, 20-19

database administrator, 1-2

application administrator versus, 22-11

initial priorities, 1-17

operating-system account, 1-4

password files for, 1-7

responsibilities of, 1-2

roles

about, 1-6

for security, 22-8

security and privileges of, 1-4

security for, 22-7

security officer versus, 1-3, 22-2

usernames, 1-5

utilities for, 1-17

database links

job queues and, 8-9

Database Resource Manager, 11-1

databases

administering, 1-1

auditing, 25-1

availability, 3-7

backing up

after creation of, 1-20

full backups, 2-7

control files of, 5-2

CREATE DATABASE command, 2-7

creating

opening and, 1-19

trouble-shooting problems, 2-8

design of

global database name

global database names

in a distributed system, 2-9

hardware evaluation, 1-18

logical structure of, 1-19

managing

size of, 10-1

migration of, 2-3

mounting a database, 3-4

mounting to an instance, 3-7

names

about, 2-9

conflicts in, 2-9

opening

a closed database, 3-7

parallel mode, 3-6

physical structure of, 1-19

planning, 1-18

production, 22-9, 22-11

renaming, 5-5

restricting access to, 3-4, 3-8

specifying control files, 2-10

starting up

before database creation, 2-6

general procedures for, 3-2

restricting access, 3-4

structure of

distributed database, 1-19

test, 22-9

tuning

archiving large databases, 7-20

responsibilities for, 1-20

user responsibilities, 1-3

viewing datafiles and redo log files, 2-8

datafiles

adding to a tablespace, 10-5

bringing online and offline, 10-7

checking associated tablespaces, 9-31

creating, 9-3

database administrators access, 1-4

default directory, 10-5

dropping, 9-14

NOARCHIVELOG mode, 10-8

fully specifying filenames, 10-5

identifying filenames, 10-11

location, 10-4

managing, 10-1

maximum number of, 10-2

minimum number of, 10-2

MISSING, 5-8

monitoring, 10-13

online, 10-8

privileges to rename, 10-9

privileges to take offline, 10-8

relocating, 10-9, 10-10

relocating, example, 10-11

renaming, 10-9, 10-10

renaming for single tables, 10-9

reusing, 10-5

size of, 10-4

storing separately from redo log files, 10-4

unavailable when database is opened, 3-3

verifying data blocks, 10-12

viewing

general status of, 10-13

V$DBFILE and V$LOGFILE views, 2-8

datatypes

character, 12-17

DATE, 12-18

individual type names, 12-17

DB_BLOCK_BUFFERS parameter

setting before database creation, 2-11

DB_BLOCK_CHECKING parameter, 19-3

DB_BLOCK_CHECKSUM, 10-12

DB_BLOCK_SIZE parameter

database buffer cache size and, 2-11

setting before creation, 2-11

DB_DOMAIN parameter

setting before database creation, 2-9

DB_NAME parameter

setting before database creation, 2-9

DB_VERIFY utility, 19-3

DBA, 1-2

DBA role, 1-6, 24-5

DBA_DATA_FILES, 9-31, 10-13

DBA_EXTENTS, 10-13

DBA_FREE_SPACE, 9-31, 10-13

DBA_FREE_SPACE_COALESCED view, 9-9

DBA_INDEXES view

DBA_ROLLBACK_SEGS view, 21-14

DBA_SEGMENTS, 9-31, 10-13

DBA_TAB_COLUMNS view

DBA_TABLES view

DBA_TABLESPACES, 9-31, 10-13

DBA_TABLESPACES view, 9-15

DBA_TS_QUOTAS, 9-31, 10-13

DBA_USERS, 9-31, 10-13

DBMS_JOB package

altering a job, 8-11

forcing jobs to execute, 8-14

job queues and, 8-3

REMOVE procedure and, 8-11

submitting jobs, 8-4

DBMS_LOGMNR_D.BUILD package, 7-28

DBMS_LOGMNR.ADD_LOGFILE package

LogMiner, 7-29

DBMS_LOGMNR.START_LOGMNR package

LogMiner, 7-30

DBMS_REPAIR package, 19-1

DBMS_RESOURCE_MANAGER package, 11-3

DBMS_RESOURCE_MANAGER_PRIVS package, 11-10

DBMS_SESSION package, 11-11

DBMS_UTILITY.ANALYZE_SCHEMA()

running, 20-8

dedicated server processes

configuring, 4-2

connecting with, 4-2

trace files for, 4-10

dedicated servers

multi-threaded servers contrasted with, 4-3

default

tablespace quota, 23-13

temporary tablespace, 23-13

user tablespaces, 23-12

DEFAULT_CONSUMER_GROUP, 11-9

deferred destination state, 7-14

deleting

table statistics, 20-4

dependencies

displaying, 20-32

destination states for archived redo logs, 7-13

destinations

archived redo logs

sample scenarios, 7-18

developers, application, 22-9

dictionary files

LogMiner and the, 7-27

disabled destination state

for archived redo logs, 7-13

disabling

archiving, 7-7, 7-9

audit options, 25-11, 25-12

auditing, 25-13

integrity constraints, 20-18

effects on indexes, 16-7

resource limits, 23-21

triggers, 20-12

disconnections

auditing, 25-8

dispatcher processes

number to start, 4-5

privileges to change number of, 4-7

removing, 4-7

setting the number of, 4-7

spawning new, 4-7

distributed databases

running in ARCHIVELOG mode, 7-6

running in NOARCHIVELOG mode, 7-6

starting a remote instance, 3-6

distributed processing

parameter file location in, 3-15

distributing I/O, 2-15

DROP CLUSTER command

CASCADE CONSTRAINTS option, 17-11

dropping

cluster with no tables, 17-11

hash cluster, 18-9

INCLUDING TABLES option, 17-11

DROP LOGFILE MEMBER option

ALTER DATABASE command, 6-15

DROP LOGFILE option

ALTER DATABASE command, 6-14

DROP PARTITION clause

ALTER TABLE command, 13-12

DROP PROFILE command, 23-21

DROP ROLE command, 24-8, 24-9

DROP ROLLBACK SEGMENT command, 21-14

DROP SYNONYM command, 15-12

DROP TABLE command

about, 14-12

CASCADE CONSTRAINTS option, 14-12

for clustered tables, 17-10

DROP TABLESPACE command, 9-15

DROP USER command, 23-17

DROP USER privilege, 23-17

dropping

dump_orphan_keys procedure, 19-6, 19-9

dynamic performance tables

using, 4-9

enabled destination state

for archived redo logs, 7-13

enabling

archiving, 7-7

auditing options

about, 25-9

privileges for, 25-13

integrity constraints

at creation, 20-18

example, 20-19

reporting exceptions, 20-21

when violations exist, 20-15

resource limits, 23-21

triggers, 20-12

encryption

Oracle passwords, 23-8

enroll

database users, 1-20

Enterprise Manager

operating system account, 1-4

environment of a job, 8-6

errors

ORA-1628 through 1630, 20-29

snapshot too old, 21-5

trace files and, 4-10

when creating a database, 2-8

when creating control file, 5-9

while starting an instance, 3-5

ESTIMATE STATISTICS option, 20-7

estimating size

hash clusters, 18-4

tables, 14-5

evaluating

hardware for the Oracle8i, 1-18

example

creating constraints, 20-19

examples

altering an index, 16-13

exceptions

integrity constraints, 20-21

exclusive mode

of the database, 3-6

rollback segments and, 21-3

terminating remaining user sessions, 4-16

EXP_FULL_DATABASE role, 24-5

Export utility

about, 1-17

restricted mode and, 3-4

exporting jobs, 8-7

exports

modes, 7-14, 7-18, 7-19

extents

allocating

clusters, 17-9

index creation, 16-6

tables, 14-11

data dictionary views for, 20-30

displaying free extents, 20-33

displaying information on, 20-32

multiplexed online redo logs, 6-5

failures

media

files

OS limit on number open, 9-2

fix_corrupt_blocks procedure, 19-5, 19-7

forcing a log switch, 6-16

with the ALTER SYSTEM command, 6-16

FOREIGN KEY constraint

enabling, 20-19

free space

coalescing, 9-8

listing free extents, 20-33

tablespaces and, 9-32

function-based indexes, 16-9

functions

recompiling, 20-25

global database name, 2-9

global index

dropping partition with, 13-12, 13-15

splitting partition in, 13-18

global user, 23-10

GRANT command

ADMIN option, 24-10

GRANT option, 24-11

object privileges, 24-10

SYSOPER/SYSDBA privileges, 1-13

system privileges and roles, 24-9

when takes effect, 24-15

GRANT OPTION

about, 24-11

revoking, 24-13

granting privileges and roles

listing grants, 24-19

shortcuts for object privileges, 24-3

SYSOPER/SYSDBA privileges, 1-13

groups

redo log files

LOG_FILES initialization parameter, 6-10

Guidelines, 10-2

guidelines

for managing rollback segments, 21-2

hardware

hash clusters

controlling space use of, 18-6

creating, 18-4

dropping, 18-9

estimating storage, 18-4

high water mark

historical table

moving time window in, 13-20

HOST command

SQL*Plus, 6-13

I/O

distributing, 2-15

identification

users, 23-7

IMP_FULL_DATABASE role, 24-5

implementing database design, 1-20

Import utility

about, 1-17

restricted mode and, 3-4

importing

jobs, 8-7

inactive destination state

for archived redo logs, 7-14

index partition

indexes

adding partition, 13-12

altering, 16-13

analyzing statistics, 20-3

cluster

correct tables and columns, 16-8

creating

after inserting table data, 16-3

explicitly, 16-8

unrecoverably, 16-5

disabling and dropping constraints and, 16-7

extent allocation for, 16-6

dropping, 16-15

estimating size, 16-5

guidelines for managing, 16-2

INITRANS for, 16-4

limiting per table, 16-3

managing, 16-1, 16-15

MAXTRANS for, 16-4

monitoring space use of, 16-14

overview of, 16-2

parallelizing index creation, 16-5

privileges

separating from a table, 14-6

setting storage parameters for, 16-5

SQL*Loader and, 16-3

storage parameters, 12-10

tablespace for, 16-4

temporary segments and, 16-3

validating structure, 20-8

index-organized table, 14-14

in-doubt transactions

rollback segments and, 21-11

initial

passwords for SYS and SYSTEM, 1-5

INITIAL storage parameter, 12-7

affecting sequences, 15-11

initialization parameters

LOG_ARCHIVE_BUFFER_SIZE, 7-22, 7-23

LOG_ARCHIVE_BUFFERS, 7-22, 7-23

LOG_ARCHIVE_DEST_n, 7-11

LOG_ARCHIVE_DEST_STATE_n, 7-13

LOG_ARCHIVE_MAX_PROCESSES, 7-20

LOG_ARCHIVE_MIN_SUCCEED_DEST, 7-17

LOG_ARCHIVE_START, 7-9, 7-14

LOG_BLOCK_CHECKSUM, 6-16

LOG_FILES, 6-10

multi-threaded server and, 4-4

INITRANS storage parameter

guidelines for setting, 12-9

default, 12-9

transaction entries and, 12-9

INSERT privilege

granting, 24-11

revoking, 24-13

installation

and creating a database, 2-3

Oracle8i, 1-18

tuning recommendations for, 2-14

instance menu

prevent Connections option, 3-9

instances

aborting, 3-12

shutting down immediately, 3-11

starting, 3-2

starting before database creation, 2-6

integrity constraints

disabling, 20-14, 20-19

disabling on creation, 20-18

dropping, 20-21

dropping and disabling, 16-7

dropping tablespaces and, 9-15

enabling, 20-14

enabling on creation, 20-18

enabling when violations exist, 20-15

exceptions to, 20-21

managing, 20-15

violations, 20-15

when to disable, 20-15

INTERNAL

alternatives to, 1-8

connecting for shutdown, 3-10

OSOPER and OSDBA, 1-8

security for, 22-8

INTERNAL date function

executing jobs and, 8-8

invalid destination state

for archived redo logs, 7-13

Job, 8-3

job queues, 8-2, 8-3

executing jobs in, 8-9

locks, 8-9

privileges for using, 8-4

removing jobs from, 8-11

scheduling jobs, 8-3

viewing, 8-15

jobs

join view, 15-4

DELETE statements, 15-7

key-preserved tables in, 15-5

mergeable, 15-5

modifying

rule for, 15-6

when modifiable, 15-4

key-preserved tables

keys

killing

LGWR, 4-11

LICENSE_MAX_SESSIONS parameter

changing while instance runs, 23-4

setting, 23-4

setting before database creation, 2-12

LICENSE_MAX_USERS parameter

changing while database runs, 23-6

setting, 23-6

setting before database creation, 2-12

LICENSE_SESSION_WARNING parameter

setting before database creation, 2-12

LICENSE_SESSIONS_WARNING parameter

changing while instance runs, 23-4

setting, 23-4

licensing

complying with license agreement, 2-12, 23-2

concurrent usage, 23-2

named user, 23-2, 23-5

number of concurrent sessions, 2-13

privileges for changing named user limits, 23-6

privileges for changing session limits, 23-5

session-based, 23-2

viewing limits, 23-6

limits

composite limits, 23-19

concurrent usage, 23-2

resource limits, 23-19

session, high water mark, 23-3

LIST CHAINED ROWS option, 20-9

location

rollback segments, 21-7

locks

log sequence number

log switches

log sequence numbers, 6-5

multiplexed redo log files and, 6-7

privileges, 6-16

waiting for archiving to complete, 6-7

log writer process (LGWR)

multiplexed redo log files and, 6-6

online redo logs available for use, 6-3

trace file monitoring, 4-11

trace files and, 6-6

writing to online redo log files, 6-2, 6-3

LOG_ARCHIVE_BUFFER_SIZE initialization parameter, 7-23

LOG_ARCHIVE_BUFFERS initialization parameter, 7-23

LOG_ARCHIVE_BUFFERS parameter

setting, 7-23

LOG_ARCHIVE_DEST initialization parameter

specifying destinations using, 7-11

LOG_ARCHIVE_DEST_n initialization parameter, 7-11

REOPEN option, 7-19

LOG_ARCHIVE_DUPLEX_DEST initialization parameter

specifying destinations using, 7-11

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 7-20

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 7-17

LOG_ARCHIVE_START initialization parameter, 7-9

bad param destination state, 7-14

setting, 7-9

LOG_BLOCK_CHECKSUM initialization parameter

enabling redo block checking with, 6-16

LOG_FILES initialization parameter

number of log files, 6-10

logical structure of a database, 1-19

LogMiner, 7-25

LogMiner utility, 7-25, 7-31

dictionary file, 7-27

using the, 7-29, 7-30

using to analyze archived redo logs, 7-25

LONG datatype, 12-18

maintenance release number, 1-21

managing

auditing, 25-1

cluster indexes, 17-1

clustered tables, 17-1

clusters, 17-1

indexes, 16-1, 16-15

jobs, 8-3

object dependencies, 20-23

profiles, 23-17

roles, 24-4

rollback segments, 21-1

manual archiving

in ARCHIVELOG mode, 7-10

marked user session, 4-17

MAX_DUMP_FILE_SIZE parameter, 4-11

MAX_ENABLED_ROLES parameter

default roles and, 24-8

enabling roles and, 24-8

MAXDATAFILES parameter

setting for the data dictionary, 20-27

MAXEXTENTS storage parameter

about, 12-8

MAXINSTANCES parameter

CREATE DATABASE command, 6-10

MAXLOGFILES option

MAXLOGFILES parameter

MAXLOGHISTORY

CREATE DATABASE command, 6-10

MAXLOGMEMBERS option

MAXLOGMEMBERS parameter

MAXTRANS storage parameter

guidelines for setting, 12-9

default, 12-9

transaction entries and, 12-9

media recovery

effects of archiving on, 7-4

memory

viewing per user, 23-25

migration

database migration, 2-3

MINEXTENTS storage parameter

about, 12-8

ALTER TABLE command, 13-10

mirrored control files

mirrored files

mirroring

modes

modifiable join view

MODIFY PARTITION clause

modifying

a join view, 15-4

monitoring

datafiles, 10-13

locks, 4-8

performance tables, 4-9

processes of an instance, 4-8

rollback segments, 21-6

tablespaces, 10-13

mounting a database, 3-4

exclusive mode, 3-6

parallel mode, 3-6

MOVE PARTITION clause

ALTER TABLE command, 13-11

moving

control files, 5-5

index partitions, 13-11

relocating, 10-9

table partition, 13-10

MTS_DISPATCHERS parameter

setting initially, 4-5

multiplexing

archived redo logs, 7-11

redo log files, 6-5

groups, 6-6

multi-threaded server

configuring dispatchers, 4-5

database startup and, 3-2

dedicated server contrasted with, 4-3

enabling and disabling, 4-6

OS role management restrictions, 24-19

restrictions on OS role authorization, 24-7

starting, 4-4

named user limits, 23-5

setting initially, 2-13

Net8

service names in, 7-15

transmitting archived logs via, 7-15

network protocol

dispatcher for each, 4-5

NEXT storage parameter, 12-8

setting for the data dictionary, 20-27

NOARCHIVELOG mode

taking datafiles offline in, 10-8

NOAUDIT command

disabling audit options, 25-11

privileges, 25-12

schema objects, 25-12

statements, 25-12

normal transmission mode

definition, 7-15

NOT NULL constraint, 20-19

NUMBER datatype, 12-17

objects, schema

cascading effects on revoking, 24-14

default tablespace for, 23-13

granting privileges, 24-10

in a revoked tablespace, 23-14

owned by dropped users, 23-16

privileges with, 24-3

revoking privileges, 24-12

offline rollback segments

about, 21-10

bringing online, 21-11

when to use, 21-10

offline tablespaces

altering, 9-10

priorities, 9-10

rollback segments and, 21-10

online index, 16-7

online redo log, 6-2

online rollback segments

about, 21-10

bringing rollback segments online, 21-11

taking offline, 21-12

when new, 21-8

online tablespaces

altering, 9-10

opening a database

after creation, 1-19

mounted database, 3-7

operating system

accounts, 24-17

auditing with, 25-2

authentication, 24-16

database administrators requirements for, 1-4

deleting datafiles, 9-15

enabling and disabling roles, 24-19

limit of number of open files, 10-2

Oracle8i process names, 4-9

renaming and relocating files, 10-9

role identification, 24-17

roles and, 24-16

security in, 22-3

OPTIMAL storage parameter, 21-5

Oracle blocks, 2-11

Oracle8i

installing, 1-18

Oracle8i Server

complying with license agreement, 23-2

identifying releases, 1-21

processes

checkpoint (CKPT), 4-12

monitoring, 4-8

operating-system names, 4-9

trace files fpr, 4-10

Oracle8i Server processes

processes

dedicated server processes, 4-2

identifying and managing, 4-7

ORAPWD utility, 1-9

OS authentication, 1-7

OS_ROLES parameter

operating-system authorization and, 24-7

REMOTE_OS_ROLES and, 24-19

using, 24-17

owner of a queued job, 8-7

packages

DBMS_LOGMNR_D.BUILD, 7-28

DBMS_LOGMNR.ADD_LOGFILE, 7-29

DBMS_LOGMNR.START_LOGMNR, 7-30

privileges for recompiling, 20-25

recompiling, 20-25

parallel mode

of the database, 3-6

parallel query option

number of server processes, 4-13

parallelizing index creation, 16-5

parallelizing table creation, 14-4

query servers, 4-13

Parallel Server

ALTER CLUSTER..ALLOCATE EXTENT, 17-10

datafile upper bound for instances, 10-3

licensed session limit and, 2-13

limits on named users and, 23-5

named users and, 2-13

own rollback segments, 21-3

sequence numbers and, 15-10

session and warning limits, 23-4

specifying thread for archiving, 7-11

threads of online redo log, 6-2

V$THREAD view, 6-18

PARALLEL_MAX_SERVERS parameter, 4-13

PARALLEL_MIN_SERVERS parameter, 4-13

PARALLEL_SERVER_IDLE_TIME parameter, 4-13

parameter files

character set of, 3-14

creating for database creation, 2-4

editing before database creation, 2-5

individual parameter names, 2-9

partition

adding to index, 13-12

dropping from index, 13-14

PARTITION clause

CREATE TABLE command, 13-9

partitioned index

rebuilding partitions, 13-20

partitioned objects, 13-1 to 13-21

adding, 13-11

creating, 13-9

definition, 13-2

maintaining, 13-9 to 13-21

merging, 13-18

moving, 13-10

quiescing applications during maintenance of, 13-21

splitting partition, 13-17

truncating, 13-15

partitioned table

adding partitions, 13-11

converting to non-partitioned, 13-18

splitting partition, 13-17

partitioned view

converting to partitioned table, 13-18

passwords

authentication file for, 1-9

changing for roles, 24-8

initial for SYS and SYSTEM, 1-5

password file, 1-12

creating, 1-9

OS authentication, 1-7

relocating, 1-16

removing, 1-16

state of, 1-16

privileges for changing for roles, 24-6

privileges to alter, 23-15

roles, 24-7

security policy for users, 22-4

setting REMOTE_LOGIN_PASSWORD parameter, 1-11

user authentication, 23-8

patch release number, 1-22

PCTFREE storage parameter

altering, 14-10

block overhead and, 12-6

clustered tables, 12-4

default, 12-3

guidelines for setting, 12-3

how it works, 12-2

indexes, 12-4

non-clustered tables, 12-4

PCTUSED and, 12-6

PCTINCREASE storage parameter

about, 12-8

altering, 12-11

setting for the data dictionary, 20-27

PCTUSED storage parameter

altering, 14-10

block overhead and, 12-6

default, 12-5

guidelines for setting, 12-5

how it works, 12-4

PCTFREE and, 12-6

pending area, 11-5

performance

location of datafiles and, 10-4

tuning archiving, 7-20

performance tables

dynamic performance tables, 4-9

physical structure of a database, 1-19

PL/SQL program units