DMX Agent Release Notes

2026-09-04

v1.0.9

Oracle Pro

Fixed Fixed an issue where query processing threads surged when periodic processing was delayed.

Fixed The script manager now skips processing when ORA-24347 occurs.

Fixed Fixed an issue where CPU (xos) metrics were not sent on Unix (Solaris, AIX, HP-UX).

2026-06-19

v1.0.8w

Oracle Pro

Fixed Fixed an incorrect max value in SQL statistics.

Fixed Fixed an incorrect client_info length in Active Session.

The length was incorrect or displayed garbage values.

Fixed Fixed an issue where the agent terminated abnormally on CentOS 8 and later.

Changed the logic used to save bind and plan information.

Fixed Improved the bind information duplicate-check logic.

Fixed an issue where bind information was rarely saved, and reduced the number of SQL executions.

Feature Added a feature to update the agent to the latest version from the Agent Update screen.

Feature Added a feature to change settings and restart the agent from the Agent Settings screen.

Restarting applies the changed settings.

2026-05-26

v1.0.8s

Oracle Pro

Feature Added NLS information to DB parameter collection.

Feature Added option to allow INSERT, UPDATE, DELETE operations in sqlmon.

Fixed Fixed abnormal termination caused by missing mutex handling in internal list operations.

2026-04-15

v1.0.8n

Oracle Pro

Fixed Fixed a collection error where the tablespace used value exceeded usagesize.

When a data file size exceeds maxsize (e.g., due to manual RESIZE), usagesize is corrected to use the size value.

v1.0.8m

Changed Excluded OFFLINE data files from tablespace collection.

Prevents collection errors caused by inaccessible OFFLINE files.

Fixed Fixed an issue where metric values spiked after reconnecting to the collection server.

Values accumulated during the disconnected period were displayed all at once as a delta on reconnection.

2026-03-27

v1.0.8j

Oracle Pro

Fixed Fixed the issue where the agent terminated abnormally due to SIGSEGV.

Changed Changed the DMX agent file name format.

Before: whatap.agent.dmx.19-1.0.8j.0324
After: whatap.agent.dmx-1.0.8j.19000.0324

Feature Added GCS/GES metrics for RAC environment monitoring.

Avg CR blocks receive time (ms)
Avg current blocks receive time (ms)
Fusion write to physical write ratio
Avg global lock get time (ms)
GC CR / current service time

Feature Added the auto_ext column when querying Tablespace ALL.

Fixed Fixed the issue where the elapse value in SQL statistics was inconsistent with wait + cpu.

Fixed Fixed the issue where the used value was displayed as 0 when the Tablespace was in FULL state.

2026-01-08

v1.0.8c

Oracle Pro

Changed Improved SQL identification processing

Improved to prevent misidentifying as a new SQL even if sql_exec_id changes from the initial value during single SQL execution
- This alleviates the issue where plan_hash_value = 0 was frequently displayed on the Runtime Plan screen

Changed Added Tablespace collection interval option

Option: tablespace_interval
Unit: minutes
Default value: 60
Minimum value: 5
- If set to a value less than 5, it is automatically corrected to 5 minutes. A log is recorded indicating the correction to 5 minutes
Can also be set to values greater than 60

Changed Added Agent Pause feature

Provides the ability to pause and resume agent collection
Location applied (screen): Agent list

Changed Improved Oracle detailed version information display

Displays detailed version information for Oracle 18c and later
Location applied: Instance list, Agent list

Changed Improved Wait Class periodic collection method

Option: waitclass_opt
Default value: 1
Configuration values
- 1: Changed to Memory-based collection method instead of the existing 1-minute periodic query collection method. Collects at the same interval as other metrics
- Values other than 1: Maintains the existing method. Query-based collection, fixed at 1-minute intervals

Changed Improved Tablespace information transmission method

Option: tablespace_send_opt
Default value: 0
Configuration values
- 0: Split transmission
- 1: Batch transmission
Improvement effect: Fixed the issue where duplicate data transmission caused errors in environments with many tablespaces

