Home » SQL & PL/SQL » SQL & PL/SQL » how to calculate table partition size which is growing every month
how to calculate table partition size which is growing every month [message #312147] Tue, 08 April 2008 01:55 Go to next message
sameek1211
Messages: 30
Registered: October 2007
Location: India
Member
i want calculate size to table partition which is growing every monthly .
Re: how to calculate table partition size which is growing every month [message #312149 is a reply to message #312147] Tue, 08 April 2008 01:56 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Do you want to calculate the size as it is or do you want some kind of prediction of the estimated size in the near future?

MHE
Re: how to calculate table partition size which is growing every month [message #312150 is a reply to message #312147] Tue, 08 April 2008 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway the first thing is to monthly execute a job that records your table/partition sizes somewhere in a table.

Regards
Michel
Re: how to calculate table partition size which is growing every month [message #312157 is a reply to message #312149] Tue, 08 April 2008 02:13 Go to previous messageGo to next message
sameek1211
Messages: 30
Registered: October 2007
Location: India
Member
thanks for reply

yes i want to predict size of partition table by excluding some columns

currently i am calculating size of partition table by

(Maximum Size of Row * No. of rows(of particular partition) )/1024/1024/1024
Re: how to calculate table partition size which is growing every month [message #312172 is a reply to message #312157] Tue, 08 April 2008 02:37 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read http://www.dba-village.com/village/dvp_tips.TipDetails?TipIdA=1770 and http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=6485, this will give you an example of how to do it.

Regards
Michel
Previous Topic: DBA privileges
Next Topic: Execution of Clob through dynamic sql
Goto Forum:
  


Current Time: Sat Dec 10 16:54:56 CST 2016

Total time taken to generate the page: 0.12075 seconds