PSAPTEMP Tablespace in ECC6.0

128 Views

Dear all,

After upgrading from 4.6c to ECC6.0, we found that the tablespace PSAPTEMP is quite different from the other tablespaces.

Given below is the brtools output of the tablespaces:

Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]

.

45 - PSAPSTABI DATA ONLINE LOCAL MANUAL NO 2/0

16777216 85.04 2509248 16777216 0 264 664576:656384:262080:262080:109568

46 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 1/0

9216000 0.00 9216000 9216000 0 0 0:0:0:0:0

47 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 5/0

6725632 0.00 6725312 6725632 0 842 290816:287744:142336:139200:95232

PSAPTEMP alone has the last field as 0:0:0:0:0.

1. Do we need to modify/alter the psaptemp tablespace to be normal?

2. How do we assign the correct size of the PSAPTEMP tablespace to our environment?

Thanks & Regards

Senthil