ManageEngine® Applications Manager


Oracle DB Servers

<< Prev

Home

Next >>

Oracle DB Servers

Supported Versions

Applications Manager supports monitoring of Oracle database servers of versions 8.x, 9i, 10g, 10.1.3, 11g, RAC (Real Application Clusters) and 12c.

 

Monitored Parameters

Applications Manager provides out-of-the-box performance metrics and helps you visualize the health and availability of an Oracle Database server farm. Database administrators can login to the web client and visualize the status and Oracle performance metrics.

 

Go to the Monitors Category View by clicking the Monitors tab. Click on Oracle Server under the Database Servers Table. Displayed is the Oracle servers bulk configuration view in three tabs:

Note: To create a new Oracle database monitor, you should have admin privileges. Minimum User Privileges -> user with CONNECT and SELECT_CATALOG_ROLE roles

 

Click on the monitor name to see all the server details listed under the following tabs:

 

Overview

 

Monitor Information

Parameters

Description

Name

 Name of the Oracle server monitor

Oracle Version

 Refers to the Version of the Oracle Database.

Oracle Start Time

 Refers to the time when Oracle server was started.

Availability

 Refers to the status of the database server - available or not available.

Today's Availability

Parameters

Description

Current Status

Availability history graph with uptime

Connection Time

Parameters

Description

Connection Time

 Refers to the time taken to connect to the database.

User Activity

Parameters

Description

Number of Users

Graph for the number of users executing an SQL Statement. vs time

Table spaces with least free bytes

Parameters

Description

Name

The name of the table space.

Free Bytes (MB) The free space available in bytes.
% of Free Bytes The percentage of free space available in bytes.

Database Details

Parameters

Description

Database Created Time

Creation time of the database.

Open Mode

Indicates the Open mode of the Instance which can be either Read Write or Read.

Log Mode

If the transactions are written on the Log, the Log mode will be ARCHIVELOG , or else, the Log mode will be NOARCHIVELOG.

Database Status

Parameters

Description

Database Size

Size of the database in Megabytes.

Average Executions

This is the average number of executions that happen during the execution of every SQL Statement.

Reads

Refers to the number of reads from the database.

Writes

Refers to the number of writes to the database.

Block Size

This refers to the lowest possible storage area for an Instance in bytes.


Hit Ratio

Parameters

Description

Buffer

Creation time of the database.

Data Dictionary The ratio of the data gets to the data misses in the row cache is Data Dictionary Hit Ratio.
Library The Library cache stores all shared SQL and PL/SQL blocks, along with their parse trees. In OLTP environments where a large numbers of users are entering and exchanging data, there is a great chance for overlapping the parse and execute needs of those different queries. Such an overlap in the library is called a cache hit and the ratio determined to the misses and hits is called Library Cache Hit Ratio.


SGA Details

Parameters

Description

Buffer Cache Size

The total size of the Buffer Cache given in bytes.

Shared Pool Size

The size of the shared pool given in bytes.

Redolog Buffer Size

The size of the buffers for the Redo Logs in bytes.

Library Cache Size

The size of the Library Cache given in bytes.

Data Dictionary Cache Size

The cache size of the data dictionary or row cache in bytes.

SQL Area Size

The size of the SQL Area for usage of SQL/PL statements (bytes).

Fixed Area Size

The size of the SGA, which is fixed throughout the instance.


Top

Table Space

 

Table Space Details

Parameters

Description

Name

Refers to the name of the Table space.

Allocated Bytes

Refers to the size of the Table space in bytes.

Allocated Blocks

Refers to the number of allocated blocks in Table space.

Data Files

Refers to the number of data files in Table space.

Table Space Status

Parameters

Description

Name

Refers to the name of the Table space.

Status

Tablespace status: ONLINE, OFFLINE, or INVALID (tablespace has been dropped)

Free Bytes

Refers to the available free space in bytes.

Free Blocks

Refers to the number of free blocks in Table space.

Reads

Refers to the number of reads from the Table space.

Writes

Refers to the number of writes on the Table space.

Read Time

Time taken for a single read from the Table space.

Write Time

Time taken for a single write on the Table space.

Performance of Data Files

Parameters

Description

Data File Name

