Blame
| 7ec587 | feagor | 2025-12-06 10:23:29 | 1 | ### Segment - Рост БД по месяцам |
| 2 | ```ora |
|||
| 3 | select to_char(creation_time, 'RRRR Month') "Month", |
|||
| 4 | trunc(sum(bytes) / 1024 / 1024 / 1024) "Growth in GBs" |
|||
| 5 | from sys.v$datafile |
|||
| 6 | where creation_time > SYSDATE - 365 |
|||
| 7 | group by to_char(creation_time, 'RRRR Month'), |
|||
| 8 | to_char(creation_time, 'RRRR.mm') |
|||
| 9 | order by to_char(creation_time, 'RRRR.mm') desc |
|||
| 10 | ``` |