› Fóruns › Banco de dados Oracle › Problema urgente!!!!!! › Problema urgente!!!!!!
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