This topic comes up often. What gets loaded into ram and when. Although this is not a concise answer, you should be able to use this table for a general understanding.
You can also download it as this spreadsheet.
For a detailed descripition of these files see this post :
viewtopic.php?f=184&t=5818
wizard