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

audit options, 25-11, 25-12

disabling

archiving, 7-7, 7-9

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

reporting exceptions, 20-21

enabling

archiving, 7-7

auditing options

about, 25-9

privileges for, 25-13

integrity constraints

at creation, 20-18

example, 20-19

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

shortcuts for object privileges, 24-3

granting privileges and roles

listing grants, 24-19

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

temporary segments and, 16-3

tablespace for, 16-4

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

and creating a database, 2-3

installation

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

key-preserved tables in, 15-5

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

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

changing while database runs, 23-6

LICENSE_MAX_USERS parameter

setting, 23-6

LICENSE_SESSION_WARNING parameter

changing while instance runs, 23-4

LICENSE_SESSIONS_WARNING parameter

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

MAX_DUMP_FILE_SIZE parameter, 4-11

roles, 24-4

rollback segments, 21-1

manual archiving

in ARCHIVELOG mode, 7-10

marked user session, 4-17

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

database administrators requirements for, 1-4

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

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

precedence of storage parameters, 12-11

replaced views and, 15-9

planning

database creation, 2-2

relational design, 1-19

the database, 1-18

predefined roles, 1-6

prerequisites

for creating a database, 2-3

PRIMARY KEY constraint

disabling, 20-19

dropping associated indexes, 16-15

enabling, 20-19

enabling on creation, 16-8

foreign key references when dropped, 20-20

indexes associated with, 16-8

storage of associated indexes, 16-8

private

rollback segments, 21-8

adding datafiles to a tablespace, 10-5

synonyms, 15-11

privileges, 24-2, 24-3

adding redo log groups, 6-11

altering

default storage parameters, 9-8

dispatcher privileges, 4-7

indexes, 16-13

named user limit, 23-6

passwords, 23-16

role authentication, 24-6

rollback segments, 21-9

sequences, 15-10

tables, 14-10

users, 23-15

analyzing objects, 20-3

application developers and, 22-9

audit object, 25-11

auditing system, 25-10

auditing use of, 25-9

bringing datafiles offline and online, 10-8

bringing tablespaces online, 9-10

cascading revokes, 24-14

cluster creation, 17-6

coalescing tablespaces, 9-9

column, 24-11

CREATE SCHEMA command, 20-2

creating

roles, 24-4

rollback segments, 21-7

database administrator, 1-4

disabling automatic archiving, 7-9

dropping

clusters, 17-10

indexes, 16-15

online redo log members, 6-15

redo log groups, 6-14

roles, 24-9

rollback segments, 21-14

dropping profiles, 23-21

enabling and disabling resource limits, 23-21

enabling and disabling triggers, 20-12

enabling automatic archiving, 7-8

for changing session limits, 23-5

forcing a log switch, 6-16

granting

about, 24-9

object privileges, 24-10

required privileges, 24-10

system privileges, 24-9

grouping with roles, 24-4

individual privilege names, 24-2

job queues and, 8-4

listing grants, 24-20

manually archiving, 7-10

object, 24-3

on selected columns, 24-13

operating system

required for database administrator, 1-4

policies for managing, 22-5

recompiling packages, 20-25

recompiling procedures, 20-25

recompiling views, 20-25

renaming

datafiles of a tablespace, 10-9

datafiles of several tablespaces, 10-10

objects, 20-2

redo log members, 6-12

replacing views, 15-8

RESTRICTED SESSION system privilege, 3-4, 3-8

revoking, 24-12

ADMIN OPTION, 24-12

GRANT OPTION, 24-13

object privileges, 24-14

system privileges, 24-12

revoking object, 24-12

revoking object privileges, 24-12

setting resource costs, 23-20

system, 24-2

taking tablespaces offline, 9-10

truncating, 20-10

procedures

recompiling, 20-25

processes, 4-1

SNP background processes, 8-2

PROCESSES parameter

disabling resource limits, 23-21

altering, 23-19

assigning to users, 23-18

composite limit, 23-19

creating, 23-18

default, 23-18

dropping, 23-21

enabling resource limits, 23-21

listing, 23-22

