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.20.1.1
aging
monitoring, 1.5.7
alter replication
unique constraint violation, 4.8.1
ALTER REPLICATION
troubleshooting, 4.2
application
hanging, 2.9.1, 2.9.1
multithreaded issues, 2.9.3
asynchronous writethrough cache group, see AWT cache group
autorefresh
batch jobs, 3.16
diagnose, 3.20
Failed status, 3.14.4
fails, 3.11
fragmented change log tables, 3.20.4
full, 3.19
incremental, 3.19
interval too small, 3.20.5
lock timeout, 3.17.3
monitoring
change log tables, 3.14.2, 3.14.2
SQL script, 3.14.2
support log, 3.14.3
performance, 3.20, 3.20.2, 3.20.5
setting FREELISTS, 3.20.2
setting INITRANS, 3.20.2
trace, 1.5.8
AUTOREFRESH trace, 3.20
AWR report
DBMS_LOCK, 3.22
AWT cache group
dropped object, 5.4.1, 5.4.1
error log file, 5.4.1, 5.4.1
operation failure, 3.11
Oracle errors, 5.4.1, 5.4.1, 5.4.2, 5.4.2
performance, 5.3
monitoring, 5.2, 5.2.2
replication problems, 5, 5.1
AWT performance
SYS.SYSTEMSTATS table, 5.2.3
using SYS.MONITOR table, 5.2.3
awterrs file, 5.4.1

B

base table
performance, 3.20.3
batch jobs
Oracle database, 3.16
buffer busy waits, 3.20.2

C

cache
DBMS_LOCK, 3.22
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.21
DDL tracking, 3.11
load failure, 3.11
loading fails, 3.13
performance, 3.20.3
refreshing fails, 3.13
cacheInfo.sql script, 3.14.2
change log record
size, 3.19.2
change log table, 3.19.2
fragmentation, 3.20.4
CHECK CONFLICTS
timestamp problems, 4.9.1, 4.9.2
client/server
out of space, 2.5.10
problems, 2.5
thread stack overflow, 2.5.9
troubleshooting, 2.5, 2.5
conflict reporting
suspending, 4.9.3
connect identifier, 3.5
connection
maximum concurrent for server, 2.5.2
maximum number on Windows XP, 2.5.8
status, 1.3
thread stack overflow, 2.5.9
timeout, 3.6
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
datablock
availability, 3.15
DBMS_LOCK
contention, 3.22
dbms_shared_pool.keep procedure, 3.15
DDL
tracking, 3.11
DeadDbRecovery parameter, 3.20.1.1
DEADLOCK tracing, 1.5.4
deadlocks, 3.20.2

E

error
filesize limit exceeded, 2.12.7
log
AWT cache group, 5.4.1
out of memory, 2.12.5
tracing, 1.5.6

F

failures
server, 2.5.2
file size
limits, 2.12.7
tracing, 2.12.7
filesize limit exceeded error, 2.12.7
FREELISTS
setting, 3.20.2

H

hanging application, 2.9.1

I

INITRANS
setting, 3.20.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, 3.17.3
tracing, 1.5.5
LockLevel attribute, 2.8.3
log
daemon support log, 1.4
daemon user error log, 1.4
log buffer
replication, 4.7.4
log table
performance, 3.20.3
LogBufMB first connection attribute, 4.7.4

M

memory
shared
consumption, 2.12.1
used by query, 2.12.4
MONITOR table
AWT performance, 5.2.3

N

NOVALIDATE state
cache group failure, 3.21

O

OCI initialization failure, 3.8
ODBC
tracing, 1.7, 1.7
optimizer
update table statistics, 2.8.2
ORA-12154, 3.5
Oracle
client/server interoperability, 3.6
errors reported with AWT cache groups, 5.4.1
incompatible client/server versions, 3.6
support log for AWT cache group, 5.4.2
tablespace, 3.19.2
ORACLE_HOME
changing, 3.2.2
out of memory error, 2.12.5
out of space
client/server multiple connections, 2.5.10

