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@xxxxxxxxx> 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@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
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
