Catch failed queries with ORA-01555 (snapshot too old) in alert log.
Hello,
I’m looking for script (shell bash) to catch a queries failed with ORA-01555 (snapshot too old) in alert log.
I need to cron this script to receive a report with the queries failed
ORA-01555 caused by SQL statement below (SQL ID: gg2gu3gms5jyc, Query Duration=13436 sec, SCN: 0x003d.327a7f52):
Sat Mar 29 15:23:40 CET 2014
select *
from …….
ORA-01555 caused by SQL statement below (SQL ID: gg2gu3gms5jyc, Query Duration=558sec, SCN: 55.327a7f52):
Sat Mar 28 15:22:40 CET 2014
select *
from …….
Best Regards
Djm