Home » RDBMS Server » Performance Tuning » Query Temp Tablespace allocation problem
Query Temp Tablespace allocation problem [message #64795] Mon, 02 February 2004 21:37
Raju KVG
Messages: 13
Registered: January 2004
Junior Member
Hi All,
Iam using Oracle 9i release 2 version. I have written one proc which has a input of CLOB(coma seperated values passed in) and inside the proc i convert this CLOB into a PL/SQL table and did some normal insert and update stuff. When i run this it gives me a error saying ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

i checked the sort usage for the session which is running this proc. and found that it is using almost the entire temp tablespace.(298MB) the whole schema put together is not more than 150MB. to top it all there is no Order by or Group by clause used in the proc, still this happens can any 1 help giving a solution or let me know what is the probable cause for this.

Previous Topic: How to solve latch Promble?
Next Topic: Analyze table and Index usage by CBO
Goto Forum:

Current Time: Sat Mar 02 16:00:10 CST 2024