› Fóruns › Banco de dados Oracle › ORA-01555 caused by SQL statement below › ORA-01555 caused by SQL statement below
Ate executei o script que me trouxe que houve erro, mas nao é de espaço…
select inst_id,
to_char(begin_time, 'MM/DD/YYYY HH24:MI') begin_time,
UNXPSTEALCNT as "# UnexpiredStolen",
EXPSTEALCNT as "# ExpiredReused",
SSOLDERRCNT as "ORA-1555Error",
NOSPACEERRCNT as "Out-Of-spaceError",
MAXQUERYLEN as "Max QueryLength"
from gv$undostat
where begin_time between
to_date('20/03/2012 04:20', 'DD/MM/YYYY HH24:MI:SS') and
to_date('20/03/2012 04:30', 'DD/MM/YYYY HH24:MI:SS')
order by inst_id, begin_time;
Resultado :
INST_ID BEGIN_TIME # UnexpiredStolen # ExpiredReused ORA-1555Error Out-Of-spaceError Max QueryLength
1 1 03/20/2012 04:26 0 0 1 0 0
2 2 03/20/2012 04:26 0 0 0 0 0