Login to Applicare console and go to Server Analyzer menu item on the left to view the details.
Database performance metrics help you with database performance monitoring and optimize it for your business. The metrics are calculated for the entire server not restricted to the database specified in the JDBC URL.
SQL Statement Profiling provides the performance statistics of database requests. You can view what statements are taking the most time and quickly diagnose performance impacting SQL/s. It also provides detailed stats including the database, count, average and various percentiles.
Top SQL Details
It displays the SQL statements that are executed most often, that use more system resources than other SQL statements.
It displays information about the current user’s session.
Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage.
The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information.
It display the Database Growth details.
This view provides a fast and convenient window into your physical server's/VM's performance including # of processes, context switches, CPU, memory, storage performance and etc.
CPU CORE Analyzer
This view provides the overall CPU and it's individual CPU core details.
This view provides the performance stats for CPU, memory and running processes organized. Historical snapshots of various processes running at any point of time and what kind of resources they were consuming at that point of time are available here. Applicare by default would take a snapshot of this info every 10 minutes but this can be configured by changing the snaps interval.
This view provides the disk usage accessed by each and every process.
This view provides the TCP, UDP, RAW, and UNIX connection Details.
The SQL statements can be downloaded as a report by clicking the print icon from the Server Analyzer menu SQL Screen.