• 网络与数据中心管理
  • 服务器与应用性能管理
  • IT服务管理
  • Windows AD域管理
  • 终端管理
  • IT安全
  • MSP
  • IT运维平台
 
 
应用性能管理(APM)
保证物理、虚拟、云环境的应用性能
 
 
简化终端设备管理
全面管控PC计算机、智能手机以及平板电脑,确保网络安全
 
 
IT运维外包服务工具
多租户模式,为您的客户提供更好的服务
IT运维管理平台
统一监控、集中运维
 

Monitor Oracle Sessions

Oracle Performance Monitoring: Monitor Oracle Sessions

Monitoring Oracle Sessions made easy

The ManageEngine Applications Manager Oracle Monitoring capability includes monitoring Oracle Sessions. A session consists of every connection to the Oracle database by a user from a specific process. By tracking the number of Oracle sessions, we can track how busy a particular server is. This gives insight on how loaded an Oracle Database is. It also helps understand which users take more system resources.

It is hence important for the database administrator to monitor the sessions in addition to monitoring tablespace, monitoring datafiles for ensuring smooth functioning of production databases. Below graphic represents Applications Manager's Oracle User Session monitoring capability.

Monitor Oracle Sessions

Metrics while monitoring Oracle Sessions:

Some of the metrics for Oracle datafile management are as follows.

  • User Session : This tells the exact user connecting to the Oracle DB and can also help identify which business application / host is using the Oracle database resources.
  • Elapsed Time : helps identify time a specific user uses the Oracle database and gives hints on users who could even be running long running queries.
  • CPU Used by a Specific User: helps identify users consuming high system resources. Helps segment users and identify if non critical business applications are consuming high system resources.
  • Number of Memory Sorts : helps identify if queries used by a specific user are optimal or can be optimized even more.
  • Number of Oracle Table Scans: helps identify if queries used by a specific user are optimal or can be optimized even furthur.
  • Physical Reads: gives an indication of how many times the disk is hit for a specific user. These metrics together with the other metrics give an good indication of where system resources are being spent.
  • Monitor Logical Reads
  • Monitor Number of Commits
  • Cursor
  • Buffer Cache Hit Ratio

Related Oracle Monitoring Capability

我们的客户

展开