15/15

Index

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

---

A

accent-insensitive linguistic sort, 5.5.3

acknowledging updates, 10.8.2

active standby pair

aging, 8.2.3.5

aging

active standby pair, 8.2.3.5

attributes, 8.2.3.1

foreign keys, 8.2.3.3

LRU, 8.2.3.1

ON DELETE CASCADE, 8.2.3.3

parent and child tables, 8.2.3.3

performance, 8.2.3.2

replication, 8.2.3.5

restrictions, 8.2.3

tables, 8.2.3

time-based, 8.2.3, 8.2.3.2

usage-based, 8.2.3.1

allfunctions command

ttIsql utility, 6.10

allow_network_files attribute

timesten.conf file, 7.6.2

allpackages command

ttIsql utility, 6.10

allprocedures command

ttIsql utility, 6.10

ALTER SESSION SQL statement, 5.7

ALTER TABLE

adding and removing columns, 8.2.1.1

performance, 10.3.10

application

disconnect, 2.2.2

failure

use of logs and locks, 7.3.1

linking

direct, 1.1

linking with driver manager, 1.1

shut down, 4.2.1

asynchronous checkpoints

See fuzzy checkpoints

attributes

connection, 3.2.5

database name, 1.6.1

PermWarnThreshold, 2.5.4

setting for Linux and UNIX, 1.3.1

TempWarnThreshold, 2.5.4

viewing and changing by ttIsql, 6.11

AUTO_ACKNOWLEDGE mode, 10.8.2

autocommit

performance impact, 10.5.5

autocommit command

ttIsql utility, 6.12

automatic client failover, 3.2.6

---

B

Backing up data, 2.7, 2.7.1

batch mode

ttIsql, 6.1

blocking checkpoints, 7.5.3.2

byte semantics, 5.3, 5.3

---

C

cache agent

start, 2.2.1

stop, 2.2.2

cache group

time-based aging, 8.2.3.2

cachegroups command

ttIsql utility, 6.9, 6.9.2

case-insensitive linguistic sort, 5.5.3

character semantics, 5.3, 5.3

character set

application, 5.2.2, 5.2.2

application data, 5.4

choosing, 5.2

connection, 5.4

conversion, 5.2.3, 5.4

encoding, 5.2.1

globalization, 5

languages, 5.2.1

length semantics, 5.3

multibyte, 5.2.1, 5.3

operating system, 5.2.2

performance, 5.2.3, 5.4

replication, 5.2.4

selecting, 5.2

single-byte, 5.2.1, 5.3

working with in ttIsql, 6.8

checkpoint

blocking, 7.5.3.2

definition, 7.5.3

fuzzy, 7.5.3.1

checkpoint file, 7.5.3

checkpoints

fuzzy

influences on duration, 7.5

performance, 10.5.4

setting and managing, 7.5.4

static

CkptFrequency connection attribute, 2.6.1, 7.6.3.2

CkptLogVolume connection attribute, 2.6.1, 7.6.3.2

CkptReadThreads connection attribute, 10.6.2

client

automatic failover

using read-only cache groups, 3.2.6.3

configuring authentication on Windows, 3.2.5.1.2

configuring automatic failover, 3.2.6.4

using active standby pair, 3.2.6.2

using Scaleout, 3.2.6.1

configuring automatic failover on Linux and UNIX, 3.2.6.4.2

connection attributes

described, 3.2.3, 3.2.5

creating DSN

on Linux and UNIX, 3.2.5.2

on Windows, 3.2.5.1.1

performance, 10.2.2

setting timeout interval on Windows, 3.2.5.1.2

client connection

failover

timing, 3.2.7

Client DSN

creating, 3.2.5.2

creating on Linux and UNIX, 3.2.5.2

creating on Windows, 3.2.5.1.1

Data Source Setup dialog, 3.2.5.1.1

name, 3.2.5.1.1, 3.2.5.1.1

client failover

automatic client failover, 3.2.6

CLIENT_ACKNOWLEDGE mode, 10.8.3

client/server

connection configuration, 3.2.3

multiple connections, 3.2.3

Client/Server

changing shared memory segment size, 4.4.5.2

communication

overview, 3.1.2

configuring, 3.2

connections across releases, 3.2.2.2

managing shared memory segment size, 4.4.5.1

performance, 10.2.1

shared memory, 4.4.5.2

TCP/IP communication, 3.1.2.1, 3.1.2.1

UNIX socket communication, 3.1.2.3, 3.1.2.3

Client/Server communication

shared memory, 4.4.5

TCP/IP, 4.4.5

close command

ttIsql utility, 6.13

cmdcache command

ttIsql utility, 6.19.2.1

coexistence of different locking levels

columns

adding, 8.2.1.1

default values, 8.2.1.3

inline, 8.2.1.2

nullability, 8.2.1.1

command

history

ttIsql, 6.6

invalidated, 9.1

invalidation, 10.3.9

command cache

displaying, 9.2.2

command history

ttIsql

clearing, 6.6.1

saving, 6.6.1

commit behavior

Oracle Database, 7.2.2

TimesTen, 7.2.2

commit buffer

transaction

configuring, 7.8.2

commit command

ttIsql utility, 6.12

CommitBufferSizeMax connection attribute, 7.8.2

commitdurable command

ttIsql utility, 6.12

compression

table, 10.3.14

concurrency

locking, 7.4, 10.2.5.1

types of isolation, 7.4

configuring

Client/Server, 3.2

connect

