This is a very good link note the queries that can help and also
you may want to look at v$log

http://download.oracle.com/docs/cd/B...htm#SBYDB00426