managing, 23-17

privileges for dropping, 23-21

privileges to alter, 23-19

privileges to set resource costs, 23-20

PUBLIC_DEFAULT, 23-18

setting a limit to null, 23-19

viewing, 23-24

program global area (PGA)

effect of MAX_ENABLED_ROLES on, 24-8

public

synonyms, 15-11

public rollback segments

making available for use, 21-10

granting and revoking privileges to, 24-15

PUBLIC user group

procedures and, 24-15

PUBLIC_DEFAULT profile

dropping profiles and, 23-21

using, 23-18

query server process

about, 4-13

quotas

listing, 23-22

revoking from users, 23-14

setting to zero, 23-14

tablespace, 23-13

tablespace quotas, 9-3

temporary segments and, 23-14

unlimited, 23-14

viewing, 23-24

read-only database open, 3-8

read-only tablespaces

altering to writable, 9-14

creating, 9-12

datafiles, 10-8

on a WORM device, 9-14

REBUILD PARTITION clause

ALTER INDEX command, 13-11, 13-20

rebuild_freelists procedure, 19-6, 19-10

recompiling

recovery

creating new control files, 5-5

startup with automatic, 3-5

redo entries

content of, 6-2

See redo records

redo log buffers

writing of, 6-2

redo log files

active (current), 6-4

archived

advantages of, 7-2

contents of, 7-2

log switches and, 6-5

archived redo log files, 7-7

archived redo logs, 7-4

available for use, 6-3

creating

groups and members, 6-11

creating members, 6-11

distributed transaction information in, 6-3

groups, 6-6

creating, 6-11

decreasing number, 6-10

dropping, 6-14

LOG_FILES initialization parameter, 6-10

members, 6-6

threads, 6-2

how many in redo log, 6-9

inactive, 6-4

legal and illegal configurations, 6-7

LGWR and the, 6-3

log sequence numbers of, 6-5

maximum number of, 6-10

mirrored

log switches and, 6-7

multiplexed

diagrammed, 6-6

if all inaccessible, 6-7

multiplexing, 6-5

groups, 6-6

if some members inaccessible, 6-7

online, 6-2

recovery use of, 6-2

requirement of two, 6-3

threads of, 6-2

online redo log, 6-1

planning the, 6-5 to 6-10

privileges

adding groups and members, 6-11

redo entries, 6-2

requirements, 6-7

verifying blocks, 6-16

viewing, 2-8

redo records, 6-2

REFERENCES privilege

CASCADE CONSTRAINTS option, 24-13

dropping table partition with, 13-13

referential integrity constraints

truncating table partition with, 13-16

relational design

planning, 1-19

releases

checking the release number, 1-22

identifying for Oracle8i, 1-21

maintenance release number, 1-21

patch release number, 1-22

port-specific release number, 1-22

versions of other Oracle software, 1-22

relocating

control files, 5-5

datafiles, 10-9, 10-10

remote connections, 1-16

connecting as SYSOPER/SYSDBA, 1-14

password files, 1-9

REMOTE_LOGIN_PASSWORDFILE parameter, 1-11

REMOTE_OS_AUTHENT parameter

setting, 23-10

REMOTE_OS_ROLES parameter

setting, 24-8, 24-19

RENAME command, 20-2

renaming

control files, 5-5

datafiles, 10-9, 10-10

datafiles with a single table, 10-9

online redo log members, 6-12

schema objects, 20-2

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, 7-19

replacing

views, 15-8

resource allocation methods, 11-2

resource consumer groups, 11-2

resource limits

altering in profiles, 23-19

assigning with profiles, 23-18

composite limits and, 23-19

costs and, 23-20

creating profiles and, 23-18

disabling, 23-21

enabling, 23-21

privileges to enable and disable, 23-21

privileges to set costs, 23-20

PUBLIC_DEFAULT profile and, 23-18

service units, 23-19

setting to null, 23-19

resource plan directives, 11-2

resource plans, 11-2

RESOURCE role, 24-5

RESOURCE_LIMIT parameter

enabling and disabling limits, 23-21

resources

