首页 > 数据库 > Oracle > GoldenGate11g长交易造成CPU负载高
SQL>select spid from v$process where addr not in (select paddr from v$session) |
ggsic>info all; ggsci>stop extract * |
GGSCI> send extract EXTXXXX, showtrans thread 1 Sending showtrans request to EXTRACT EXTDXXXX ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 31144, SCN 3108.3631174241 (13352389530209), RBA 123683344 Redo Thread 2, Redo Log Sequence Number 28782, SCN 3193.2127650774 (13715958226902), RBA 332887056 ------------------------------------------------------------ XID: 24.0.4087185 Items: 0 Extract: EXTDXXXX Redo Thread: 1 Start Time: 2013-11-14:21:27:12 SCN: 3108.3631174241 (13352389530209) Redo Seq: 31144 Redo RBA: 123683344 Status: Running ------------------------------------------------------------ XID: 27.20.3177181 Items: 0 Extract: EXTXXXX Redo Thread: 1 Start Time: 2013-11-14:21:30:31 SCN: 3108.3631249907 (13352389605875) Redo Seq: 31144 Redo RBA: 130199568 Status: Running |
SQL>select addr, start_time from v$transaction where xidusn=27; (通过以上输出XID获取第一位数值) ADDR START_TIME -------------------------- -------------------- 0700000E998CE528 11/14/13 21:30:30 SQL>select sid, command,sql_id from v$session where taddr in (select addr from v$transaction where xidusn=27) SID COMMAND SQL_ID ---------- ---------- ------------- 4202 2 dd2jh9ht3h4fy SQL> select sql_text from v$sqlarea where sql_id='dd2jh9ht3h4fy' insert into xxx@dblink values xxxxxxxxxxxxx SQL> select spid from v$process where addr in (select paddr from v$session where sid=4202); SPID ------------------------ 24183256 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/354732/viewspace-1074331/,如需转载,请注明出处,否则将追究法律责任。