Index

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

base table

performance, 3.19.3

buffer busy waits, 3.19.2

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

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

error

filesize limit exceeded, 2.12.8

out of memory, 2.12.6

error tracing, 1.5.6

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

hanging application, 2.9.1

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

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

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

NOVALIDATE state

cache group failure, 3.20

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

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

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, 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

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

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

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

VALIDATE state

primary key, 3.20

vmstat reporting tool, 2.12.1

XLA

poor performance, 6.7