select inst_id,thread#,sequence#,status
from gv$log
where status=’CURRENT’
order by inst_id,thread#,sequence#