of a database administrator, 1-2

responsibilities

of database users, 1-3

RESTRICTED SESSION privilege

instances in restricted mode, 3-8

restricted mode and, 3-4

session limits and, 23-3

restricting access to database

starting an instance, 3-4

REVOKE command, 24-12

when takes effect, 24-15

revoking

privileges and roles

SYSOPER/DBA privileges, 1-13

revoking privileges and roles

on selected columns, 24-13

REVOKE command, 24-12

shortcuts for object privileges, 24-3

when using operating-system roles, 24-18

roles

ADMIN OPTION and, 24-10

application developers and, 22-10

authorization, 24-6

backward compatibility, 24-5

changing authorization for, 24-8

changing passwords, 24-8

CONNECT role, 24-5

database authorization, 24-7

DBA role, 1-6, 24-5

default, 23-16

dropping, 24-8

EXP_FULL_DATABASE, 24-5

GRANT command, 24-19

GRANT OPTION and, 24-11

granting

about, 24-9

grouping with roles, 24-4

IMP_FULL_DATABASE, 24-5

listing, 24-22

listing grants, 24-21

listing privileges and roles in, 24-23

management using the operating system, 24-16

managing, 24-4

multi-byte characters

in names, 24-5

multi-byte characters in passwords, 24-7

multi-threaded server and, 24-7

operating system granting of, 24-17, 24-19

operating-system authorization, 24-7

OS management and the multi-threaded server, 24-19

passwords for enabling, 24-7

predefined, 1-6, 24-5

privileges

changing authorization method, 24-6

changing passwords, 24-6

for creating, 24-4

for dropping, 24-9

granting system privileges or roles, 24-9

RESOURCE role, 24-5

REVOKE command, 24-19

revoking, 24-12

revoking ADMIN OPTION, 24-12

security and, 22-6

SET ROLE command, 24-19

unique names for, 24-4

without authorization, 24-8

rollback segments

acquiring automatically, 21-3, 21-11

acquiring on startup, 2-12

allocating, 2-14

altering public, 21-9

altering storage parameters, 21-9

AVAILABLE, 21-11

bringing

online, 21-11

online automatically, 21-11

online when new, 21-8

PARTLY AVAILABLE segment online, 21-11

checking if offline, 21-12

choosing how many, 2-14

choosing size for, 2-14

creating, 21-8

creating after database creation, 21-3

creating public and private, 21-3

decreasing size of, 21-10

deferred, 21-16

displaying

all deferred rollback segments, 21-16

deferred rollback segments, 21-16

information on, 21-14

PENDING OFFLINE segments, 21-15

displaying names of all, 21-15

dropping, 21-13

equally sized extents, 21-5

explicitly assigning transactions to, 21-13

guidelines for managing, 21-2

initial, 21-2

invalid status, 21-14

listing extents in, 20-32

location of, 21-7

making available for use, 21-10

managing, 21-1

monitoring, 21-6

OFFLINE, 21-11

offline rollback segments, 21-10

offline status, 21-12

online rollback segments, 21-10

online status, 21-12

PARTLY AVAILABLE, 21-11

PENDING OFFLINE, 21-12

privileges

for dropping, 21-14

required to alter, 21-9

required to create, 21-7

setting size of, 21-4

status for dropping, 21-13

status or state, 21-11

storage parameters, 21-8

storage parameters and, 21-8

taking tablespaces offline and, 9-12

transactions and, 21-13

using multiple, 21-2

ROLLBACK_SEGMENTS parameter

adding rollback segments to, 21-8

chaining across blocks, 12-4, 20-8

rows

violating integrity constraints, 20-15

schema objects

creating multiple objects, 20-2

default audit options, 25-11

dependencies between, 20-23

disabling audit options, 25-12

enabling audit options on, 25-11

listing by type, 20-31

listing information, 20-29

privileges to access, 24-3

privileges to rename, 20-2

renaming, 20-2, 20-3

SCN, 10-14

security

segments

data and index

default storage parameters, 12-10

data dictionary, 20-27

displaying information on, 20-32

