Our customer runs Oracle database and my chief has given me a task to do for today.
I need to prepare prognosis of how much oracle database will grow in next 3 years. After short googling I’ve found interesting sripts :
select sum(bytes)/1024/1024 "Meg" from dba_data_files; select nvl(sum(bytes),0)/1024/1024 "Meg" from dba_temp_files; select sum(bytes)/1024/1024 "Meg" from sys.v_$log; select sum(BLOCK_SIZE*FILE_SIZE_BLKS/1024/1024) "MEG" from v$controlfile;
The main idea is to create oracle DBMS job which will fire each hour for let’s say 7 days (yeah, we’ve got only 7 days :() and outputs statistics about database size into some database table.