16/16

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

access control, 4

authorizing, 4.2.1

overview, 4.2

acknowledging updates, 10.8.2

active standby pair

aging, 8.2.3.5

ADMIN privilege, 4.2.1.1, 4.2.2

administrator

privileges, 4.2.1.1

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

aging, see also LRU aging

ALL keyword, 4.2.3.1

system privileges, 4.2.2.2

ALL_TAB_PRIVS view, 4.2.6

ALL_USERS view, 4.1.2

allfunctions command

ttIsql utility, 6.10

-allowNetworkFiles option

ttendaemon.options file, 3.3.4

allpackages command

ttIsql utility, 6.10

allprocedures command

ttIsql utility, 6.10

ALTER ANY CACHE GROUP privilege, 4.2.5.2

ALTER ANY privilege, 4.2.2.5.1, 4.2.3.7

ALTER SESSION SQL statement, 5.7

ALTER TABLE

adding and removing columns, 8.2.1.1

performance, 10.3.10

REFERENCES privilege, 4.2.3.6

ANY system privileges, 4.2.2.5

application

failure

use of logs and locks, 7.3.1

linking

direct, 1.1

linking with driver manager, 1.1

shut down, 3.2

asynchronous checkpoints

See fuzzy checkpoints

attributes

connection, 2.2.5

database name, 1.6.4

PermWarnThreshold, 1.11.4

setting for UNIX, 1.3.2.1

specifying, 1.3.1.3

TempWarnThreshold, 1.11.4

viewing and changing by ttIsql, 6.11

AUTO_ACKNOWLEDGE mode, 10.8.2

autocommit

performance impact, 10.5.4

autocommit command

ttIsql utility, 6.12

automatic client failover, 2.2.6

---

B

batch mode

ttIsql, 6.1

bitmap index, 10.3.3

when used, 8.5.1

byte semantics, 5.3, 5.3

---

C

cache group

altering, 4.2.5.2

creation, 4.2.5.2

dropping, 4.2.5.2

granting privileges, 4.2.5

privileges, 4.2.1.2, 4.2.5.3

required privileges for AWT, 4.2.5.1

time-based aging, 8.2.3.2

CACHE_MANAGER privilege, 4.2.5.1

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

TIMESTEN8, 5.7.1

working with in ttIsql, 6.8

checkpoints

automatic, 8.1.3

fuzzy

influences on duration, 7.5

performance, 10.5.3

setting and managing, 7.5.4

static

CkptFrequency connection attribute, 7.6.2.1

CkptLogVolume connection attribute, 7.6.2.1

CkptReadThreads connection attribute, 10.6.2

client

configuring authentication on Windows, 2.2.5.1.2

configuring automatic failover on UNIX, 2.2.6.2.2

configuring automatic failover on Windows, 2.2.6.2

connection attributes

described, 2.2.3, 2.2.5

creating DSN

on UNIX, 2.2.5.2

on Windows, 2.2.5.1.1

performance, 10.2.2

setting timeout interval on Windows, 2.2.5.1.2

client DSN

creating, 2.2.5.2

creating on UNIX, 2.2.5.2

creating on Windows, 2.2.5.1.1

Data Source Setup dialog, 2.2.5.1.1

name, 2.2.5.1.1, 2.2.5.1.1

client failover

automatic client failover, 2.2.6

CLIENT_ACKNOWLEDGE mode, 10.8.3

Client/Server

changing shared memory segment size, 3.4.5.2

communication

overview, 2.1.2

configuring, 2.2

connections across bit-levels, 2.2.2.2

connections across releases, 2.2.2.2

managing shared memory segment size, 3.4.5.1

performance, 10.2.1

shared memory, 3.4.5.2

TCP/IP communication, 2.1.2.1, 2.1.2.1

UNIX socket communication, 2.1.2.3, 2.1.2.3

Client/Server communication

shared memory, 3.4.5

TCP/IP, 3.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.7.2

commit command

ttIsql utility, 6.12

CommitBufferSizeMax connection attribute, 7.7.2

commitdurable command

ttIsql utility, 6.12

compression

table, 10.3.14

