top of page

Database Health Check

Take the 100 point performance & health check with RIYOSU’s database performance software. Simply click the "Run Health Chek" button in "VITALS" to initiative the health check...

vitals.png

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

Complete Database Performance Management
bottom of page