OK - I was confused because you're referring to resonance as oscillation. If you have a peak at RF, that's resonance, but if it's self-sustaining (necessarily powered unless we're breaking the laws of thermodynamics), that would be oscillation.
MM cartridges should not have an electrical peak exceeding a few dB at most. Manufacturers will often use the electrical peak to add an extra bit of boost to compensate for mechanical roll-off at the top of the audio band.
LOMCs are loaded with low resistance to absorb energy in the system and prevent peaks. With a 120 ohm loading resistor and 800pF of capacitance, it's quite easy to make sure the response never peaks more than 3dB or so with the vast majority of cartridges. Adding more capacitance creates a lower frequency of resonance and also increases the amplitude of the peak. The peak is proportional to the relative impedance of the LC circuit, against the loading resistor which absorbs the energy. Adding RF beads don't do much to prevent RF peaks, as the resonant frequency is much too low for them to be effective, and if the layout is done carefully the loading capacitor will make short work of VHF/UHF interference through simple shunt action. The problem with LOMC RFI is typically within the region of 1-5MHz.
As far as HOMC cartridges go, the inductance is around 1-2mH, with 100-200 ohms of dc series resistance. This can produce a peak of around +10dB to +20dB at 300-600kHz when loaded with 50k/100pF, which is luckily low enough for most high GBW-product ICs to handle without non-linearity or detection of ambient RFI pickup, so long as you make sure you have a continuous RIAA response to attenuate it for the next piece of gear in the signal path. ICs have much better immunity to RFI than discrete transistor designs, and using an IC such as the 5534 without compensation makes an input that's highly robust. I can speak from experience here in many such home applications.
In relation to surface transients exciting RF resonances: considering that the mechanical rolloff of the cartridge begins between 20-40kHz in most cases, and that the worst-case resonances that will have serious peaks (the HOMC case) of a high Q from 300kHz upwards, I'm quite happy to categorically say this will never be an issue. The mechanical response of the cartridge is simply unable transmit anywhere near a high enough frequency to remotely tickle a 300Hz RF resonance. RF peaks with high and low output MC devices are problematic because they are excited by ambient/environmental interference picked up by cabling, not because they can be set off by a miraculous cantilever and stylus that are capable of transmitting 300kHz signals.