commit 239252

2025-12-06 09:49:34 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` ..
@@ 2,11 2,12 @@

	```ora=
	select d.type
-	, trunc(completion_time) as "DATE"
-	, trunc(sum(blocks*block_size)/1024/1024/1024) as GB
-	, count(1) cnt
-	from v$archived_log l join V$ARCHIVE_DEST_STATUS d on d.DEST_ID = l.DEST_ID and d.status='VALID'
-	where first_time > trunc(sysdate-10)
+	, trunc(completion_time) as "DATE"
+	, trunc(sum(blocks*block_size)/1024/1024/1024) as GB
+	, count(1) cnt
+	from v$archived_log l
+	join V$ARCHIVE_DEST_STATUS d on d.DEST_ID = l.DEST_ID and d.status='VALID'
+	where first_time > trunc(sysdate-10)
	group by d.type, trunc(completion_time)
	order by 2 desc ,1;
	```