Consumo de PGA e TEMP por sessão
Pessoal,
No Oracle 11g release 2 ficou simples identificar quais sessões consumiram mais PGA e TEMP =)
Basta consultar a view DBA_HIST_ACTIVE_SESS_HISTORY e verificar as novas colunas:
- PGA_ALLOCATED – Amount of PGA memory (in bytes) consumed by this session at the time this sample was taken
- TEMP_SPACE_ALLOCATED – Amount of TEMP memory (in bytes) consumed by this session at the time this sample was taken
Abraços