Will I get any confirmation from DVLA?

If you've received a Certificate of Destruction, you won't get any additional form of confirmation from DVLA.

However, if you've been in touch with DVLA yourself, you should get a letter from them confirming that you're no longer responsible for the car. If you don't receive this letter within four weeks, you should contact DVLA.