Re: Deadlock and ORA-0600 ocurred yesterday

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_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-l