Sure there are cool teams in every org. What is the probability I will join one of them if they are very small % of workforce, even if you do join a such a team with great manager there is higher probability that will not last in orgs with bad reputation.

Also while teams have variances org culture is rarely so different. Toxic cultures , red tape bureaucracy, or how performance is evaluated is typically mostly global not localised.

That's isn't to say nobody should in such places, there are plenty of people who just want a paycheck and don't care where they work or what their work environment is like, these orgs are perfect for them.

If you are passionate about your work and environment, and compensation wise squeezing your current value immediately in cash is not your priority then most big orgs especially ones like Oracle are bad place for you