DESTROY is a special name of the destructor method for blessed objects and tied variables. It is called automatically when an object is no longer referenced, and is about to be destroyed. See more f.ex. in perltoot Destructors

As to what should it do, that depends on the nature of the class, f.ex. if constructor opens a connection, then destructor should close it, same OO stuff as elsewhere.