Check growth of a segment

[Former Member]

Hello All,

   I would like to know the growth of a table for 4 years in SAP (version 4.6), it's possible ?

  The table is the COEP and in DB02 I can only see one year.

Regards,

Lincoln

[Reagan · Accepted solution]

Hello

As far as I know DB02 will show data only for a year.

I believe the segment growth data is pulled out from DBA_HIST_SEG_STAT and there should be a retention period for that or the data must be automatically purged to avoid unnecessary database growth.

Lastly DBA_HIST_SEG_STAT is a view and NOT a table.

http://docs.oracle.com/cd/B19306_01/license.102/b40010/database_management.htm#sthref18

Cheers

RB

[Former Member · Accepted solution]

Reagan,

   You're correct...In DB02 i only see 1 year.......But I need 4 years.....I see it will be very hard to have this information....

regards

[former_member188883]

Hi Lincoln,

To store historical data into sap you shall need BI cubes to be populated. You may use existing BI system or from Solution Manager system..

Alternatively you may query the table dba_hist_seg_stat.

Refer link http://www.dba-oracle.com/oracle10g_tuning/t_dba_hist_segstat.htm

for its usage.

Hope this helps.

Regards,

Deepak Kori

[former_member206552]

Hi Lincoln

i do not think what you are asking for is possible without solution manager,

best regards

marius