Apart from the above excellent advice, it's worth understanding that student loans are not "debt" in the sense that any other debt may be considered. They don't affect your credit score, and you will never have bailiffs knocking down your door looking for repayments provided you aren't actively trying to evade them (such as by moving to another country to work and not telling them
).
What happens when you graduate is, when you find a job, you tick a box when you start indicating that you have student loans and they match your PAYE with your student loans. Then if you are earning over the threshold, a small percentage of your monthly paycheque gets deducted and goes towards these - like your NI contributions or income tax. If you don't pay off your loan by the time you graduate or earn under the threshold for a given number of years (not 100% certain this is still the case, although it was when I was first getting SFE loans), the loan is written off.
It is essentially "invisible" debt - it's there, possibly for a long time, but it shouldn't make a difference in your day to day life, because the only time you will be repaying your student loan is when you are earning over the threshold, and the amount you pay back over that is quite small. The months where I work enough hours to go over the threshold I normally only pay back about £20. If you were paying back more each month, it would be because you are earning a lot more and so would easily be able to afford it anyway!
So the £9000 tuition fees will be covered in full by a tuition fee loan, and you will be able to get up to £8900 (rising with inflation each year) as a maintenance loan to help pay for accommodation, food, etc. I think the more expensive colleges tend to end up around £6k a year for rent and food costs, with some having cheaper room options or just more heavily subsidizing rent costs and so being less than that. You will then still have a good chunk leftover to pay for e.g. travel from/to home in vacations and potentially e.g. personal computing equipment, books, stationery etc. As above on top of that both Cambridge and Oxford offer bursaries of various forms (very generous ones as well). Cambridge gives a lump sum each year while Oxford I believe discounts tuition fees and gives a smaller lump sum for maintenance/other purposes, to my knowledge.
Honestly the only "pain" involved in SFE is having to call them if you need to check something
the hold periods can be very long at peak times!