using connection string, 1.8

connect command

ttIsql utility, 6.20.2

connection

closed database, 2.1, 2.2.2

failover

timing, 3.2.7

lock wait timeout interval, 10.2.4

locking, 10.2.5

locks, 10.2.4

open database, 2.1, 2.2.1

performance, 10.2.9

performance overhead, 10.1.7

PLSQL_TIMEOUT, 10.3.16

setAutoCommit method, 7.2.1

SQLQueryTimeout, 10.3.16

SQLQueryTimeoutMSec, 10.3.16

testing on Windows, 3.2.5.1.4

TTC_ConnectTimetout, 10.2.3, 10.3.16

TTC_Timeout, 10.2.3, 10.3.16

Connection

setAutoCommit method, 7.2.1

connection attribute

CommitBufferSizeMax, 7.8.2

connection, 3.2.3

Linux, 1.3.1

LockLevel, 10.2.5

LogFlushMethod, 10.5.3

PermSize, 2.5, 2.5

PLSCOPE_SETTINGS, 1.6.2

PLSQL_MEMORY_ADDRESS, 1.6.2

PLSQL_MEMORY_SIZE, 1.6.2

PLSQL_OPTIMIZE_LEVEL, 1.6.2

TempSize, 2.5, 2.5

UID, 8.1.2

UNIX, 1.3.1

connection character set, 3.2.5.1.1, 5.4

connection string

using to connect, 1.8

ConnectionCharacterSet connection attribute, 5.4

Connection.prepareStatement method, 9.3.1

execution plan generation, 9.4.2

Connection.prepareStatement methods, 9.3.1

connections

concurrent, 3.2.3

configuration, 3.2.3

disconnect, 2.4

forced, 2.4

maximum, 3.2.3

Connections connection attribute, 3.2.3

Connection.setAutoCommit methods, 7.2.1

contention

lock, 10.1.10

CREATE INDEX statement, 8.5.2

CREATE OR REPLACE SYNONYM statement, 8.7.1

CREATE SYNONYM statement, 8.7.1

createandloadfromoraquery command, 6.18, 6.18.1

cancel, 6.18.1

creating, 8.5.2

critical events, 4.5.1

---

D

daemon

attributes, see timesten.conf file

control operations, 4.3.2

listener, 4.3.1

IPv4 protocol, 4.3.1.1

listening address, 4.3.1, 4.3.1

log file, 4.5

modifying attributes, 4.4.1

overview, 4

starting, 2.2.1

Linux, 4.1

UNIX, 4.1

stop, 2.2.2

stopping

Linux, 4.1

UNIX, 4.1

daemon log file, 4.5

daemon options file, 3.2.3

daemon_log_snippet_interval_in_mins configuration attribute, 4.5.1

data

permanent, 2.5

temporary, 2.5

data source names, See DSN

client, 1.2.2, 3.2.5.1.1

Client, 1.2.2, 3.2.5

connection attributes, 1.2.3

creating, 3.2.3

Data Manager, 1.2.2

default, 1.6.3

direct, 1.2.2

example, 1.6

finding in order of precedence, 1.5

maximum length, 1.2

naming rules, 1.2

number of server processes, 4.4.4.2

.odbc.ini file, 1.2.1

setting attributes, 1.6.1

system, 1.2.1

user, 1.2.1

database

accessing on a local system, 3.1.2.3

accessing on a remote system, 3.1.2.1

automatic recovery, 2.3.1, 2.3.2

changing size of, 2.5

character set, see character set

close for connections, 2.1, 2.2.2

contention, 10.1.10

definition, 1

defragment, 2.9

defragmentation, 2.5.3

disconnect, 2.4

fragmentation, 2.5.3

getting information with ttIsql, 6.9

identify mode, 2.10

invalidation

messages, 4.5

Linux and UNIX configuration files, 1.7.3

loading to memory, 2.2, 2.2.1, 2.2.1

lock contention, 10.1.10

multithreaded, 3.2.3

objects, 8.1.1, 8.1.1

open for connections, 2.1, 2.2.1

owner, 8.1.2

path names, environment variables in, 1.3.2

prefix name, 1.3.1

prevent automatic reload, 2.3.2

recovery, 2.3.1, 7.9

reduce size, 2.5.3

setting attributes for Linux and UNIX, 1.3.1

sizing, 10.1.3

specification, 1.7.2

specifying size, 10.1.3

statistics, 10.1.14

status, 2.2.2

TCP/IP Client/Server access, 3.1.2.1

UID connection attribute, 8.1.2

UNIX socket Client/Server access, 3.1.2.3

unload, 2.4

unloading from memory, 2.2, 2.2.2

user names, 8.1.2

users, 8.1.2

DatabaseCharacterSet attribute, 5.2

database-level locks, 7.4.2, 7.4.2, 7.4.2

default column values, 8.2.1.3

default DSN, 1.6.3

defragment

database, 2.9

partition, 2.9

defragmentation

database, 2.5.3

deleting

rows, 8.6.2

Windows server name, 3.2.4.1

describe command

ttIsql utility, 6.9, 6.9.1, 6.13

detail table, 8.4.1

dicsonnect

forced, 2.4

distributed database, 2.10

driver manager

JDBC, 1.1.2

linking with, 1.1

ODBC, 1.1

DriverManager.getConnection method, 3.2.5, 3.2.5

drop

materialized view, 8.4.2.2

DROP SYNONYM statement, 8.7.2

dropping

