The following are the Oracle data dictionary views that can help you manage processes and sessions.
View | Description |
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 |
No comments:
Post a Comment