SELECT se.username,
         se.sid,
         se.serial#,
         su.extents,
         su.blocks * TO_NUMBER (RTRIM (p.VALUE)) AS Space,
         tablespace,
         segtype,
         sql_text
    FROM v$sort_usage su,
         v$parameter p,
         v$session se,
         v$sql s
   WHERE     p.name = 'db_block_size'
         AND su.session_addr = se.saddr
         AND s.hash_value = su.sqlhash
         AND s.address = su.sqladdr
ORDER BY se.username, se.sid;

版权声明：本文为博主原创文章，未经博主允许不得转载。