Oracle stats (Part 1)

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 [1]:

 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.

Read the rest of this entry »