indexes, 8.5.4

tables, example, 8.2.2.2

dssize command

ttIsql utility, 6.9, 6.9.3

DUPS_OK_ACKNOWLEDGE mode, 10.8.2

durability, 7.7

delayed, 7.7

guaranteed, 7.7

overview, 7.3.2

performance, 7.7

Durability connection attribute, 7.7.1.1

durable commit

performance, 10.5.3

transaction, 10.5.2

DurableCommits connection attribute, 7.7.2.1, 7.7.2.1, 7.7.2.2

---

E

editline for ttIsql, 6.5

See also ee also LRU aging

enableIPv6 attribute

timesten.conf file, 4.3.1.1

encoding

character set, 5.2.1

enhanced write concurrent mode, 10.3.15

environment variables

in database path names, 1.3.2

TTISQL, 6.2

error messages, 4.5

examples

creating indexes, 8.5.2

creating tables, 8.2.2.1

drop materialized view, 8.4.2.2

dropping tables, 8.2.2.2

PLAN rows, 9.3.1.2

exec command

ttIsql utility, 6.13

execandfetch command

ttIsql utility, 6.13

execution plan

generating, 9.1, 9.4.2

SQLPrepare, 9.4.2

generation, 9.4.2

Connection.prepareStatement, 9.4.2

modifying, 9.4.1, 9.4.3, 9.4.3

explain command

ttIsql utility, 6.19.2.2

explain plan

display, 6.19.2.2

---

F

facility attribute

timesten.conf file, 4.5

failover, 3.2.6

configuring client, 3.2.6.1, 3.2.6.2, 3.2.6.4

configuring for client on Linux and UNIX, 3.2.6.4.2

fetchall command

ttIsql utility, 6.13

fetchone command

ttIsql utility, 6.13

file system

provisioning, 2.6

files

odbc.ini, 1.2.1, 1.7.3

timesten.conf, 4.3, 4.3.2, 4.4.5

first connection attribute

CkptReadThreads, 10.6.2

PLSQL_MEMORY_SIZE, 10.1.4

ForceDisconnectEnabled connection attribute, 2.4.2

foreign key

constraint

performance, 10.3.5

fragmentation

block-level, 2.5.2

database, 2.5.3

free command

ttIsql utility, 6.13

functions command

ttIsql utility, 6.10

fuzzy checkpoints, 7.5.3.1

---

G

getConnection method, 3.2.5

global system view, 8.8

globalization, 5

character set, 5

---

H

hash index, 10.3.3

definition, 8.5.1, 10.3.3

overview, 8.5.1, 10.3.3

sizing, 10.3.4

when used, 8.5.1, 10.3.3

high availability

replication, 7.7.2

hints

connection level, 9.4.3.3

overview, 9.4.3

statement level, 9.4.3.1

transaction level, 9.4.3.2

history command, 6.6

host binds

using ttIsql, 6.13

---

I

IF command, 6.17

index, 8.5.2

aging performance, 8.2.3.2

creating, 8.2.1.5, 8.5.2

example, 8.5.2

dropping, 8.5.4, 8.5.4

estimating size, 8.5.5

explicit creation, 8.2.1.5

overview, 8.5

owner, 8.5.2

performance, 10.3.1

recommendations, 8.5.6

recovery, 10.6

referencing, 8.5.4

unique, 8.5, 8.5

See also range index

See also hash indexes

Index Advisor

capture data, 8.5.6.2

data collection information, 8.5.6.3

drop data collected, 8.5.6.4

example, 8.5.6.5

overview, 8.5.6

retrieve index recommendations, 8.5.6.3

index size

estimating, 8.5.5

ttSize utility, 8.5.5

informational messages

modifying, 4.5

inline columns, 8.2.1.2

inserting rows, 8.6.1

interactive mode

ttIsql, 6.1

.inval file, 4.5

invalidatino file, 4.5

I/O

performance, 10.5.2

IPC

Client/Server communication, 4.4.5

isolation command

ttIsql utility, 6.12

isolation level

performance, 10.2.5.2

isolation modes

described, 7.4

performance, 10.2.5.2

Serializable, 7.4.1

IXNAME column in PLAN table, 9.3.1.3.5

---

J

JDBC

driver, 1.1.2

driver manager, 1.1.2

JDBC driver, 1.1.2

JDBC tracing, 10.1.13

---

L

least recently used aging, See also LRU

length semantics, 5.3

LEVEL column in PLAN table, 9.3.1.3.2

linguistic index, 5.5.5

linguistic sort

accent-insensitive, 5.5.3

case-insensitive, 5.5.3

monolingual, 5.5.1

multilingual, 5.5.2

Linux

configuration file

odbc.ini, 1.7.3, 1.7.3

setting attributes, 1.3.1

stopping daemon, 4.1

listen_6_addr attribute

timesten.conf file, 4.3.1.1

listen_addr attribute

timesten.conf file, 4.3.1, 4.3.1

local system view, 8.8

lock contention

avoid, 10.7.6

LockLevel connection attribute, 10.2.5

locks

coexistence of different levels

concurrency, 10.2.5.1

database-level, 7.4.2, 10.2.5.1

overview table, 7.3.1

performance, 10.2.5

reduce contention, 10.1.10

row-level, 7.4.2, 10.2.5.1

set wait time, 7.4.2.1

table-level, 7.4.2, 10.2.5.1

wait timeout interval and performance, 10.2.4

See also ttLockLevel

LockWait attribute, 7.4.2.1

