The Precise Platform is designed specifically to keep your Oracle environment available and performing at peak efficiency. It captures, measures, and analyzes performance metrics from all critical system components and helps you detect and correct the root causes of problems before end users are affected. The Precise Platform provides high-level visibility across multiple Oracle and Oracle RAC instances and provides alerting to problems, reports on collected data, and maintains a warehouse of Oracle database performance information.
The Precise Platform continuously analyzes database behavior to find the poorest performing objects or processes, including Heavy Statements, Heavy Objects, High I/O, RAC events, storage devices, and more. Historical statistics stored by instance, by user, and by program provide the necessary context to further help DBA in seeing the whole picture.
The Precise Platform quickly analyzes SQL statements, database objects, and Oracle instances to uncover specific causes of performance problems. It presents the Oracle access path in detailed steps and displays the statistics needed to understand each step so you can isolate problems fast.
Once a performance problem is identified, The Precise Platform allows DBAs to drill down in context of the user transaction to pinpoint the problem’s root cause, whether it is a poorly designed SQL statement, program, database object, or even a bottleneck due to a resource shortage in the underlying operating system, virtualization infrastructure, or storage.
The Precise Platform provides DBAs with a library of knowledge and experience designed to help them tune their Oracle environment. Recommendations around SQL statement tuning, database object tuning, index tuning, and index cost are just a few examples of the many recommendations available.
The Precise Platform automatically identifies problem areas and provides actionable advice on how to address them. Before any change is made, DBAs can perform “what-if” analysis to predict the impact of proposed changes to remove the risk of accidentally making things worse.
Oracle databases are constantly growing and evolving. By connecting transaction performance with the infrastructure it touches, the Precise Platform makes it easier to align server and storage capacity with the growing needs of the business.