Skip to Content
avatar image
Former Member

HANA garbage collection might be blocked alert

We are on Hana 1.0 SP11, we are receiving alerts "N-IM016794632-HANA LP0 M_MVCC_TABLES shows 1809497 active versions, Garbage Collector may be blocked. Check the SA".

When I check I don't find any transaction, query and statement in blocking situation. Can somebody guide me if I can increase the threshold value from 1000000 to 180000 as whenever Active version crossed 1000000 value it generates an alert? I studied that Active version more than 8 million is problematic slowness in Hana DB.

So my question is that: can I increase the value from 1000000 to 18 million to reduce the alert frequency.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 13, 2017 at 07:18 AM
    -1

    Have you already checked the KBA 2169283 - FAQ: SAP HANA Garbage Collection -> 13. Is the update transaction ID range relevant for garbage collection?

    Is that relevant for your case?

    Add comment
    10|10000 characters needed characters exceeded