取ASH日志

create table dba_hist_active_20210717 as
select * from dba_hist_active_sess_history 
where sample_time between to_date('2021-07-17 04:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date ('2021-07-17 06:00:00','yyyy-mm-dd hh24:mi:ss');   

exp \'/ as sysdba\' file=/home/oracle/ash_support.dmp tables=dba_hist_active_20210717

imp \'/ as sysdba\' file=/home/oracle/ash_support.dmp tables=dba_hist_active_oracle_support

set linesize 300
col owner for a20
col DIRECTORY_NAME for a30
col DIRECTORY_PATH for a60
select * from dba_directories;

create directory dir1  as '/u01/app/oracle/dmps';             /oracle/app/oracle/implog
grant write,read on directory dir1 to sys;

CREATE TABLE system.ASH_TEMP_0311   AS
SELECT *
FROM DBA_HIST_ACTIVE_SESS_HISTORY D
WHERE D.SAMPLE_TIME BETWEEN TO_DATE('2021-03-11 07:00:00', 'YYYY-MM-DD HH24:MI:SS') AND
TO_DATE('2021-03-11 07:30:00', 'YYYY-MM-DD HH24:MI:SS');

nohup expdp "'/ as sysdba'" directory=DIR1  tables=system.ASH_TEMP_0311 dumpfile=ASH_TEMP_0311.dmp logfile=ASH_TEMP_0311.log content=ALL cluster=n  parallel=4 > expdp_08.log &      

drop table system.ASH_TEMP_20201118;

drop directory dir1;