2025-10-20

v1.0.6

Oracle Pro

Fixed Fixed an issue where SQL text was missing in SqlStat

Feature Changed the unit of time_waited in db_oracle_dma_wait_class to seconds

Feature Excluded Idle events from db_oracle_dma_wait_class

Feature Added 5-minute and 1-hour statistics for db_oracle_dma_wait_class category

Feature Changed the unit of time_waited in event top to seconds

Feature Added partition information to object layout lookup

2025-08-18

v1.0.5m

Change When sqlmon results contain multiple rows, send all rows within 100 entries

Change Recognize int and float values in sqlmon results and add idx field

Change Added subpartition information in ObjectDetail and removed ini_trans, max_trans, avg_space_freelist_blocks, num_freelist_blocks fields

Fixed Fixed abnormal agent termination caused by memory violation

Fixed Changed tablespace result unit to M bytes

2025-07-08

v1.0.5g

Oracle Pro

Feature Improved sqlmon: stores up to 100 rows of results and recognizes int or float as numbers

Fixed Modified event handling by con_id for Oracle 12.1.0.2

Fixed Fixed error caused by null values when processing ASM disk info

Fixed Modified tablespace increment_by to be sent in MB (converted from blocks, float applied)

2025-06-25

v1.0.5b

Oracle Pro

Fixed Removed erroneous \n character from wait_class name in db_oracle_dma_sqlstat

2025-06-23

v1.0.5a

Feature Added holder_inst_id to db_oracle_dma_lock_info

Feature Added wait_class to db_oracle_dma_sqlstat

2025-06-10

v1.0.4y

New Added shmon feature to periodically execute shell scripts and collect results

Enable with shmon=1 in xos.conf
Create shmon directory under the agent path and place .sh files for periodic execution and result collection

New Oracle Pro 11.2.0.4 and 19.3 supported on AIX machines

Feature Processed with script manager thread

Feature Executed tkprof via thread during SQL trace

Feature Added agent option trace_tkprof_path=

2025-05-21

v1.0.4s

New Added wait information to sqlstat

Added wait time by event and wait time by wait class
Event names sent twice a day in db_index_event category

New Added support for Oracle 10.2.0.5 on Linux and AIX

New Added ASM disk size information

New Added Multi Script Manager feature

New Added table name of index in Plan info

New Added SQL trace on/off feature

2025-04-23

v1.0.4k

Oracle Pro

Feature Added the usagesize metric to the tablespace category.

Applies maxbytes if the data file is autoextensible (YES), or bytes if not (NO).
Calculates the tablespace usagesize by summing all values.

2025-04-03

v1.0.4h

New Added the option to handle code conversion when Korean characters are broken.

Defined character encoding for codefrom= and codeto=.
Selected and specified out of the results of the iconv -l command.
e.g. codefrom=EUC-KR, codeto=UTF-8

Feature Changed the default value for plan_elapse and bind_elapse from 5 seconds to 3 seconds.

Feature Changed the default sqlstat transmission cycle from 5 minutes to 1 minute.

Feature Added !rectype, @id, and @stime to sqlstat.

2025-01-21

v1.0.2b

Feature Added the sqlstat_send_interval=5 option (unit: minute).

2025-01-21

v1.0.2a

Feature Added the feature to create the plan.user file.

2024-12-24

v1.0.1y

Changed Adjusted the frequency at which the dmx agent is run with prx again.

Default cycle 20 times: The default cycle is 10 seconds, and can be set with the interval option in the prx.conf file.
After that, it tries to re-run 10 times every minute, then 5 times every 10 minutes, and afterwards every hour.

2024-12-20

v1.0.1x

Feature Added the tablespace option.

When querying the free space, a query timeout occurs. So a different view is provided depending on the option.

Changed Added the sequence in object_info.

Fixed Fixed the SIGSEGV issue when there is any file with a long file name (32 characters or more) in the same path as the agent.