Index

A  B  C  D  E  F  H  I  L  M  N  O  P  Q  R  S  T  U  V  X 

A

AgentTimeout parameter, 3.19.1.1
aging
monitoring, 1.5.7
ALTER REPLICATION
troubleshooting, 6.2
asynchronous writethrough cache group, see AWT cache group
autorefresh
diagnose, 3.19
Failed status, 3.14.4
fails, 3.11
full, 3.18
incremental, 3.18
interval too small, 3.19.4
monitoring
change log tables, 3.14.2
SQL script, 3.14.2
support log, 3.14.3
monitoring the change log tables, 3.14.2
performance, 3.19, 3.19.1, 3.19.2, 3.19.4
setting FREELISTS, 3.19.2
setting INITRANS, 3.19.2
trace, 1.5.8
AUTOREFRESH trace, 3.19
AWR report
DBMS_LOCK, 3.21
AWT cache group
dropped object, 5.6
error file, 5.6
operation failure, 3.11
Oracle errors, 5.6, 5.7, 5.7
replication problems, 5
awterr file, 5.6

B

base table
performance, 3.19.3
buffer busy waits, 3.19.2

C

cache
DBMS_LOCK, 3.21
trigger
performance, 3.15
cache agent
problems starting, 3.2
cache grid
attach, 3.3
detach, 3.3
recover, 3.3
unexpected failure, 3.3
cache group
autorefresh fails, 3.11
AWT operation failure, 3.11
create failure, 3.20
DDL tracking, 3.11
load failure, 3.11
loading fails, 3.13
performance, 3.19.3
recover, 3.19.1
refreshing fails, 3.13
cache groups
performance, 3.15
cacheInfo.sql script, 3.14.2
change log record
size, 3.18.2
change log table, 3.18.2
CHECK CONFLICTS
timestamp problems, 6.9.1, 6.9.2
client/server
out of space, 2.5.10
problems, 2.5
thread stack overflow, 2.5.9
concurrent connections
maximum for server, 2.5.2
conflict reporting
suspending, 6.9.3
connect identifier, 3.5
connection
maximum concurrent server, 2.5.2
connection status, 1.2
connection timeout
Oracle client/server versions, 3.6
connections
maximum number on Windows XP, 2.5.8
create cache group
null constraint, 3.10
unsupported data type mapping, 3.9
CREATE SESSION privilege, 2.4.2

D

daemon
support log, 1.4
user error log, 1.4
database
dead, 3.19.1
recover, 3.19.1
datablock
availability, 3.15
DBMS_LOCK
contention, 3.21
dbms_shared_pool.keep procedure, 3.15
DDL
tracking, 3.11
DeadDbRecovery parameter, 3.19.1.1
DEADLOCK tracing, 1.5.4
deadlocks, 3.19.2
downgrade
version 7 to version 6, 4.2

E

error
filesize limit exceeded, 2.12.8
out of memory, 2.12.6
error tracing, 1.5.6

F

failures
server, 2.5.2
file size
limits, 2.12.8
tracing, 2.12.8
filesize limit exceeded error, 2.12.8
FREELISTS
setting, 3.19.2

H

hanging application, 2.9.1

I

IMDB cache
database
recover, 3.19.1
dead database, 3.19.1
performance, 3.15
INITRANS
setting, 3.19.2
ipcrm command, 2.4.6
ipcs command, 2.4.6
isolation
levels, 2.8.3

L

LOAD CACHE GROUP
failure, 3.13
lock
levels, 2.8.3
timeout, 1.6
tracing, 1.5.5
LockLevel attribute, 2.8.3
log buffer
replication, 6.7.4
log table
performance, 3.19.3
LogBufMB first connection attribute, 6.7.4

M

memory
shared
consumption, 2.12.1
used by query, 2.12.4
multiple connections
thread stack overflow, 2.5.9
multithreaded applications
conflicts, 2.9.3

N

NOVALIDATE state
cache group failure, 3.20

O

OCI initialization failure, 3.8
ODBC tracing, 1.7
optimizer
update table statistics, 2.8.2
ORA-12154, 3.5
Oracle client/server interoperability, 3.6
Oracle errors
AWT cache group, 5.7
AWT cache groups, 5.6
Oracle tablespace, 3.18.2
ORACLE_HOME
changing, 3.2.2
out of memory error, 2.12.6
out of space
client/server multiple connections, 2.5.10

P