LockWait connection attribute, 10.2.4

log file

accumulation, 7.6.3.3

log files

accumulation, 7.6.3, 7.6.3.3

CkptFrequency attribute, 7.6.3.2

CkptLogVolume attribute, 7.6.3.2

critical event log file, 4.5.1

daemon log files, 4.5.1

hold, 7.6.3.1

.inval file, 4.5.1

monitoring, 7.6.3, 7.6.3.3

purging, 7.6.3.2

sequence number, 7.6.3.3

ttCkpt built-in function, 7.6.3.2

ttmesg.log.ts_timestamp.gz, 4.5.1

log holds

monitoring, 7.6.3.3

LogBufMB connection attribute, 7.6.1

LogBufParallelism connection attribute, 7.6.1

LogDir connection attribute, 7.6.1

LogFileSize connection attribute, 7.6.1

LogFlushMethod connection attribute, 7.7.2.1, 10.5.3

logging, 4.5.1

invalidation, 4.5.1

managing, 4.4.6

overview table, 7.3.1

logical server

Network Address, 3.1.2.3, 3.2.4.1, 3.2.4.2

logical server name, 3.2.4.1

creating on Linux and UNIX, 3.2.4.2

LRU aging, 8.2.3, 8.2.3.1, 8.2.3.1

attributes, 8.2.3.1

---

M

maintenance options

performance impact, 10.1.11

materialized view

create, 8.4.2.1

detail table, 8.4.1

drop, 8.4.2.2, 8.4.2.2

performance, 8.4.2.4

restrictions, 8.4.2.3

SELECT queries in, 8.4.2.1.2

synchronous

create, 8.4.2.1.1

overview, 8.4.1

tuning recommendations, 10.4

outer join, 10.4.4

understanding, 8.4

max_conns_per_server attribute

timesten.conf file, 4.4.4

max_subs attribute

timesten.conf file, 4.3.2

max_support_log_files attribute

timesten.conf file, 4.5

max_support_log_size attribute

timesten.conf file, 4.5

MaxConnsPerServer connection attribute, 3.2.3, 10.2.9

maximum name length, 8.2.1.4

memory

loading a database into, 2.2.1

permanent, 2.5

policy for loading a database, 2.3

regions, 2.5

temporary, 2.5

unloading a database from, 2.2.2

messages

informational, 3.3.1, 4.5

location, 4.5

server log, 3.3.1

turn off, 4.5

metadata, TimesTen, 8.2.1.8

min_subs attribute

timesten.conf file, 4.3.2

modifying execution plan

overview, 9.4

monitor command

ttIsql utility, 6.9, 6.9.5

multi-threaded server, 10.2.9

---

N

names

log files, 7.6.1

maximum, 8.2.1.4

nested subqueries

performance, 10.3.11

Network Address for logical server

Linux and UNIX, 3.2.4.2

ttLocalHost, 3.1.2.3

ttShmHost, 3.1.2.2

Windows, 3.2.4.1

NFS mounted systems

restriction, 7.6.2

NLS_LENGTH_SEMANTICS connection attribute, 5.3

NLS_LENGTH_SEMANTICS general connection attribute, 5.3

NLS_SORT connection attribute, 5.5.4

NLSSORT SQL function, 5.5.4

non-durable commit, 10.5.3

non-durable commits

advantages and disadvantages, 10.5.3

noserverlog attribute

timesten.conf file, 4.4.6

not inline columns, 8.2.1.2

NULL values, sorting, 8.5

nullable columns

definition, 8.2

primary key not nullable, 8.2.1.6

---

O

ODBC

cancel function, 6.20.1

JDBC driver, 1.1.2

timing function calls, 6.20.2

tracing and performance, 10.1.13

odbc.ini file, 1.2.1, 1.2.1, 1.7.3

default DSN, 1.6.3

defined, 3.2.3

entry example, 1.7.3

format, 1.7.3

format of, 1.7.3

online help, 6.4

OPERATION column in PLAN table, 9.3.1.3.3

optimizer

application hints, 9.1

example scenario, 9.1, 9.1

generating plan, 9.3.1.1

hints, 9.4.3

statement level, 9.4.3.1

ttOptSetFlag built-in procedure, 10.2.5

invalid statistics, 9.1, 10.3.9

modifying execution plan, 9.4

PLAN row example, 9.3.1.2

query plan, 9.3.1

reading plan, 9.3.1.2

specifying hints, 9.4.3

optprofile command

ttIsql utility, 6.19.1

OTHERPRED column in PLAN table, 9.3.1.3.7

OUT parameters, 6.16

out-of-memory warnings, 2.5.4

owners

of indexes, 8.5.2

---

P

packages command

ttIsql utility, 6.10

parameterized SQL statements, 6.13

partition

defragment, 2.9

performance

ALTER TABLE, 10.3.10

altered tables, 10.3.10

application tuning

autocommit mode, 10.5.5

checkpoints, 10.5.4

connection overhead, 10.1.7

durable commits, 10.5.3

maintenance options, 10.1.11

ODBC tracing, 10.1.13

transaction roll back, 10.5.6

transaction size, 10.5.2

autocommit, 7.2.1, 7.2.1

automatic index creation, 8.2.1.5

character set, 5.2.3

conversion, 5.4

checkpoints, 10.5.4

Client, 10.2.2

Client/Server statistics, 10.2.1

database tuning

driver usage, 10.1.12

specifying size, 10.1.3

