Look under the hood.
If the intake tube goes in at an angle and the engine cover says 4.0 SOHC then you have the SOHC.
If the intake tube goes in straight and the cover says 4.0 EFI then you have the OHV.
The SOHC makes about 50 more peak hp and revs higher. 97 was the first year for it and it did have many recalls and TSBs with engine issues. Hopefully those would be fixed on yours.
The OHV is a proven workhorse. It makes great power down low but many feel it lacks some power on the highway. Overall a very good motor.
EDIT: The SOHC stands for single overhead cam. The OHV stands for overhead valve, with the cam in the block like older engine designs. There is no DOHC V6 for the Explorer.