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,