Strange temp table tblspaces in onstat -g ses

Hi Family, I was monitoring a very active user (holding ~1500 locks) and ran onstat -g ses <sessionid>. At the bottom of the output is a list of thesession's temp tables. The following caught my eye: User-created Temp tables : partnum tabname rowsize 500002 temp_ean_store 122 500002 temp_ean_store 122 500002 temp_ean_store 84 4000a0 temp_ean_store 122 Now I can understand the first and last of these entries. We have multiple temp dbspaces so the emp table got fragmented (round robin) across the two dbspaces. This explains two values for partnum. But the second one looks identical to the first - same partition number and row size. Could this be simply another extent being treated like a separate table? Sounds really unlikely! Then there is the matter of the third temp table. Same partnum, different row size. . ??????????????????? Can someone tell me what's going on here? Thanks. -- +---- Jacob Salomon - DBA JSalomon@bn.com - ---------------------------+ |--------------- Obligatory sesquipedalian obfuscation: ---------------| | An object of igneous, sedimentary or metamorphic mineral in combined | | states of elevated linear and rotational kinetic energy acquires no | | accumulation of bryophytic vegetation. | +----------------------------------------------------------------------+ Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.