SAP HANA – Check Number Of Versions

select * from m_mvcc_tables

If there are too many versions (e.g. more than > 1,000,000), find out who is blocking the garbage collection.
Possibility:

  • long-running or unclosed cursors
  • long-running Serializable/RepeatableRead-isolation-mode transactions
  • hanging threads

 

 

Leave a Reply