well turn the autoextend off then

cursor does not cause temp tablespace to grow, it's your SQL statements that cause them with ORDER BY, GROUP BY or MERGE JOINs