OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Growth Estimation (Oracle 10.2 , AIX)

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

Growth Estimation [message #449441]

Mon, 29 March 2010 10:16

DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai

Member

Please help for any links that have scripts for below or share common experience to calculate it correctly.
Current database size is 31 gb from dba_segments.

How to estimate.?

1.Projected Annual Data Size
2.Daily Growth Data Size
3.Software and Maintenance space size
4.Database Server Overhead in GB
5.Undo space overhead factor %

Report message to a moderator

Re: Growth Estimation [message #449444 is a reply to message #449441]

Mon, 29 March 2010 10:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to estimate.?
At time T1 snapshot needed metrics.
At time T2 snapshot needed metrics.
Compute delta values & growth rates.

Report message to a moderator

Re: Growth Estimation [message #449445 is a reply to message #449441]

Mon, 29 March 2010 10:27

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This old How to follow the growth of your database with its follow-up at http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=6485

Regards
Michel

Report message to a moderator

Re: Growth Estimation [message #449446 is a reply to message #449444]

Mon, 29 March 2010 10:31

DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai

Member

Hi Black Swan,

Thanks for replying back.

Are you saying I need to run AWR reaport giving a range of time.? Please reply.

Report message to a moderator

Re: Growth Estimation [message #449449 is a reply to message #449445]

Mon, 29 March 2010 10:41

DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai

Member

Script is using a table/view watch_file. This object is not exist.

Report message to a moderator

Re: Growth Estimation [message #449457 is a reply to message #449449]

Mon, 29 March 2010 11:47

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The script first CREATES this table and fill it with size information.
IT is at file level, you can do the same at segment level if you want.

Regards
Michel

[Updated on: Mon, 29 March 2010 11:47]

Report message to a moderator

Previous Topic:	How does SGA and PGA split memory when we use MEMORY_TARGET
Next Topic:	ORA-04063: view "SYS.DBA_CAPTURE" has errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:00:48 CDT 2024