Get Oracle Database Growth up by Month
SELECT To_char(creation_time, 'RRRR') year, To_char(creation_time, 'MM') month, Round(SUM(bytes) / 1024 / 1024 ) MB FROM v$datafile GROUP BY To_char(creation_time, 'RRRR'), To_char(creation_time, 'MM') ORDER BY 1, 2;
Xem thêm:
- Q68 Which three activities are recorded in the database alert log?
- Q75 It will return an error because creation of a local role is not allowed in CDB$ROOT
- Tạo Database mới bằng DBCA trong Oracle database 19c
- Có thể thực hiện switch logfile khi database trong chế độ mount hay không?
- Q6 After successfully performing all the pre-upgrade tasks, you execute these commands from the Oracle Database 18c environment