Name and location of the data file.

Table Space Name

Name of the Table space.

Status

If a data file is a part of the system table space, its status is SYSTEM (unless it requires recovery). If a data file in a non-SYSTEM table space is online, its status is ONLINE. If a data file in non-SYSTEM table space is offline, its status can be either OFFLINE OR RECOVER.

Created Bytes

Size of the Data file in bytes.

Reads

Refers to the number of reads from the Data file.

Writes

Refers to the number of writes to the Data file.

Average Read Time

Refers to the average read time.

Average Write Time

Refers to the average write time.

 

Objects Approaching MAX Extents

Parameters

Description

Owner

Owner name of the table space.

Table space name Name of the table space.
Segment Name Name of the segment approaching maximum extents
Segment Type The type of segment approaching maximum extents
Extents Number of extents allocated to the segment
Max Extents Maximum allowed extents that can be filled in a segment
Next Extent (MB) Next extent size in MB

Top

Session

 

Session Details

Parameters

Description

ID

Session Identifier for the connected session.

Status

Current status: ONLINE, OFFLINE, or INVALID (tablespace has been dropped).

Machine

Name of the operating system user.

User Name

Name of the Oracle process user.

Elapsed Time

Time elapsed in seconds after which the user has logged into the oracle server.

CPU Used

CPU centiseconds (divide by 100 to get real CPU seconds) used by this session.

Memory Sorts

Number of memory sorts performed.

Table Scans

Number of table scans performed.

Physical Reads

Physical reads for the session.

Logical Reads

Sum of consistent gets and db block gets.

Commits

Number of commits made by user in a second.

Cursor

Number of cursor currently in use.

Buffer Cache Hit Ratio

Percentage of session logical reads taking place from the buffer (1-physical reads/session logical reads*100).


Session Waits

Parameters

Description

ID

Session Identifier for the connected session.

User Name

Name of the Oracle process user.

Event

Resource or event for which the session is waiting

State

Wait state:
0 - WAITING (the session is currently waiting)
-2 - WAITED UNKNOWN TIME (duration of last wait is unknown)
-1 - WAITED SHORT TIME (last wait <1/100th of a second)
>0 - WAITED KNOWN TIME (WAIT_TIME = duration of last wait)

Wait Time

A nonzero value is the session's last wait time. A zero value means the session is currently waiting.

Seconds in Wait

If WAIT_TIME = 0, then SECONDS_IN_WAIT is the seconds spent in the current wait condition. If WAIT_TIME 0, then SECONDS_IN_WAIT is the seconds since the start of the last wait, and SECONDS_IN_WAIT - WAIT_TIME / 100 is the active seconds since the last wait ended.


Top

Rollback & Corrupted blocks

 

Rollback Segment

Parameters

Description

Segment Name

Name of the rollback segment.

Table Space Name

Name of the tablespace containing the rollback segment.

Status

ONLINE if the segment is online, or PENDING OFFLINE if the segment is going offline but some active (distributed) transactions are using the rollback segment. When the transaction(s) complete, the segment goes OFFLINE.

Current Size

Current size in bytes of the rollback segment.

Initial Extent

Initial extent size in bytes.

Next Extent

Secondary extent size in bytes.

Min. Extent

Minimum number of extents.

Max. Extent

Maximum number of extents.

Hit Ratio

Ratio of gets to waits. This should be >= 99%.

HWMSize

High Water Mark of rollback segment size.

Shrinks

Number of times rollback segment shrank, eliminating one or more additional extents each time.

Wraps

Number of times rollback segment wraps from one extent to another.

Extend

Number of times rollback segment was extended to have a new extent.

 

Blocks Corrupted

Parameters

Description

File Number

Datafile number

Block Number First block of the corrupted range
Number of corrupted blocks Number of contiguous blocks in the corrupted range
Type of block corruption

