My Oracle Support Banner

[OVM] Issues with huge OVM_STATISTIC.ibd used as OVM_STATISTIC Table. (Doc ID 2216441.1)

Last updated on MAY 21, 2024

Applies to:

Oracle VM - Version 3.4.1 and later
Oracle Cloud Infrastructure - Version N/A and later
Linux x86-64

Symptoms

The OVM_STATISTIC.ibd of OVMM database is growing too huge.

# du -hs /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC*
16K /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC.frm
62G /u01/app/oracle/mysql/data/ovs/OVM_STATISTIC.ibd <--- this file

 

 

Login MySQL, the table contains too many records.

# mysql ovs -u ovs -p -S /u01/app/oracle/mysql/data/mysqld.sock
mysql> select count(*) from OVM_STATISTIC;
+----------+
| count(*) |
+----------+
| 97147640 |
+----------+

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.