9 where (SAMPLE_TIME >=
10 to_date('2014-07-13 18:30:00', 'yyyy-mm-dd hh24:mi:ss') and
11 SAMPLE_TIME <=
12 to_date('2014-07-13 18:45:00', 'yyyy-mm-dd hh24:mi:ss'))
13 and a.session_id=529
14 order by session_id,SAMPLE_TIME;

SUBSTRB(SES SUBSTRB(EVENT,1 BLOCKING_SESSION TO_CHAR(SAMPLE_ INSTANCE_NUMBER SQL_ID SUBSTRB(PROGRAM,1,30)
----------- --------------- ---------------- --------------- --------------- ------------- ------------------------------
529.1 20140713 183204 2 oracle@KXYEB02 (LMON)
529.1 20140713 183215 2 oracle@KXYEB02 (LMON)

529.1 20140713 183609 1 oracle@KXYEB01 (LMON)
529.1 20140713 184151 1 oracle@KXYEB01 (LMON)------------
529.1 20140713 184218 2 oracle@KXYEB02 (LMON)
529.1 20140713 184332 1 oracle@KXYEB01 (LMON)

--dump systemstate 已经无法分析当时数据
--分析awr报告，没有发现latch 问题

-- 下次遇到这个问题的是及时进行一下操作
--1 登录数据库
sqlplus /nolog
conn / as sysdba
oradebug setmypid
oradebug dump systemstate 10
oradebug tracefile_name

--2 可以的话再执行一次
1 获取process id
ps -ef|grep expdp
id
2 10046分析

SQL> select to_char(a.last_analyzed,'yyyymmdd hh24miss') from dba_tables a where table_name='H_ACK_DIVIDEND';

TO_CHAR(A.LAST_
---------------
20140713 181130

SQL>

异常中止或者lmon引起等待挂起，根源原因分析不出来!