commit b38952

2025-12-06 09:23:42 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

`oracle/oracle_files/Archivelog_Объем_сгенерированных_логов.md` ..
@@ 44,6 44,8 @@
	sum(decode(to_char(completion_time,'HH24'),'23',1,0)) as "h23"
	from v$archived_log
	where first_time > trunc(sysdate-10)
-	and dest_id = (select dest_id from V$ARCHIVE_DEST_STATUS where status='VALID' and type='LOCAL')
+	and dest_id = (select dest_id
+	from V$ARCHIVE_DEST_STATUS
+	where status='VALID' and type='LOCAL')
	group by thread#, trunc(completion_time), to_char(completion_time, 'Dy') order by 2,1;
	```