Latest version information
Guardians for oracle provides an easy-to-use analysis and diagnostic platform that significantly reduces the need for additional costly investments to maintain and manage multiple application systems.
The advantages of Guardians for Oracle
► The four major advantages are real-time analysis, diagnosis, monitoring, and preserving system performance without compromise.
Exclusive technologies of Guardians for Oracle
► There is no need to create any objects within the database, which eliminates potential burdens or security audit issues in the database.
► It does not involve any database operation processes, reducing administrative complexity.
► Even if the database speed is slow or inexplicably stagnant, it is still possible to continue collecting data and identify the underlying causes.
► High-performance real-time retrieval of various performance KPIs and statistical indicators.
► System resource utilization is close to zero.
The analysis and diagnostic capabilities of Guardians for Oracle
► It can clarify ambiguous issues and track down any uncertainties encountered, including difficult-to-confirm process-related problems.
► Significantly reducing additional costs, by over 85%, for investigating and resolving performance issues that may have already occurred.
The core value of innovation and revolution in Guardians for Oracle is to provide users with genuine assistance
► Maximizing the efficient utilization of database system resources to align with the benefits of enterprise users.
► The tedious management tasks of the database can be handed over to Guardians for Oracle, Development task and project advancement work can be more focused.
| New features | Function description |
| Workload trend chart | The Workload module has added transaction trend chart |
| Real time module | Memory consumption is measured using the “free” command, which displays the actual usage status. |
| Monitoring for all agents. | The Real Monitor module has been enhanced to simultaneously monitor both the hosts with installed agents and their resource consumption. |
| Email alerts use groups | Email alerts are configured to use groups in the “db_alert.ini” file. |
| New UI | The Client interface adopts New UI and expands the window to maximize visual experience. |
| New features | Function description |
| HTML report | Changed the default zoom time range from 10% to 100%. |
| Added search functionality | Added SQL query functionality to the Orbit client. |
| Bug Fixes | Bug Fixed Description |
| FIX-0011 | Fix for failed sending of syncbot messages. |
| Enhancements | Feature Description |
| Added Syncbot | Support for sending JSON messages. (Requires an API receiver) |
| Bug Fixes | Bug Fixed Description |
| FIX-0010 | In Oracle 12c version, when setting the MEMORY_TARGET parameter, data collection is not being captured. |
| Enhancements | Feature Description |
| Added SQL execution time | When the SQL execution time is greater than or equal to the configured value (in seconds), an alert will be triggered. |
| Added Tablespace Free % alert | When tablespace freespace is less than or equal to the configured value (in percentage), an alert will be triggered. |
| Enhancements | Feature Description |
| Added Syncbot | Support for sending Line Notify and Telegram Bot messages |
| Enhancements | Feature Description |
| Sender Name for Email | Support for setting sender_name to specify the sender’s name in emails. |
| Enable Session IP Configuration |
Create Session Logon Trigger with client_info supporting Session IP address. Please refer to the Installation Guide: V. Enabling Session IP Configuration. |
| Performance Report | Added MBPS, Redo, Net I/O trends |
| Bug Fixes | Bug Fixed Description |
| FIX-0009 | SYS Event Performance Optimization in Windows environment |
| Enhancements | Feature Description |
| System Statistics |
Added system statistics for MBPS, IOPS, and NETWORK. 1. IOPS = “physical reads total I/O requests”+ “physical writes total I/O requests” 2. MBPS = “physical reads total bytes”+ “physical writes total bytes” 3. OraNet = “bytes sent via SQL*Net to client”+”bytes received via SQL*Net from client”+”bytes sent via SQL*Net to dblink”+”bytes received via SQL*Net from dblink” |
| Active SQL Module | The expense time of Active SQL was distorted in the Session Scheduler JOB due to the use of the last_call_ct value. It has been changed to the sum of Active SQL sampling counts. |
| Bug Fixes | Bug Fixed Description |
| FIX-0008 | In AIX and Solaris environments, the memory usage of Guardians for Oracle has been changed from RSS to data/heap size. |
| Enhancements | Feature Description |
| Active SQL Module | Added consumption time and SQL statistics for Active SQL. |
| Bug Fixes | Bug Fixed Description |
| FIX-0007 |
Memory Usage Monitoring: Using RSS memory for memory usage, which includes accessed SGA memory. It has been changed to data/heap size. |
| Bug Fixes | Bug Fixed Description |
| FIX-0006 | After several days of service suspension, when restarting the service, the Daily Report still displays the content of the previous Old Snapshot from several days ago. |
| Enhancements | Feature Description |
| Client-side | Added Tablespace Daily Report and Table Daily Report. |
| Bug Fixes | Bug Fixed Description |
| FIX-0004 | When restarting the service, it fails to properly read historical memory cache pointers. |
| FIX-0005 | In the Daily Report, there are instances where very small time intervals (<5) are displayed for Snapshot points. By default, the time axis is shown in milliseconds. Modify the minimum unit to 1 minute. |
| Enhancements | Feature Description |
| Email Sending Functionality | Support for sending emails via SMTP, with the option to use either hostname or IP address. |
| Bug Fixes | Bug Fixed Description |
| FIX-0003 | When the data files for Daily Report / Monthly Report storage are corrupted, it can cause a process crash. |
| Enhancements | Feature Description |
| Reporting | Regularly send performance reports, Tablespace Daily reports, and Monthly reports via email. |
| Bug Fixes | Bug Fixed Description |
| FIX-0001 | Support for bypassing SMTP password authentication. |
| FIX-0002 | Retrieve the name of the SYSTEM tablespace from the row cache. |
| Enhancements | Feature Description |
| SSL Password | Support for SSL email encryption and storage. |
| Email Alerts | Added Tablespace Alerts and attached Tablespace Usage Trend Chart in the email. |
| Enhancements | Feature Description |
| Alerts | Support for email alerts. |
| Enhancements | Feature Description |
| Connection Encryption | Support for client / server connection using HTTPS / SSL and HTTP / gzip compression. |
| Enhancements | Feature Description |
| Support Oracle Version | Support for Oracle 19c database |
| Multiple languages | Support for SQL statements in multiple languages. |
| Dynamic loading of OCI | The Windows version of the watchsetup program has been modified to dynamically load OCI, allowing better compatibility for running multiple Oracle versions and multi-instance environments on the same machine. |