Pular para o conteúdo

Fóruns Banco de dados Oracle Problema urgente!!!!!! Problema urgente!!!!!!

#99727
mpungan
Participante

    Bom, o select esta ai abaixo. Acrescentamos mais redologs, e parece que o problema deixo de existir.

    SELECT thread#,group#,sequence#,bytes,
    members,archived,
    status,first_change#,
    TO_CHAR(first_time, ‘DD-MM-YYYY HH24:MI:SS’) first_time
    FROM
    sys.v_$log
    ORDER BY
    thread#,
    group#

    1 1 27752 524288000 1 YES INACTIVE 40583949638 20-06-2011 10:00:13
    1 2 27755 524288000 1 NO CURRENT 40584553864 20-06-2011 10:22:41
    1 3 27750 524288000 1 YES INACTIVE 40583895653 20-06-2011 09:57:29
    1 4 27751 524288000 1 YES INACTIVE 40583943871 20-06-2011 09:59:45
    1 5 27753 524288000 1 YES INACTIVE 40584009648 20-06-2011 10:03:27
    1 6 27754 524288000 1 YES INACTIVE 40584204763 20-06-2011 10:10:48