foreign key constraint, 10.3.5

index, 10.3.1

isolation modes, 10.2.5.2

lock wait timeout interval, 10.2.4

materialized view recommendations, 10.4

materialized views, 10.4.4

nested subqueries, 10.3.11

PLSQL_TIMEOUT, 10.3.16

SQL

execution times, 10.3.2

histogram, 10.3.2

sampling data, 10.3.2

statistics, 10.3.2

SQL tuning

indexes, 10.3.1

prepare operations, 10.3.13

SQLQueryTimeout, 10.3.16

SQLQueryTimeoutMSec, 10.3.16

temporary databases, 10.1.6

transaction recommendations, 10.5

TTC_ConnectTimeout, 10.2.3, 10.3.16

TTC_Timeout, 10.2.3, 10.3.16

tuning, 10

working locally, 10.2.2

permanent memory region, 2.5.1

PermSize attribute, 2.5, 2.5, 2.5.3

monitoring, 2.5.2

specifying, 10.1.3

PermSize connection attribute, 2.6.1

PermWarnThreshold attribute, 2.5.4

phantoms, 10.2.5.2

plan

See execution plan, 9.3.1.3

PLAN rows, 9.3.1.2

PLAN table

columns, 9.3.1.3

IXNAME column, 9.3.1.3.5

LEVEL column, 9.3.1.3.2

OPERATION column, 9.3.1.3.3

OTHERPRED column, 9.3.1.3.7

PRED column, 9.3.1.3.6

STEP column, 9.3.1.3.1

TBLNAME column, 9.3.1.3.4

PLSCOPE_SETTINGS connection attribute, 1.6.2

PL/SQL

creating and executing blocks, 6.15

host variables

using ttIsql, 6.13

objects

using ttIsql to list, 6.10

shared memory sizing, 10.1.4

PLSQL_MEMORY_ADDRESS connection attribute, 1.6.2

PLSQL_MEMORY_SIZE connection attribute, 1.6.2, 10.1.4

PLSQL_OPTIMIZE_LEVEL connection attribute, 1.6.2

PRED column in PLAN table, 9.3.1.3.6

limit on length, 9.3.1.3.6

prefetch multiple update records, 10.8.2

prepare command

ttIsql utility, 6.13

prepared SQL statements, 6.13

PreparedStatement objects, 9.4.2, 9.4.2

preparing statements, 9.3.1, 9.3.1

primary keys, 8.2.1.6

NOT NULL, 8.2.1.6

See Also unique index

PrivateCommands connection attribute, 10.7.6

procedures command

ttIsql utility, 6.10

PWD connection attribute, 3.2.5.1.2

---

Q

query

plan, 9.3.1

query optimizer

plans, 9.1

viewing with ttIsql, 6.19.1

See optimizer

query plan

display, 6.19.2.2

hints, 9.4.3.1

---

R

RAM policy

always, 2.3

changes after database invalidation, 2.3

changes after failure, 2.3.1

defined, 2.3

inUse, 2.2.1, 2.2.2, 2.3

inUse with RamGrace, 2.3

manual, 2.2.1, 2.2.2, 2.3

overview, 2.2

setting, 2.2.1, 2.2.2, 2.3

range index, 10.3.3

overview, 8.5.1

reclaim operations

transaction, 7.8

configuring commit buffer, 7.8.2

recovery, 2.3.1, 2.3.2, 7.9

tuning, 10.6

RecoveryThreads connection attribute, 10.6

REF CURSOR

using ttIsql, 6.13

referencing indexes, 8.5.4

remote database

accessing on Linux and UNIX, 3.2.4.2, 3.2.5.2, 3.4, 3.4.1

accessing on Windows, 3.2.5.1.3

removing

columns, 8.2.1.1

rows, 8.2.1.1

replication

active standby pair

high availability, 7.7.2

aging, 8.2.3.5

character sets, 5.2.4

FAILTHRESHOLD clause, 2.6.1

limit transaction log file accumulation, 2.6.1

TimesTen daemon, 4

replication agent

pause, 2.2.2

set state, 2.2.2

start, 2.2.1

.res files, 7.6.1

Restoring data, 2.7, 2.7.2, 2.7.2

restrictions on table names, 8.2.1.4

return twosafe

definition, 7.7.2.1

roll back

logs and locks, 7.3.1

performance impact, 10.5.6

rollback command

ttIsql utility, 6.12

row-level locks, 7.4.2

rows

adding, 8.2.1.1

deleting, 8.6.2

inline and out-of-line portions, 8.2.1.2

inserting, 8.6.1

understanding, 8.6

---

S

semantics

byte, 5.3

character, 5.3

length considerations, 5.3

Serializable isolation mode, 7.4.1

serializable transaction

performance, 10.2.7

server

logical name, 3.2.4.1

multi-threaded, 10.2.9

Server

controlling, 4.4.2

creating a DSN, 3.2.3, 3.2.3

creating logical name, 3.2.4.1

on Linux and UNIX, 3.2.4.2

described, 3.3

modifying attributes, 4.4.1

name, 3.2.4.1, 3.2.5.1.1

creating on Windows, 3.2.4.1

number of processes, 4.4.4.2

port number, 4.4.2

prespawning processes, 4.4.3

Server List dialog, 3.2.4.1

Server Name Setup dialog, 3.2.4.1

specifying number of connections, 4.4.4

starting, 3.3, 4.4.2

stopping, 3.3

thread stack size, 4.4.4.3

server attribute

