Displays the free holes in databases.

Introduction

OrientDB keep the free space as “holes”. To remove the holes you have to compact the database using the compact database command.

Syntax

  1. show holes

Example:

  1. orientdb> show holes
  3. Found 20 holes in database demo:
  4. +----------------------+----------------------+
  5. | Position             | Size (in bytes)      |
  6. +----------------------+----------------------+
  7. |                49907 |                   87 |
  8. |               181183 |                   71 |
  9. |               272858 |                  150 |
  10. |               623022 |                  137 |
  11. |               198122 |                   85 |
  12. |               519971 |                  108 |
  13. |              2267766 |                  160 |
  14. |               369795 |                   82 |
  15. |              1017483 |                  128 |
  16. |               736590 |                   92 |
  17. |              1052774 |                  117 |
  18. |               934513 |                   71 |
  19. |              1180103 |                   91 |
  20. |              1137256 |                   75 |
  21. |              1242670 |                   81 |
  22. |              1685483 |                  124 |
  23. |                46420 |                  107 |
  24. |                46143 |                   66 |
  25. |               815670 |                   88 |
  26. |                24839 |                   79 |
  27. +----------------------+----------------------+
  28. |      Total hole size |               1,95Kb |
  29. +----------------------+----------------------+

This is a command of the Orient console. To know all the commands go to Console-Commands.