EvenTorEx: Event Collector/Index
Oracle ASH is short lived – only 1/10th of it’s sampling is saved in AWR. We loose a lot of fidelity and some session details going from Oracle ASH to Oracle AWR. My proposal is to develop a monitoring framework that:
- Samples Oracle ASH every N minutes and captures the live heartbeat of the database.
- Allows you to define thresholds on top of this sampling and notifies you if something is amiss.
- Saves all this data for historical purposes so that when AWR is wiped out you have solid performance metrics years later.
- Monitors Oracle LOCKS.
- Monitors Oracle SPACE.
- Delivers this functionality in an easy to deploy (single binary) distribution that only takes a minute to install on a new host.
Does this sound like something you’d like in your shop? If yes – then I’d like to hear from you because I am building it! Sign up for the mailing list below to start the discussion and get the private beta as soon as it’s ready (no SPAM here I guarantee it!):EvenTorEx Mailing List
Vitaliy Mogilevskiy August 7, 2008