Insider for Oracle

The Art Of Performance Tuning

What is Insider?

    Comprehensive analysis Real-time monitoring Enterprise ready Cross-platform

Comprehensive analysis     Drilldown views Historical analysis Wait-time analysis Load analysis

Real-time monitoring   Detects problems before they occur not after Shows statistics in real-time

Enterprise ready    Can monitor hundreds of databases with a single console Detects and displays hot standby databases Cluster-ready

Cross-platform   Runs on any platform Monitors any platform

What is Insider used for?

      Proactive monitoring Database administration Load testing Capacity planning Historical performance analysis Wait-time analysis

Proactive monitoring  Monitors your systems 24x7 and fires an alert whenever its performance or availability is at risk

Database administration  View and edit database parameters, user sessions, locks, storage and other vital information

Load testing  Run a load test and get immediate feedback on Insider Instance view

Capacity planning  Study past performance and load and make future load predictions based on saved statistics

Historical performance analysis  Saves and allows to analyze historical performance information without aggregation

Wait-time analysis  Find the bottleneck by analyzing wait events and time spent

Insider architecture  Three-tier architecture

Insider views – top-to-bottom approach

Enterprise view     Provides an overview of all servers Displays all alerts Shows primary-standby relationships and alerts Easy access to 3 rd party tools

Instance view    Gives a single server overview Displays inter-instance alerts Provides navigation to the drilldown views for a specific component

Drilldown views   Rich set of drilldown views help pinpoint a specific problem The information is preserved for a month to help compare past and current performance

Alerts   More than 70 customizable alerts Can be extended with user alerts

Insider key features     Powerful Easy to use Extensible Low impact

Powerful     Collects hundreds of statistics Fires around a hundred alerts Can handle hundreds of servers Saves performance history for a month

Easy to use

Download Install Run

Extensible   Pluggable architecture Custom alerts

Low impact  All the processing takes place on the client side, not on the server Collect data Transform, analyze, save Display

Who benefits from using Insider?

   DBA  Monitor 24x7   Detect and resolve bottlenecks Analyze past and predict future performance Manager  Plan resources proactively   Get immediate feedback Quick turnaround on ROI Developer  Load test and analyze the impact

Who is using Insider?

   ING TransUnion IFS   Oracle Stanford university just to name a few