commit 3d0ad2

2025-12-06 09:50:18 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` ..
@@ 6,7 6,7 @@
	, 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'
+	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;