PRD PSAPSR3 Tablespace at 95%

[Former Member]

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 · Accepted solution]

Hi...

It is not that much worrying if following points fulfills

1) If the Table Space PSAPSR3 is in auto extended mode.

2) There is sufficient space in the disk/file system where the data files of PSAPSR3 resides.

If there is no sufficient space in the Disk /file system the data file may over flow which is serious, to avoid this, add a new file system and add new data files in the new disk/file systemor move some of the data files to the new disk / file system by using BRtools.

As you are saying yours is a production environment, if there is any DR / standby system you have to take care of that also.

Cheers

KHS

[Former Member · Accepted solution]

Thank you all for your replies,

Wht will happen if PSAPSR3 total used space: 172,192.00 reaches total size: 180,000.00. Total Remaining size is: 7,837.56 and Total Used % is: 96.

How can i add new File System/Data file using any other method except BRTOOLS? I dont want to use Command Line Method.

Thanks.

[Former Member · Accepted solution]

Hi,

You can create a datafile by executing the command below, on SQLplus;

alter tablespace PSAPSR3DB add datafile '/oracle/<SID>/sapdata<n>/sr3db_<x>/<datafile>.data<x>' size <Size>M;

This is an example command. You should change, add or remove parameters regarding your needs.

But, I strongly recommend you that extend the tablespace by using br*tools.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi ,

Even if you use brtools it will eventually execute a sql command.Why we need to use brtools since the numbering is important for the new dat file to be addedd.Thanks.

[Former Member · Accepted solution]

Hi Orkun,

Cant i use SAP GUI to edit the Tablespace? Or is there any TCODE?

Thanks,

Please answer my question:

*Wht will happen if PSAPSR3 total used space: 172,192.00 reaches total size: 180,000.00. 
Total Remaining size is: 7,837.56 and Total Used % is: 96.*

[Former Member · Accepted solution]

Hi Diya,

>> Cant i use SAP GUI to edit the Tablespace? Or is there any TCODE?

Unfortunately, you can execute this command in SAP application. Please note that you can create your own solution by using SM49, for example

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Thank you Orkun,

My Question is still pending:

Please answer my question:

*Wht will happen if PSAPSR3 total used space: 172,192.00 reaches total size: 180,000.00.

Total Remaining size is: 7,837.56 and Total Used % is: 96.*

What is the Recommended size for Tablespace if we want to add? Current free space in partition is 275 GB.

ST04 is showing:

DB system:        ORA
Size:                   249.85 GB                       Total size:                 351.56 GB
Free Size:               14.94 GB                       Total free size:            116.66 GB
Used:                       94 %                        Total used:                     67 %

Regards,

[Former Member · Accepted solution]

Thank you Orkun,
> 
> My Question is still pending:
> Please answer my question:
> *Wht will happen if PSAPSR3 total used space: 172,192.00 reaches total size: 180,000.00. 
> Total Remaining size is: 7,837.56 and Total Used % is: 96.*
> 
> What is the Recommended size for Tablespace if we want to add? Current free space in partition is 275 GB. 
> 
> ST04 is showing:
> 
DB system:        ORA
> Size:                   249.85 GB                       Total size:                 351.56 GB
> Free Size:               14.94 GB                       Total free size:            116.66 GB
> Used:                       94 %                        Total used:                     67 %
> 
> Regards,

Hi Diya,

Maybe, you can resize the datafiles belong to the other tablespaces, in order to make more space, on the partition. Please note that those datafiles shouldn't be used by the objects.

At my customers, I am creating tablespaces 8000M initially and configuring max 16000M with the autoextent on, for PSAPSR3.

So, I can't give you an exact value. It is depended how much your tablespace is growing. You should take into account, history of the tablespace while calculating required space.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hai....

With reference to the statement

"What is the Recommended size for Tablespace if we want to add? Current free space in partition is 275 GB. "

As such there is no serious issue currently now, but you should have the eye on it, what is the database growth rate, depending on that you have to take the action.

Just share the statistics about, database growth in last 3 monts, 6months.

Cheers

KHS

[Former Member · Accepted solution]

Hi Shankar,

Please check the Data Growth below and reply.

