Tool Enhances Oracle Database

By Matthew Hicks  |  Posted 2002-06-01 Print this article Print

Lecco DB Expert for Oracle 3.2 lets DBAs track changes to execution plans and SQL cost so they can predict the impact to performance from such activities as database migrations.

Database tool vendor LeccoTech Inc. on Friday introduced the latest version of its Lecco DB Expert for Oracle Corp. databases with new features to improve performance. Version 3.2 of Lecco DB Expert for Oracle includes part of LeccoTechs proprietary Feedback Searching Engine technology, which the company says lets users ensure reliable performance and prevent uncertainty in indexing by managing index changes. The San Francisco-based vendor is incorporating a series of new features in Version 3.2, including ones that it calls Plan Version Tracker, Virtual Index Simulator, Index Impact Analyzer and Index Expert. Plan Version Tracker allows users to track changes to execution plans and SQL cost so they can predict the impact to performance from such activities as database migrations, upgrades, configuration changes and data growth.
Virtual Index Simulator and Index Expert work together, with the simulator displaying the execution plans that an Oracle database would create if it used the index set alternatives created by Index Expert. The simulator also can predict the effect on performance of an index set on a SQL statement. Index Impact Analyzer can evaluate the creation of indexes in other SQL statements without affecting database performance.
Lecco DB Expert for Oracle 3.2 will be available June 14 with pricing starting at $8,495, officials said.
Matthew Hicks As an online reporter for, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel