Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1285
  • Last Modified:

estimating oracle database growth over a period of time

scripts to interpolate/extrapolate database growth in oracle
0
exceed123
Asked:
exceed123
  • 3
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
If you can afford the license, a very, very useful alternative is to use TOAD for DBAs.  It's a snap to set up automated capture and graphing for disk I/O, and for tablespace size changes.<input id="gwProxy" type="hidden"><!--Session data--><input onclick="jsCall();" id="jsProxy" type="hidden">
0
 
mrjoltcolaCommented:
If you have AWR licensed, Oracle collects this already.

See:

dba_hist_tbspc_space_usage for the history of tablespace usage.

You can join this table's tablespace_id to v$datafile.ts# for the tablespace name.
0
 
DavidSenior Oracle Database AdministratorCommented:
True, but my take is that the request implies an out-of-the-box solution.  The approach using script, will still require manual manipulation of the cumulative result sets.  My two cents.<input id="gwProxy" type="hidden"><!--Session data--><input onclick="jsCall();" id="jsProxy" type="hidden">
0
 
mrjoltcolaCommented:
A quick check of the price list shows Diagnostics pack is 3k per processor license, so I would be inclined to forego AWR (I don't use it) and write a script to check DBA_FREE_SPACE every 24 hours and log to a table, or for even better data, use:

create table tblspc_hist (
  rep_time date,
  tablespace_name varchar2(200),
  mbytes integer
);

-- Daily SQL to collect
insert into tblspc_hist
select sysdate, tablespace_name, sum(bytes) / 1000000 as mbytes
  from dba_segments
  group by sysdate, tablespace_name;


Schedule the insert to run daily and you have a trend table.
0
 
mrjoltcolaCommented:
@dvz: You are probably right. Toad is cheaper than AWR too, even with DBA addon, and certainly more useful all around. I have not used Toad for long-term trends, though, so I cannot speak as to how that works, but I will probably research it now that you pointed it out.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now