Date	Name	Size(Gb)	Chg.Size	Free(Gb)	Chg.Free	Used(%)	Chg.Used	Users	Chg.Users	Tablespaces	Chg.Tablespaces	Segments	Chg.Segments	Data(%)	Chg.Data	Temp(%)	Chg.Temp	Tables(%)	Chg.Tables	Indexes(%)	Chg.Indexes	Others(%)	Chg.Others
01-06-11	PRD	247.93	8.38	14.87	-0.31	94	0	10	0	7	0	158120	4	97	0	3	0	47	0	30	0	23	0
01-05-11	PRD	239.55	6.34	15.18	0.48	94	0	10	0	7	0	158116	42	97	0	3	0	47	1	30	0	23	-1
01-04-11	PRD	233.21	6.04	14.70	-0.07	94	1	10	0	7	0	158074	6	97	0	3	0	46	0	30	0	24	0
01-03-11	PRD	227.17	1.15	14.77	-3.33	93	1	10	0	7	0	158068	9	97	0	3	0	46	1	30	1	24	-2
01-02-11	PRD	226.02	0.67	18.10	-1.23	92	1	10	0	7	0	158059	16	97	0	3	0	45	1	29	0	26	-1
01-01-11	PRD	225.35	0.00	19.33	-3.80	91	1	10	0	7	0	158043	-29	97	0	3	0	44	0	29	1	27	-1
01-12-10	PRD	225.35	8.00	23.13	4.19	90	-1	10	0	7	0	158072	8	97	0	3	0	44	0	28	-1	28	1
01-11-10	PRD	217.35	0.04	18.94	-3.37	91	1	10	0	7	0	158064	10	97	0	3	0	44	1	29	1	27	-2
01-10-10	PRD	217.31	9.76	22.31	6.78	90	-3	10	0	7	0	158054	6	97	0	3	0	43	-1	28	-1	29	2
01-09-10	PRD	207.55	0.00	15.53	-3.32	93	2	10	0	7	0	158048	6	97	0	3	0	44	1	29	1	27	-2
01-08-10	PRD	207.55	17.73	18.85	5.30	91	-2	10	1	7	0	158042	1281	97	0	3	0	43	-2	28	-2	29	4
01-07-10	PRD	189.82	8.80	13.55	2.67	93	-1	9	0	7	0	156761	14	97	-1	3	1	45	0	30	0	25	0
01-06-10	PRD	181.02	9.98	10.88	-0.32	94	1	9	0	7	0	156747	37	98	0	2	0	45	1	30	1	25	-2

You mean that i dont need to increase Tablespace size? What if the Table space TOTAL Size reaches zero?

Thank you,

Regards,

[Former Member · Accepted solution]

When the tablespace grows to 100% sap won't be able to write new data to the tables and some programs will crash.

So add another datafile and start analysing which tables are growing. I fyou don't want to use command line try brgui.

[Former Member · Accepted solution]

Hi Gerd,

Thank you for the reply,

what are the commands to add tablespace in BRTOOLS?

Please reply,

Regards,

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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

[Former Member]

thank you very much for all expert, specially Orkun.

[Former Member]

>> 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?

Hi,

You can grow the database by creating new datafiles on the new storage area. You don't need any additional configuration to do that. Please note that while creating new datafile, you just need to change old path to the new path, in br*tools. Please find the sample, below;

1 * Last added file name (lastfile) ....... E:\ORACLE\<SID>\SAPDATA4\....
2 * Last added file size in MB (lastsize) . [8000]
3 - New file to be added (file) ........... E:\oracle\<SID>\sapdata4\....
4 # Raw disk / link target (rawlink) ...... []
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]
9 - SQL command (command) ................. [alter tablespace ... add datafile 'E:\oracle\<SID>\sapdat
4\...' size 8000M autoextend on next 1000M maxsize 16000M]

As you see in the sample, you should change the value from E:\oracle\<SID>\sapdata4 to F:\oracle\<SID>\sapdata5, for example.

As an additional info, you can move datafiles to the other partition, by creating controlfiles, again.

In order to identify what objects are grwoing so fast, take a look at the list of the segments in the tablespace (DB02). Then, you can identify what tables are growing very fast and consider to take archive of those documents, periodically.

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jun 9, 2011 11:46 AM

[Former Member]

Take a look at the segments overview and analyse which tables of the tablespace have top size and growth.

Then you can try to stop that growth Starting point could be snote 706478.

Kind regards,

Gerd