There have been a lot of changes and improvements in the heavier 9mm loads in recent years. In years past, the typical 147gr JHP load was usually subsonic and tended not to expand well, or at all, in human bodies. However, there are currently some really excellent choices in 147 9mm loadings which do a fine job.
The Federal HST 147gr +P load is excellent as is the Winchester Ranger 127gr +P RA9TA round. Gold Dot is another fine product to consider. Here's a video link to help you get some more info.