Files
oracle/Kevin_Meade/showallworkareas.sql
2026-03-12 21:23:47 +01:00

13 lines
258 B
SQL

--
-- show work areas in use
--
col SQL_EXEC_START noprint
col SQL_EXEC_ID noprint
col WORKAREA_ADDRESS noprint
col OPERATION_TYPE format a20 trunc
col active_time noprint
col expected_size noprint
select * from gv$sql_workarea_active;