Top10的PGA消耗

Top10的PGA消耗

select sess.sid,
       sess.serial#,
       sess.username,
       trunc(proc.pga_used_mem, 2) "PGA_USED(MB)",
       prof.user_name,
       prof.user_chin_nm,
       prof.phone_num,
       prof.terr_cd
  from v$session sess,
       (select *
          from (select addr, pga_used_mem / 1024 / 1024 pga_used_mem
                  from v$process
                 order by pga_used_mem desc)
         where rownum < 11) proc,
       (select user_id, user_name, user_chin_nm, phone_num, terr_cd
          from tuser_profiles) prof
 where sess.paddr = proc.addr
   and prof.user_id = sess.username
 order by 4 desc
/
Trackback

no comment untill now

Add your comment now

切换到手机版