When I would go to Oceans of Fun as a child, I always generally upset. I was too scared of the huge water slides, and everything else was either for very small children, or for adults. It isn't any different now, so if you take your 7-10 year old, make sure they aren't afraid of the water rides, or they will be a little bored.
As an adult, the pools are great, because they have bars! Tickets are fairly cheap, I believe under $20. dollars a person.
more