A basic question. How is memory allocated for a temp table in memory. I am wondering if memory is partly allocated based on the data types and probably the max bytes for a varchar2 say? Does anybody know how it's done?
I am asking as somebodies query with temp tables crashed a database yesterday, and I am not sure how the memory allocation got so big.