Replaced two slow queries using cc_users with their faster equivalent using parties and users. Makes a huge difference on Oracle when there are many, many users (49,000 in this case). And yes, I checked, the original queries used indexes galore, Oracle was doing as well as can be expected.