Pular para o conteúdo

Fóruns Banco de dados Oracle ORA-01555 caused by SQL statement below ORA-01555 caused by SQL statement below

#103128
Doug
Participante

    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