## 28.4.3.15 The latest_file_io and x$latest_file_io Views 

• total_read 

The number of bytes read for the I/O event. 

• avg_read 

The average number of bytes per read for the I/O event. 

• count_write 

The number of write requests for the I/O event. 

• total_written 

The number of bytes written for the I/O event. 

• avg_written 

The average number of bytes per write for the I/O event. 

These views summarize file I/O activity, grouped by file and thread. By default, rows are sorted with most recent I/O first. 

The latest_file_io  and x$latest_file_io  views have these columns: 

• thread 

For foreground threads, the account associated with the thread (and port number for TCP/IP connections). For background threads, the thread name and thread ID 

## 28.4.3.16 The memory_by_host_by_current_bytes and x $memory_by_host_by_current_bytes Views 

• file 

The file path name. 

• latency 

The wait time of the file I/O event. 

• operation 

The type of operation. 

• requested 

The number of data bytes requested for the file I/O event. 

These views summarize memory use, grouped by host. By default, rows are sorted by descending amount of memory used. 

The memory_by_host_by_current_bytes  and x$memory_by_host_by_current_bytes  views have these columns: 

• host 

