Commit 7ec587
2025-12-06 10:23:29 feagor: -/-| /dev/null .. oracle/oracle_files/Segment_-_Рост_БД_по_месяцам.md | |
| @@ 0,0 1,10 @@ | |
| + | ### 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 |
| + | ``` |