收集 ASH dump文件
ASH dump:
create a table m_ash
SQL> conn / as sysdba
SQL> create table m_ash as select * from dba_hist_active_sess_history where SAMPLE_TIME between TO_TIMESTAMP ('2022-05-25 03:15:00', 'YYYY-MM-DD HH24:MI:SS') and TO_TIMESTAMP ('2022-05-25 03:45:00', 'YYYY-MM-DD HH24:MI:SS');
export the newly created table m_ash, compress the dump file and upload it to this SR.
eg:
$ exp system/<password> file=m_ash.dmp tables=sys.m_ash
$ gzip m_ash.dmp
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle
- 上一篇:oracle隐藏参数
- 下一篇:ansible普通用户提权