space usage of Temporary table
802709Jul 13 2012 — edited Jul 19 2012Hello,
how much space is a specific temporary table used in my current session ? how can i learn that.
V$SORT_USAGE view shows everything (sorting and all temporary tables). I want to learn a specific temporary tables usage percent. I can see them row by row in V$SORT_USAGE but which one is belong to which, i cant separete them.
for ex there are 4 temp table that i used in a session, when i select V$SORT_USAGE, I can see 4 rows (segtype is DATA) but which one is which table ?
edit: I changed the subject because of missunderstandings.