DBA_TAB_MODIFICATIONS table returns no rows

Yesterday I run a query on that table and nothing returned. After a little search on support I realized that there is a bug about “union all” queries. DBA_TAB_MODIFICATIONS view is based on “union all”.

The bug is reported on and versions. After I execute the workaround, I could bypass the bug and got some results.

Info for that table :

Bug description :
Bug 13984324 – wrong result with UNION ALL of similar queries / in DBA_TAB_MODIFICATIONS [ID 13984324.8]

Workaround :
alter session set “_optimizer_join_factorization”=false;


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s