Feature released in SummitAI IT Operations Management (Denali SP1)

What's New?

New parameter groups are added to monitor the Oracle Servers.

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

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

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

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.
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.