dba_tab_mod view

From: Ram Raman <veeeraman_at_gmail.com>
Date: Mon, 11 May 2015 18:12:40 -0500
Message-ID: <CAHSa0M2EGy=etkn6h6qkUuPtrX_m0tcEgXQnNShBK29ea3Qifg_at_mail.gmail.com>


After seeing lots of global services enqueue deadlock errors in our rac, I was looking up the trace files. I was able to see the sql; the trace files are huge (in GBs) . The sql was simple and was updating one table only repeatedly. I wanted to know how many updates had happened in the table, but the dba_tab_mod view is empty for that table. The table was last analyzed last night. Does this mean that the updates did not happen at all due the deadlock errors?

To my knowledge, the DTM view is emptied out after a stats collection. Is there anything else that would cause the no rows selected for a table from that view. v11.2


Received on Tue May 12 2015 - 01:12:40 CEST

Original text of this message