--获取SPID
[root@RSRAC1 ~]# ps -ef|grep exp
oracle 4967 4656 7 16:28 pts/2 00:00:42 exp tables=TCUSTINFO file=TCUSTINFO.dump log=1.log
root 5364 5076 0 16:37 pts/11 00:00:00 grep exp
root 6672 1 0 2013 ? 00:09:25 gpm -m /dev/input/mice -t exps2
[root@RSRAC1 ~]# ps -ef|grep 4967
oracle 4967 4656 7 16:28 pts/2 00:00:42 exp tables=TCUSTINFO file=TCUSTINFO.dump log=1.log
oracle 4971 4967 1 16:28 ? 00:00:07 oracleTADB1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) --
root 5397 5076 0 16:37 pts/11 00:00:00 grep 4967
[root@RSRAC1 ~]#
--打开新会话,挂起导出操作
SQL> conn / as sysdba
Connected.
SQL> oradebug setospid 4971
Oracle pid: 44, Unix process pid: 4971, image: oracle@RSRAC1 (TNS V1-V3)
SQL> oradebug suspend
Statement processed.
SQL>
--awr报告分析 --有执行次数,没有模拟出问题
Elapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text
10.36 3 3.45 26.31 27.12 0.00 arhmv1sazb9k7 exp@RSRAC1 (TNS V1-V3) SELECT /*+NESTED_TABLE_GET_REF...
-其它地方一样,这个地方不一样
-故障现象还是不清楚啊