concurrency

locking, 7.4, 10.2.4.1

types of isolation, 7.4

configuring

Client/Server, 2.2

connect

using connection string, 1.8

connect command

ttIsql utility, 6.20.2

connection

locking, 10.2.4

locks, 10.2.3

performance overhead, 10.1.6

setAutoCommit method, 7.2.1

testing on Windows, 2.2.5.1.4

timeout interval, 10.2.3

Connection

setAutoCommit method, 7.2.1

connection attribute

CommitBufferSizeMax, 7.7.2

connection, 2.2.3

LockLevel, 10.2.4

LogFlushMethod, 10.5.2

PermSize, 1.11, 1.11

PLSCOPE_SETTINGS, 1.6.3

PLSQL_MEMORY_ADDRESS, 1.6.3

PLSQL_MEMORY_SIZE, 1.6.3

PLSQL_OPTIMIZE_LEVEL, 1.6.3

TempSize, 1.11, 1.11

UID, 8.1.2

UNIX, 1.3.2.1

connection character set, 2.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

Connection.setAutoCommit methods, 7.2.1

contention

lock, 10.1.9

CREATE ANY CACHE GROUP privilege, 4.2.5.2

CREATE ANY privilege, 4.2.2.5.1

CREATE ANY SYNONYM statement, 4.2.3.8

CREATE ANY TABLE privilege, 4.2.5.2

CREATE CACHE GROUP privilege, 4.2.5.2

CREATE INDEX statement, 8.5.2

CREATE OR REPLACE SYNONYM statement, 4.2.3.8, 8.7.1

CREATE privilege, 4.2.2.5.1

CREATE PUBLIC SYNONYM statement, 4.2.3.8

CREATE SESSION privilege, 4.2.2.3, 4.2.2.3

CREATE SYNONYM statement, 4.2.3.8, 8.7.1

CREATE TABLE privilege, 4.2.5.2

createandloadfromoraquery command, 6.18, 6.18.1

cancel, 6.18.1

creating, 8.5.2

Custom setup, Windows, 1.1.1

---

D

daemon

control operations, 3.3.3

informational messages on Windows

listener, 3.3.1

IPv4 protocol, 3.3.1.1

listening address, 3.3.1, 3.3.1

modifying options, 3.4.1

options, 3.3

options, see ttendaemon.options file

overview, 3

starting

UNIX, 3.1.2, 3.1.2

Windows, 3.1.1, 3.1.1

stopping

UNIX, 3.1.2, 3.1.2

Windows, 3.1.1, 3.1.1

data

permanent, 1.11

temporary, 1.11

Data Manager

starting, 3.1.1

starting service, 3.1.1

stopping, 3.1.1

stopping service, 3.1.1

Data Manager service, 3.1.1

data source names, See DSN

database

accessing on a local system, 2.1.2.3

accessing on a remote system, 2.1.2.1

automatic recovery, 1.9.1, 1.9.2

changing size of, 1.11

character set, see character set

components, 8.1.1, 8.1.1

connecting, 4.2.2.3, 4.2.2.3

contention, 10.1.9

definition, 1

defragment, 1.14

getting information with ttIsql, 6.9

loading to memory, 1.10.1

lock contention, 10.1.9

owner, 8.1.2

path names, environment variables in, 1.3.2.2

permanent, 8.1.3

prefix name, 1.3.2.1

prevent automatic reload, 1.9.2

recovery, 7.8

policyInactive mode, 1.9.1

setting attributes for UNIX, 1.3.2.1

sizing, 10.1.2

specification, 1.7.2

specifying size, 10.1.2

statistics, 10.1.14

TCP/IP Client/Server access, 2.1.2.1

temporary, 1.6.2, 8.1.3, 10.1.5

performance, 10.1.5

UID connection attribute, 8.1.2

UNIX configuration files, 1.7.3

UNIX socket Client/Server access, 2.1.2.3

unloading from memory, 1.10.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

DBA_SYS_PRIVS view, 4.2.2, 4.2.2.1, 4.2.6

DBA_TAB_PRIVS view, 4.2.2.1, 4.2.6

