Did 10.1 also exist holding temp free problem ?
I found that SELECT / UPDATE lob column which has holding temp creating involved still has memery problems in 10.1 version. For example:
select long_varchar(name) from aa; --name is a varchar column
For every row in aa, the dbms will create a new holding temp table to hold convered name value, and then in the adu_redeem to get value from that holding temp, BUT I found that the system will not delete the holding temp, so row after row, many holding temps will accumulate until end of selection the dmpe_free_temps frees all temps. But if aa has many many rows , it will use up memetry resource before end of selection!