OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » data growth (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

data growth [message #523146]

Thu, 15 September 2011 15:09

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
Is there any way to tell the total data growth increase of some tables when compared with last year.

Thanks,
Varun

Report message to a moderator

Re: data growth [message #523151 is a reply to message #523146]

Thu, 15 September 2011 15:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there any way to tell the total data growth increase of some tables when compared with last year.
Where did you store last year's values?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: data growth [message #523161 is a reply to message #523151]

Thu, 15 September 2011 15:52

varunvir
Messages: 389
Registered: November 2007

Senior Member

Yeah that was my quesion.Is there any way if u dont store last
year values?

Report message to a moderator

Re: data growth [message #523167 is a reply to message #523161]

Thu, 15 September 2011 17:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Consider storing away the current values now so that when you ask this same question next year, you'll have the needed data.

Report message to a moderator

Re: data growth [message #523436 is a reply to message #523167]

Sun, 18 September 2011 12:22

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Assuming you have not designed your system to tell this, there are a few possibilities:

1) see if there are database reports from last year that show a freespace dump.  Then compare to now.
2) see if there are database reports from last year that show rowcounts in tables.  Then compare to now.
3) check your tables to see if they have an INSERT date column.  If so, do rowcounts with last year and today.
4) check with your disk keepers and ask them for disk storage reports mapped to your data files.
5) ask for size reports on you BACKUP FILES.  Backup size will increase with database size.

Each of the above will let you do some kind of calculation that can yield a growth number. Each will have its margin of error but I guess you go with what you can get eh?

Good luck, Kevin

Report message to a moderator

Previous Topic:	ORA-16014: log 2 sequence# 80 not archived, no available destinations
Next Topic:	size_clause issue of parameters method_opt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:45:46 CST 2024