DBA_USERS view, 4.1.2

DDLCommitBehavior connection attribute, 7.2.2

default column values, 8.2.1.3

default DSN, 1.6.1

defragment

database, 1.14

partition, 1.14

DELETE ANY privilege, 4.2.2.5

DELETE privilege, 4.2.3.2

deleting

rows, 8.6.2

Windows server name, 2.2.4.1

describe command

ttIsql utility, 6.9, 6.9.1, 6.13

detail table, 8.4.1

diagnostics

SNMP traps, 1.11.4

driver

JDBC, 1.3.1.1

DRIVER attribute, 1.3.2.1

driver manager

JDBC, 1.1.2

linking with, 1.1

ODBC, 1.1

DriverManager.getConnection method, 2.2.5, 2.2.5

drop

materialized view, 8.4.2.2

materialized view log, 8.4.2.2

DROP ANY CACHE GROUP privilege, 4.2.5.2

DROP ANY privilege, 4.2.2.5.1

DROP ANY SYNONYM statement, 4.2.3.8

DROP PUBLIC SYNONYM statement, 4.2.3.8

DROP SYNONYM statement, 8.7.2

dropping

indexes, 8.5.4

tables, example, 8.2.2.2

DSN, 4.2.2.3

client, 1.2.2, 2.2.5.1.1

Client, 1.2.2, 2.2.5

connection attributes, Data Manager, 1.2.3

Data Manager, 1.2.2

default, 1.6.1

example, 1.6

example, Windows

finding in order of precedence, 1.5

maximum length, 1.2

naming rules, 1.2

number of server processes, 3.4.4.2

.odbc.ini file, 1.2.1

setting attributes, 1.6.4

system, 1.2.1

user, 1.2.1

dssize command

ttIsql utility, 6.9, 6.9.3

DUPS_OK_ACKNOWLEDGE mode, 10.8.2

durability

overview, 7.3.2

durable commit

performance, 10.5.2

transaction, 10.5.1

---

E

editline for ttIsql, 6.5

-enableIPv6 option

ttendaemon.options file, 3.3.1.1

-enablePolicyInactive option

ttendaemon.options file, 1.9.1, 3.3.6

encoding

character set, 5.2.1

enhanced write concurrent mode, 10.3.15

environment variables

in database path names, 1.3.2.2

TTISQL, 6.2

examples

creating indexes, 8.5.2

creating tables, 8.2.2.1

drop materialized view, 8.4.2.2

drop materialized view log, 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

EXECUTE ANY privilege, 4.2.2.5

EXECUTE privilege, 4.2.3.7

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 option

ttendaemon.options file, 3.3.2

failover, 2.2.6

configuring for client on UNIX, 2.2.6.2.2

configuring for client on Windows, 2.2.6.2

fetchall command

ttIsql utility, 6.13

fetchone command

ttIsql utility, 6.13

files

odbc.ini, 1.2.1, 1.7.3

ttendaemon.options, 3.3, 3.3.3, 3.4.5

first connection attribute, 4.2.2.3

CkptReadThreads, 10.6.2

PLSQL_MEMORY_SIZE, 10.1.3

FLUSH ANY CACHE GROUP privilege, 4.2.5.2

FLUSH privilege, 4.2.5.3

foreign key

constraint

performance, 10.3.5

REFERENCES privilege, 4.2.3.6

fragmentation

block-level, 1.11.3

free command

ttIsql utility, 6.13

functions

object privileges, 4.2.3.7

functions command

ttIsql utility, 6.10

fuzzy checkpoints, definition

---

G

getConnection method, 2.2.5

globalization, 5

character set, 5

GRANT ALL command, 4.2.2.2, 4.2.3.1

GRANT command, 4.2.2, 4.2.3

---

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

hints

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

automatic creation, 8.2.1.5, 8.2.1.5

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

referencing, 8.5.4

See also range index

See also bitmap index

See also hash indexes

unique, 8.5, 8.5

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 privilege, 4.2.3.2, 4.2.3.5

index size

estimating, 8.5.5

ttSize utility, 8.5.5

informational messages

modifying, 3.3.2

