Skip Headers
Oracle® TimesTen In-Memory Database Operations Guide
11g Release 2 (11.2.2)

E21633-11
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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.10.4
setting for UNIX, 1.3.2.1
specifying, 1.3.1.3
TempWarnThreshold, 1.10.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
static
CkptFrequency connection attribute, 7.6.2.1
CkptLogVolume connection attribute, 7.6.2.1
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.10, 1.10
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.10, 1.10
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.10
temporary, 1.10
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 machine, 2.1.2.3
accessing on a remote machine, 2.1.2.1
automatic recovery, 1.9.1, 1.9.2
changing size of, 1.10
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.13
getting information with ttIsql, 6.9
loading to memory, 1.9
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
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.13
partition, 1.13
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.10.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, 2.2.5.1.1
Client, 1.2.2, 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
.ttconnect.ini, 2.2.4.3
ttendaemon.options, 3.3, 3.3.3, 3.4.5
first connection attribute, 4.2.2.3
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.10.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.9
partitions, 1.10
permanent, 1.10
policy for loading a database, 1.9
temporary, 1.10
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.10.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.13
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 data partition, 1.10.1
permanent database, 8.1.3
automatic checkpointing, 8.1.3
PermSize attribute, 1.10, 1.10
monitoring, 1.10.3
specifying, 10.1.2
PermWarnThreshold attribute, 1.10.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
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 data partition, 1.10.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.10
sizing
hash indexes, 10.3.4
transactions, 10.5.1
SNMP traps
described, 1.10.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.10.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 data partition
replication, 1.10.1
temporary database, 8.1.3
logging, 8.1.3
TempSize attribute, 1.10, 1.10
monitoring, 1.10.3
specifying, 10.1.2
testing connections on Windows, 2.2.5.1.4
thread programming, 1.12
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.10.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
ttconnect.ini file, 2.2.4.3
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.13
offline, 1.13.1
online, 1.13.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.13
online, 1.13.2
ttShmHost, 2.2.4.3.1
logical server address, 2.1.2.2
ttSize utility, 1.10.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.10.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