RIYOSU

VITALS will analyse your database’s critical performance and stability metrics such as:

• ​Cluster Balance

• Cluster Errors

• Cluster Latency    Wait Events:

• Top Wait Events

• Buffer Busy Waits(By Object)

• Row Lock Waits(By Object)

• Trans Slot Waits(By Object)

• Data Dictionary

• Library Cache

• Shared Pool

• Buffer Cache

• Log Buffer Waits

• Log Buffer Latching

• Log Wait Times

• Log Switch Frequency

• Execution plan flip-flops

• Long Operations

• Hard Parses

• Failed Parses

• PL/SQL CPU Consumption

• Uncommitted Transactions

• Invisible Indexes

• Excessive Indexing

• Insufficient Indexing

• Index Usage Statistics

• General Alerts

• High Water Marks

• Flashback Advice

• Force logging Advice

• Parameter Advice

• Ctrl File Multiplexing

• Ctrl File Retention

• REDO Log Multiplexing

• UNDO Statistics

• ASM Statistics

• Files In Backup Mode

• Media Recovery

• Dataguard Gaps

• Unusable Indexes

• Invalid Objects

• Disabled Constraints

• SYS/SYSTEM Object violations

• Missing & Stale Statistics

• Row Chaining

• Orphaned Synonyms

• Not Null Columns

• Locked Statistics

• Locked Objects

• Number Precision

• Tablespace Space Check

• Extent Space Check

• Orphaned Tablespaces

• Active Restore Points

• TEMP Space Usage

• UNDO Space Usage

• Database File Count

• Physical I/O(By Object)

• Logical I/O(By Query)

• CPU(By Query)

• Physical I/O(By Query)

• Sorts(By Query)

• Elapsed Time(Query)

• Table Scans(By Object)

• Tables Scans(By Query)

• PGA Effectiveness

• Disk Sorts

• Top Latches

• Memory Resize Operations

• Result Cache Statistics

• PGA Consumption

• PGA Advisor

• SGA Advisor