inline columns, 8.2.1.2

INSERT ANY privilege, 4.2.2.5

INSERT privilege, 4.2.3.2

inserting rows, 8.6.1

interactive mode

ttIsql, 6.1

I/O

performance, 10.5.1

IPC

Client/Server communication, 3.4.5

isolation command

ttIsql utility, 6.12

isolation level

performance, 10.2.4.2

isolation modes

described, 7.4

performance, 10.2.4.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

large page support

Linux, 3.3.5

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

large page support, 3.3.5

-linuxLargePageAlignment option

ttendaemon.options file, 3.3.5

-listenaddr entry

ttendaemon.options file, 3.3.1

-listenaddr option

ttendaemon.options file, 3.3.1

-listenaddr6 option

ttendaemon.options file, 3.3.1.1

LOAD ANY CACHE GROUP privilege, 4.2.5.2

LOAD privilege, 4.2.5.3

LockLevel connection attribute, 10.2.4

locks

coexistence of different levels

concurrency, 10.2.4.1

database-level, 7.4.2, 10.2.4.1

overview table, 7.3.1

performance, 10.2.4

reduce contention, 10.1.9

row-level, 7.4.2, 10.2.4.1

See also ttLockLevel

set wait time, 7.4.2.1

table-level, 7.4.2, 10.2.4.1

timeout interval and performance, 10.2.3

LockWait attribute, 7.4.2.1

log files

accumulation, 7.6.2, 7.6.2.3

CkptFrequency attribute, 7.6.2.1

CkptLogVolume attribute, 7.6.2.1

hold, 7.6.2.2

monitoring, 7.6.2, 7.6.2.3

purging, 7.6.2.1

sequence number, 7.6.2.3

ttCkpt built-in function, 7.6.2.1

LogFlushMethod connection attribute, 10.5.2

logging

managing, 3.4.6

overview table, 7.3.1

temporary database, 8.1.3

logical server

Network Address, 2.1.2.3, 2.2.4.1, 2.2.4.2

logical server name

creating on UNIX, 2.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

asynchronous

create, 8.4.2.1.2

overview, 8.4.1.2

create, 8.4.2.1

detail table, 8.4.1

drop, 8.4.2.2, 8.4.2.2

invalidated, 4.2.3.5.1

performance, 8.4.2.4.2

privileges, 4.2.3.5

restrictions, 8.4.2.3

SELECT queries in, 8.4.2.1.3

synchronous

create, 8.4.2.1.1

overview, 8.4.1.1

tuning recommendations, 10.4

outer join, 10.4.4

understanding, 8.4

materialized view log

drop, 8.4.2.2, 8.4.2.2

-maxConnsPerServer option

ttendaemon.options file, 3.4.4

maximum name length, 8.2.1.4

-maxsubs option

ttendaemon.options file, 3.3.3

-maxsupportlogfiles option

ttendaemon.options file, 3.3.2

-maxsupportlogsize option

ttendaemon.options file, 3.3.2

-maxuserlogfiles option

ttendaemon.options file, 3.3.2

-maxuserlogsize option

ttendaemon.options file, 3.3.2

memory

loading a database into, 1.10.1

permanent, 1.11

policy for loading a database, 1.9

regions, 1.11

temporary, 1.11

unloading a database from, 1.10.2

messages

informational, 2.3.1, 3.3.2

server log, 2.3.1

turn off, 3.3.2

metadata, TimesTen, 8.2.1.7

-minsubs option

ttendaemon.options file, 3.3.3

modifying execution plan

overview, 9.4

monitor command

ttIsql utility, 6.9, 6.9.5

---

N

names

log files, 7.6.1

maximum, 8.2.1.4

nested subqueries

performance, 10.3.11

Network Address for logical server

ttLocalHost, 2.1.2.3

ttShmHost, 2.1.2.2

UNIX, 2.2.4.2

Windows, 2.2.4.1

NFS mounted systems

restriction, 3.3.4

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.2

non-durable commits

advantages and disadvantages, 10.5.2

-noserverlog option

ttendaemon.options file, 3.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

object privileges

