Re: Deadlock and ORA-0600 ocurred yesterday

What was the exact error message you saw and what was the piece of code you ran that raised it?

I’m a little suspicious, there’s a fairly decent chance in my opinion that you misread ORA-0060 deadlock detected.. as an ORA-0600 internal error. If you received an ORA-0600 then the only place to go is Oracle Support, only they can help you. If you received an ORA-0060 then the deadlock graph that was dumped at the same time will have all the information you should need to know. If you don’t have access to the alert.log then speak to your friendly DBA.

That query will not be any relevance at all. The view is just some statistics about numbers of certain operations since the last time statistics were gathered on a table at the moment some information was last flushed from memory. It tells you nothing about locks or deadlocks.

Hope that helps,
Andrew

On Sat, 24 Mar 2018 at 22:03, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> 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