monitoring, 21-15

rollback, 21-1

temporary storage parameters, 12-12

sensitivity

security, 22-3

SEQUENCE_CACHE_ENTRIES parameter, 15-11

sequences

altering, 15-10

creating, 15-10

dropping, 15-11

initialization parameters, 15-11

managing, 15-9

Parallel Server and, 15-10

privileges for altering, 15-10

privileges for creating, 15-10

privileges for dropping, 15-11

server units

composite limits and, 23-19

servers

dedicated

multi-threaded contrasted with, 4-3

multi-threaded

dedicated contrasted with, 4-3

session limits, license

setting initially, 2-13

session monitor, 4-8

session, user

active, 4-16

inactive, 4-17

marked to be terminated, 4-17

terminating, 4-15

viewing terminated sessions, 4-17

sessions

auditing connections and disconnections, 25-8

limits per instance, 23-2

listing privilege domain of, 24-22

number of concurrent sessions, 2-13

Parallel Server session limits, 2-13

setting maximum for instance, 23-4

setting warning limit for instance, 23-4

viewing current number and high water mark, 23-6

viewing memory use, 23-25

SET ROLE command

how password is set, 24-7

when using operating-system roles, 24-19

SET TRANSACTION command

USE ROLLBACK SEGMENT option, 21-13

setting archive buffer parameters, 7-22

SGA

determing buffers in cache, 2-11

shared mode

rollback segments and, 21-3

shared pool

ANALYZE command and, 20-8

shared server processes

changing the minimum number of, 4-6

privileges to change number of, 4-6

trace files for, 4-10

shared SQL areas

ANALYZE command and, 20-8

shortcuts

CONNECT, for auditing, 25-8

object auditing, 25-9

object privileges, 24-3

statement level auditing options, 25-8

Shut Down menu

Abort Instance option, 3-12

Immediate option, 3-11

SHUTDOWN command

ABORT option, 3-12

IMMEDIATE option, 3-11

NORMAL option, 3-11

shutting down a database, 3-1

shutting down an instance

aborting the instance, 3-12

connecting and, 3-9

connecting as INTERNAL, 3-10

size

rollback segments, 21-4

skip_corrupt_blocks procedure, 19-5, 19-11

snapshot logs

snapshots

OPTIMAL storage parameter and, 21-5

too old

SNP background processes

about, 8-2

software versions, 1-21

SORT_AREA_SIZE parameter

index creation and, 16-3

space

adding to the database, 9-4

used by indexes, 16-14

space management

PCTFREE, 12-2

PCTUSED, 12-4

specifying destinations

for archived redo logs, 7-11

specifying multiple ARCH processes, 7-20

SPLIT PARTITION clause, 13-18

ALTER INDEX command, 13-18

ALTER TABLE command, 13-11, 13-17

SQL statements

disabling audit options, 25-12

enabling audit options on, 25-10

SQL trace facility

when to enable, 4-12

SQL*Loader

about, 1-17

indexes and, 16-3

SQL*Plus commands

See commands, SQL*Plus

SQL_TRACE parameter

trace files and, 4-10

STALE status

of redo log members, 6-15

standby transmission mode

definition of, 7-15

Net8 and, 7-15

RFS processes and, 7-15

Start Up Instance dialog box, 3-2

starting a database

about, 3-1

general procedures, 3-2

starting an instance

STARTUP command, 3-2

FORCE option, 3-5

MOUNT option, 3-4

NOMOUNT option, 2-6, 3-3

RECOVER option, 3-5

specifying database name, 3-3

statistics

updating, 20-4

Step, 1-18, 1-20

storage

altering tablespaces, 9-8

quotas and, 23-14

revoking tablespaces and, 23-14

unlimited quotas, 23-14

storage parameters

stored procedures

privileges for recompiling, 20-25

using privileges granted to PUBLIC, 24-15

stream

tape drive, 7-23

SWITCH LOGFILE option

ALTER SYSTEM command, 6-16

synonyms

creating, 15-12

displaying dependencies of, 20-32

privileges for creating, 15-12

dropping, 15-12