ALL keyword, 4.2.3.1

functions, 4.2.3.7

granting, 4.2.1.2, 4.2.3

materialized views, 4.2.3.5

object

cache group, 4.2.5.3

overview, 4.2.1.2

packages, 4.2.3.7

procedures, 4.2.3.7

revoking, 4.2.3

sequences, 4.2.3.4

tables, 4.2.3.2

view user grants, 4.2.6

views, 4.2.3.3

ODBC

cancel function, 6.20.1

JDBC driver, 1.1.2

timing function calls, 6.20.2

tracing and performance, 10.1.13

UNIX driver, 1.3.2.1

odbc.ini file, 1.2.1, 1.2.1, 1.7.3

default DSN, 1.6.1

entry example, 1.7.3

format, 1.7.3

format of, 1.7.3

online help, 6.4

operating system

paging, 10.1.10

OPERATION column in PLAN table, 9.3.1.3.3

optimizer

application hints, 9.1

computing statistics, 8.4.2.4.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.4

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

owners

of indexes, 8.5.2

---

P

packages

object privileges, 4.2.3.7

packages command

ttIsql utility, 6.10

parameterized SQL statements, 6.13

partition

defragment, 1.14

performance

ALTER TABLE, 10.3.10

altered tables, 10.3.10

application tuning

autocommit mode, 10.5.4

checkpoints, 10.5.3

connection overhead, 10.1.6

durable commits, 10.5.2

maintenance options, 10.1.11

ODBC tracing, 10.1.13

transaction rollback, 10.5.5

transaction size, 10.5.1

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.3

Client, 10.2.2

Client/Server statistics, 10.2.1

database tuning

driver usage, 10.1.12

specifying size, 10.1.2

temporary database performance, 10.1.5

foreign key constraint, 10.3.5

index, 10.3.1

isolation modes, 10.2.4.2

lock timeout interval, 10.2.3

materialized view recommendations, 10.4

materialized views, 10.4.4

nested subqueries, 10.3.11

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

temporary database, 10.1.5

temporary databases, 10.1.4

transaction recommendations, 10.5

tuning, 10

using privileges, 4.2.3.2

working locally, 10.2.2

permanent database, 8.1.3

automatic checkpointing, 8.1.3

permanent memory region, 1.11.1

PermSize attribute, 1.11, 1.11

monitoring, 1.11.3

specifying, 10.1.2

PermWarnThreshold attribute, 1.11.4

phantoms, 10.2.4.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.3

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.3

PLSQL_MEMORY_ADDRESS connection attribute, 1.6.3

PLSQL_MEMORY_SIZE connection attribute, 1.6.3, 10.1.3

PLSQL_OPTIMIZE_LEVEL connection attribute, 1.6.3

policyInactive mode, 1.9.1

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

nullability, 8.2.1.6

See Also unique index

privileges

ADMIN, 4.2.1.1, 4.2.2

administrator, 4.2.1.1

ALL keyword, 4.2.3.1

ALL keyword system privileges, 4.2.2.2

ALTER ANY, 4.2.2.5.1, 4.2.3.7

ANY, 4.2.2.5

authorizing, 4.2.1

cache group, 4.2.1.2, 4.2.5, 4.2.5.3

CACHE_MANAGER, 4.2.5.1

CREATE ANY, 4.2.2.5.1

CREATE SESSION, 4.2.2.3

CREATE system, 4.2.2.5.1

definition, 4.2.1

DELETE, 4.2.3.2

DELETE ANY, 4.2.2.5

DROP ANY, 4.2.2.5.1

EXECUTE, 4.2.3.7

EXECUTE ANY, 4.2.2.5

first connection attributes, 4.2.2.3

grant system, 4.2.2

granting rights, 4.2.1

granting system privileges, 4.2.1.1

hierarchy rules, 4.2.1.4

INDEX, 4.2.3.2

INSERT ANY, 4.2.2.5

levels, 4.2.1

object, 4.2.1.2

cache group, 4.2.5.3

functions, 4.2.3.7

granting, 4.2.1.2, 4.2.3

materialized view, 4.2.3.5

packages, 4.2.3.7

