HI,

select * from v\$logfile.

Manoj