P

parallel query
enable, 3.15
parallel replication, 4.10
performance
autorefresh cache group, 3.20.2
AWT cache group, 5.3
busy waits, 3.20.2
excessive deadlocks, 3.20.2
isolation levels, 2.8.3
large tables, 3.20.3
lock levels, 2.8.3
refresh, 3.20.2
row lock waits, 3.20.2
UNLOAD CACHE GROUP, 5.3.2
PermSize attribute, 2.4.6
primary key
VALIDATE state, 3.21
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, 4.3
log buffer, 4.7.4
performance
conflict reporting, 4.9.3
poor performance, 4.7
troubleshooting, 4, 4, 4.5, 5.1
rollbacks
tracing, 1.5.3
row lock waits, 3.20.2

S

sar reporting tool, 2.12.1, 2.12.1
SELECT statement
duplicate results, 2.13
semaphore
removal, 2.4.6
server
failures, 2.5.2
troubleshooting failures, 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
SNMP traps, 1.8
replication, 4.4
space
monitoring, 1.5.3
troubleshooting low on space, 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.4.2
SYS tables, 1.9
SYS.MONITOR table
AWT performance, 5.2.3
SYS.SYSTEMSTATS table
AWT performance, 5.2.3
system tables
monitoring, 1.9
troubleshooting contention, 2.9.3

T

tables
abnormally large, 3.20.3
large, 3.15
update statistics, 2.8.2
tablespace
cache administration user, 3.19.2
create, 3.19.2
diagnose, 3.19.3
full, 3.19.3, 3.19.5
managing, 3.19.5
monitor, 3.19.4
Oracle, 3.19.2
recovery, 3.19.5
set threshold warning, 3.19.4
TblSpaceFullRecovery parameter, 3.19.5
TblspaceThreshold parameter, 3.19.4
TempSize attribute, 2.4.6
thread
stack overflow, 2.5.9
thread stack overflow
multiple client connections, 2.5.9
tnsnames.ora identifier, 3.5
top reporting tool
vmstat tool, 2.12.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.7
how to turn on, 1.7
LOCK trace, 1.5.5
ODBC trace, 1.7
output format, 1.5.1
SQL trace, 1.5.2
transaction
log buffer, 4.7.4
log files
accumulation, 2.12.6, 2.12.6
triggers
performance, 3.15
troubleshooting, 3
ttCacheAutorefreshStatsGet procedure, 3.20
Failed status, 3.14.4
ttCacheAwtMonitorConfig built-in procedure, 5.2
ttCacheConfig built-in procedure, 3.19.4, 3.19.5, 3.20.1.1
ttCapture utility, 1.1
ttGridAttach utility, 3.3.1
ttGridDetachList utility, 3.3.1
ttIsql utility
using, 1.2
ttLockLevel procedure, 2.8.3
ttmodinstall utility
using, 3.2.2
ttOptSetFlag procedure, 2.8.3
ttOptUpdateStats procedure, 2.8.2
ttRepAdmin utility, 5.2.2, 5.2.3
alter replication
unique constraint violation, 4.8.1
changing receiver state, 4.8.1, 4.8.1
duplicate
database already created, 4.8.2
troubleshooting, 4.8.2
wrong database name, 4.8.2
wrong user name, 4.8.2
troubleshooting, 4.8
ttRepStart utility, 3.3.1
ttSize utility
estimate memory, 2.4.6
ttStatus utility
using, 1.3
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
UNIX
ipcrm command, 2.4.6
ipcs command, 2.4.6
ps command, 2.4.6
ulimit command, 2.4.6
UNLOAD CACHE GROUP
performance, 5.3.2

V

VALIDATE state
primary key, 3.21
vmstat reporting tool, 2.12.1

X

XLA
poor performance, 4.7