procedures, 4.2.3.7

revoking, 4.2.3

sequences, 4.2.3.4

tables, 4.2.3.2

view, 4.2.3.3

overview, 4.2

parent-child table rules, 4.2.8

performance, 4.2.3.2

REFERENCES, 4.2.3.2

replication, 4.2.1.2

revoke system, 4.2.2

revoking ALL, 4.2.2.2

role, 4.2.1.3

SELECT, 4.2.3.2, 4.2.3.3, 4.2.3.4, 4.2.3.5

SELECT ANY, 4.2.2.5

system

overview, 4.2.1.1

UPDATE, 4.2.3.2

UPDATE ANY, 4.2.2.5

view user grants, 4.2.6

XLA, 4.2.2.4

procedures

object privileges, 4.2.3.7

procedures command

ttIsql utility, 6.10

PUBLIC role, 4.2.1.3

role

PUBLIC, 4.2.1.3

PWD connection attribute, 2.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

changes after database invalidation, 1.9

changes after failure, 1.9.1

defined, 1.9

setting, 1.9

range index, 10.3.3

overview, 8.5.1

reclaim operations

transaction, 7.7

configuring commit buffer, 7.7.2

recovery, 1.9.1, 1.9.2, 7.8

tuning, 10.6

REF CURSOR

using ttIsql, 6.13

REFERENCES privilege, 4.2.3.2, 4.2.3.5, 4.2.3.6

referencing indexes, 8.5.4

REFRESH ANY CACHE GROUP privilege, 4.2.5.2

REFRESH privilege, 4.2.5.3

remote database

accessing on UNIX, 2.2.4.2, 2.2.5.2, 2.4, 2.4.1

accessing on Windows, 2.2.5.1.3

removing

columns, 8.2.1.1

rows, 8.2.1.1

replication

aging, 8.2.3.5

character sets, 5.2.4

privileges, 4.2.1.2

temporary memory region, 1.11.1

TimesTen daemon, 3

.res files, 7.5.2

restrictions on table names, 8.2.1.4

REVOKE ALL command, 4.2.2.2, 4.2.3.1

REVOKE command, 4.2.2, 4.2.3

role

PUBLIC, 4.2.1.3

rollback

logs and locks, 7.3.1

performance impact, 10.5.5

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

schema

definition, Glossary

SELECT ANY privilege, 4.2.2.5

SELECT privilege, 4.2.3.2, 4.2.3.3, 4.2.3.4, 4.2.3.5, 4.2.3.5

semantics

byte, 5.3

character, 5.3

length considerations, 5.3

sequences

object privileges, 4.2.3.4

Serializable isolation mode, 7.4.1

serializable transaction

performance, 10.2.6

Server

controlling, 3.4.2

creating a DSN, 2.2.3, 2.2.3

creating logical name, 2.2.4.1

on UNIX, 2.2.4.2

described, 2.3

modifying options, 3.4.1

name, 2.2.4.1, 2.2.5.1.1

creating on Windows, 2.2.4.1

number of processes, 3.4.4.2

port number, 3.4.2

prespawning processes, 3.4.3

Server List dialog, 2.2.4.1

Server Name Setup dialog, 2.2.4.1

specifying number of connections, 3.4.4

starting, 2.3, 3.4.2

stopping, 2.3

thread stack size, 3.4.4.3

Server daemon

modifying options, 3.4.1

Server log messages

controlling, 3.4.6

-server option

ttendaemon.options file, 3.4.2

-serverpool option

ttendaemon.options file, 3.4.3

-serverShmIpc option

ttendaemon.options file, 3.4.5

-serverShmSize option

ttendaemon.options file, 3.4.5.2

-serversPerDSN option

ttendaemon.options file, 3.4.4.2

-serverStackSize option

ttendaemon.options file, 3.4.4.3

service

See daemon

setjoinorder command

ttIsql utility, 6.19.1

setuseindex command

ttIsql utility, 6.19.1

shared memory

changing size, 3.4.5.2

Client/Server IPC, 3.4.5

Client/Server, managing size, 3.4.5.1

IPC-enabled server, 3.4.5

