Versions Compared

Old Version 1

changes.mady.by.user Chilukuri Srinivasa Reddy

Saved on

compared with

New Version 2

changes.mady.by.user Mayuresh Balaji Kamble

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated the hideelements-macro macro with the following parameter(s): []

Read Complete Release Notes

Feature released in SummitAI IT Operations Management (Denali SP1)

What's New?

New parameter groups are added to monitor the Oracle Servers.

Section
bordertrue
Column

Alert Logs

  • Host Address
  • Message Level
  • Message Text
  • Originating Time
  • Record Id

Archive Log Destination

  • Applied Sequence
  • Delay
  • Destination
  • Destination ID
  • Error
  • Fail Sequence
  • Log Sequence
  • Net Timeout
  • Status
  • Transmit Mode
  • Type

ASM Status

  • Header Status
  • Mode Status
  • Mount Status
  • State

ASM Utilization

  • Bytes Read
  • Bytes Written
  • Failed Read Requests
  • Failed Write Requests
  • Read Requests
  • Used Space
  • Used Space Perc
  • Write Requests

Buffer Gets Details

  • Buffer Gets
  • Executions
  • SQL Query

Corrupted Block

  • File Number
  • Number of Corrupted Blocks
  • Type of Block Corruption

Data File Utilization

  • Data File Status
  • Read Time
  • Write Time

Database Config

  • Archive Log Compression
  • Control File Type
  • Database Created Time
  • DB ID
  • DB Role
  • Force Logging
  • FRA Status
  • Guard Status
  • Log Mode
  • Open Mode
  • Open Reset Logs
  • Protection Mode
  • Switch Over Status

Database Data Files

  • Data Files Size
  • Temp Files Size
Column

Database Parameter

  • Available Free Memory
  • Available Free Space
  • Buffer Cache Hit Ratio
  • Dictionary Cache Hit Ratio
  • Library Cache Hit Ratio
  • No of connected users to DB through SQL-Net

DB Links

  • Creation Time
  • Link Owner
  • Link User Name

Deadlock Details

  • Blocking Session Status
  • Event
  • QUERY
  • Schema
  • SID
  • SQLFULLTEXT
  • Status
  • Terminal
  • User Name
  • Wait Class

Fast Recovery Area Details

  • FRA Space Limit
  • FRA Space Reclaimable Limit
  • FRA Space Used
  • Used Percentage

Fast Recovery Area Usage

  • FRA Actual Used Percentage
  • FRA Reclaimable Percentage

Index Details

  • Index Status
  • Owner
  • Table Space Name

Listener Status

  • Listener Status

Longest Transaction

  • Elapsed Seconds
  • Message
  • Opname
  • Sofar
  • Start Time
  • Target
  • Total Work
  • Units

OEM Advisor Status

  • OEM Status

PGA Stats

  • Cache Hit Percentage
  • Maximum PGA Allocated
  • PGA Freed Back To OS
  • Total Freeable PGA
  • Total PGA Allocated
  • Total PGA Used
Column

PGA Stats Per Process

  • Freeable PGA
  • Max PGA Used
  • PGA Allocated
  • PGA Used
  • Process Id

Redo Logs

  • Archive Status
  • Log Group
  • Log size
  • Log Status
  • Log Thread
  • Member Count
  • Member Group
  • Member Status
  • Member Type

Resource Limit For Process

  • Current Utilization
  • Max Utilization

RMAN Backup

  • End Time
  • Input Type
  • Session Key
  • Start Time
  • Status

Rollback Segment

  • Extends
  • High Water Mark Size
  • Hit Ratio
  • Initial Extent
  • Maximum Extent
  • Minimum Extent
  • Next Extent
  • Shrinks
  • Table Space Name
  • Wraps

Session Details

  • Serial Number
  • Session Commits
  • Session CPU Used
  • Session Cursor
  • Session Logical Reads
  • Session Memory Sorts
  • Session Physical Reads
  • Session Table Scans

Shared Pool Area

  • Fixed Area Size
  • Library Cache Size
  • Shared Pool Free Size
  • Shared Pool Size
  • SQL Area Size

User Details

  • Account Status
  • Days To Expire
  • DB Privileges
  • Expiry Date
  • User Name
  • User Profile

UI Changes

  • New Oracle Advanced option is available for the Server Type on the FILTERS pop-up page of the APPLICATION PARAMETER THRESHOLD. Select this option to search the newly added Groups and the respective Parameters.



  • You can select the Copy Below checkbox to replicate the values in the first row of that column to all the subsequent empty rows. 
    For example:
    If you select the Copy Below checkbox of the column Threshold Values, the value 9000 in the first row of the column replicates in all the empty rows of that column. See the below screenshot:


Configuration

  1. On the SERVICE ENTITLEMENT page, select the Monitoring Parameters (Operations > Configuration > General > Service Entitlement > Select the Tenant and Device Type as Server from the Filters pop-up page > Click ADD NEW on the ACTIONS panel and specify the Service Entitlement name > Select the required parameter’s check box and click SUBMIT). For more information, see Configuring Service Entitlements.

  2. On the APPLICATION PARAMETER THRESHOLD page, select the required filter criteria with the Server Type as Oracle Additional, and configure the threshold value to create an Event or log an Incident (Operations > Configuration > General >Application Parameter Threshold > Select the Tenant , Device Type as Server, and other required details from the Filters pop-up page > Click SEARCH > Specify the required Threshold values, Action Template, and Incident Template  > Click SUBMIT). For more information, see Configuring Application Parameter Threshold.