Performance issue query select obj#, name.. from rmtab$ in Oracle

A lot of execution and parsing for the following query caused performance issues in the 12c database

select obj#, name, stab#, sobj#, sobjd#, ttab#, tobj#, tobjd#, mflags from rmtab$ where (stab# = :1 or ttab# = :1) order by obj#

In statspack report, we find high hard parsing on checking the following query is caused by high parsing in top queries. It is related to a bug in 12c Bug 20853821. The following query executed with every module occurred in the 12.1.0.2 version of Oracle as doc id(20853821.8)

                         % Total    Old
 Parse Calls   Executions   Parses Hash Value
------------ ------------ -------- ----------
     111,393      111,408     6.40 1512023764
select obj#, name, stab#, sobj#, sobjd#, ttab#, tobj#, tobjd#, m
flags from rmtab$ where (stab# = :1 or ttab# = :1) order by obj#

To overcome the execution problem of the query in 12.1.0.2 version.

We need to apply the latest patches of Jan 2017 released. Oracle released bug fixed in Jan Patch 12.1.0.2.170117 (Jan 2017) Bundle Patch.