Differences

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

--- performance_memory_etc [2023/01/18 07:55] – 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 ====
@@ Line 26: / Line 38: @@
 2 335 .9817 0
+Backup
+   set linesize 212
+   set pagesize 1024
+   col filename format a64
+   select
+       filename,
+       round(bytes/1024/1024/1024, 2) "GByte",
+       open_time,
+       close_time,
+       round(elapsed_time/100/60, 2) "Minuten",
+       round(short_wait_time_total/100/60, 2) "Short Waits gesamt (Min)",
+       round(long_wait_time_total/100/60, 2) "Long Waits gesamt (Min)",
+       round(effective_bytes_per_second/1024/1024, 2) "MB/Sekunde"
+   from
+       v$backup_async_io
+   where
+       open_time > sysdate - 1
+       and filename not like '%archivelog%'
+   order by 3;
+   exit;