Oracle® Database Lite Tools and Utilities Guide
10g (10.0.0) Part No. B12263-01 |
|
![]() Previous |
![]() Next |
This document provides an introduction to all the tools and utilities that are used during application development. Topics include:
Oracle Database Lite is shipped with a set of tools and utilities that enable tasks relevant to developing, packaging, publishing and synchronizing mobile applications on the Mobile Server. The following sections provide a brief introduction to these tools and utilities.
The Packaging Wizard is a graphical tool that enables you to perform the following tasks.
Create a new mobile application.
Edit an existing mobile application.
Publish an application to the Mobile Server.
When you create a new mobile application, you must define its components and files. In some cases, you may want to edit the definition of an existing mobile application's components. For example, if you develop a new version of your application, you can use the Packaging Wizard to update your application definition. The Packaging Wizard also enables you to package application components in a .jar file which can be published using the Mobile Manager. The Packaging Wizard also enables you to create SQL scripts which can be run to create base tables in the Oracle database.
This section describes how to use the following database tools and utilities.
Allows databases to be created with linguistic sort capability enabled
Create Oracle Database Lite databases
Decrypt Oracle Database Lite
Remove Java classes from Oracle Database Lite
Encrypt Oracle Database Lite
Load Java classes into Oracle Database Lite
Migrate to Oracle Database Lite from a previous release
Connect to Oracle Database Lite databases
Manage ODBC connections
Identify version number and volume ID of Oracle Database Lite
Load data from an external file into a table in Oracle Database Lite, or unload (dump) data from a table in Oracle Database Lite to an external file.
Remove Oracle Database Lite
Validate the structure of Oracle Database Lite
The Consperf utility is used to profile Consolidator publications. Application developers and administrators can use this utility to analyze performance of publications and identify potential bottlenecks during publication. This tool enables users to perform four primary functions:
Generate Timing Statistics for Publications
Generate Explain Plans for Publications
Automatically Tune Publication Properties
Analyze Mobile Server Objects for Cost Based Optimizer
During the Synchronization and MGP process, the Consolidator wraps publication item queries in templates to determine incremental changes. With complex snapshot queries, these templates can confuse the Oracle optimizer frequently and may result in poor execution plans. The Consperf utility exposes such templates and profiles their performance in conjunction with actual publication item queries. The Consperf utility generates SQL explain plans for each query.