sorts(memory) and sorts(disk) in v$sysstat
hi guys,
I am a bit confused.
My temp tablespace grew and grew to over 19G. Only one query was being run (a poorly written one), that was doing a lot of sorts. However, in v$sysstat it said sorts(disk) = 7, and sorts (memory) = 1971. This is the second time I have seen something like this. If so many sorts are happening in memory, then surely the temp tablespace should not be growing as much (unless the 7 sorts were HUGE sorts)
thanks