SOFTWARE STIMULUS PACKAGE
SOFTWARE STIMULUS PACKAGE
The Recession is Real...It is Ugly...and Ugly it will be for the foreseeable future!
IT budgets have been slashed, staff has been reduced, and there is more work than ever! All of the focus is on market sectors and companies that are "too large to fail".
It is Our Opinion that
IT is also Too Large to Fail!
That is why we have created this Software Stimulus Package. We are offering one of our break-through technologies at no charge! This way, you can put in a new tool and not have to worry about budget! Especially at a time when you need more tools just to keep up!
ActiveBase SQL Expert for Oracle can be downloaded and used on an unlimited basis, at absolutely no cost. ActiveBase SQL Expert, the newest module of the ActiveBase Suite, helps the DBA and SQL developer by automating the process of finding the right Oracle Hint, for a given SQL statement. The “right Hint” is the one that, when added to the original SQL statement, produces the lowest result (shortest elapsed time or the least CPU or I/O). Oracle Hints change the way Oracle executes queries, without changing the source code or the database. This is especially powerful when running proprietary applications where you don't have access to the source code.
Finding the right Hint using existing current methods is an iterative and highly-time consuming process, and is simply not feasible. Often times, you may find a "good" solution, but not always the "best". A statement with a cost of 175, will run certainly better with a cost of 142, but it would run even better than that with a cost of 125. Wouldn't you rather know that you got the best alternative, rather than just a good one?
Through its simple graphic interface, ActiveBase SQL Expert completely automates the process and guarantees the best alternative, without any extra effort!
- 1. Identify: Select un-tuned SQL requests from the Oracle SGA using the ‘Hotspot’ viewer, or a flat file that you create from either source code, or another application monitor.
- 2. Set benchmark options: Set the number of alternatives to execute, total benchmark time, automatic cancelling, session and parallel degree settings, etc.
- 3. Analyze: Find different alternatives (SQL + ‘Hints’) generating multiple unique execution plans.
- 4. Run Benchmark: Execute the alternatives against a database to find the best result.
- 5. Analyze results: Using the automatically generated, detailed benchmark audit trail with a color-coded summary view quickly identify the best improvement.
What's the catch? This is a legitimate question, one I would ask myself. The answer is, there is no catch, unless you consider an occasional pop-up that describes the other ActiveBase modules to pique your interest.
For more information, or to schedule an installation or demo, please contact me:
Tony Cannizzo | President
Silos-Connect Technologies
404 580 3451
tony@silos-connect.com
###