Hi Eriovaldo,
No, this view can't help with your problem:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2097.htm#i1591024
You can use the following script to view alert message:
https://github.com/xtender/xt_scripts/blob/master/diag/alertlog_grep.sql
On Sun, Mar 25, 2018 at 12:54 AM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx
wrote:
Hi,
There were a error ORA-0600 yesterday caused by a deadlock.
I don´t have acesss to the alert of the database server.
Can I trust on this query ?
select table_name,inserts,updates,deletes,truncated,timestamp
from dba_tab_modifications
where timestamp > TO_DATE('23/03/2018 18:00:00','DD/MM/YYYY HH24:MI_SS')
and timestamp < TO_DATE('23/03/2018 19:00:00','DD/MM/YYYY HH24:MI_SS')
With this query I got a list of tables.
Is there another way to know what is the table that were root cause of the
error ?
Great
Eriovaldo
