select b.PGA_USED_MEM PGA_USED_MEM, b.PGA_ALLOC_MEM PGA_ALLOC_MEM,
b.PGA_FREEABLE_MEM PGA_FREEABLE_MEM,b.PGA_MAX_MEM PGA_MAX_MEM
from v$session a, v$process b
where a.PADDR=b.ADDR and a.sid ='&sid'
最初由 Talmud 发布
[B]select b.PGA_USED_MEM PGA_USED_MEM, b.PGA_ALLOC_MEM PGA_ALLOC_MEM,
b.PGA_FREEABLE_MEM PGA_FREEABLE_MEM,b.PGA_MAX_MEM PGA_MAX_MEM
from v$session a, v$process b
where a.PADDR=b.ADDR and a.sid ='&sid' [/B]
能否解释一下a.sid ='&sid'是何意思?谢谢