|
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.
|