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.