What is MaxGauge?

MaxGague is a software that provides various functions essential for database performance management such as real time monitoring, diagnosis and analysis, and performance tuning for database systems.

Back To Top

MaxGauge Function

The following are the main functions which MaxGague provides.

Back To Top

SUB) Minimum Load Data Collection

MaxGauge’s agent uses the SGA Direct Access method for data collection which minimizes the load.

Note. With the SGA Direct Access method, data can be collected even in a DB hang mode.

Back To Top

SUB) Resourcing Monitoring and Analysis

The quickest way to check the current status of a database system is by checking the trends of main performance indicators. In other words, for DBMS performance monitoring, you need to check the trends of main performance indicators such as the system CPU usage (%), I/O generated in the database, SQL execution count, the number of sessions currently in active state and the wait time of wait events. And for this reason, the data which MaxGauge collects are as follows:

  • All performance indicators provided by Oracle
  • Active session count
  • Lock wait session count
  • All wait events (wait class) provided by the oracle
  • OS main resource performance data

Back To Top

SUB) Session and OS Process Monitoring and Analysis

One of the important things in database performance monitoring is the ability to easily check the sessions and OS processes that are currently running or in waiting from various points of view.  As for such, the types of monitoring and analysis which MaxGauge provides are as follows:

  • Active session monitoring
  • (Global) Lock wait session monitoring
  • Parallel query process monitoring
  • Remote query process monitoring
  • OS process monitoring

Back To Top

SUB) SQL Elapsed Time Monitoring

MaxGauge offers a function in which you can see the SQL elapsed time distribution chart, which provides the elapsed time of all SQLs being executed in the database system in a distribution chart format.

Back To Top

SUB) Application and SQL Tuning

Among the numerous applications and SQLs being executed in a complex work environment, identifying the cause of the bottleneck which is slowing down the application performance and verifying the malicious SQL in a quick and accurate manner are very critical.  MaxGauge clearly analyzes the cause of application’s performance delay through an OWI-based performance analysis methodology.  It also provides a function which quickly tracks down the cause of the individual SQL’s performance delay by checking the real time execution plan.

Back To Top

SUB) Real Time Performance Analysis

MaxGauge employs an architecture which stores up all the performance data in the repository in real time. Therefore, in the event you are trying to closely analyze the performance degradation discovered during real time monitoring, you can immediately connect with the performance analysis window.

Back To Top

SUB) Alarm Settings and SMS Connection

In order to build a pro-active monitoring environment, one of the essential components is an effective alarm setting function. MaxGauge not only offers alerts for various performance items but also provides the SMS (Short Message Service) connection function. The items for which you can set up the alerts in MaxGauge are as follows:

  • All performance indicators provided by Oracle
  • Active session count
  • Lock wait session count
  • All wait events provided by Oracle
  • Programs’ excessive use of resource
  • SGA free memory
  • OS disk usage
  • Tablespace usage
  • Oracle alert log
  • Monitoring the life and death of DB and listener process

Note. Reference the “MaxGauge Configuration Manual” for further information regarding the SMS connection function.

Back To Top

SUB) SQL Performance Analysis

MaxGauge’s agent collects the workload information of SQLs executed by the active sessions at 20 times per second (maximum 100 times per second) by polling method. The workload information which the MaxGauge agent collects is as follows:

  • Elapsed time
  • CPU usage time
  • Wait events wait time (Provides wait time by wait event)
  • Session logical reads
  • Physical reads
  • Redo size
  • Table scan blocks gotten
  • Table fetch by row id
  • Sorts (rows)

Back To Top

SUB) Data Visualization

One of the advantages of data visualization is that it provides convenience for analysis through the “visualization” technique. In the event of analyzing multiple dates or multiple instances simultaneously, MaxGauge provides views which have applied the “data visualization” technique. The visualization techniques that have been applied in MaxGauge are as follows:

  • Flow Visualization
  • Heat Map

Back To Top

Getting Started

To get started on the task of performance management with MaxGauge, enter the MaxGague web address into the web browser.


Note. IP is the IP of the server in which one of MaxGauge’s components, platform.JS, is located.  The Port is port the platform.JS uses.  Please reference “MaxGauge Admin Manual” for information regarding MaxGauge architecture.

The initial window will appear as follows.


Item Description
 3 Use the Connection Manager Window and go through the process of selecting the target instance for monitoring.
 4 Connect to the Performance Analyzer.

Note. MaxGauge ID and password are case-sensitive. Reference the “MaxGauge Configuration Manual” regarding user account management.

Back To Top

SUB) Enter ID/Password

Enter the MaxGauge ID and password.  The default ID and password are as follows.

ID Default Password Permission
admin manager Super User

Note. MaxGauge ID and password are case-sensitive.  Reference the “MaxGauge Configuration Manual” regarding user account management.

Back To Top

Connection Manager

The connection manager is used in the startup stage for selecting the target instance for monitoring. Even after the connection set up is complete, you can use the Connection Manager icon 5 to change the target instance for monitoring.

The initial window configuration is as follows.


Back To Top

SUB) Grid Column

Column Name Description
Group Name Group Name
Instance Name Instance Name
Business Name Work Name
IP Address DB Server IP
Port No MaxGauge Agent (RTS) Port#
RTS Status MaxGauge Agent (RTS) Status
7 Agent Down
8 Agent Alive
DB Status DB Status
7 DB Down
8 DB Alive
RAC Name RAC Group Name

Back To Top