Search notes:
v$thread
See also
Redo log file threads
v$log
Oracle Dynamic Performance Views
Index