on 05-13-2013 3:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lincoln
i do not think what you are asking for is possible without solution manager,
best regards
marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.