Skip Headers
Oracle® Database Lite Troubleshooting and Tuning Guide
10g (10.3.0)

Part Number B28927-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

A

AddPublicationItem method
restricting predicate, 1.2.10
Address already in use error, 2.2.2
ADMIN_JDBC_URL parameter, 2.3.2
application
automatic deployment, 2.1.8
component architecture, 1.4.4.1
application server
viewing log files, 3.4
architecture
Oracle Database Lite architecture
applications, 1.4.4.1
authentication
certificate rejection, 2.6.1

B

backup, 4
BindException, 2.2.2
Branch Office
IllegalArgumentException, 2.5.2

C

check-for-updates parameter, 2.1.8
checksum error
diagnosing, 2.4.2
client
complete refresh, 2.1.4
out of sync, 2.1.4
complete refresh
reasons for, 2.1.4
triggered by out of sync, 2.1.4
compose
postponed error, 2.1.6
COMPOSE_TIMEOUT parameter, 1.2.4
concurrency
configuring, 1.2.4
connection
limit requests, 1.1.2
pool, 1.2.4
pooling, 1.1.1
connection pooling, 1.1.1
CONNECTION_POOL parameter, 1.2.4
CONNECTION_TIMEOUT parameter, 1.2.4
consperf
query optimizer, 1.2.5.3
tuning queries, 1.2.5
Consperf utility, 1.2.1
configuring, 1.2.1.1, 1.2.1.1
execution plan file, 1.2.1.1
timing file, 1.2.1.1
consperf utility
EXPLAIN PLAN, 1.3

D

Data Synchronization
tracing, 3.1.2
database engine
overview, 1.4.4.1.3
DDL
dependent statements, 1.2.3
DEBUG section
tracing, 3.2.1
deployment
automatic, 2.1.8
DISABLE_SSL_CHECK parameter, 2.6.1

E

environment
troubleshoot, 2.3.1.2
validate, 2.3.1.2
Error
Address already in use, 2.2.2
exception
Server Busy, 2.1.7
execution plan
access methods, 1.4.4.3.2
generation
overview, 1.4.4.3
execution plan file
deciphering, 1.2.1.1
EXPLAIN PLAN, 1.3

H

heap size
definition, 2.5.1.1.1
HINTS feature
performance, 1.4.2.2

I

IllegalArgumentException, 2.5.2
inconsistent datatype
SQL exception, 2.1.5
index access method
query optimization, 1.4.4.5.1
in-queue
compose postponed, 2.1.6
IP address
modifying database server, 2.3.2

J

join query
optimizing, 1.4.2
JVM
defining heap size, 2.5.1.1.1

M

map
partititions, 1.2.8
maps
shared, 1.2.7
MAX_CONCURRENT parameter, 1.2.4
MAX_THREADS parameter, 1.2.4, 1.2.4
memory
defining heap size, 2.5.1.1.1
MGP
compose postponed, 2.1.6
timeout, 1.2.4
Mobile client
tracing, 3.2
tracing with console window, 3.2.2
Mobile Server
defining memory size, 2.5.1.1.1
general tracing, 3.1.1
online application, 2.1.8
tracing, 3.1
msrdt, 2.3.1
msrdt tool, 2.3.1.2

N

non-mergable views, 1.2.5.1

O

OC4J
viewing log files, 3.4
OKAPI
overview, 1.4.4.1.3
OLITE_WRITE_VERIFY parameter, 2.4.2
online
Mobile Server, 2.1.8
optimizer
performance, 1.2.5.3
Oracle Support
retrieving Lite database information, 2.3.1
OracleAS
troubleshooting, 2.2.3
OutOfMemory exception, 2.5.1.1.1

P

partition, 1.2.8
perfomance
analyzing synchronization, 1.2.1
performance
advanced SQL query techniques, 1.4.4
configuring Consperf utility, 1.2.1.1
connection pooling, 1.1.1
Consperf utility, 1.2.1
execution plan file, 1.2.1.1
EXPLAIN PLAN, 1.3
limit connection requests, 1.1.2
optimizing SQL queries, 1.4
query optimizer, 1.2.5.3
shared maps, 1.2.7
SQL queries, 1.2.5
streamlining large amount of data, 1.2.8
synchronization, 1.2.4
tablespace layout, 1.2.6
timing file, 1.2.1.1
using map table partitions, 1.2.8
pool
connection, 1.2.4
primary key
composite
query rule, 2.1.5
publication item
caching queries, 1.2.11
read-only
performance, 1.2.7
publication items
analyzing performance, 1.2.1.1
evaluating performance, 1.2.1.1
publications
performance, 1.2.1

Q

query
optimizer, 1.2.5.3
optimizing, 1.4
optimizing join queries, 1.4.2
optimizing order by and group by, 1.4.3
rule
composite primary key, 2.1.5
single-table
optimizing, 1.4.1
tree transformations, 1.4.4.2.2
query optimizer
bypassing, 1.4.2.2

R

recovery, 4
Repository
troubleshoot, 2.3.1.2
validate, 2.3.1.2
repository
checking for errors, 2.3.1
IP address change, 2.3.2
validation, 2.3.1
restricting predicate, 1.2.10

S

script
dependent DDL statements, 1.2.3
Server Busy
exception, 2.1.7
shared maps, 1.2.7
SQL
EXPLAIN PLAN, 1.3
query
advanced optimization techniques, 1.4.4
execution steps, 1.4.4.4
index access method optimization, 1.4.4.5.1
join query optimization, 1.4.4.3.4
optimization for predicate push, 1.4.4.2.2
optimization for view expansion, 1.4.4.2.2
optimization for view merging, 1.4.4.2.2
optimization for view replacement, 1.4.4.2.2
optimizing join queries, 1.4.2
optimizing order by and group by, 1.4.3
optimizing single-table queries, 1.4.1
single table query optimization, 1.4.4.5.3
tracing, 1.4.4.5.2
tree transformations, 1.4.4.2.2
query optimization, 1.4
tuning queries, 1.2.5
SQL exception
inconsistent datatypes, 2.1.5
SQLRT
definition, 1.4.4.1.2
generating execution tree, 1.4.4.2.1
subscriptions
profiling, 1.2.1
synchronization
analyzing performance, 1.2.1
map table partition
add, 1.2.8.2
create, 1.2.8.1
drop, 1.2.8.3
drop all, 1.2.8.4
merge, 1.2.8.5
monitor with SQL scripts, 1.2.2
performance, 1.2.8
performance tuning, 1.2.4
Server Busy exception, 2.1.7
tablespace layout, 1.2.6
timeout, 1.2.4
tracing, 3.1.2

T

tablespace
layout, 1.2.6
THIN_JDBC_URL parameter, 2.3.2
threads
configuring, 1.2.4
timeout
MGP, 1.2.4
synchronization, 1.2.4
timing file
deciphering, 1.2.1.1
tracing, 3, 3.3
Data Synchronization
tracing, 3.1.2
enabling in webtogo.ora, 3.2.1
Mobile client, 3.2
Mobile Server, 3.1
viewing OC4J log files, 3.4
transaction
compose postponed, 2.1.6
troubleshooting
access client database offline, 2.4.1
browser time-out, 2.1.3
debugging Mobile Server, 2.2.1
Lite database, 2.3.1
repository, 2.3.1, 2.3.1.1
truncate command, 1.2.8.1, 1.2.8.2

U

user
large amounts of data, 1.2.8

V

validation
repository, 2.3.1
views
non-mergable, 1.2.5.1

W

Web-to-Go
interaction with OracleAS, 2.2.3
webtogo.ora
tracing, 3.2.1
web.xml, 2.2.3