Deadlock and ORA-0600 ocurred yesterday
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 24 Mar 2018 18:54:15 -0300
Message-ID: <CAJdDhaPui8ZOM7wfxy9doxrENRuaRVKzVSYHx751xNx54qBk_A_at_mail.gmail.com>
Hi,
Date: Sat, 24 Mar 2018 18:54:15 -0300
Message-ID: <CAJdDhaPui8ZOM7wfxy9doxrENRuaRVKzVSYHx751xNx54qBk_A_at_mail.gmail.com>
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
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
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')
Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 24 2018 - 22:54:15 CET