If you are dealing with lots of hierarchical data, then I recommend you take a look at Neo4j (or other graph databases) since they are much better suited for these kind of queries as well as updates at any level and multi parent hierarchies.
See https://maxdemarzi.com/2016/10/27/catalogs-and-hierarchies/ for a quick example. Read until the end 'cause the kicker is being able to go UP a hierarchy in no time at all.
See http://www.slideshare.net/StampedeCon/managing-genetic-ances... for a real world use case with Neo4j vs Oracle RAC comparisons.