Segment - Рост БД по месяцам - blame (7ec587)

Blame

7ec587	feagor	2025-12-06 10:23:29

### Segment - Рост БД по месяцам

```ora

select to_char(creation_time, 'RRRR Month') "Month",      

       trunc(sum(bytes) / 1024 / 1024 / 1024) "Growth in GBs"

from   sys.v$datafile

where  creation_time > SYSDATE - 365

group  by to_char(creation_time, 'RRRR Month'),

          to_char(creation_time, 'RRRR.mm')

order  by to_char(creation_time, 'RRRR.mm') desc

```