Type of block corruption in the datafile:

  • ALL ZERO - Block header on disk contained only zeros. The block
    may be valid if it was never filled and if it is in an Oracle7 file. The
    buffer will be reformatted to the Oracle8 standard for an empty
    block.
  • FRACTURED - Block header looks reasonable, but the front and back
    of the block are different versions.
  • CHECKSUM - optional check value shows that the block is not
    self-consistent. It is impossible to determine exactly why the check
    value fails, but it probably fails because sectors in the middle of the
    block are from different versions.
  • CORRUPT - Block is wrongly identified or is not a data block (for
    example, the data block address is missing)
  • LOGICAL - Specifies the range is for logically corrupt blocks.
    CORRUPTION_CHANGE# will have a nonzero value.

 


Top

SGA

 

SGA Performance

Graph displaying value (in %) of Buffer Hit Ratio, Data Dictionary Hit Ratio and Library Hit Ratio vs time

Parameters

Description

Buffer Hit Ratio

When a scan of the buffer cache shows that there are no free buffers, Database Block Writer determines which blocks to be eliminated based on a least recently used algorithm or LRU. Having a block required by a user process in the buffer cache already is called a buffer cache hit or is determined as a ratio. Hits are good because they reduce the amount of disk I/O required for the user process.

Data Dictionary Hit Ratio

The purpose of the row or dictionary cache is to store rows of information from the data dictionary in memory for faster access. The row cache is designed to hold the actual rows of data from objects in data dictionary. While this data is held in the row cache, the users of the database may access that information more quickly than if Oracle had to read the data into memory from disk. The ratio of the data gets to the data misses in the row cache is Data Dictionary Hit Ratio.

Library Hit Ratio

The Library cache stores all shared SQL and PL/SQL blocks, along with their parse trees. In OLTP environments where a large numbers of users are entering and exchanging data, there is a great chance for overlapping the parse and execute needs of those different queries. Such an overlap in the library is called a cache hit and the ratio determined to the misses and hits is called Library Cache Hit Ratio.

 

SGA Details

Parameters

Description

Buffer Cache Size

The total size of the Buffer Cache given in bytes.

Shared Pool Size

The size of the shared pool given in bytes.

Redolog Buffer Size

The size of the buffers for the Redo Logs in bytes.

Library Cache Size

The size of the Library Cache given in bytes.

Data Dictionary Cache Size

The cache size of the data dictionary or row cache in bytes.

SQL Area Size

The size of the SQL Area for usage of SQL/PL statements (bytes).

Fixed Area Size

The size of the SGA, which is fixed throughout the instance.


SGA Status

Parameters

Description

Buffer Hit Ratio

When a scan of the buffer cache shows that there are no free buffers, Database Block Writer determines which blocks to be eliminated based on a least recently used algorithm or LRU. Having a block required by a user process in the buffer cache already is called a buffer cache hit or is determined as a ratio. Hits are good because they reduce the amount of disk I/O required for the user process.

Data Dictionary Hit Ratio

The purpose of the row or dictionary cache is to store rows of information from the data dictionary in memory for faster access. The row cache is designed to hold the actual rows of data from objects in data dictionary. While this data is held in the row cache, the users of the database may access that information more quickly than if Oracle had to read the data into memory from disk. The ratio of the data gets to the data misses in the row cache is Data Dictionary Hit Ratio.

Library Hit Ratio

The Library cache stores all shared SQL and PL/SQL blocks, along with their parse trees. In OLTP environments where a large numbers of users are entering and exchanging data, there is a great chance for overlapping the parse and execute needs of those different queries. Such an overlap in the library is called a cache hit and the ratio determined to the misses and hits is called Library Cache Hit Ratio.

Free Memory

Refers to the size of the free memory in bytes.

 


Top

Query

Query attributes are not monitored by default. To monitor query metrics:

Buffer Gets

Parameters

Description

Buffer Gets

Number of buffer gets for the child cursor

Executions

Number of executions that took place on the object since it was brought into the library cache

Buffer Gets per Executions

The ratio of buffer gets to execution in the current polling interval

Query

First thousand characters of the SQL text for the current cursor

Disk Reads

Parameters

Description

Disk Reads

Number of disk reads for this child cursor

Executions

Number of executions that took place on this object since it was brought into the library cache

Disk Reads per Executions

The ratio of disk reads to execution in the current polling interval

Query

First thousand characters of the SQL text for the current cursor


Top

Lock Statistics

 

Lock statistics are not monitored by default. To monitor lock metrics:

 

Sessions holding a lock

Parameters

