44 lines
807 B
Plaintext
Executable File
44 lines
807 B
Plaintext
Executable File
col SAMPLE_TIME for a21
|
|
col Mb for 999 999 999
|
|
|
|
select
|
|
SAMPLE_TIME
|
|
,SQL_ID
|
|
,SESSION_ID
|
|
,PGA_ALLOCATED/1024/1024 Mb
|
|
,TEMP_SPACE_ALLOCATED/1024 Mb
|
|
from
|
|
DBA_HIST_ACTIVE_SESS_HISTORY
|
|
where
|
|
SAMPLE_TIME between to_date('2020-05-16 11:00','YYYY-MM-DD HH24:MI') and to_date('2020-05-16 12:00','YYYY-MM-DD HH24:MI')
|
|
order by
|
|
SAMPLE_TIME asc
|
|
/
|
|
|
|
|
|
|
|
select
|
|
max(PGA_ALLOCATED/1024/1024) Mb
|
|
, max(TEMP_SPACE_ALLOCATED/1024) Mb
|
|
from
|
|
DBA_HIST_ACTIVE_SESS_HISTORY
|
|
where
|
|
SAMPLE_TIME between sysdate-14 and sysdate
|
|
/
|
|
|
|
|
|
select
|
|
SAMPLE_TIME
|
|
,SQL_ID
|
|
,SESSION_ID
|
|
,PGA_ALLOCATED/1024/1024 Mb
|
|
,TEMP_SPACE_ALLOCATED/1024 Mb
|
|
from
|
|
DBA_HIST_ACTIVE_SESS_HISTORY
|
|
where
|
|
SAMPLE_TIME between sysdate-14 and sysdate
|
|
and PGA_ALLOCATED is not null
|
|
order by
|
|
4 asc
|
|
/
|