Oracle Performance Intelligence
Oracle Performance Intelligence in Confio Ignite applies business intelligence analysis techniques to Oracle performance. It captures detailed data in the Ignite Performance Data Warehouse, then mines the data for historical trends, correlates problems, and exposes anomalies. Unlike other monitors, Ignite analyzes historical trends to show how the system has changed over months, weeks and days. Performance Intelligence gives the performance answers based on what matters most to end users – how long their application has to wait on Oracle.
Wait Time Analysis
Ignite for Oracle Performance applies best practice Wait Time analysis techniques to Oracle database performance management. Ignite measures wait time associated with each tiny operation – or Wait Event - and uses it to expose delays in end user service.
Typical systems focus on counting server operations, which shows server health but is not a good indicator of IT service. Measuring the time taken for each step a query takes in Oracle translates directly into how well the application performs. Ignite tracks the time spent by each query on each Wait Event, from 8/9i up to 800 different events in 10/11g.
Wait Time techniques focus on the most important performance question – why is an application waiting on the Oracle database, and what can be done?
Agentless Monitoring
Ignite for Oracle performance monitors Oracle databases without installing any software on the production systems, and can be used with installed client software or from a browser. The Igniter Suite is built on the three tier architecture shown. DBAs, developers and managers access the solution from any browser or Windows desktop. The Ignite Performance Data Warehouse is installed on an Oracle test or development system. And the Ignite agentless probes reach across the network to the monitored servers – Oracle as well as other vendor databases – and pull performance statistics back to the data warehouse.
No Load on Production Systems
Using the agentless architecture, Ignite for Oracle performance places less than 1% load on the monitored servers. For production use in the most sensitive environments, Ignite gives continuous Performance Intelligence without impacting the target system. When it is time to upgrade Ignite to access new features, all the change takes place on the Performance Data Warehouse, with nothing to change on the Client or Monitored servers. Ignite is self contained with its own captive web server, so all you need is a non-dedicated Oracle instance to house the Performance Data Warehouse.
OEM is Not Enough
Confio customers know that Ignite provides deeper, faster and more effective problem resolution than using Oracle Enterprise Manager/Grid Control alone. While OEM is a great database system admin tool, Ignite is focused specifically on finding and resolving performance issues, fast.
Ignite Complements OEM
Ignite is built from the ground up to use Wait Event data to find the most important problems. Agentless, without production load, and supporting Oracle 8 through 11, Ignite gives performance insight that OEM cannot provide. Run a free trial. In 30 minutes you will see the dimensions that OEM is missing, and why so many Oracle DBAs are successful with Ignite even when they use OEM/Grid for basic database administration.
Eliminate RAC Bottlenecks
As an extension of Confio Ignite for Oracle, Ignite for RAC offers DBAs unparalleled insight into overhead caused by delays in RAC cluster coordination and cache operations, which can cause critical RAC performance problems for DBAs and end-users.
Ignite for RAC performance solution identifies the impact of up to 40 different RAC-specific Wait-Events that create overhead in a RAC environment. Each SQL statement performance is analyzed for how efficiently it uses the RAC resources. Performance is measured for the entire RAC as well as individual RAC nodes at an SQL level, giving DBAs practical data on wait times between the application and database and where in the RAC cluster performance time is being wasted.
Top Plans
Ignite for Oracle 6.5 monitors the Explain Plans that Oracle uses to execute each SQL statement and charts the wait time associated with execution of each unique Plan. For Oracle 10g and higher, a “Top Plans” dimension allows drill down into a list of “plan hash” values (similar to a SQL hash). Ignite is unique in saving this historical view of the actual plans that executed during every period, so that DBAs can associate wait time changes with variations in Oracle execution plans.
Top Objects
Ignite for Oracle 6.5 monitors the database objects (e.g. table, indexes, etc.) that are in-use as a monitored SQL statement executes. For Oracle 9i and higher monitored databases, a “Top Objects” dimension shows a list of objects and their schema owner, object type and, if applicable, the partition. If a table or index becomes a critical resource bottleneck, Ignite will expose it.
Other New Features – call Confio for more information
- Top locking and blocking sessions
- Automatic email report subscriptions