sizing, 10.1.3

shared memory key

specify range, 3.3.7

shared memory segment

managing size, 3.4.5.1

size, 3.4.5.2

-shmkeyrange daemon option, 3.3.7

-showdate option

ttendaemon.options file, 3.3.2

showplan command, 6.13, 6.19.1

ttIsql utility, 6.19.1

size

database, 1.11

sizing

hash indexes, 10.3.4

transactions, 10.5.1

SNMP traps

described, 1.11.4

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

static checkpoints, definition

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

ttOptUpdateStats, 8.4.2.4.1, 10.3.6

update, 8.5.6.1

STEP column in PLAN table, 9.3.1.3.1

subdaemons

definition, 3.3.3

minimum required, 3.3.3

setting allowable number, 3.3.3

specifying allowable range, 3.3.3

subqueries

nested

performance, 10.3.11

-supportlog option

ttendaemon.options file, 3.3.2

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

required privileges, 4.2.3.8

viewing, 8.7

SYS owner of tables, 8.2.1.4

syslog

specify facility, 3.3.2

SYS.MONITOR table, 1.11.3

SYS.SYSTEMSTATS table, 7.6.2.3, 10.2.1, 10.5.2, 10.8.1

system DSN, 1.3.1.1, 2.2.4.1, 2.2.5.1.4

system failure

resulting logs and locks, 7.3.1

system privileges

ANY, 4.2.2.5

cache group, 4.2.5

CREATE, 4.2.2.5.1

default privileges, 4.2.2.1

granting, 4.2.1.1, 4.2.2

granting ALL, 4.2.2.2

overview, 4.2.1.1

revoking, 4.2.2

view user grants, 4.2.6

system tables

access, 4.2.2.1

indexes on, 8.5.2

overview, 8.2.1.7

---

T

table

calculating size, 6.9.4

compression, 10.3.14

computing statistics, 8.4.2.4.1

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

object privileges, 4.2.3.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

system, 4.2.2.1

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

Temporary attribute

performance, 10.1.4, 10.1.5

temporary database, 8.1.3

logging, 8.1.3

temporary memory region

replication, 1.11.1

TempSize attribute, 1.11, 1.11

monitoring, 1.11.3

specifying, 10.1.2

testing connections on Windows, 2.2.5.1.4

thread programming, 1.13

time-based aging, 8.2.3.2

Timeout connection attribute, 2.2.5.1.2

timeout interval

setting on Windows, 2.2.5.1.2, 2.2.5.1.2

TimesTen

ODBC driver, 1.1.1

TimesTen daemon

options, 3.3

TIMESTEN8 character set, 5.7.1

timestend, 3

timing command

ttIsql utility, 6.20.2

transaction

commit

buffer sizing, impact, 10.5.7

logs and locks, 7.3.1

durable commit, 10.5.1

locking, 10.2.4

log files, 7.6.2.1

accumulation, 7.6.2, 7.6.2.3

CkptFrequency attribute, 7.6.2.1

CkptLogVolume attribute, 7.6.2.1

holds, 7.6.2.2

how to control, 7.6.1

monitor, 7.6.2

monitoring, 7.6.2.3

names, 7.6.1

purging, 7.6.2.1

sequence number, 7.6.2.3

logging, 7.6.1

management

isolation levels, 7.4

locking, 7.3.1

logging, 7.3.1

semantics, 7.3.1

performance, 7.6.3.3, 10.5.1, 10.5.2

reclaim operations, 7.7

configuring commit buffer, 7.7.2

rollback

logs and locks, 7.3.1

performance impact, 10.5.5

ttXactAdmin utility, 7.6.2.2

serializable

performance, 10.2.6

sizing, 10.5.1

ttIsql utility, 6.12

tuning recommendations, 10.5

XLA, 10.8.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.6

TT_STATS PL/SQL package, 10.1.14, 10.2.1

ttAdmin utility

-autoreload, 1.9.2

-noautoreload, 1.9.2

ttAgingLRUConfig built-in procedure, 8.2.3.1

ttBlockInfo utility, 1.11.3

