The biggest problems I've had with Oracle databases are getting CDC data out of it. There's conflicting technologies with their own tradeoffs - LogMiner vs. Flashback, neither of which cover all use cases well, licensing is ambiguous, and docs are conflated with information you don't need.