Spoto

An Oracle DBA will spend a vast amount of time pouring over the contents of a trace file in attempt to decipher statistics for certain database operations. SPOTO aims to drastically reduce such analysis by extracting and translating all information and presenting it in a manner which is comprehensive and yet simple to understand. SPOTO focuses on two key types of analysis:

Oracle SQL Trace Files: This is probably the most important trace file to analyse when you want to determine the execution statistics for any given SQL. However the instrumentation on todays market for performing such a fundamental analysis does not quite cut it. SPOTO aims to provide the Oracle DBA with an insight into all valuable trace file information in one simple glance.

OSW Trace Files: (Oracle System Watcher) OSW trace files provide statistical information for the operating system on which an Oracle database resides. OSW generates important system information which is not captured by standard monitoring tools such as OEM. The content of an OSW trace file is superb. However trying to decipher this information can be quite the challenge. Once again SPOTO rescues the DBA from such a pain stacking task and presents the OSW information in a series of easy to read graphs.