ttCkpt built-in function, 7.6.2.1, 7.6.2.1

ttCkptHistory built-in procedure, 7.6.2.3

ttCommitBufferStats built-in procedure, 7.7.2

ttCommitBufferStatsReset built-in procedure, 7.7.2

ttdaemon.options file

changing, 3.3

ttDbWriteConcurrencyModeGet built-in procedure, 10.3.15

ttDbWriteConcurrencyModeSet built-in procedure, 10.3.15

ttDurableCommit procedure, 10.5.2

ttendaemon.options file, 3.3, 3.3.2, 3.3.2, 3.3.3, 3.4.5

-allowNetworkFiles option, 3.3.4

-enableIPv6, 3.3.1.1

-enablePolicyInactive option, 1.9.1, 3.3.6

-facility option, 3.3.2

-linuxLargePageAlignment option, 3.3.5

-listenaddr entry, 3.3.1

-listenaddr option, 3.3.1

-listenaddr6 option, 3.3.1.1

-maxConnsPerServer option, 3.4.4

-maxsubs option, 3.3.3

-maxsupportlogfiles option, 3.3.2

-maxsupportlogsize option, 3.3.2

-maxuserlogfiles option, 3.3.2

-maxuserlogsize option, 3.3.2

-minsubs option, 3.3.3

-noserverlog option, 3.4.6

-server option, 3.4.2

-serverpool option, 3.4.3

-serverShmlpc option, 3.4.5

-serverShmSize option, 3.4.5.2

-serversPerDSN option, 3.4.4.2

-serverStackSize option, 3.4.4.3

-shmkeyrange daemon option, 3.3.7

-showdate, 3.3.2

specify syslog facility, 3.3.2

-supportlog option, 3.3.2

turn off messages, 3.3.2

-verbose option, 3.3.2

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

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

ttLogHolds built-in procedure, 7.6.2.3

ttMigrate utility

use in defragmentation, 1.14

offline, 1.14.1

online, 1.14.2

ttmodinstall utility, 3.3

ttOptClearStats built-in procedure, 9.4.3.2

ttOptCmdCacheInvalidate built-in procedure, 10.3.9

ttOptEstimateStats built-in procedure, 8.4.2.4.1, 8.5.6.1, 9.4.3.2

statistics computing, 8.4.2.4.1, 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.4

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

ttRepAdmin utility

use in defragmentation, 1.14

online, 1.14.2

ttShmHost

logical server address, 2.1.2.2

ttSize utility, 1.11.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, 1.10.2

ttTableSchemaFromOraQueryGet built-in procedure, 6.18, 6.18.2

cancel, 6.18.2

ttWarnOnLowMemory procedure, 1.11.4

ttXactAdmin utility, 7.6.2.2

---

U

UID connection attribute, 2.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.2.1

socket

Client/Server communication, 2.1.2.3

stopping daemon, 3.1.2

UNLOAD ANY CACHE GROUP privilege, 4.2.5.2

UNLOAD privilege, 4.2.5.3

unsetjoinorder command

ttIsql utility, 6.19.1

unsetuseindex command

ttIsql utility, 6.19.1

UPDATE ANY privilege, 4.2.2.5

UPDATE privilege, 4.2.3.2

usage-based aging, 8.2.3.1

USER_SYS_PRIVS view, 4.2.2, 4.2.6

USER_TAB_PRIVS view, 4.2.6

USER_USERS view, 4.1.2

-userlog option

ttendaemon.options file, 3.3.2

UTL_RECOMP package, 4.2.2.1

---

V

variable

automatically created, 6.14.2

declaring, 6.14

-verbose option

ttendaemon.options file, 3.3.2

view

creating, 8.3.1

drop, 8.3.2

object privileges, 4.2.3.3

overview, 8.3

restrictions, 8.3.3

SELECT query, 8.3.1.1

---

W

WHENEVER SQLERROR command, 6.21

Windows

setting timeout interval, 2.2.5.1.2

starting, 3.1.1

stopping, 3.1.1

---

X

XLA

performance, 10.8.1

privilege, 4.2.2.4

updates

acknowledging, 10.8.3