oracle查找客户端未提交的事务语句

oracle查找客户端未提交的事务语句 ?âÊÔ???? Ö??ú:cent os 4.3 (192.168.1.33) Êý?Ý?â?æ??:Version 10.2.0.1.0 windows?Í???Ë(192.168.1.11) ×öÕâ?ö?âÊÔÖ?Ç???ÏÈÊìÏ?ÒÔϵÄ??Ì?ÐÔÄÜ?í(?É?Î??10gR2Îĵµ) v$session (lists session information for each current session) v$transaction (lists the active transactions in the system) v$process (contains information about the currently active processes) v$sql (lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered) ?é??µ?Ç?Á??ÓµÄ?á??×?Ì? SQL> select sid,username,status from v$session where username is not null; SID USERNAME STATUS ---------- ------------------------------ -------- 159 SYS ACTIVE Æô???àÌý??ÈÃwindows?Í???ËÄÜÁ??ÓÉÏÀ? SQL> !lsnrctl start È?ºóÔÚwindowsÉÏÓÃscottÁ??ÓÉÏÀ? ÔÚ192.168.1.33ÉÏÓÃnetstat?é??µ?Ç??ø?Ì×?Ì?(netstat -anp) [oracle@centos ~]$ netstat -anp (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:32768 0.0.0.0:* LISTEN - tcp 0 0 0.0.0.0:32769 0.0.0.0:* LISTEN 2770/ora_d000_lihui tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN - tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 2981/tnslsnr tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN - tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN - tcp 0 0 127.0.0.1:32795 127.0.0.1:1521 ESTABLISHED 2748/ora_pmon_lihui tcp 0 0 192.168.1.33:1521 192.168.1.11:1042 ESTABLISHED 3155/oraclelihui tcp 0 0 127.0.0.1:1521 127.0.0.1:32795 ESTABLISHED 2981/tnslsnr tcp 0 0 :::22 :::* LISTEN - tcp 0 0 ::ffff:192.168.1.33:22 ::ffff:192.168.1.11:1041 ESTABLISHED - ............................... ...............ÒÔÏÂÊ?ÂÔ ?é???ßÌåÁ??Óµ?oracleµÄÄÄ?ö?ø?Ì [oracle@centos ~]$ ps -ef |grep 3155 oracle 3155 1 0 05:39 ? 00:00:00 oraclelihui (LOCAL=NO) oracle 3696 2682 0 05:55 pts/0 00:00:00 grep 3155 ÔÚwindowsÉÏÒ??ÉÒÔ?é??Á??Óµ?192.168.1.33ÉϵÄ?ø?Ì: C:\>netstat -b TCP china:1042 192.168.1.33:1521 ESTABLISHED 2148 [sqlplus.exe] ?Í???Ë??ÆðÁ??Ó(192.168.1.11)(µ???Òªcommit?????ÖÊÂÎñ) SQL> conn scott/tiger@lihui ÒÑÁ??Ó?? SQL> create table m (id number(5),name char(10)); ?íÒÑ?????? SQL> insert into m values (0,'test'); ÒÑ???? 1 ÐÐ?? ?ËÊ???ÒªcommitÌá???? ?þÎñ?Ë?éÑ?(192.168.1.33) SQL> select addr,ses_addr from v$transaction; ADDR SES_ADDR -------- -------- 28967184 29F056AC SQL> select saddr,sid,paddr,username,status from v$session where username is not null; SADDR SID PADDR USERNAME STATUS -------- ---------- -------- ------------------------------ -------- 29F056AC 154 29E1DA40 SCOTT INACTIVE 29F0B430 159 29E1C370 SYS ACTIVE SQL> select sid,prev_sql_addr,username,status from v$session 2 where username is not null; SID PREV_SQL USERNAME STATUS ---------- -------- ------------------------------ -------- 154 26A365C8 SCOTT INACTIVE 159 26A35DD0 SYS ACTIVE SQL> select sql_text,address from v$sql 2 where address='26A365C8'; SQL_TEXT -------------------------------------------------------------------------------- ADDRESS -------- insert into m values (0,'test') 26A365C8 µ??Ë?éµ?ÁËÕýÔÚ?øÐÐtransactionµÄsqlÓï?ä?? ???º select addr,ses_addr from v$transaction; select saddr,sid,serial#,username,status from v$session where username is not null; select saddr,sid,serial#,username,status,prev_sql_addr,prev_hash_value from v$session where username is not null; select addr,sid,username,s.status,process,program from v$transaction t,v$session s where t.ses_addr=s.saddr; select addr,pid,spid,program from v$process; select saddr,sid,paddr,username,status from v$session where username is not null; select sql_text,address,hash_value from v$sql q,v$session s where s.sid=154 and s.prev_sql_addr=q.address; ??????????? ???“??????????????????????”?????? ???????? ?? ????? 1? ????? 23 ????? ?????”???“??????????? ???????????????????????????????????????????????????????????????????????????????? 2? ????? 34? ?? ???????????????????? ?????????????????????????????????????????????????????????????? ????????????????????5? ?? ????? 1? ????????????????????5?? ???????WHO???????????????5??????????????12?????????2.3?/??????? 2? ??????????? ?????????????????????????????????????????????????“????????????????”???????????????????????????????????????2??????????????2.0mmHg?1.2mmHg? “?????„????????????????”?????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????“????”??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ??????????????? 3????????????????? ???????????????????????????????????????????????????????????? ????????????????????????????????????????????????????????? ???????????????????????????????????????????????????????? ??????????????????????????? ????????1600??????????????????????????????????? ???????????????????1000?????????26????????????? ?????1??10? ??????????? ?????????? ??????????? ??????5??? ??????????