commit d5f633

2025-12-02 11:47:00 feagor: -/-

0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9

`home/oracle/awr и ash/ash - дерево блокировок.md` ..
@@ 31,5 31,10 @@
	```
	В результат находим виновника, которым оказался джоб
	```oraclesql
-	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN COLVIR.Z_S03_PKGICM.pRun(next_date,COLVIR.C_pkgJob.fOpenUsr(4070,'COLVIR')); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
+	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE;
+	BEGIN
+	COLVIR.Z_S03_PKGICM.pRun(next_date,COLVIR.C_pkgJob.fOpenUsr(4070,'COLVIR'));
+	:mydate := next_date;
+	IF broken THEN :b := 1; ELSE :b := 0; END IF;
+	END;
	```