查看ORACLE数据库内存使用情况

select asidbnameavalue from v$sesstat av$statname b

where (bname like %uga% or bname like %pga%) and astatistic# = bstatistic#

order by sid