1 / 28

Insider for Oracle

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.

sereno
Download Presentation

Insider for Oracle

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Insider for Oracle The Art Of Performance Tuning

  2. What is Insider? • Comprehensive analysis • Real-time monitoring • Enterprise ready • Cross-platform

  3. Comprehensive analysis • Drilldown views • Historical analysis • Wait-time analysis • Load analysis

  4. Real-time monitoring • Detects problems before they occur not after • Shows statistics in real-time

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

  6. Cross-platform • Runs on any platform • Monitors any platform

  7. What is Insider used for? • Proactive monitoring • Database administration • Load testing • Capacity planning • Historical performance analysis • Wait-time analysis

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

  9. Database administration • View and edit database parameters, user sessions, locks, storage and other vital information

  10. Load testing • Run a load test and get immediate feedback on Insider Instance view

  11. Capacity planning • Study past performance and load and make future load predictions based on saved statistics

  12. Historical performance analysis • Saves and allows to analyze historical performance information without aggregation

  13. Wait-time analysis • Find the bottleneck by analyzing wait events and time spent

  14. Insider architecture • Three-tier architecture

  15. Insider views – top-to-bottom approach

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

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

  18. 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

  19. Alerts • More than 70 customizable alerts • Can be extended with user alerts

  20. Insider key features • Powerful • Easy to use • Extensible • Low impact

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

  22. Easy to use

  23. Extensible • Pluggable architecture • Custom alerts

  24. Low impact • All the processing takes place on the client side, not on the server

  25. 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

  26. Who is using Insider? • ING • TransUnion • IFS • Oracle • Stanford university just to name a few

More Related