managing, 15-11

private, 15-11

privileges for dropping, 15-12

public, 15-11

SYS

initial password, 1-5

objects owned, 1-5

policies for protecting, 22-7

privileges, 1-5

user, 1-5

SYS.AUD$

audit trail, 25-2

creating and deleting, 25-4

SYSOPER/SYSDBA privileges

adding users to the password file, 1-12

connecting with, 1-14

determining who has privileges, 1-13

granting and revoking, 1-13

SYSTEM

initial password, 1-5

objects owned, 1-5

policies for protecting, 22-7

user, 1-5

System Change Number (SCN)

checking for a datafile, 10-14

system change number (SCN)

when determined, 6-2

System Global Area, 2-11

System Global Area (SGA), 2-11

system privileges, 24-2

SYSTEM rollback segment

altering storage parameters of, 21-9

SYSTEM tablespace

cannot drop, 9-15

initial rollback segment, 21-2

non-data dictionary tables and, 14-3

restrictions on taking offline, 10-7

when created, 9-4

table partition

containing global index, 13-12

tables

adding partitions, 13-11

allocating extents, 14-11

altering, 14-10, 14-11

analyzing statistics, 20-3

clustered tables

privileges to drop, 17-10

creating, 14-9

designing before creating, 14-2

dropping, 14-12

estimating size, 14-5

guidelines for managing, 14-1, 14-6

hash clustered

creating, 18-4

managing, 18-1

increasing column length, 14-10

indexes and, 16-2

key-preserved, 15-5

limiting indexes on, 16-3

location, 14-10

location of, 14-3

managing, 14-1

parallelizing creation of, 14-4

privileges for creation, 14-9

privileges for dropping, 14-12

privileges to alter, 14-10

schema of clustered, 17-7

separating from indexes, 14-6

specifying PCTFREE for, 12-4

specifying tablespace, 14-3, 14-10

SYSTEM tablespace and, 14-3

temporary space and, 14-6

transaction parameters, 14-3

truncating, 20-9

UNRECOVERABLE, 14-4

validating structure, 20-8

tablespace set, 9-20

tablespaces

adding datafiles, 10-5

altering availability, 9-10

altering storage settings, 9-8

assigning defaults for users, 23-12

assigning user quotas, 9-3

bringing online, 9-10

checking default storage parameters, 9-31

coalescing, 9-8

creating, 9-3

creating additional, 9-4

default quota, 23-13

default storage parameters for, 12-10

default temporary, 23-13

dropping

about, 9-14

required privileges, 9-15

guidelines for managing, 9-2

listing files of, 9-31

listing free space in, 9-32

location, 10-4

managing, 10-1

monitoring, 10-13

privileges for creating, 9-4

privileges to take offline, 9-10

quotas

assigning, 9-3

quotas for users, 23-13

read-only, 9-12

revoking from users, 23-14

rollback segments required, 9-5

setting default storage parameters for, 9-3

SYSTEM tablespace, 9-4

taking offline normal, 9-10

taking offline temporarily, 9-11

temporary, 23-13

unlimited quotas, 23-14

using multiple, 9-2

viewing quotas, 23-24

writable, 9-14

taking offline

tablespaces, 9-10

tape drives

streaming for archiving, 7-23

temporary segments

index creation and, 16-3

temporary space

allocating, 14-6

terminating

a user session, 4-15

terminating sessions

active sessions, 4-16

identifying sessions, 4-16

inactive session, example, 4-17

inactive sessions, 4-17

test

security for databases, 22-9

threads

online redo log, 6-2

time window

moving, in historical table, 13-20

tip

object privilege shortcut, 24-3

shortcuts for auditing objects, 25-9

statement auditing shortcut, 25-8

TNSNAMES.ORA file, 7-12

To, 10-5, 21-12

trace files

job failures and, 8-10

location of, 4-11

log writer, 4-11

log writer process and, 6-6

size of, 4-11

using, 4-10, 4-11

when written, 4-12

transaction entries

guidelines for storage, 12-9

transactions

assigning to specific rollback segment, 21-13