parallel query
enable, 3.15
performance
autorefresh cache group, 3.19.2
buffy busy waits, 3.19.2
excessive deadlocks, 3.19.2
IMDB cache, 3.15
isolation levels, 2.8.3
large tables, 3.19.3
lock levels, 2.8.3
refresh, 3.19.2
row lock waits, 3.19.2
PermSize attribute, 2.4.6
primary key
VALIDATE state, 3.20
problems
checking connection status, 1.2
client/server, 2.5
finding tables, 2.10.1
hanging application, 2.9.1
transaction log files accumulating, 2.12.7
ps command, 2.4.6

Q

query
checking memory used, 2.12.4

R

Read Committed isolation level
SELECT gives duplicate results, 2.13
REFRESH CACHE GROUP
failure, 3.13
replication
agent
unable to stop or start, 6.3
log buffer, 6.7.4
performance
conflict reporting, 6.9.3
poor performance, 6.7
troubleshooting, 5.2, 6, 6, 6.5
rollbacks
tracing, 1.5.3
row lock waits, 3.19.2

S

sar reporting tool, 2.12.1
sar tool, 2.12.1
SELECT statement
duplicate results, 2.13
semaphore
removal, 2.4.6
server
failures, 2.5.2
maximum concurrent connections, 2.5.2
SGA
datablock
availability, 3.15
keep portion, 3.15
shared memory
estimate size, 2.4.6
maximum size reached, 2.4.6
query limits, 2.4.6
remove segment, 2.4.6
shared segment
too many in use, 2.3
unable to create, 2.3
SIGXFSZ signal, 2.12.8
SNMP traps, 1.8
replication, 6.4
space
monitoring, 1.5.3
SQL tracing, 1.5.2
statement preparation
importance of, 2.8.3
support log
monitoring autorefresh, 3.14.3
Oracle errors, 5.7
SYS tables, 1.9
system tables
monitoring, 1.9
troubleshooting contention, 2.9.3

T

table
update statistics, 2.8.2
tables
abnormally large, 3.19.3
large, 3.15
tablespace
cache administration user, 3.18.2
create, 3.18.2
diagnose, 3.18.3
full, Preface, 3.18.3, 3.18.5
managing, Preface, 3.18.5
monitor, Preface, 3.18.4
Oracle, 3.18.2
recovery, Preface, 3.18.5
set threshold warning, Preface, 3.18.4
TblSpaceFullRecovery parameter, 3.18.5
TblspaceThreshold parameter, 3.18.4
TempSize attribute, 2.4.6
thread stack overflow
multiple client connections, 2.5.9
TimesTen daemon
support log, 1.4
user error log, 1.4
tnsnames.ora identifier, 3.5
top reporting tool
vmstat tool, 2.12.1
trace
output format, 1.5.1
tracing
AGING trace, 1.5.7
API trace, 1.5.3
AUTOREFRESH trace, 1.5.8
deadlocks, 1.5.4
error tracing, 1.5.6
file size, 2.12.8
how to turn on, 1.7
LOCK trace, 1.5.5
ODBC trace, 1.7
SQL trace, 1.5.2
transaction
log buffer, 6.7.4
log files
accumulation, 2.12.7
triggers
performance, 3.15
troubleshooting, 3
AWT dropped object, 5.6
client/server, 2.5
connection status, 1.2
finding tables, 2.10.1
hanging application, 2.9.1
low on space, 1.5.3
ODBC trace, 1.7
replication, 6
server failures, 2.5.2
transaction log files accumulating, 2.12.7
ttCacheAutorefreshStatsGet procedure, 3.19
Failed status, 3.14.4
ttCacheConfig built-in procedure, 3.18.4, 3.18.5, 3.19.1.1
ttCapture utility, 1.3
ttGridAttach utility, 3.3.1
ttGridDetachList utility, 3.3.1
ttIsql utility
using, 1.1
ttLockLevel procedure, 2.8.3
ttmodinstall utility
using, 3.2.2
ttOptSetFlag procedure, 2.8.3
ttOptUpdateStats procedure, 2.8.2
ttRepAdmin utility
troubleshooting, 6.8
ttRepStart utility, 3.3.1
ttSize utility
estimate memory, 2.4.6
ttStatus utility
using, 1.2
ttTraceMon utility
AGING tracing, 1.5.7
API tracing, 1.5.3
AUTOREFRESH tracing, 1.5.8
DEADLOCK tracing, 1.5.4
error tracing, 1.5.6
LOCK tracing, 1.5.5
output format, 1.5.1
SQL tracing, 1.5.2
using, 1.5
ttXactAdmin utility
using for troubleshooting, 1.6

U

ulimit command, 2.4.6
UNIC
ps command, 2.4.6
UNIX
ipcrm command, 2.4.6
ipcs command, 2.4.6
ulimit command, 2.4.6

V

VALIDATE state
primary key, 3.20
vmstat reporting tool, 2.12.1

X

XLA
poor performance, 6.7