Continuing my exploration of DBA_OBJECTS using NEO4J, and Cypher, there can be VERY MANY paths between one object and another. The more complex and interconnected the graph, the number of paths between nodes goes up exponentially.
Here’s how to find the paths to all generations of parents or children of an Oracle object using the graph database, NEO4J and Cypher.
How would you visualize almost fifty thousand Oracle DBA_OBJECTS? Using the graph database NEO4J and Gephi.
Here’s how you can visualize a tree of DBA_OBJECTS
Here is a script I’ve used to quickly hunt down objects and information about them. Very useful to find things like: exact spellings, other objects with a similar spelling, or owned by a different user, synonyms, etc.