timesten.conf file, 4.4.2

Server daemon

modifying attributes, 4.4.1

Server DSN, 3.2.3

Server log messages

controlling, 4.4.6

server_pool attribute

timesten.conf file, 4.4.3

server_shmipc attribute

timesten.conf file, 4.4.5

server_shmsize attribute

timesten.conf file, 4.4.5.2

server_stack_size attribute

timesten.conf file, 4.4.4.3

servers_per_dsn attribute

timesten.conf file, 4.4.4.2

ServersPerDSN connection attribute, 3.2.3

ServerStackSize connection attribute, 3.2.3

setjoinorder command

ttIsql utility, 6.19.1

setuseindex command

ttIsql utility, 6.19.1

shared memory

changing size, 4.4.5.2

Client/Server IPC, 4.4.5

Client/Server, managing size, 4.4.5.1

IPC-enabled server, 4.4.5

sizing, 10.1.4

shared memory key

specify range, 4.3.3

shared memory segment

managing size, 4.4.5.1

size, 4.4.5.2

shmkey_range daemon attribute, 4.3.3

showplan command, 6.13, 6.19.1

ttIsql utility, 6.19.1

single-instance database, 2.10

size

database, 2.5

sizing

hash indexes, 10.3.4

transactions, 10.5.2

sorting NULL values, 8.5

SQL

parameterized statements, 6.13

prepared statements, 6.13

query plan, 9.3.1

tuning and performance, 10.3

SQL command cache

invalidated, 9.1

invalidation, 10.3.9

viewing commands, 6.19.2.1

SQLPrepare, 9.3.1

execution plan generation, 9.4.2

performance impact, 10.3.13

sqlquerytimeout command

ttIsql utility, 6.12

statistics

collected, 10.1.14

computing, 10.3.6

evaluate, 10.2.1

generate script to restore, 10.3.8

recomputation, 9.1, 9.1, 10.3.9

SQL statements, 10.3.2

tools, 10.2.1

ttOptEstimateStats, 10.3.6

ttOptUpdateStats, 10.3.6

update, 8.5.6.1

STEP column in PLAN table, 9.3.1.3.1

storage

provisioning, 2.6

subdaemons

minimum required, 4.3.2

services performed, 4.3.2

setting allowable number, 4.3.2

specifying allowable range, 4.3.2

subqueries

nested

performance, 10.3.11

supportlog attribute

timesten.conf file, 4.5

supportlog configuration attribute, 4.5.1

synchronous checkpoints

See static checkpoints

synonym

create, 8.7, 8.7.1

definition, 8.7

drop, 8.7.2

invalidation, 8.7.3

private, 8.7

public, 8.7

recompiled, 8.7.3

viewing, 8.7

SYS owner of tables, 8.2.1.4

SYS.GV$CKPT_HISTORY system view, 7.5.4.3, 7.5.4.4, 7.6.3.3

SYS.GV$LOG_HOLDS system view, 7.6.3.2, 7.6.3.3

syslog

specify facility, 4.5

SYS.MONITOR table, 2.5.2

SYS.SYSTEMSTATS table, 7.6.3.3, 10.2.1, 10.5.3, 10.8.1

system DSN, 3.2.4.1, 3.2.5.1.4

system failure

resulting logs and locks, 7.3.1

system tables

indexes on, 8.5.2

overview, 8.2.1.8

system view

global, 8.8

local, 8.8

SYSTTCONNECTINI environment variable, 3.2.4.2

sys.ttconnect.ini file, 3.2.4.2

SYS.V$CKPT_HISTORY system view, 7.5.4.3, 7.5.4.4, 7.6.3.3

SYS.V$LOG_HOLDS system view, 7.6.3.2, 7.6.3.3

---

T

table

calculating size, 6.9.4

compression, 10.3.14

creating, example, 8.2.2.1, 8.2.2.1

deleting rows, 8.6.2

dropping, example, 8.2.2.2, 8.4.2.2

estimating size, 8.2.2.3

format, 8.2

inline vs. not inline columns, 8.2.1.2

inserting rows, 8.6.1

load Oracle Database data, 6.18

modifying format, 8.2.1.1

name length, 8.2.1.4

names, 8.2.1.4

restrictions, 8.2.1.4

nullable columns, 8.2

owners, 8.2.1.4

performance, 10.3.10

size

estimating, 8.2.2.3

ttSize utility, 8.2.2.3

SYS owner, 8.2.1.4

understanding rows, 8.6

unique indexes

table-level locks, 7.4.2

tablesize command, 6.9

ttIsql utility, 6.9.4

TBLNAME column in PLAN table, 9.3.1.3.4

TCP/IP

Client/Server

communication, 3.1.2.1

Temporary attribute

performance, 10.1.6

TempSize attribute, 2.5, 2.5, 10.1.3

monitoring, 2.5.2

testing connections on Windows, 3.2.5.1.4

thread programming, 2.8

time-based aging, 8.2.3.2

Timeout connection attribute, 3.2.5.1.2

timeout interval

setting on Windows, 3.2.5.1.2, 3.2.5.1.2

TimesTen

ODBC driver, 1.1.1

TimesTen Classic

single-instance, 2.10

TimesTen daemon

options, 4.3

TImesTen Scaleout

distributed database, 2.10

timesten.conf, 4.3

timesten.conf file, 3.2.3, 4.3, 4.3.2, 4.4.5, 4.5, 4.5

allow_network_files attribute, 7.6.2

