select count(*) from v$session; // 查看连接数
select
(case when(round(a.resourceSize/(1024*1024*1024),2)>=1)
then round(a.resourceSize/(1024*1024*1024),2)||'G'
when(round(a.resourceSize/(1024*1024),2)>=1)
then round(a.resourceSize/(1024*1024),2)||'M'
when(round(a.resourceSize/(1024),2)>=1)
then round(a.resourceSize/(1024),2)||'K'
else a.resourceSize||'B'
end )
resourceSize from r_resource a;