Home » SQL & PL/SQL » SQL & PL/SQL » view to find data growth in table
icon12.gif  view to find data growth in table [message #419193] Thu, 20 August 2009 06:00 Go to next message
tcsdba
Messages: 6
Registered: July 2009
Junior Member
I need to calculate Object level in oracle table growth between the date ranges.

For instance: the objective is to find growth from 1st April to 15th April. Is there any Oracle View or some script to calculate it ?

Shocked
Re: view to find data growth in table [message #419195 is a reply to message #419193] Thu, 20 August 2009 06:03 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

This maybe
Re: view to find data growth in table [message #419199 is a reply to message #419193] Thu, 20 August 2009 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no view or table, you have to create your own one.
Here's an example (for files, easy to convert for segments):
http://www.dba-village.com/village/dvp_tips.TipDetails?TipIdA=1770

Regards
Michel
icon8.gif  Re: view to find data growth in table [message #419204 is a reply to message #419199] Thu, 20 August 2009 06:34 Go to previous messageGo to next message
tcsdba
Messages: 6
Registered: July 2009
Junior Member
Hi
thanks for the reply. But my problem is that I have to calculate data growth that has already occuredin previous month. Is there any solution for this??? Shocked
Re: view to find data growth in table [message #419206 is a reply to message #419204] Thu, 20 August 2009 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: view to find data growth in table [message #419208 is a reply to message #419204] Thu, 20 August 2009 06:57 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Restore database as per both dates and compare..
Previous Topic: Implementing row_number function using SQL (merged)
Next Topic: Help needed migrating MSSQL Function To Oracle 10g
Goto Forum:
  


Current Time: Wed Dec 07 02:54:45 CST 2016

Total time taken to generate the page: 0.20238 seconds