changing, 4.3

daemon_log_snippet_interval_in_mins, 4.5.1

enableIPv6, 4.3.1.1

facility attribute, 4.5

listen_6_addr attribute, 4.3.1.1

listen_addr attribute, 4.3.1, 4.3.1

logging, 4.5.1

max_conn_per_server attribute, 4.4.4

max_subs attribute, 4.3.2

max_support_log_files attribute, 4.5

max_support_log_size option, 4.5

min_subs attribute, 4.3.2

noserverlog attribute, 4.4.6

server option, 4.4.2

server_pool attribute, 4.4.3

server_shmipc attribute, 4.4.5

server_shmsize attribute, 4.4.5.2

server_stack_size attribute, 4.4.4.3

servers_per_dsn attribute, 4.4.4.2

shmkey_range daemon attribute, 4.3.3

specify syslog facility, 4.5

supportlog, 4.5.1

supportlog attribute, 4.5

turn off messages, 4.5

verbose attribute, 4.5

timestend, 4

timing command

ttIsql utility, 6.20.2

transaction

commit

buffer sizing, impact, 10.5.8

logs and locks, 7.3.1

durable commit, 10.5.2

locking, 10.2.5

log buffer, 7.6.1

strands, 7.6.1

log files, 7.6.3.2

accumulation, 7.6.3, 7.6.3.3

CkptFrequency attribute, 7.6.3.2

CkptLogVolume attribute, 7.6.3.2

concurrency, 7.6.1

holds, 7.6.3.1

how to control, 7.6.1

location, 7.6.1

monitor, 7.6.3

monitoring, 7.6.3.3

names, 7.6.1

performance, 7.6.1

purging, 7.6.3.2

sequence number, 7.6.3.3

sizing, 7.6.1

logging, 7.6.1

management

isolation levels, 7.4

locking, 7.3.1

logging, 7.3.1

semantics, 7.3.1

performance, 7.7, 10.5.2, 10.5.3

reclaim operations, 7.8

configuring commit buffer, 7.8.2

roll back

logs and locks, 7.3.1

performance impact, 10.5.6

ttXactAdmin utility, 7.6.3.1

serializable

performance, 10.2.7

sizing, 10.5.2

synchronization, 7.7.2.1

ttIsql utility, 6.12

tuning recommendations, 10.5

XLA, 10.8.1

transaction log file

accumulation, 7.6.3.3

transaction log files

accumulation, 2.6.1

limit accumulation, 2.6.1, 2.6.1

storage provisioning, 2.6.1

tryhash command

ttIsql utility, 6.19.1

trymergejoin command

ttIsql utility, 6.19.1

trynestedloopjoin command

ttIsql utility, 6.19.1

tryrange command

ttIsql utility, 6.19.1

tryrowid command

ttIsql utility, 6.19.1

tryserial command

ttIsql utility, 6.19.1

trytbllocks command

ttIsql utility, 6.19.1

trytmphash command

ttIsql utility, 6.19.1

trytmprange command

ttIsql utility, 6.19.1

trytmptable command

ttIsql utility, 6.19.1

TT_PREFETCH_CLOSE connection option, 10.2.7

TT_STATS PL/SQL package, 10.1.14, 10.2.1

ttAdmin utility, 2.2.2

-autoreload, 2.3.2

-cacheStart command, 2.2.1

-cacheStop command, 2.2.2

close database, 2.1, 2.2.2

-disconnect command, 2.2.2, 2.4.2, 4.2.1

-abort option, 2.4.2

-immediate option, 2.4.2

-transactional option, 2.4.2

-noautoreload, 2.3.2

open database, 2.1, 2.2.1

-ramLoad command, 2.2.1, 2.3

-ramPolicy command, 2.2.1, 2.2.2, 2.3

-ramUnload command, 2.2.2, 2.3

-repStart command, 2.2.1

ttAdmin utlity

-disconnect command, 2.2.2

ttAgingLRUConfig built-in procedure, 8.2.3.1

ttBlockInfo utility, 2.5.2

ttBulkCp, 2.7

-directload mode, 2.7.2

-i mode, 2.7.2

-o mode, 2.7.1

ttBulkCp utility

-directLoad mode, 2.7.2

-i mode, 2.7.2

multi-threaded, 2.7.2

TTC_ConnectTimeout connection attribute

connection attributes

TTC_ConnectTimeout, 10.2.3, 10.3.16

TTC_TCP_KEEPALIVE_INTVL_MS connection attribute, 3.2.7

TTC_TCP_KEEPALIVE_PROBES connection attribute, 3.2.7

TTC_TCP_KEEPALIVE_TIME_MS connection attribute, 3.2.7

TTC_TIMEOUT connection attribute, 3.2.5.1.2

ttCkpt built-in function, 7.6.3.2, 7.6.3.2

ttCkptConfig built-in procedure, 7.5.4.4

ttCkptHistory built-in procedure, 7.5.4.3, 7.5.4.4, 7.6.3.3

ttCommitBufferStats built-in procedure, 7.8.2

ttCommitBufferStatsReset built-in procedure, 7.8.2

ttConfiguration built-in procedure

ttGridEnable attribute, 2.10

ttconnect.ini file, 3.2.4.2

ttDaemonAdmin utility

-restartserver command, 3.2.3

-stop command, 2.2.2

ttDaemonLog utility, 4.5

ttDbWriteConcurrencyModeGet built-in procedure, 10.3.15

