ELLAROSE

ELLAROSE is a Windows-based tool designed to provide Oracle users users with an easy way of managing and optimizing database performance using powerful features. It's capable of generating a graphical view of key performance metrics after extracting and processing the raw information.

The application is wrapped in a simple GUI that shows the connection, data source, environment and file options right at startup. To avoid a startup error concerning a text documents, it's necessary to save the downloaded package in the C:\ drive.

When it comes to the data source, ELLAROSE can use automatic workload repository or statspack. It can load baseline data from a specified file in order to generate historical performance (SQLStat) as well as run statistics to determine the total and average executions, elapsed and CPU time, processed rows, disk reads, sorts, and others.

The tool supports object, security and storage browsers, datafile statistics and maps, an I/O profile, wait events, latching, buffer cache content, SGA hit ratios, advisors, health check, parameter history, along with SQL and system topology.

Extensive user documentation is included in the downloaded package. The program is not wrapped in a setup package, so it can be unpacked and launched right away.