| DbCool:
Lots
of Tools In One |
The
Grid |
| DbCool has
built in tools for many common tasks. See screenshots for just a
few:
SQL
execution with bind variables
PL/SQL execution with bind variables
Reverse engineering of objects
PL/SQL compiling and development
data and schema comparison
lock monitoring
SQL script execution and management
performance monitoring and tuning
EXPLAIN PLAN* and plan step through
Graphical Free And Used Segment Maps
*EXPLAIN PLAN is partition and
parallel query aware and supports 9iRelease2 access and filter
predicates as shown in the screen shot above
|
A
powerful grid is at the heart of DbCool.
Save result sets
from the grid in HTML, and load and save in
comma delimited, tab delimited, or DbCool (.cog) format, complete
with all formatting. Send grids to your colleagues so they can
analyze and check query results. Display
results inline, like SQL*Plus®. Run
the grid in edit mode, where changes
you make to cells are reflected back into the underlying table.
Copy
and Paste grid cells between DbCool and Microsoft Excel®. Load grid data into tables. Move columns
around the grid by drag and drop. Hide rows
and columns. Change justification.
You can even view and format grid results offline. You don't need to
be connected to a database. Just save a grid in .cog format and
double-click the DbCool Grid icon in Explorer.
 |
| Database
Running Slow? |
Client
Side Reports |
| DbCool can help to tell
your database is running slow. It contains many tools for monitoring
the system as a whole and individual sessions. Oracle performance
tuning no longer needs to be a mystery. Anyone with SELECT ANY TABLE
privilege, or the DBCOOL_READ role can do it |
Ever
executed a long running query and wished you could reformat, group, or
reorder results
without re-executing? With DbCool's Reporter tool you can. You can
sort, group and order
grid results as many times as you want, after a
query has completed. Turn your plain old query
results into this formatted report
with a few keystrokes |
| Tune
the Database in 5 Minutes |
Design
Your SQL For Performance |
Perform
a tuning study in 5 minutes. Really. If you never ran DbCool on your
database before, there are probably some quick, low risk fixes you
can make to speed things up.
Look for Tuning in 5 Minutes in the
online help. |
Oracle's
SQL*Plus® tool allows you to trace a few key
statistics for SQL you run after it has completed. DbCool can show you all
statistics
that change when you run your SQL and all event
waits that take place. It can provide the information while your SQL is executing. Statistics
alone are not enough. They won't show you network waits, for
example. |
| Cache
all SQL
Results |
Execute
PL/SQL |
| DbCool
caches a history of all your query
results locally to save loading the server for the same query. You can retrieve previous result sets into the grid
using the Back, Forward, and History buttons on the main button bar. |
Use
DbCool to execute your function, procedure or package
subprogram.
Just right-click on the object in the Explorer, choose Execute and DbCool generates a form for you to fill
in. Set the arguments in the form and execute. As simple as that. |
| Advanced
Tracing |
RUN_COOL_SQL |
| Other
tools let you turn on SQL tracing. Of course DbCool does that. DbCool also lets you turn on tracing of bind
variable values, and session waits, for those hard-to-pin-down
coding and performance problems. You can toggle the settings on-the-fly for existing sessions. |
RUN_COOL_SQL
is a feature that allows you to populate the grid with DDL statements and run them. Several scripts are provided in Script
Manager based on this feature.
Look for RUN_COOL_SQL in the online
help.
|
helps you find out why your
Oracle database is running slow.
17
June 2003
224K
zip