Description

Id

Session identifier of Session holding a lock

Serial 

Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.

Machine

Operating system machine name.

PROGRAM

Operating system program name.

Lock Wait  Address of lock waiting for; null if none.

Sessions waiting for a lock

Parameters

Description

Waiting Session ID

ID of Session waiting for lock.  

Holding Session ID

ID of Session holding lock.

Lock Type

The lock type.

Mode Held 

The mode held.

Mode Requested The mode requested.
Lock ID1, ID2 The Lock IDs.

Lock Statistics

Parameters

Description

Object Name

Name of the locked object.

Session Id 

Session Id of locked object.

Serial   

Session serial number. Used to uniquely identify a session's objects.

Lock Mode

Mode of lock.

OS Process ID Operating system process identifier.
Last call Minute If the session STATUS is currently ACTIVE, then the value represents the elapsed time in seconds since the session has become active. If the session STATUS is currently INACTIVE, then the value represents the elapsed time in seconds since the session has become inactive.
Time of logon Time of logon.

Top

Jobs & Backup

 

Schedule jobs details

Parameters

Description

Job name

Name of the job.

Current state

Current state of the job (DISABLED, RETRY SCHEDULED, SCHEDULED, RUNNING, COMPLETED, BROKEN, FAILED, REMOTE, SUCCEEDED, CHAIN_STALLED).

Last run status Status of the job run.
Last run date Last date on which the job started running.
Last run duration Amount of time the job took to complete during the last run (in seconds)
Next run date Next date on which the job is scheduled to run.
Run count Number of times the job has run.
Failed count Number of times the job has failed to run.
Retry count Number of times the job has retried, if it is retrying.
Elasped time Elapsed time since the job was started (in seconds).

 

Backup jobs details

Parameters

Description

Session Key

Session identifier.

Input Type Type of input files backed up in this session.
Last backup time Last backup start time.
Status Back up status One of the following values:( RUNNING WITH WARNINGS,RUNNING WITH ERRORS,COMPLETED,COMPLETED WITH WARNINGS, COMPLETED WITH ERRORS, FAILED).
Time Taken Time Taken to complete last back-up (in seconds).
Backup size in MB Backup size in megabytes.

 


Top

PGA

 

TOP 10 Process using PGA

Graphical representation of the PGA used by processes.

 

PGA Stats Per Process (TOP 10)

Parameters

Description

Process Id

Oracle process identifier.

Program Name

Program in progress.

PGA used (MB)

Amount of PGA memory consumed in megabytes.

PGA Allocated (MB)

Maximum PGA memory allocated at one time since instance startup.

Max PGA Used (MB)

PGA memory currently used by the process.

Freeable PGA (MB)

Allocated PGA memory which can be freed.

PGA Stats

Parameters

Description

Total PGA used (MB)

Indicates how much PGA memory is currently consumed.

Total PGA allocated (MB)

Current amount of PGA memory allocated by the instance.

Maximum PGA allocated (MB)

Maximum amount of PGA memory consumed .

Total freeable PGA (MB)

Number of bytes of PGA memory in all processes that could be freed back to the operating system.

PGA freed back to OS (MB)

Number of bytes of PGA memory freed back to the operating system.
Cache hit percentage Percentage of PGA memory component, cumulative since instance startup
Resource being used by processes (%) Percentage resources currently being used by processes.

Resouce limit for processes

Parameters

Description

Resource being used by processes

Resources (locks or processes) currently
being used.

Free Resource

Percentage of unused resources.


Top

ASM

Disk Group Details

Parameters

Description

Disk Group Number

Cluster-wide number assigned to the disk group.

Name Name of the disk group.
State State of the disk group relative to the instance (Connected, Broken, Unknown, Dismounted, Mounted).
Type Redundancy type for the disk group (EXTERN, NORMAL, HIGH).
Total Memory (GB) Total capacity of the disk group (in megabytes).
Free Memory (GB) Unused capacity of the disk group (in megabytes).

Note:
This monitor type is not supported in the Cloud Starter Edition. Compare Editions.

See Also

Creating New Monitor - Oracle Database Server

 

 

<< Prev

Home

Next >>

MySQL DB Servers

MS SQL DB Servers