committing

writing redo log buffers and, 6-2

rollback segments and, 21-13

TRANSACTIONS parameter

using, 21-2

TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter

using, 21-2

transmitting archived redo logs, 7-14

in normal transmission mode, 7-14

in standby transmission mode, 7-14

transportable tablespaces, 9-18

triggers

auditing, 25-20

disabling, 20-12

privileges for enabling and disabling, 20-12

enabling, 20-12

examples, 25-20

TRUNCATE command, 20-9

DROP STORAGE option, 20-11

REUSE STORAGE option, 20-11

TRUNCATE PARTITION clause

ALTER TABLE command, 13-15

truncating

clusters, 20-9

partitioned objects, 13-15

privileges for, 20-10

tuning

UNIQUE key constraints

disabling, 20-19

dropping associated indexes, 16-15

enabling, 20-19

enabling on creation, 16-8

foreign key references when dropped, 20-20

indexes associated with, 16-8

storage of associated indexes, 16-8

UNLIMITED TABLESPACE privilege, 23-14

unrecoverable

tables, 14-4

UNRECOVERABLE DATAFILE option

ALTER DATABASE command, 6-17

unrecoverable indexes

indexes, 16-5

UPDATE privilege

USER_DUMP_DEST parameter, 4-11

Use, 10-10, 23-10

USER_EXTENTS, 10-13

USER_FREE, 9-31, 10-13

USER_INDEXES view

USER_SEGMENTS, 9-31, 10-13

USER_TAB_COLUMNS view

USER_TABLES view

USER_TABLESPACES, 9-31, 10-13

usernames

SYS and SYSTEM, 1-5

users

altering, 23-15

assigning profiles to, 23-18

assigning tablespace quotas, 9-3

assigning unlimited quotas for, 23-14

auhentication

database authentication, 23-8

authentication

about, 22-2, 23-7

changing default roles, 23-16

composite limits and, 23-19

default tablespaces, 23-12

dropping, 23-16

dropping profiles and, 23-21

dropping roles and, 24-8

end-user security policies, 22-5

enrolling, 1-20

identification, 23-7

in a newly created database, 2-14

limiting number of, 2-13

listing, 23-22

listing privileges granted to, 24-20

listing roles granted to, 24-21

managing, 23-11

multi-byte characters

in passwords, 23-12

objects after dropping, 23-16

password security, 22-4

policies for managing privileges, 22-5

privileges for changing passwords, 23-15

privileges for creating, 23-11

privileges for dropping, 23-17

PUBLIC group, 24-15

security and, 22-2

security for general users, 22-4

session, terminating, 4-17

specifying user names, 23-12

tablespace quotas, 23-13

unique user names, 2-13, 23-5

viewing information on, 23-23

viewing memory use, 23-25

viewing tablespace quotas, 23-24

utilities

Export, 1-17

for the database administrator, 1-17

Import, 1-17

SQL*Loader, 1-17

UTLCHAIN.SQL, 20-8

UTLLOCKT.SQL script, 4-8

V$ARCHIVE view, 7-23

V$ARCHIVE_DEST view

obtaining destination status, 7-14

V$DATABASE view, 7-24

V$DATAFILE, 9-31, 10-13

V$DBFILE view, 2-8

V$DISPATCHER view

controlling dispatcher process load, 4-7

V$LICENSE view, 23-6

V$LOG view, 7-23

displaying archiving status, 7-23

online redo log, 6-18

viewing redo data with, 6-18

V$LOGFILE view, 2-8

logfile status, 6-15

viewing redo data with, 6-18

V$LOGMNR_CONTENTS view, 7-31

using to analyze archived redo logs, 7-25

V$PWFILE_USERS view, 1-13

V$QUEUE view

controlling dispatcher process load, 4-7

V$ROLLNAME

finding PENDING OFFLINE segments, 21-15

V$ROLLSTAT

finding PENDING OFFLINE segments, 21-15

V$SESSION, 8-14

V$SESSION view, 4-17

V$THREAD view, 6-18

viewing redo data with, 6-18

valid destination state