Re: Deadlock and ORA-0600 ocurred yesterday
Date: Sun, 25 Mar 2018 01:03:05 +0300
Message-ID: <CAOVevU6dkK1ygxMK3j4MKnyntD+oT4+LuMBa2_8ytZFKNm+0aw_at_mail.gmail.com>
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_at_gmail.com
> 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
>
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 24 2018 - 23:03:05 CET