Knowledge Management

Question:
Env: oracle817,sap46c.
Description:
When a user execute a program, there is a dump: ora-1652 :can not allocate extent by 121 in tablespace PSAPTEMP.
First I add a data file: I do it in sapdba, but when execute this program, the dump come again;
Then I increase parameter : initial extents, next extents，the same result(use sqlplus)。
I check something about this temporary tablespace:：
User sapr3，system ‘s temp tablespace is PSAPTEMP, and PSAPTEMP’s contents(from dba_tablespace’s colume) is permenent, logging, while not temporary, nologging, then I change it into temporary：
alter tablespace PSAPTEMP temporary, nologging.
But the the above dump is still comes，another things is the allocation of PSAPTEMP is always 0.
How I can do it? Thanks any help.
Answer:
Helen,
Even though it's pointing to PSAPTEMP, I don't think it's temporary table sapce problem.
In the dump find out whether it's referring to any othething other than PSAPTEMP.(I.E IT MAY REFER TO A TABLE OR INDEX).
If you know what tablesapce that object belongs to you can increase the size.
The otherway is find out from db02 what tablespaces are full.
HTH
Ven
Answer:
i would love to tell you to increase your temp tablespace, but my oracle knowledge really questions why the heck your temp needs such space (unless it was allocated very little space in the first place). Temp is usually used for sorting, so i would go about checking the intial size of the tablespace, and if its big enough, then im guessing its code/performance issue.
Answer:
yes, psaptemp used for sorting, so if there are lots of sorting, then u required a big space.... maybe like archiving, ixos?
Answer:
Dear Helen,
I got same exper'ce in my pre's project.
Maintain ur PSAPTEM syze 10 OR 20 OR 50 GB Above...
Thanks,
Praveen.
Praveen_doddy@yahoo.co.in