Database Administration (MOSC)

MOSC Banner

Catch failed queries with ORA-01555 (snapshot too old) in alert log.

edited Jul 25, 2014 5:02AM in Database Administration (MOSC) 10 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center