|Home||Consulting||Training||Services||List Server||Search Engine||SQL|
In over twenty years of experience with a large variety of client situations, JCC Consultants have developed some extremely useful tools. Some of these have been further enhanced to make them available as products.
Discussed here are:
The JCC LogMiner Loader™ is used in a variety of mission critical architectures to transmit the changes from an Rdb™ database to another data store. Target platforms include Oracle 10G (and previous versions), Rdb, Tuxedo and XML. Targets can contain all of the data or a subset of the data in the source as well as a variety of materialized data (such as commit time stamps). With some restrictions, the Loader can support transforms from one data model to another. The JCC LogMiner Loader™ is high throughput, robust in the face of environmental or downstream difficulties, and flexible. The Loader also provides extensive monitoring options and other tools to assist the DBA. Loader applications include replication for remote copies, rollup of local databases to a corporate database, data warehousing, conversion, database reorganization, regression testing, and others. Specific case studies are available.
The LogMiner Loader features page provides a more detailed view, including how to acquire the full documentation, the kit, and a trial license. An extract from the release notes details testing with different versions of the companion products. A special one-day version of the seminar on JCC's LogMiner Loader is available on July 15, 2005 in the JCC seminar facilities.
The Data Pump is a companion product to the JCC LogMiner Loader and is included in the Loader distribution kit at no additional fee.
The Data Pump can be used for initial population of the target, data conversion, or to repair the data after difficulties with downstream processing. The Data Pump "understands" parent-child relationships and can be instructed to "pump" specific data trees including a specified set of rows in one table and all the dependent rows in other tables. The Data Pump is fast and accurate.
A description of the Data Pump is also included with the notes on the Loader.
The JCC BLR Parser is an instrumentation kit that forms the basis for a complete application instrumentation philosophy using ORACLEtrace. As such these routines provide the application developer with the ability to measure performance and costs of:
In addition, routines are provided to allow complete exception logging, partitioning the exception space into ORACLE Rdb exceptions and application exceptions. The facility stores all relevant text information regarding the exception.
The JCC Query Tuning seminars discuss the methodology employed and include the right to use the tool.
JCC uses the BLR Parser in our consulting for performance tuning and in our remote DBA work. JCC also uses the BLR parser to understand the load placed on an existing database before recommending application changes or conversion.
Need a carefully selected tool for seeing what is in your environment?
Fast Index Verify for Oracle Rdb is a tool to shorten the B-tree index verification at the data level. Fast Index Verify avoids costly random reads to the data, shortening index verification by hours or even days for large tables. If you have found you cannot completely verify indexes because of time constraints, you need Fast Index Verify.
Send mail to firstname.lastname@example.org
with additional questions or comments.
Copyright © 2005, JCC Consulting, Inc.
Last modified: March 5, 2005
Trademarks and credits.