DBA_HIER_JOIN_PATHS describes the join paths for all hierarchies in the database. Its columns are the same as those in ALL_HIER_JOIN_PATHS.