Re: [sap-basis] Database Growth
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Awnindra Tiwary (Manager IT) on Feb 14 at 9:08 AM |  Mark as helpful |
Hi All,
I have scheduled the job RSPO1041(FOR TABLE TST03) now my database growth is
decreased to about 96 MB per day from 300MB.
Now following tables are growing fast. Please suggest me what should i do
for BASIS related tables. For users table(transactional table) i m taking
care. and what is idle growth in my case.
Table name Sample dt Dt delta Data Data delta Index Idx
delta Reserved Res. delta Rows Rows delta OCSCMPLOBJ 13.02.2010
16.09.2009 1,342,648 68,488 286,864 41,928 1,629,752 110,360 1,956,300
100,901 ACCTIT 13.02.2010 11.02.2010 1,097,336 17,368 113,200 1,800
1,210,960 19,136 841,121 13,313 MSEG 14.02.2010 12.02.2010 1,185,672 16,520
276,080 3,656 1,463,296 20,160 738,183 10,293 TTREEI 14.02.2010 21.08.2009
215,624 14,200 319,152 120,168 534,840 134,344 1,482,320 97,548 COSP
14.02.2010 12.02.2010 727,488 10,664 266,288 3,928 994,544 14,600 439,848
6,103 TPR_XREF_D 14.02.2010 21.08.2009 10,008 10,008 14,064 14,064 24,096
24,096 75,022 75,022 QASE 14.02.2010 12.02.2010 523,488 8,040 11,216 192
534,832 8,192 898,046 14,378 BSIS 14.02.2010 12.02.2010 476,216 6,888
90,656 1,328 567,792 7,936 585,905 8,741 S033 13.02.2010 11.02.2010 363,168
5,568 307,168 4,056 671,056 9,664 674,232 10,124 COEP 13.02.2010 11.02.2010
308,456 4,936 145,104 2,312 454,040 7,232 410,480 6,460 FAGL_SPLINFO
14.02.2010 12.02.2010 254,336 3,928 166,160 2,688 422,224 6,592 386,039
5,906 RFBLG 13.02.2010 11.02.2010 235,704 3,904 3,984 56 239,880 3,968
121,988 1,906 BDLSADATA 13.02.2010 16.07.2009 9,296 3,296 224 72 9,576
3,408 64,783 21,375 S094 14.02.2010 25.08.2009 3,016 3,016 1,096 1,096
4,192 4,192 7,362 7,362
rgds
Awnindra Dutt Tiwary
On Fri, Feb 12, 2010 at 2:56 PM, D. Caddick via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by D. Caddick (SAP
> NetWeaver/BASIS Consultant)
> on Feb 12 at 4:36 AM
>
> Hi Awnindra,
>
> You can also use Tx SP01 and select all the Spool requests up to a selected
> date and delete them.
>
> Regards
>
> ---------------Original Message---------------
> From: kalyan11
> Sent: Thursday, October 09, 2008 12:55 PM
> Subject: Database Growth
>
> > Hi there<br/><br/>Is there any SAP Function module or report that would
> report the database growth for a month or so or thereabouts.....Other than
> all the wonderful information that you get from DB02 ofcourse. Our database
> is oracle 9.x and sap version is Enterprise 4.7. Any thoughts would be
> appreciated.<br/><br/>Regards<br/>Kalyan
__.____._ I have scheduled the job RSPO1041(FOR TABLE TST03) now my database growth is
decreased to about 96 MB per day from 300MB.
Now following tables are growing fast. Please suggest me what should i do
for BASIS related tables. For users table(transactional table) i m taking
care. and what is idle growth in my case.
Table name Sample dt Dt delta Data Data delta Index Idx
delta Reserved Res. delta Rows Rows delta OCSCMPLOBJ 13.02.2010
16.09.2009 1,342,648 68,488 286,864 41,928 1,629,752 110,360 1,956,300
100,901 ACCTIT 13.02.2010 11.02.2010 1,097,336 17,368 113,200 1,800
1,210,960 19,136 841,121 13,313 MSEG 14.02.2010 12.02.2010 1,185,672 16,520
276,080 3,656 1,463,296 20,160 738,183 10,293 TTREEI 14.02.2010 21.08.2009
215,624 14,200 319,152 120,168 534,840 134,344 1,482,320 97,548 COSP
14.02.2010 12.02.2010 727,488 10,664 266,288 3,928 994,544 14,600 439,848
6,103 TPR_XREF_D 14.02.2010 21.08.2009 10,008 10,008 14,064 14,064 24,096
24,096 75,022 75,022 QASE 14.02.2010 12.02.2010 523,488 8,040 11,216 192
534,832 8,192 898,046 14,378 BSIS 14.02.2010 12.02.2010 476,216 6,888
90,656 1,328 567,792 7,936 585,905 8,741 S033 13.02.2010 11.02.2010 363,168
5,568 307,168 4,056 671,056 9,664 674,232 10,124 COEP 13.02.2010 11.02.2010
308,456 4,936 145,104 2,312 454,040 7,232 410,480 6,460 FAGL_SPLINFO
14.02.2010 12.02.2010 254,336 3,928 166,160 2,688 422,224 6,592 386,039
5,906 RFBLG 13.02.2010 11.02.2010 235,704 3,904 3,984 56 239,880 3,968
121,988 1,906 BDLSADATA 13.02.2010 16.07.2009 9,296 3,296 224 72 9,576
3,408 64,783 21,375 S094 14.02.2010 25.08.2009 3,016 3,016 1,096 1,096
4,192 4,192 7,362 7,362
rgds
Awnindra Dutt Tiwary
On Fri, Feb 12, 2010 at 2:56 PM, D. Caddick via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by D. Caddick (SAP
> NetWeaver/BASIS Consultant)
> on Feb 12 at 4:36 AM
>
> Hi Awnindra,
>
> You can also use Tx SP01 and select all the Spool requests up to a selected
> date and delete them.
>
> Regards
>
> ---------------Original Message---------------
> From: kalyan11
> Sent: Thursday, October 09, 2008 12:55 PM
> Subject: Database Growth
>
> > Hi there<br/><br/>Is there any SAP Function module or report that would
> report the database growth for a month or so or thereabouts.....Other than
> all the wonderful information that you get from DB02 ofcourse. Our database
> is oracle 9.x and sap version is Enterprise 4.7. Any thoughts would be
> appreciated.<br/><br/>Regards<br/>Kalyan
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
