Index

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

base table

performance, 3.20.3

batch jobs

Oracle database, 3.16

buffer busy waits, 3.20.2

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

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

error

filesize limit exceeded, 2.12.7

log

AWT cache group, 5.4.1

out of memory, 2.12.5

tracing, 1.5.6

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

hanging application, 2.9.1

INITRANS

setting, 3.20.2

ipcrm command, 2.4.6

ipcs command, 2.4.6

isolation

levels, 2.8.3

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

memory

shared

consumption, 2.12.1

used by query, 2.12.4

MONITOR table

AWT performance, 5.2.3

NOVALIDATE state

cache group failure, 3.21

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

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

query

checking memory used, 2.12.4

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

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

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

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

VALIDATE state

primary key, 3.21

vmstat reporting tool, 2.12.1

XLA

poor performance, 4.7