The table below show the self resonate frequencies of ceramic caps leaded and SMT. As you know the decoupling cap is connected between VCC and GND for each active device (IC’s) on the PCB. Rule of thumb, all active devices get a decoupling cap using the table below and every 10 or so decouplers should have a bulk decoupling cap.
|Capacitor Value||Through Hole 0.25” Leads*||Surface Mount**|
* For through hole, L=3.75nH (15nH per/inch)
** For surface mount, L=1nH