The following are the data dictionary views that can help you manage processes and sessions.
Contains information about the currently active processes
Lists session information for each current session
Contains I/O statistics for each user session
Displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution. More operations are added for every Oracle Database release.
Displays the current or last wait for each session
Lists the last ten wait events for each active session
Displays information about blocked sessions
Contains session statistics
Provides information about current and maximum global resource utilization for some system resources
Contains statistics about shared SQL areas. Contains one row for each SQL string. Provides statistics about SQL statements that are in memory, parsed, and ready for execution