Log in to Applicare console and navigate to the Server Analyzer menu item on the left to view the details.
Dashboard
Database performance metrics assist monitoring and optimizing your database's performance business. These metrics are calculated for the entire server, not just the database specified in the JDBC URL.
SQL
SQL Statement Profiling offers performance statistics for database queries. Helping you identify which statements most time-consuming and diagnose performance issues swiftly. It also provides detailed stats including information of the database, query count, average execution time and various percentiles.
Top SQL Details
This view shows the SQL statements that are executed most frequently and consume more system resources compared to others.
Session Details
It provides details about the current user’s session.
RAC Details
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.
SGA Details
The System Global Area (SGA) is a collection of shared memory structures, referred to as SGA components, that store data and control information.
Database Growth
It display the Database Growth details.
OS
This view offers a quick and easy overview of your physical server's or VM's performance, including metrics such as the number of processes, context switches, CPU Usage, memory and storage performance, among others.
CPU Core Analyzer
This view provides the overall CPU and it's individual CPU core details.
Processes
This view offers performance stats for CPU, memory and running processes. It includes historical snapshots of various processes. showing their resource consumption at specific times. By default, Applicare takes a snapshot every 10 minutes, but this interval can be adjusted through configuration.
Disk
This view shows the disk usage for each individual process.
Network Connections
This view provides the TCP, UDP, RAW, and UNIX connection Details.
SQL Report
You can download the SQL Statements as a report by clicking the print icon from the SQL Screen within the Server Analyzer menu.
Comments
0 comments
Article is closed for comments.