Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

PRD PSAPSR3 Tablespace at 95%

Dear All,

I was checking ST04 and checked with Tablespaces, which shows me the status mentioned below:

Tablespacename	Size(MB)	Free(MB)	Used(%)	Autoextend	TotalSize(MB)	Sum of all Free Segments(MB)	Total Used(MB)	#Files	#Segments	#Extents	Status	Contents
PSAPSR3	172,192.00	29.56	100	YES	180,000.00	7,837.56	96	16	155,060	230,626	ONLINE	PERMANENT

Above is the current status. Here is the Detailed View of Last Months:

Date	Tablespace name	Size(MB)	Chg.size(MB)	Free(MB)	Chg. #extents/day	Increment by	Chg. used (%)	Autoextend	User blocks	Chg.tot.size (MB)	Total free(MB)	Chg. total free (MB)	Total used(%)	Chg.used(%)	#Files	Chg.#Files	#Segments	Chg. # segments	#Extents	Chg. # extents
01-06-11	PSAPSR3	170232.00	8580.00	14.63	0.32	100	0	YES	180000.00	0.00	9782.63	-8579.68	95	5	16	0	155060	4	230325	1164
01-05-11	PSAPSR3	161652.00	6360.00	14.31	8.50	100	0	YES	180000.00	0.00	18362.31	-6351.50	90	4	16	0	155056	4	229161	917
01-04-11	PSAPSR3	155292.00	6180.00	5.81	-11.94	100	0	YES	180000.00	0.00	24713.81	-6191.94	86	3	16	0	155052	4	228244	1062
01-03-11	PSAPSR3	149112.00	920.00	17.75	-3229.75	100	2	YES	180000.00	0.00	30905.75	-4149.75	83	2	16	0	155048	9	227182	720
01-02-11	PSAPSR3	148192.00	0.00	3247.50	-2744.19	98	2	YES	180000.00	0.00	35055.50	-2744.19	81	2	16	0	155039	16	226462	671
01-01-11	PSAPSR3	148192.00	0.00	5991.69	-3135.31	96	2	YES	180000.00	0.00	37799.69	-3135.31	79	2	16	0	155023	6	225791	793
01-12-10	PSAPSR3	148192.00	8192.00	9127.00	4791.69	94	-3	YES	180000.00	40000.00	40935.00	36599.69	77	-20	16	2	155017	8	224998	731
01-11-10	PSAPSR3	140000.00	0.00	4335.31	-3760.82	97	3	NO	140000.00	0.00	4335.31	-3760.82	97	3	14	0	155009	10	224267	901
01-10-10	PSAPSR3	140000.00	10000.00	8096.13	6518.32	94	-5	NO	140000.00	10000.00	8096.13	6518.32	94	-5	14	1	154999	6	223366	907
01-09-10	PSAPSR3	130000.00	0.00	1577.81	-3074.19	99	3	NO	130000.00	0.00	1577.81	-3074.19	99	3	13	0	154993	6	222459	742
01-08-10	PSAPSR3	130000.00	11450.00	4652.00	4609.62	96	-4	NO	130000.00	0.00	4652.00	-6840.38	96	5	13	0	154987	1269	221717	2633
01-07-10	PSAPSR3	118550.00	6360.00	42.38	-6.43	100	0	YES	130000.00	0.00	11492.38	-6366.43	91	5	13	0	153718	14	219084	1450
01-06-10	PSAPSR3	112190.00	10060.00	48.81	16.00	100	0	YES	130000.00	0.00	17858.81	-10044.00	86	7	13	0	153704	0	217634	1546

As you can see we modified it in November and now it is remaining with 7 GB.

We need to increase the size of tablespace. Also if we increase it to maximum of our hard disk's capacity, will there be any issues? Should we modify any other tablespace? How can we shift Data files to other Partition? Is PSAPSR3 Increasing as it should or are there any issues regarding its increments?

Please Help,

Regards,

Former Member
Former Member replied

Thank you all for ur replies,

>

> Hi Orkun,

> I wanted to ask you that I need to create Tablespace. What is the recommended size which should be configured? How Much GB is required to work for atleast a year?

>

> Please Reply,

>

> Regards.

Ok. You should calculate this value by yourself. I'll show you how to calculate this value, below;

DB02 -> Space -> Tablespaces -> Detailed analysis -> On the popup window, enter PSAPSR3. Then, hit the ENTER --> Double click on the Tablespace line -> Click on "History" tab -> Click on "Months" tab -> Take average value of the Chg.Size (MB) column for 1 year.

Regarding your stats, your database is increasing ~6 GB per month. If we assume that only and only PSAPSR3 is tablespace is increasing in your database, you should create 6 * 12 = 72 GB datafile. I assume that you are running on Windows, create datafiles 4 (72 / 16 GB=4) initial size 8GB with maxsize 16GB and next 1G.

In order t o extend the tablespace, execute the command, below;

brspace -f tsextend -t PSAPSR3

Then, incoming screen, enter the values, below;

5 - Size of the new file in MB (size) ..... [8000]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [16000]

8 - File increment size in MB (incrsize) .. [1000]

This will create 8 GB datafile, with maxsize 16GB. If you apply this scenario 4 times, you will have (8*4 = 24) 24GB freespace and can be extended 72GB automatically.

I hope that everyting is ok with this scenario,

Best regards,

Orkun Gedik

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question