DB SESSIONS


	Here is a screenshot of the VROOM Session Info page, showing user sessions currently logged in. The text of a query run by the highlighted user session is also shown. The query text is parsed, with different elements color-coded for clarity.


	Notice that VROOM will not display the data retrieved by the query, but only information about how the database is functioning. This makes VROOM valuable for businesses where data integrity and security are important. The explain plan, the steps that the database will take to find and return the results of the query, can also be displayed for the selected query. Clicking on a step in the explain plan will bring up a brief description of the operation, including references to how specific tables or indexes are utilized in that step. This information can be used to rewrite SQL statements to improve performance and limit resource contention.



	The status of long-running operations being run by the selected session can also be tracked and observed. You can see the outcome of previous operations, in addition to estimated time to completion for current operations.


	[VROOM!] [SESSION INFO] [DB SESSIONS] [SERVER SESSIONS] [STORAGE MANAGEMENT] [PERFORMANCE TUNING] [BACKUP & RECOVERY] [SCHEMA OBJECTS] [REPORTING] [WIZARDS] [DOCUMENTATION] [DOWNLOAD]