The list below is a comprehensive list of features offered by Lighty For Oracle. You can carry out a free 30-day trial software in order to measure the range of possibilities.
Browser Activity
Visualization of past activity in graph form
- If you have the diagnosis + tuning licenses, the data is read from ASH
. If not, the data is read from the table L_ASH (L-ASH must be installed)
Many results filtering possibilities
Choice of activity dates
Detailed activity in the form of widgets
Customizable dashboard
Real-Time Activity
Many graphs (data coming from Oracle metrics)
Incremental statistics
Customizable dashboard
Many widgets
- (Blocking Sessions, SQL supervised, Sessions long operations...)
Monitoring
Real-time monitoring
E-mails Alerts beyond a certain customizable threshold
Comparator
Compare your current database with a snapshot
Compare two different periods of the current base
Compare two snapchots
Reports
Reports on most of these statistics
Object statistics Explorer
- (Tables, Indexes, Partitions...)
Monitored SQLs
- (Detailed execution statistics)
AWR repository Explorer
Statspack repository Explorer
Generating AWR reports (HTML or Text Format)
Generate ASH reports (HTML Format)
Create Custom Reports
Statistics Per SQL
Detailed Usage
Execution Plans
- (Outlines, Bind variables...)
Execution History
- (Derived from AWR or Statspack)
Profiles, baselines, patches
Memory footprint
Statistics Per Session
Detailed Usage
Activity history
Execution Stats
