Differences

This shows you the differences between two versions of the page.

--- performance_memory_etc [2023/03/15 08:38] – mduersch
+++ performance_memory_etc [2024/09/12 09:24] (current) – mduersch
@@ Line 1: / Line 1: @@
 ====== Performance ======
+==== Processes =====
+    select total, active, inactive, system, killed
+    from
+       (select count(*) total from v$session)
+     , (select count(*) system from v$session where username is null)
+     , (select count(*) active from v$session where status = 'ACTIVE' and username is not null)
+     , (select count(*) inactive from v$session where status = 'INACTIVE')
+     , (select count(*) killed from v$session where status = 'KILLED');
 ==== Memory ====