commit 57fe36

2025-12-06 09:48:41 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` ..
@@ 1,6 1,6 @@
	## Archivelog_Объем_сгенерированных_логов

-	```sql=
+	```orasql=
	select d.type
	, trunc(completion_time) as "DATE"
	, trunc(sum(blocks*block_size)/1024/1024/1024) as GB
@@ 45,7 45,7 @@
	from v$archived_log
	where first_time > trunc(sysdate-10)
	and dest_id = (select dest_id
-	from V$ARCHIVE_DEST_STATUS
+	from v$archive_dest_status
	where status='VALID'
	and type='LOCAL')
	group by thread#, trunc(completion_time), to_char(completion_time, 'Dy')