commit 408756

2025-12-06 09:16:08 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
+	```sql=
	select d.type
	, trunc(completion_time) as "DATE"
	, trunc(sum(blocks*block_size)/1024/1024/1024) as GB
@@ 11,7 11,7 @@
	order by 2 desc ,1;
	```
	#### Разбивка по часам
-	```ora
+	```ora=
	alter session set nls_date_format='DD MON YYYY';
	select thread#, trunc(completion_time) as "date", to_char(completion_time,'Dy') as "Day", count(1) as "total",
	sum(decode(to_char(completion_time,'HH24'),'00',1,0)) as "h00",