Oracle VM Manager (OVMM): How To Check OVM_STATISTIC Table File Size and Records For Troubleshooting OVMM Slowness Issue?

In some cases we will see slowness from OVM Manager where jobs will take forever to complete or will hang. These kind of issues can happen if Oracle VM Manager statistics table file size grows huge in size or if there are millions of records in Oracle VM Manager statistics table.

Steps in this article will provide steps on how to validate OVM statistics table and number of records in OVM statistics table.

Verify OVM statistics table file size

Below command can be executed to check the file size of OVM statistics table file size.

ls -hlrt /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC.ibd

Usually above OVM_STATISTIC.ibd file size should be few GB in size (less than 5 GB) if OVM Manager is healthy.

Verify the number of records in OVM statistics table file

Follow below steps to check the records in OVM_STATISTIC statistics table

a. Run below command. When prompted for password enter the password, default is welcome1.

mysql ovs -u ovs -p -S /u01/app/oracle/mysql/data/mysqld.sock

You will be logged into SQL prompt.

b. Run below command in SQL prompt.

select count(*) from OVM_STATISTIC;

Usually records in OVM_STATISTIC.ibd table should be less than million if OVM Manager is healthy.

Products to which Article Applies

Oracle VM Manager - All versions

Additional References

https://docs.oracle.com/cd/E50245_01/

tarun boyella