Oracle7 Server Administrator's Guide
Library
Product
Contents
Index
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
Y
Z
@
A
abort, shutting down an instance
access
database
database administrator account
granting privileges
restricting
revoking privileges
data
system privileges
object
privilege types
revoking privileges
accounts
operating-system
role identification
user
active extents
Add Datafiles to Tablespace dialog
Add Online Redo Log Group dialog box
Add Online Redo Log Member dialog
ADMIN OPTION
about
revoking
AFTER triggers, auditing and
ALERT file
about
location of
session high water mark in
size of
using
when written
ALL_INDEXES view, filling with data
ALL_TAB_COLUMNS view, filling with data
ALL_TABLES view, filling with data
allocation
extents
extents for clusters
minimizing extents for rollback segments
multi-threaded server and
temporary space
alphanumeric datatypes
ALTER CLUSTER command
ALLOCATE EXTENT option
MAXTRANS option
using for hash clusters
using for index clusters
ALTER DATABASE command
ADD LOG MEMBER option
ADD LOGFILE option
ARCHIVELOG option
BACKUP CONTROLFILE TO TRACE option
CREATE DATAFILE option
database partially available to users
DATAFILE...OFFLINE DROP option
DROP LOGFILE MEMBER option
DROP LOGFILE option
MOUNT option
NOARCHIVELOG option
NORESETLOGS option
[
2
] [
3
]
OPEN NORESETLOGS option
OPEN option
RENAME FILE option
RESETLOGS option
[
2
] [
3
]
ALTER FUNCTION command, COMPILE option
ALTER INDEX command
about
MAXTRANS option
ALTER PACKAGE command, COMPILE option
ALTER PROCEDURE command, COMPILE option
ALTER PROFILE command
altering resource limits
COMPOSITE_LIMIT option
Alter Profile dialog
ALTER RESOURCE COST command
ALTER ROLE command, changing authorization method
Alter Role dialog
ALTER ROLLBACK SEGMENT command
changing storage parameters
OFFLINE option
ONLINE option
[
2
]
PUBLIC option
STORAGE clause
Alter Rollback Segment Storage dialog
ALTER SEQUENCE command
ALTER SESSION command, SET SQL_TRACE parameter
ALTER SYSTEM command
ARCHIVE LOG ALL option
ARCHIVE LOG START option
ARCHIVE LOG START option, specifying destination
ARCHIVE LOG STOP option
CHECKPOINT option
ENABLE RESTRICTED SESSION option
SET LICENSE_MAX_SESSIONS option
SET LICENSE_MAX_USERS option
SET LICENSE_SESSIONS_WARNING option
SET MTS_DISPATCHERS option
SET MTS_SERVERS option
SET RESOURCE_LIMIT option
SWITCH LOGFILE option
ALTER TABLE command
ALLOCATE EXTENT option
DISABLE ALL TRIGGERS option
DISABLE integrity constraint option
DROP integrity constraint option
ENABLE ALL TRIGGERS option
ENABLE integrity constraint option
example
MAXTRANS option
ALTER TABLESPACE command
ADD DATAFILE parameter
BEGIN BACKUP option
minimizing time between begin and end
DEFAULT STORAGE option
END BACKUP option
minimizing time between begin and end
OFFLINE option
ONLINE option
example
READ ONLY option
READ WRITE option
RENAME DATA FILE option
ALTER TRIGGER command
DISABLE option
ENABLE option
ALTER USER command, changing passwords with
Alter User dialog
ALTER USER privilege
ALTER VIEW command, COMPILE option
altering
cluster indexes
clustered tables
clusters
database status
hash clusters
indexes
passwords
public rollback segments
rollback segment storage parameters
sequences
storage parameters
tables
[
2
]
tablespace storage
users
ANALYZE command
CASCADE option
COMPUTE STATISTICS option
ESTIMATE STATISTICS SAMPLE option
LIST CHAINED ROWS option
number of cluster keys
shared SQL and
STATISTICS option
VALIDATE STRUCTURE option
analyzing objects
about
privileges
application administrator
database administrator versus
application developers
privileges for
roles for
application development, security for
ARCHIVE LOG command, LIST parameter
archived redo log, applying during recovery
[
2
]
archiving modes
automatic archiving
automatic, disabling archiving
default filename format
deleting after recovery
enabling automatic archiving
errors during recovery
filename format
listing status
location during recovery
loss of
preserving or resetting log sequence number
[
2
] [
3
]
restoring to disk
setting archive destination
specifying archive destination
ARCHIVELOG mode
archiving
datafile loss in
distributed database backups
enabling
setting at database creation
strategies for backups in
taking datafiles offline and online in
archiving
advantages
automatic
disabling after setup
disabling at startup
enabling
changing mode
default file name format
disadvantages
enabling and disabling
enabling automatic
increasing speed of
manually
minimizing impact on system performance
privileges
enabling
for manually archiving
to view status
specifying destination
tuning
viewing information on
AUDIT command
schema objects
statement auditing
system privileges
audit trail
archiving
auditing changes to
controlling size of
creating and deleting
deleting views
interpreting
maximum size of
protecting integrity of
purging records from
recording changes to
records in
reducing size of
table that holds
views on
AUDIT_TRAIL parameter, setting
auditing
AUDIT command
audit option levels
audit trail records
default options
disabling default options
disabling options
[
2
] [
3
]
disabling options versus auditing
enabling options
[
2
]
enabling options versus auditing
guidelines
historical information
keeping information manageable
managing the audit trail
operating-system audit trails
policies for
privilege audit options
privileges required for object
privileges required for system
schema object types
schema objects
session level
shortcuts for object
shortcuts for system
statement
statement level
suspicious activity
system privileges
triggers and
[
2
]
using the database
viewing
active privilege options
active statement options
defauly object options
views
authentication
changing
database managed
multi-threaded server and
operating system
operating-system managed
password file
password policy
specifying when creating a user
users
[
2
] [
3
]
authorization
changing for roles
omitting for roles
operating-system role management and
roles
multi-threaded server and
automatic archiving, archive log destination
B
background processes, Oracle7 processes
BACKGROUND_DUMP_DEST parameter
backups
after creating new databases
guidelines
after structural changes to database
ARCHIVELOG mode in
before database creation
checking datafile backup status
control files
creating a strategy
DB_VERIFY
[
2
]
DB_VERIFY utility
distributed databases
effects of archiving on
Export utility and
frequency of
full backups
guidelines for
keeping
listing files needed
marking end
NOARCHIVELOG mode in
often-used tablespaces
partial backups
planning before database creation
privileges for control files
procedures for
offline datafiles
offline tablespaces
online datafiles
online tablespaces
read-only tablespaces
restoring a full backup
tablespaces
test strategies
Begin Manual Archive dialog box
Begin Online Tablespace Backup dialog
branch blocks, space required
bringing online, tablespaces
broken jobs
about
marking
running
buffers, buffer cache in SGA
bug fixes
C
CASCADE option
integrity constraints
when dropping unique or primary keys
cascading revokes
CATAUDIT.SQL, running
CATBLOCK.SQL script
CATNOAUD.SQL, running
change-based recovery, procedure for
CHAR datatype
increasing column length
space use of
[
2
]
character sets
multi-byte characters
in role passwords
in user names
user passwords and
parameter file and
specifying when creating a database
supported by Oracle
CHECK constraint
checkpoint
checkpoint process (CKPT), starting
CHECKPOINT_PROCESS parameter, setting
checkpoints
controlling
fast checkpoint
forcing
log switches and
setting intervals
checksums
for data blocks
for redo blocks
CKPT
CLEAR LOGFILE clause
clearing log files
cluster keys
ANALYZE command and
columns for
SIZE parameter
clustered tables
clusters
allocating extents
altering
analyzing statistics
choosing data
columns for cluster key
creating
dropped tables and
dropping
estimating space
[
2
] [
3
]
guidelines for managing
hash clusters
hash
index creation
index
indexes and
keys
location
managing
overview of
privileges
for creating
for dropping
specifying PCTFREE for
storage parameters
truncating
validating structure
cold backups, full backups
columns
displaying information about
granting privileges for selected
granting privileges on
increasing length
INSERT privilege and
listing users granted to
privileges
revoking privileges on
complete recovery, procedures for
composite limits
costs and
service units
COMPUTE STATISTICS option
configuring an instance, with dedicated server processes
CONNECT audit option, shortcut for auditing
CONNECT role
connecting
administrator privileges
to a database as INTERNAL
connections
auditing
dedicated servers
during shutdown
control files
adding
backing up
[
2
]
changing size
conflicts with data dictionary
creating
additional control files
initially
new files
default name
[
2
]
dropping
during incomplete recovery
[
2
] [
3
]
errors during creation
finding filenames
guidelines for
importance of mirrored
location of
loss of
[
2
]
managing
mirroring
moving
names
number of
overwriting existing
privileges to backup
relocating
renaming
requirement of one
size of
specifying names before database creation
unavailable during startup
V$BACKUP view and
CONTROL_FILES parameter
overwriting existing control files
setting
[
2
]
names for
costs, resource limits and
CREATE CLUSTER command
example
for hash clusters
HASH IS option
HASHKEYS option
SIZE option
[
2
]
CREATE CONTROLFILE command
about
checking for inconsistencies
NORESETLOGS option
RESETLOGS option
CREATE DATABASE command
CONTROLFILE REUSE option
example
MAXDATAFILES option
MAXLOGFILES option
MAXLOGMEMBERS option
CREATE INDEX command
explicitly
ON CLUSTER option
temporary space required
UNRECOVERABLE
with a constraint
CREATE PROFILE command
about
COMPOSITE_LIMIT option
Create Profile dialog
CREATE ROLE command
IDENTIFIED BY option
IDENTIFIED EXTERNALLY option
CREATE ROLLBACK SEGMENT command
about
tuning guidelines
Create Rollback Segment dialog
CREATE SCHEMA command
multiple tables and views
privileges required
CREATE SEQUENCE command
CREATE SYNONYM command
CREATE TABLE command
about
CLUSTER option
UNRECOVERABLE
CREATE TABLESPACE command
datafile names in
example
Create Tablespace dialog
CREATE USER command
IDENTIFIED BY option
IDENTIFIED EXTERNALLY option
CREATE VIEW command
about
OR REPLACE option
WITH CHECK OPTION
creating
audit trail
cluster index
clustered tables
clusters
control files
database
[
2
]
archiving mode
backing up the new database
during installation
executing CREATE DATABASE
maximum number of datafiles
migration from different versions
preparing to
prerequisites for
problems encountered while
steps
datafiles
[
2
]
hash clustered tables
hash clusters
indexes
multiple objects
online redo log groups
parameter file
profiles
redo log members
rollback segments
specifying storage parameters
sequences
synonyms
tables
tablespaces
rollback segments required
views
D
data blocks
altering size of
managing space usage of
managing space use of
operating system blocks versus
PCTFREE storage parameter
PCTUSED storage parameter
shared in clusters
size of
verifying
data dictionary
changing storage parameters
conflicts with control files
dropped tables and
schema object views
segments in the
setting storage parameters of
V$DBFILE view
V$DISPATCHER view
V$LOGFILE view
V$QUEUE view
data integrity
integrity constraints
database administrator
application administrator versus
initial priorities
operating-system account
password files for
responsibilities of
roles
for security
security and privileges of
security for
security officer versus
[
2
]
usernames
utilities for
database links
job queues and
privileges for controlling
databases
administering
auditing
availability
backing up
full backups
checking the default instance
control files of
CREATE DATABASE command
creating
opening and
steps for
trouble-shooting problems
design of
dropping
exclusive mode
global database name
global database names
hardware evaluation
logical structure of
managing
migration of
mounting a database
mounting to an instance
names
conflicts in
name
opening
parallel mode
physical structure of
planning
production
[
2
]
renaming
restricting access to
[
2
]
shutting down
specifying control files
starting up
general procedures for
parameter filenames
restricting access
structure of
test
tuning
responsibilities for
user responsibilities
viewing datafiles and redo log files
datafiles
adding to a tablespace
backing up offline
backing up online
bringing online and offline
checking associated tablespaces
creating
database administrator's access to
default directory
dropping
NOARCHIVELOG mode
FILEXT$
fully specifying filenames
identifying filenames
location
loss of
managing
maximum number of
[
2
]
minimum number of
MISSING
monitoring
offline
online
privileges to rename
privileges to take offline
recovering without a backup
recovery creation
relocating
[
2
]
relocating, example
renaming
[
2
]
renaming for single tables
reusing
size of
storing separately from redo log files
unavailable when database is opened
verifying data blocks
viewing
files needing recovery
general status of
V$DBFILE and V$LOGFILE views
data, security of
datatypes
character
DATE
individual type names
LONG
LONG RAW
MLSLABEL
NUMBER
RAW
ROWID
space use of
summarized
DATE datatype
DB_BLOCK_BUFFERS parameter, setting before database creation
DB_BLOCK_CHECKSUM
DB_BLOCK_SIZE parameter
database buffer cache size and
setting before creation
DB_DOMAIN parameter, setting before database creation
[
2
]
DB_FILES parameter
default
optional use of
DB_NAME parameter
MTS_SERVICE and
setting before database creation
DBA
DBA audit option shortcuts
DBA role
[
2
]
DBA_DATA_FILES
[
2
]
DBA_EXTENTS
DBA_FREE_SPACE
[
2
]
DBA_FREE_SPACE_COALESCED view
DBA_INDEXES view, filling with data
DBA_ROLLBACK_SEGS view
[
2
]
DBA_SEGMENTS
[
2
]
DBA_TAB_COLUMNS view, filling with data
DBA_TABLES view, filling with data
DBA_TABLESPACES
[
2
]
DBA_TABLESPACES view
DBA_TS_QUOTAS
[
2
]
DBA_USERS
[
2
]
DBMS_JOB package
altering a job
forcing jobs to execute
job queues and
REMOVE procedure and
submitting jobs
DBMS_UTILITY.ANALYZE_SCHEMA(), running
dedicated server processes
configuring
connecting with
trace files for
dedicated servers, multi-threaded servers contrasted with
default
archive log filename format
audit options
disabling
profile
role
tablespace quota
temporary tablespace
user tablespaces
deleting, table statistics
dependencies, displaying
developers, application
disabling
archiving
audit options
[
2
]
auditing
automatic archiving
integrity constraints
effects on indexes
resource limits
triggers
disconnections, auditing
dispatcher processes
calculating maximum number of
number to start
privileges to change number of
removing
service name
setting the number of
spawning new
distributed databases
coordinated time-based recovery
media recovery and snapshots
recovery in
running in ARCHIVELOG mode
running in NOARCHIVELOG mode
starting a remote instance
taking backups
distributed processing, parameter file location in
distributing I/O
DROP CLUSTER command
CASCADE CONSTRAINTS option
dropping
hash cluster
INCLUDING TABLES option
DROP INDEX command
Drop Online Redo Log dialog
Drop Online Redo Log Member dialog box
DROP PROFILE command
Drop Profile dialog
DROP ROLE command
[
2
]
DROP ROLLBACK SEGMENT command
Drop Rollback Segment dialog
DROP SYNONYM command
DROP TABLE command
about
CASCADE CONSTRAINTS option
for clustered tables
DROP TABLESPACE command
Drop Tablespace dialog box
DROP USER command
Drop User dialog
DROP USER privilege
dropping
audit trail
cluster indexes
clusters
control files
databases
datafiles
hash clusters
indexes
integrity constraints
effects on indexes
online redo log groups
online redo log members
profiles
roles
rollback segments
[
2
]
sequences
synonyms
tables
tablespaces
required privileges
users
views
dynamic performance tables, using
E
enabling
archiving
auditing options
privileges for
integrity constraints
example
reporting exceptions
when violations exist
resource limits
triggers
encryption, Oracle passwords
End Online Tablespace Backup dialog
enroll, database users
environment of a job
errors
ALERT file and
during startup
ORA-00028
ORA-00114
ORA-01090
ORA-01173
ORA-01176
ORA-01177
ORA-1215
ORA-1216
ORA-1547
ORA-1628 through 1630
snapshot too old
trace files and
when creating a database
when creating control file
while starting an instance
ESTIMATE STATISTICS option
estimating size
hash clusters
indexes
tables
[
2
]
evaluating, hardware for the Oracle7 Server
example, creating constraints
examples, altering an index
exceptions, integrity constraints
exclusive mode
of the database
rollback segments and
terminating remaining user sessions
EXP_FULL_DATABASE role
Export utility
about
backups and
read consistency and
restricted mode and
using for backup
exporting jobs
extents
allocating
index creation
tables
data dictionary views for
displaying free extents
displaying information on
dropped tables and
F
failures
media (disk)
media failure
fast checkpoint
filenames, listing
files, OS limit on number open
FILEXT$
Force Checkpoint menu option
Force Log Switch menu option
FOREIGN KEY constraint, enabling
fragmentation, reducing
free space
coalescing
listing free extents
tablespaces and
full backups
restoring
functions, recompiling
G
global database name
GRANT command
ADMIN option
GRANT option
object privileges
SYSOPER/SYSDBA privileges
system privileges and roles
when takes effect
GRANT OPTION
about
revoking
granting privileges and roles
listing grants
shortcuts for object privileges
SYSOPER/SYSDBA privileges
group, redo log, online redo log, archived redo log
guidelines, for managing rollback segments
H
hardware, evaluating
hash clusters
altering
choosing key
clusters
controlling space use of
creating
dropping
estimating storage
example
managing
usage
high water mark, for a session
HOST, command in Server Manager
hot backups, partial backups
I
I/O, distributing
identification, users
IMP_FULL_DATABASE role
implementing database design
Import utility
about
procedure for using
restricted mode and
using for recovery
importing, jobs
in-doubt transactions, rollback segments and
incomplete recovery, procedures for
indexes
altering
analyzing statistics
cluster
creating
dropping
managing
correct tables and columns
creating
explicitly
unrecoverably
disabling and dropping constraints and
dropped tables and
dropping
estimating size
[
2
]
extent allocation for
guidelines for managing
INITRANS for
limiting per table
managing
[
2
]
MAXTRANS for
monitoring space use of
overview of
parallelizing index creation
PCTFREE for
PCTUSED for
privileges
for controling
for creating
for dropping
separating from a table
setting storage parameters for
SQL*Loader and
storage parameters
tablespace for
temporary segments and
temporary space and
validating structure
INITIAL storage parameter
altering
initialization parameters
affecting sequences
multi-threaded server and
initial, passwords for SYS and SYSTEM
INITRANS storage parameter
altering
default
guidelines for setting
transaction entries and
INSERT privilege
granting
revoking
installation
and creating a database
Oracle7 Server
tuning recommendations for
instance identifier
checking
process names and
instance menu
Open option
prevent Connections option
instances
aborting
default
shutting down immediately
starting
starting before database creation
integrity constraints, disabling
[
2
]
disabling on creation
dropping
dropping and disabling
dropping tablespaces and
enabling
enabling on creation
enabling when violations exist
exceptions to
managing
UTLEXCPT.SQL script
violations
when to disable
INTERNAL date function, executing jobs and
INTERNAL
alternatives to
connecting for shutdown
creating a database as
OSOPER and OSDBA
security for
starting an instance as
interrupting, media recovery
J
job queues
executing jobs in
locks
multiple SNP processes and
privileges for using
removing jobs from
scheduling jobs
starting up SNP processes
submitting new jobs
viewing
jobs
altering
broken
database links and
executing
exporting
forcing to execute
importing
INTERNAL date function and
job definition
job number
killing
managing
marking broken jobs
ownership of
removing from job queue
running broken jobs
scheduling
submitting to job queue
trace files
troubleshooting
join view
DELETE statements
key-preserved tables in
mergeable
modifying
when modifiable
JQ locks
K
key-preserved tables, in join views
keys, cluster
Kill User Session dialog
killing, jobs
L
LGWR
LICENSE_MAX_SESSIONS parameter
changing while instance runs
setting
setting before database creation
LICENSE_MAX_USERS parameter
changing while database runs
setting
setting before database creation
LICENSE_SESSION_WARNING parameter, setting before database creation
LICENSE_SESSIONS_WARNING parameter
changing while instance runs
setting
licensing, complying with license agreement
[
2
]
concurrent usage
named user
[
2
]
number of concurrent sessions
privileges for changing named user limits
privileges for changing session limits
session-based
viewing limits
limits
composite limits
concurrent usage
resource limits
session, high water mark
LIST CHAINED ROWS option
listener process
configuration file
setting MTS_LISTENER_ADDRESS
location, rollback segments
locks
job queue
monitoring
log sequence numbers
[
2
]
preserving after recovery
[
2
] [
3
]
requested during recovery
resetting to 1
[
2
] [
3
]
log switches
checkpoints and
forcing
privileges
log writer process (LGWR), trace file monitoring
LOG_ARCHIVE_BUFFER_SIZE parameter, setting
[
2
]
LOG_ARCHIVE_BUFFERS parameter, setting
[
2
]
LOG_ARCHIVE_DEST parameter, setting
LOG_ARCHIVE_FORMAT parameter, setting
LOG_ARCHIVE_START parameter
setting
[
2
]
LOG_CHECKPOINT_INTERVAL parameter, setting
LOG_CHECKPOINT_TIMEOUT parameter, setting
LOG_FILES parameter, number of log files and
logical structure of a database
LONG datatype
LONG RAW datatype
M
maintenance release number
managing
auditing
cluster indexes
clustered tables
clusters
indexes
[
2
]
jobs
object dependencies
profiles
roles
rollback segments
sequences
synonyms
tables
users
views
[
2
]
manual archiving, in ARCHIVELOG mode
marked user session
MAX_DUMP_FILE_SIZE parameter
MAX_ENABLED_ROLES parameter
default roles and
enabling roles and
MAXDATAFILES parameter
changing
optional use of
MAXEXTENTS storage parameter
about
setting for the data dictionary
MAXINSTANCES parameter, changing
MAXLOGFILES parameter
changing
number of log files and
MAXLOGHISTORY, changing
MAXLOGMEMBERS parameter
changing
number of log files and
MAXTRANS storage parameter
altering
default
guidelines for setting
transaction entries and
media failure (disk failure)
about
archived redo log file loss
control file loss
[
2
]
datafile loss
online redo log group loss
online redo log loss
media recovery
applying archived redo logs
at instance startup
cancel-based
change-based
complete recovery
completion of
[
2
] [
3
]
coordinated time-based distributed database
deciding which files need recovery
determining appropriate operation
distributed databases
errors with redo log files
guidelines and prerequisites
incomplete
interrupting
lost files
lost archived redo log files
lost control files
lost datafiles
lost online redo log files
lost mirrored control files
NOARCHIVELOG mode
[
2
]
open database-offline tablespace
performing
requirements of incomplete
[
2
] [
3
]
restoring
damaged files
full backups
to different devices
resuming
Server Manager and
snapshots and
starting
successfully applied redo logs
SYSTEM tablespace
[
2
] [
3
] [
4
]
testing
time-based
undamaged tablespaces online
[
2
]
memory, viewing per user
migration, database migration
MINEXTENTS storage parameter
about
altering
mirrored control files
importance of
loss of
mirrored redo log files
location of
size of
mirroring, control files
MLSLABEL datatype
modes
exclusive
parallel
restricted
[
2
]
modifiable join view, definition of
modifying, a join view
MONITOR command, ROLLBACK option
monitoring
datafiles
locks
performance tables
processes of an instance
rollback segments
[
2
]
tablespaces
mounting a database
exclusive mode
parallel mode
moving
control files
relocating
MTS_DISPATCHERS parameter, setting initially
MTS_LISTENER_ADDRESS parameter
setting
starting new dispatchers and
MTS_MAX_DISPATCHERS parameter
setting
MTS_MAX_SERVERS parameter, setting
MTS_SERVERS parameter
minimum value
setting
MTS_SERVICE parameter
DB_NAME parameter as default
setting
multi-plex online redo logs, symmetric groups
multi-plexing online redo log
multi-plexing
online redo log
redo log files
[
2
]
multi-threaded server
configuring dispatchers
database shutdown and
database startup and
dedicated server contrasted with
enabling and disabling
[
2
]
operating-system authentication restrictions
OS role management restrictions
restrictions on OS role authorization
service name
shared pool and
starting
N
name resolution
named user limits
setting initially
network protocol, dispatcher for each
NEXT storage parameter
setting for the data dictionary
NOARCHIVELOG mode
archiving
datafile loss
distributed database backups
partial backups and
setting at database creation
strategies for backups in
taking datafiles offline in
NOAUDIT command
disabling audit options
privileges
schema objects
statements
non-clustered tables, estimating size of
NORESET LOGS option, backing up control file
NOT NULL constraint
NUMBER datatype
O
objects, schema
cascading effects on revoking
default tablespace for
granting privileges
in a revoked tablespace
owned by dropped users
privileges with
revoking privileges
offline backups
offline datafiles
offline rollback segments
about
bringing online
when to use
offline tablespaces
altering
priorities
rollback segments and
online backups
online datafiles
online redo log
active group
applying during recovery
archived group
creating groups
creating members
current group
dropping groups
dropping members
forcing a log switch
guidelines for configuring
inactive group
location of
loss of
loss of all members
loss of group
loss of mirrored members
managing
moving files
multi-plexing
number of files
preserving or resetting log sequence number
[
2
] [
3
]
privileges
dropping groups
dropping members
forcing a log switch
renaming files
renaming members
STALE members
status of members
storing separately from datafiles
unavailable when database is opened
viewing filenames
viewing information about
online rollback segments
about
bringing rollback segments online
taking offline
when new
online tablespaces, altering
opening a database
after creation
mounted database
operating system
accounts
auditing with
authentication
database administrator's requirements for
deleting datafiles
enabling and disabling roles
limit of number of open files
Oracle7 process names
renaming and relocating files
role identification
role management
roles and
security in
OPS$ account, OS_AUTHENT_PREFIX parameter
OPTIMAL storage parameter
options of Oracle7 Server
Oracle blocks
Oracle Parallel Server
Oracle7 Server processes
processes
identifying and managing
Oracle7 Server
complying with license agreement
identifying releases
installing
options
processes
monitoring
operating-system names
service names for dispatchers
trace files fpr
ORAPWD utility
OS authentication
OS_AUTHENT_PREFIX parameter
operating-system authentication and
setting
OS_ROLES parameter
operating-system authorization and
REMOTE_OS_ROLES and
using
OSDBA, privileges included in
OSOPER, privileges included in
owner of a queued job
P
packages
privileges for recompiling
recompiling
parallel mode, of the database
parallel query option
number of server processes
parallelizing index creation
parallelizing table creation
query servers
Parallel Server
ALTER CLUSTER..ALLOCATE EXTENT
archive log file name format
datafile upper bound for instances
forcing a checkpoint for the local instance
licensed session limit and
limits on named users and
LOG_CHECKPOINT_TIMEOUT and
managing rollback segments
named users and
own rollback segments
sequence numbers and
session and warning limits
specifying thread for archiving
switching archiving modes
V$THREAD view
PARALLEL_MAX_SERVERS parameter
parallel recovery
PARALLEL_MIN_SERVERS parameter
PARALLEL_SERVER_IDLE_TIME parameter
parameter files
character set of
choosing for startup
creating for database creation
default for instance startup
editing
editing before database creation
individual parameter names
location of
minimum set of
number of
sample of
using
partial backups
passwords
altering user passwords
authentication file for
changing for roles
initial for SYS and SYSTEM
password file
creating
OS authentication
relocating
removing
state of
privileges for changing for roles
privileges to alter
roles
security policy for users
setting REMOTE_LOGIN_PASSWORD parameter
user authentication
patch release number
PCTFREE storage parameter
altering
block overhead and
clustered tables
default
guidelines for setting
how it works
indexes
non-clustered tables
PCTUSED and
PCTINCREASE storage parameter
about
altering
setting for the data dictionary
PCTUSED storage parameter
altering
block overhead and
default
guidelines for setting
how it works
PCTFREE and
performance tables, dynamic performance tables
performance
location of datafiles and
tuning archiving
physical structure of a database
PL/SQL program units
dropped tables and
replaced views and
planning
database creation
relational design
the database
precedence of storage parameters
predefined roles
prerequisites, for creating a database
PRIMARY KEY constraint
disabling
dropping associated indexes
enabling
enabling on creation
foreign key references when dropped
indexes associated with
storage of associated indexes
private
rollback segments
taking offline
synonyms
privileges
[
2
]
adding datafiles to a tablespace
adding redo log groups
altering
dispatcher privileges
indexes
named user limit
passwords
role authentication
rollback segments
sequences
tables
users
analyzing objects
application developers and
audit object
auditing system
auditing use of
backing up
bringing datafiles offline and online
bringing tablespaces online
cascading revokes
cluster creation
coalescing tablespaces
column
CREATE SCHEMA command
creating
roles
rollback segments
sequences
synonyms
tables
tablespaces
users
views
database administrator
disabling automatic archiving
dropping profiles
dropping
indexes
online redo log members
redo log groups
roles
rollback segments
sequences
synonyms
tables
views
enabling and disabling resource limits
enabling and disabling triggers
enabling automatic archiving
for changing session limits
forcing a checkpoint
forcing a log switch
granting
object privileges
required privileges
system privileges
grouping with roles
individual privilege names
job queues and
listing grants
manually archiving
object
on selected columns
operating system
policies for managing
recompiling packages
recompiling procedures
recompiling views
renaming
datafiles of several tablespaces
objects
redo log members
replacing views
RESTRICTED SESSION system privilege
[
2
]
revoking
revoking object
revoking object privileges
revoking
GRANT OPTION
object privileges
system privileges
setting resource costs
SQL statements permitted by
system
taking rollback segments online and offline
taking tablespaces offline
truncating
viewing archive status
procedures, recompiling
processes
PROCESSES parameter, setting before database creation
processes, SNP background processes
profiles
altering
assigning to users
composite limit
creating
default
disabling resource limits
dropping
enabling resource limits
listing
managing
privileges for dropping
privileges to alter
privileges to set resource costs
PUBLIC_DEFAULT
setting a limit to null
viewing
program global area (PGA), effect of MAX_ENABLED_ROLES on
pseudo-column
public rollback segments
making available for use
taking offline
PUBLIC user group
granting and revoking privileges to
procedures and
PUBLIC_DEFAULT profile
dropping profiles and
using
public, synonyms
Q
query server process, about
quotas
listing
revoking from users
setting to zero
tablespace
tablespace quotas
temporary segments and
unlimited
viewing
[
2
]
R
RAW datatype
about
VARCHAR2 and
read consistency, Export utility and
read-only tablespaces
altering to writable
backing up
creating
datafiles
on a WORM device
recovering
recompiling
automatically
functions
packages
procedures
views
Recover Closed Database dialog box
RECOVER command
DATABASE parameter
DATAFILE parameter
TABLESPACE parameter
Recover Offline Tablespaces dialog box
RECOVERY_PARALLELISM parameter
recovery
creating new control files
effects of archiving on
Import utility
media recovery
PARALLEL_MAX_SERVERS parameter
read-only tablespaces
setting parallelism
startup with automatic
redo log files
archived redo log files
log sequence numbers of
multi-plexing
online
viewing
redo log
archived redo log
online redo log
relocating
renaming
redo records
reducing fragmentation
REFERENCES privilege
CASCADE CONSTRAINTS option
revoking
[
2
]
relational design, planning
releases
checking the release number
identifying for Oracle7 Server
maintenance release number
patch release number
port-specific release number
versions of other Oracle software
relocating
control files
datafiles
[
2
]
remote connections
connecting as INTERNAL
connecting as SYSOPER/SYSDBA
password files
REMOTE_LOGIN_PASSWORDFILE parameter
REMOTE_OS_AUTHENT parameter, setting
REMOTE_OS_ROLES parameter, setting
[
2
]
RENAME command
Rename Data File dialog
Rename Online Redo Log Member dialog box
renaming
control files
datafiles
[
2
]
datafiles with a single table
online redo log members
schema objects
replacing, views
RESOURCE audit oiption, shortcut for auditing
resource limits
altering in profiles
assigning with profiles
composite limits and
costs and
creating profiles and
disabling
enabling
privileges to enable and disable
privileges to set costs
profiles
PUBLIC_DEFAULT profile and
service units
setting to null
RESOURCE role
RESOURCE_LIMIT parameter, enabling and disabling limits
resources, profiles
responsibilities
of a database administrator
of database users
restoring, full backup
RESTRICTED SESSION privilege
instances in restricted mode
restricted mode and
session limits and
restricting access to database, starting an instance
resuming recovery
REVOKE command
when takes effect
Revoke System Privileges/Roles dialog
revoking privileges and roles
on selected columns
REVOKE command
[
2
]
shortcuts for object privileges
when using operating-system roles
revoking, privileges and roles, SYSOPER/DBA privileges
roles
ADMIN OPTION and
application developers and
authorization
backward compatibility
changing authorization for
changing passwords
CONNECT role
database authorization
DBA role
[
2
]
default
dropping
EXP_FULL_DATABASE
GRANT command
GRANT OPTION and
granting
grouping with roles
IMP_FULL_DATABASE
listing
listing grants
listing privileges and roles in
management using the operating system
managing
multi-byte characters in passwords
multi-byte characters
multi-threaded server and
operating system granting of
[
2
]
operating-system authorization
OS management and the multi-threaded server
passwords for enabling
predefined
[
2
]
privileges
changing passwords
for creating
for dropping
granting system privileges or roles
RESOURCE role
REVOKE command
revoking
revoking ADMIN OPTION
security and
SET ROLE command
unique names for
without authorization
rollback segments, acquiring automatically
[
2
]
acquiring on startup
allocating
altering public
altering storage parameters
AVAILABLE
average byte size of active extents
average size of truncated space
bringing
online automatically
online when new
PARTLY AVAILABLE segment online
checking if offline
choosing how many
choosing size for
creating
creating after database creation
creating public and private
decreasing size of
deferred
[
2
]
displaying names of all
displaying
deferred rollback segments
information on
PENDING OFFLINE segments
dropping
equally sized extents
explicitly assigning transactions to
extends
guidelines for managing
initial
invalid status
listing extents in
location of
making available for use
managing
MINEXTENTS and
monitoring
[
2
]
OFFLINE
offline rollback segments
offline status
online rollback segments
online status
PARTLY AVAILABLE
PENDING OFFLINE
privileges
required to alter
required to create
taking online and offline
setting size of
shrinks
status for dropping
status or state
storage parameters
storage parameters and
SYSTEM rollback segment
taking offline
taking tablespaces offline and
transactions and
using multiple
wraps
ROLLBACK_SEGMENTS parameter
adding rollback segments to
setting before database creation
ROWID datatype
ROWID pseudo-column
changes in
rows, chaining across blocks
[
2
] [
3
] [
4
]
estimating size
ROWID changes
violating integrity constraints
S
schema objects
auditing
creating multiple objects
default audit options
dependencies between
disabling audit options
enabling audit options on
listing by type
listing information
name resolution
privileges to access
privileges to rename
renaming
[
2
]
SCN
security
accessing a database
administrator of
application developers and
auditing policies
authentication of users
data
[
2
]
database administrator's responsibilities
database security
database users and
establishing policies
general users
multi-byte characters
in role passwords
in user names
in user passwords
operating-system role management
operating-system security and the database
policies for database administrators
privilege management policies
privileges
protecting the audit trail
REMOTE_OS_ROLES parameter
roles to force security
security officer
sensitivity
segments
data and index
reducing fragmentation
data dictionary
displaying information on
monitoring
rollback
temporary storage parameters
sensitivity, security
SEQUENCE_CACHE_ENTRIES parameter
sequences
altering
creating
dropping
initialization parameters
managing
Parallel Server and
privileges for altering
privileges for creating
privileges for dropping
Server Manager
about
operating system account
starting
server units, composite limits and
servers
dedicated
multi-threaded
service name, for dispatcher in multi-threaded server
session limits, license, setting initially
session monitor
session, user
active
inactive
marked to be terminated
terminating
viewing terminated sessions
sessions
auditing connections and disconnections
limits per instance
listing privilege domain of
number of concurrent sessions
Parallel Server session limits
setting maximum for instance
setting warning limit for instance
viewing current number and high water mark
viewing memory use
SET ROLE command
how password is set
when using operating-system roles
Set Rollback Segment Offline dialog
Set Rollback Segment Online dialog
Set Rollback Segment Storage dialog
Set Tablespace Offline dialog
Set Tablespace Online dialog
[
2
]
Set Tablespace Storage dialog box
SET TRANSACTION command, USE ROLLBACK SEGMENT option
[
2
]
SGA, determing buffers in cache
shared mode, rollback segments and
shared pool
ANALYZE command and
multi-threaded server and
shared server processes
changing the minimum number of
maximum number of
number to start initially
privileges to change number of
trace files for
shared SQL areas, ANALYZE command and
shortcuts
CONNECT, for auditing
object auditing
object privileges
statement level auditing options
shrunken extents
Shut Down menu
Abort Instance option
Immediate option
Normal option
SHUTDOWN command
ABORT option
IMMEDIATE option
NORMAL option
shutting down a database
shutting down an instance
aborting the instance
connecting and
connecting as INTERNAL
example of
general procedures
immediately
multi-threaded server
normally
size
clusters
datafile
hash clusters
indexes
on non-clusterd tables
rollback segments
snapshot logs, storage parameters
snapshots
media recovery and
storage parameters
too old
SNP background processes
about
initialization parameters
job queues and
multiple
software versions
SORT_AREA_SIZE parameter, index creation and
space management
PCTFREE
PCTUSED
space
adding to the database
used by indexes
SQL statements
disabling audit options
enabling audit options on
privileges required for
SQL trace facility, when to enable
SQL*Loader
about
indexes and
SQL_TRACE parameter, trace files and
STALE status, of redo log members
Start Automatic Archiving dialog
Start Up Instance dialog box
Force check box
Mount radio button
Nomount radio button
Open radio button
Recover checkbox
Restrict to DBAs check box
specifying a parameter file
starting a database
about
general procedures
recovering during
starting an instance
at database creation
automatically at system startup
connecting as INTERNAL
database closed and mounted
database name conflicts and
dispatcher processes and
enabling automatic archiving
examples of
exclusive mode
forcing
general procedures
mounting and opening the database
multi-threaded server and
normally
parallel mode
parameter files
problems encountered while
recovery and
remote instance startup
restricted mode
specifying database name
troubleshooting
with multi-threaded servers
without mounting a database
starting Server Manager
STARTUP command
FORCE option
MOUNT option
NOMOUNT option
OPEN option
RECOVER option
[
2
]
RESTRICT option
specifying database name
specifying parameter file
statistics, updating
Stop Auto Archive menu option
storage parameters
applicable objects
changing settings
data dictionary
default
for the data dictionary
INITIAL
[
2
]
INITRANS
[
2
]
MAXEXTENTS
MAXTRANS
[
2
]
MINEXTENTS
[
2
]
NEXT
OPTIMAL (in rollback segments)
PCTFREE
PCTINCREASE
PCTUSED
precedence of
rollback segments
SYSTEM rollback segment
temporary segments
storage
altering tablespaces
quotas and
revoking tablespaces and
unlimited quotas
stored procedures
privileges for recompiling
using privileges granted to PUBLIC
stream, tape drive
synonyms
creating
displaying dependencies of
dropped tables and
dropping
managing
private
privileges for creating
privileges for dropping
public
SYS.AUD$
audit trail
creating and deleting
SYS
initial password
objects owned
SYSOPER/SYSDBA privileges
adding users to the password file
connecting with
determining who has privileges
granting and revoking
[
2
]
SYS
policies for protecting
privileges
System Change Number (SCN)
checking for a datafile
use in distributed recovery
System Global Area
System Global Area (SGA)
system identifier
system privileges
SYSTEM rollback segment
adding
altering storage parameters of
remaining online always
rollback segments
SYSTEM tablespace
backing up
cannot drop
initial rollback segment
non-data dictionary tables and
recovery of
[
2
]
restrictions on taking offline
when created
system time, changing
SYSTEM
initial password
objects owned
policies for protecting
user
SYS, user
T
tables
allocating extents
altering
[
2
]
analyzing statistics
clustered
clustered tables
creating
dropping
managing
privileges to drop
storage
creating
designing before creating
dropping
estimating initial size
estimating size
[
2
]
guidelines for managing
[
2
]
hash clustered
managing
increasing column length
indexes and
key-preserved
limiting indexes on
location
location of
managing
tablespaces
adding datafiles
altering availability
altering storage settings
assigning defaults for users
assigning user quotas
backing up offline
backing up online
backing up several online
bringing online
checking default storage parameters
coalescing
creating
creating additional
default quota
default storage parameters for
default temporary
dropping
required privileges
frequency of backups
guidelines for managing
listing files of
listing free space in
location
managing
monitoring
privileges for creating
privileges to take offline
quotas for users
quotas
read-only
revoking from users
rollback segments required
setting default storage parameters for
SYSTEM tablespace
taking offline immediately
taking offline normal
taking offline temporarily
temporary
unlimited quotas
using multiple
viewing quotas
[
2
]
writable
tables
parallelizing creation of
privileges for creation
privileges for dropping
privileges to alter
schema of clustered
separating from indexes
specifying PCTFREE for
specifying tablespace
[
2
]
storage parameters
SYSTEM tablespace and
temporary space and
transaction parameters
truncating
UNRECOVERABLE
validating structure
taking offline, tablespaces
tape drives, streaming for archiving
temporary segments, index creation and
temporary space, allocating
terminating sessions
active sessions
identifying sessions
inactive session, example
inactive sessions
terminating, a user session
test, security for databases
time-based recovery
coordinated in a distributed database
procedure for
tip
executing OS commands within Server Manager
object privilege shortcut
shortcuts for auditing objects
statement auditing shortcut
trace files
control file backups to
job failures and
location of
log writer
size of
using
[
2
]
when written
trailing nulls
transaction entries, guidelines for storage
TRANSACTIONS parameter, using
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, using
transactions
assigning to specific rollback segment
rollback segments and
triggers, auditing
[
2
]
disabling
dropped tables and
enabling
examples
privileges for controlling
privileges for enabling and disabling
TRUNCATE command
DROP STORAGE option
REUSE STORAGE option
truncated extents
truncating
clusters
privileges for
tables
Trusted Oracle7 Server
auditing
controlling database access
database migration to
LOG_CHECKPOINT_INTERVAL and
managing rollback segments
managing tablespaces and datafiles
managing users and resources
shutting down a database
Trusted Oracle
role management
security policies for
special datatypes
system privileges
tuning parameters
tuning
archiving
databases
initially
U
UNIQUE key constraints
disabling
dropping associated indexes
enabling
enabling on creation
foreign key references when dropped
indexes associated with
storage of associated indexes
UNLIMITED TABLESPACE privilege
unrecoverable indexes, indexes
unrecoverable
objects and recovery
tables
UPDATE privilege, revoking
USER_DUMP_DEST parameter
USER_EXTENTS
USER_FREE
[
2
]
USER_INDEXES view, filling with data
USER_SEGMENTS
[
2
]
USER_TAB_COLUMNS view, filling with data
USER_TABLES view, filling with data
USER_TABLESPACES
[
2
]
usernames, SYS and SYSTEM
users
altering
assigning profiles to
assigning tablespace quotas
assigning unlimited quotas for
auhentication
authentication
[
2
]
operating-system authentication
changing authentication method
changing default roles
changing passwords
composite limits and
default tablespaces
dropping
dropping profiles and
dropping roles and
end-user security policies
enrolling
identification
in a newly created database
limiting number of
listing
listing privileges granted to
listing roles granted to
managing
multi-byte characters
in passwords
objects after dropping
password security
policies for managing privileges
privileges for changing passwords
privileges for creating
privileges for dropping
PUBLIC group
security and
security for general users
session, terminating
specifying user names
tablespace quotas
unique user names
[
2
]
viewing information on
viewing memory use
viewing tablespace quotas
[
2
]
utilities
Export
for the database administrator
Import
Server Manager
SQL*Loader
UTLCHAIN.SQL
UTLEXCPT.SQL, running
UTLLOCKT.SQL script
V
V$ARCHIVE view
V$BACKUP view
V$DATABASE view
V$DATAFILE
[
2
]
V$DATAFILE view
V$DBFILE view
V$DISPATCHER view, controlling dispatcher process load
V$LICENSE view
V$LOG view
displaying archiving status
online redo log and
V$LOGFILE view
listing files before backup
V$PWFILE_USERS view
V$QUEUE view, controlling dispatcher process load
V$RECOVERY_FILE view
V$RECOVERY_FILE_STATUS
V$RECOVERY_STATUS
V$ROLLNAME, finding PENDING OFFLINE segments
V$ROLLSTAT, finding PENDING OFFLINE segments
V$SESSION
V$SESSION view
V$THREAD view
VALIDATE STRUCTURE option
VARCHAR2 datatype
space use of
versions
of other Oracle software
views
creating
creating with errors
displaying dependencies of
dropped tables and
dropping
FOR UPDATE clause and
managing
[
2
]
ORDER BY clause and
privileges
privileges for dropping
privileges for recompiling
privileges to replace
recompiling
replacing
wildcards in
WITH CHECK OPTION
violating integrity constraints
W
warning
archiving mode for first backup
changing data dictionary storage parameters
consistency and Export backups
creating a rollback segment
data in dropped tablespace is unrecoverable
datafile names missing from control file
disabling audit options
enabling auditing
keeping symmetric online redo log groups
number of control files
setting the CONTROL_FILES parameter
use mirrored control files
wildcards, in views
WORM devices, and read-only tablespaces
writable tablespaces
X
Y
Z