The oven has a certain amount of heat energy. It will release that as it cools to be in thermal equilibrium with its surroundings.
The net amount transferred to the house itself, will depend on a couple of things:
Firstly, is the oven, as a system, completely contained within the house envelope, or does it have some direct connection to the outside? For example, if there's an open hearth behind your oven, or if the oven has a flue, the oven system is open to the outside, and some of the heat will be lost to the outside. In that case, to get the most heat into the house, rather than going outside, you need to speed up the rate at which heat is transferred from oven to room, by enabling convection as well as conduction and radiation, so open the oven door.
However, if there's no rapid heat loss directly to the outside, and if opening the door would make the house warmer than you'd want it, then keep the oven door closed: you'll still get all the heat eventually; whereas if you open the door, you'll over-heat the house and just make it less comfortable; in doingso, you'll also temporarily have increased the rate at which the house loses heat by conduction through the external envelope (heat losses being proportional to the difference between internal and external temperature), so you'll have wasted some more of the heat.