ttDbWriteConcurrencyModeSet built-in procedure, 10.3.15

ttDurableCommit built-in procedure, 7.7.2.2

ttDurableCommit procedure, 10.5.3

tterrors.log file, 4.5

ttGridAdmin utility

dbDisconnect command, 2.4.1

ttGridEnable attribute, 2.10

ttIndexAdviceCaptureDrop built-in procedure, 8.5.6.4

ttIndexAdviceCaptureEnd built-in procedure, 8.5.6.2

ttIndexAdviceCaptureInfoGet built-in procedure, 8.5.6.3

ttIndexAdviceCaptureOutput built-in procedure, 8.5.6.3

ttIndexAdviceCaptureStart built-in procedure, 8.5.6.2

ttInstanceModify utility, 4.3

ttIsql, 6.4

autocommit command, 6.12

built-in command usage, 6.9, 6.12, 6.13, 6.19.1

cachegroups command, 6.9, 6.9.2

clearing command history, 6.6.1

cmdcache command, 6.19.2.1

command history, 6.6

commit command, 6.12

commitdurable command, 6.12

connect command, 6.20.2

customizing command prompt, 6.3

deleting rows, 8.6.2

describe command, 6.9, 6.9.1

displaying database information, 6.9

dssize command, 6.9, 6.9.3

editline feature, 6.5

error recovery, 6.21

explain command, 6.19.2.2

IF command, 6.17

isolation command, 6.12

modes, interactive and batch, 6.1

monitor command, 6.9, 6.9.5

online help, 6.4

rollback command, 6.12

saving command history, 6.6.1, 6.6.1

showplan command, 6.19.1

sqlquerytimeout command, 6.12

tablesize command, 6.9.4

timing command, 6.20.2

timing ODBC function calls, 6.20.2

using, 6

using OUT parameters, 6.16

variable, 6.14, 6.14.2

view and set connection attributes, 6.11

viewing optimizer plan, 6.19.1

WHENEVER SQLERROR, 6.21

working with character sets, 6.8

working with parameterized SQL statements, 6.13

working with prepared SQL statements, 6.13

working with transactions, 6.12

TTISQL environment variable, 6.2

ttIsql utility

createandloadfromoraquery command, 6.18, 6.18.1

history command, 6.6

ttLoadFromOracle built-in procedure, 6.18, 6.18.2

cancel, 6.18.2

ttLocalHost

logical server address, 3.1.2.3

ttLockWait built-in procedure, 10.2.4

ttLogHolds built-in procedure, 7.6.3.2, 7.6.3.3

ttmesg.log file, 4.5

ttMigrate utility

use in defragmentation, 2.9

offline, 2.9.2

online, 2.9.3

ttOptClearStats built-in procedure, 9.4.3.2

ttOptCmdCacheInvalidate built-in procedure, 10.3.9

ttOptEstimateStats built-in procedure, 8.5.6.1, 9.4.3.2

statistics computing, 10.3.6

ttOptGetFlag built-in procedure, 9.4.3.2

ttOptSetColIntvlStats built-in procedure, 9.4.3.2

ttOptSetFlag built-in procedure, 8.5.6.1, 9.4.3.2, 10.2.5

ttOptSetOrder built-in procedure, 9.4.3.2

ttOptSetTblStats built-in procedure, 8.5.6.1, 9.4.3.2

ttOptStatsExport built-in procedure, 10.3.8

ttOptUpdateStats built-in procedure, 8.5.6.1, 9.4.3.2

ttOptUseIndex built-in procedure, 9.4.3.2

ttRamPolicyAutoReloadSet built-in procedure, 2.3.2

ttRepAdmin utility, 2.2.2

use in defragmentation, 2.9

online, 2.9.3

ttSchema utility

view index definitions, 2.7.2.2

ttShmHost

logical server address, 3.1.2.2

ttSize utility, 2.5.1

ttSQLCmdCacheInfo built-in procedure, 6.19.2.1, 9.2.2, 10.3.2

ttSQLCmdQueryPlan built-in procedure, 6.19.2.2

ttSQLExecutionTimeHistogram built-in procedure, 10.3.2

ttStats utility, 10.1.14, 10.2.1

ttStatsConfig built-in procedure, 10.3.2

ttStatus utility, 2.2.2, 2.4.2

ttTableSchemaFromOraQueryGet built-in procedure, 6.18, 6.18.2

cancel, 6.18.2

ttWarnOnLowMemory procedure, 2.5.4

ttXactAdmin utility, 7.6.3.1

---

U

UID connection attribute, 3.2.5.1.2, 8.1.2

unique index, 8.5

creating, 8.2.1.6

See also primary key

UNIX

configuration file

odbc.ini, 1.7.3, 1.7.3

setting attributes, 1.3.1

socket

Client/Server communication, 3.1.2.3

stopping daemon, 4.1

unsetjoinorder command

ttIsql utility, 6.19.1

unsetuseindex command

ttIsql utility, 6.19.1

usage-based aging, 8.2.3.1

---

V

variable

automatically created, 6.14.2

declaring, 6.14

verbose attribute

timesten.conf file, 4.5

view

creating, 8.3.1

drop, 8.3.2

overview, 8.3

restrictions, 8.3.3

SELECT query, 8.3.1.1

---

W

warning messages, 4.5

WHENEVER SQLERROR command, 6.21

Windows

setting timeout interval, 3.2.5.1.2

---

X

XLA

performance, 10.8.1

updates

acknowledging, 10.8.3