现在的情况是,有一张数据量大概为15W左右的表
我利用查看数据库v$session和v$sqlarea查到大部分连接都在查询这个表
但是好像都没响应到数据,导致连接一直处于活动状态,最后连接不够用,使客户端在也获得不到连接
<?xml version="1.0" encoding="utf-8" ?>
- <ROWDATA>
- <ROW>
<C0>1</C0>
<SID>28</SID>
<SERIAL_>61466</SERIAL_>
<SPID>22533</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select lspcell0_.ID as ID6_, lspcell0_.NETWORK_TYPE as NETWORK2_6_, lspcell0_.BSC as BSC6_, lspcell0_.SITE as SITE6_, lspcell0_.ALTITUDE as ALTITUDE6_, lspcell0_.LATITUDE as LATITUDE6_, lspcell0_.LONGITUDE as LONGITUDE6_, lspcell0_.CGI as CGI6_, lspcell0_.CELL as CELL6_, lspcell0_.ACCMIN as ACCMIN6_, lspcell0_.ANTENNA_GAIN as ANTENNA11_6_, lspcell0_.ANTENNA_TILT as ANTENNA12_6_, lspcell0_.ANTENNA_TYPE as ANTENNA13_6_, lspcell0_.BCC as BCC6_, lspcell0_.BCCHNO as BCCHNO6_, lspcell0_.BSPWR as BSPWR6_, lspcell0_.BSPWRB as BSPWRB6_, lspcell0_.CELL_DIR as CELL18_6_, lspcell0_.C_SYS_TYPE as C19_6_, lspcell0_.CELL_TYPE as CELL20_6_, lspcell0_.CI as CI6_, lspcell0_.ENV_CHAR as ENV22_6_, lspcell0_.HEIGHT as HEIGHT6_, lspcell0_.LAC as LAC6_, lspcell0_.C_LATITUDE as C25_6_, lspcell0_.C_LONGITUDE as C26_6_, lspcell0_.MAX_ALTITUDE as MAX27_6_, lspcell0_.MAX_CELL_RADIUS as MAX28_6_, lspcell0_.MCC as MCC6_, lspcell0_.MIN_ALTITUDE as MIN30_6_, lspcell0_.MNC as MNC6_, lspcell0_.NCC as NCC6_, lspcell0_.S</SQL_TEXT>
</ROW>
- <ROW>
<C0>2</C0>
<SID>29</SID>
<SERIAL_>1246</SERIAL_>
<SPID>22176</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011040' and subscripti0_.MSID='8613809282018' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>3</C0>
<SID>35</SID>
<SERIAL_>43023</SERIAL_>
<SPID>22190</SPID>
<STATUS>INACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT />
</ROW>
- <ROW>
<C0>4</C0>
<SID>36</SID>
<SERIAL_>52769</SERIAL_>
<SPID>22517</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011040' and subscripti0_.MSID='8613418004240' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>5</C0>
<SID>37</SID>
<SERIAL_>65025</SERIAL_>
<SPID>22285</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011000' and subscripti0_.MSID='8613538753045' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>6</C0>
<SID>40</SID>
<SERIAL_>59940</SERIAL_>
<SPID>22248</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='075511000' and subscripti0_.MSID='8613530649212' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>7</C0>
<SID>50</SID>
<SERIAL_>64244</SERIAL_>
<SPID>22234</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='0760110' and subscripti0_.MSID='8613590922442' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>8</C0>
<SID>56</SID>
<SERIAL_>26224</SERIAL_>
<SPID>22192</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011000' and subscripti0_.MSID='8613824461545' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>9</C0>
<SID>88</SID>
<SERIAL_>28547</SERIAL_>
<SPID>22301</SPID>
<STATUS>INACTIVE</STATUS>
<PROG>PLSQLDev.exe</PROG>
<MACH>WW-TXWG\WW-B-XA-10</MACH>
<SQL_TEXT />
</ROW>
- <ROW>
<C0>10</C0>
<SID>92</SID>
<SERIAL_>7572</SERIAL_>
<SPID>22240</SPID>
<STATUS>INACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT />
</ROW>
- <ROW>
<C0>11</C0>
<SID>95</SID>
<SERIAL_>2757</SERIAL_>
<SPID>22289</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011020' and subscripti0_.MSID='8613602224553' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>12</C0>
<SID>96</SID>
<SERIAL_>36793</SERIAL_>
<SPID>22228</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT>select lspcell0_.ID as ID6_, lspcell0_.NETWORK_TYPE as NETWORK2_6_, lspcell0_.BSC as BSC6_, lspcell0_.SITE as SITE6_, lspcell0_.ALTITUDE as ALTITUDE6_, lspcell0_.LATITUDE as LATITUDE6_, lspcell0_.LONGITUDE as LONGITUDE6_, lspcell0_.CGI as CGI6_, lspcell0_.CELL as CELL6_, lspcell0_.ACCMIN as ACCMIN6_, lspcell0_.ANTENNA_GAIN as ANTENNA11_6_, lspcell0_.ANTENNA_TILT as ANTENNA12_6_, lspcell0_.ANTENNA_TYPE as ANTENNA13_6_, lspcell0_.BCC as BCC6_, lspcell0_.BCCHNO as BCCHNO6_, lspcell0_.BSPWR as BSPWR6_, lspcell0_.BSPWRB as BSPWRB6_, lspcell0_.CELL_DIR as CELL18_6_, lspcell0_.C_SYS_TYPE as C19_6_, lspcell0_.CELL_TYPE as CELL20_6_, lspcell0_.CI as CI6_, lspcell0_.ENV_CHAR as ENV22_6_, lspcell0_.HEIGHT as HEIGHT6_, lspcell0_.LAC as LAC6_, lspcell0_.C_LATITUDE as C25_6_, lspcell0_.C_LONGITUDE as C26_6_, lspcell0_.MAX_ALTITUDE as MAX27_6_, lspcell0_.MAX_CELL_RADIUS as MAX28_6_, lspcell0_.MCC as MCC6_, lspcell0_.MIN_ALTITUDE as MIN30_6_, lspcell0_.MNC as MNC6_, lspcell0_.NCC as NCC6_, lspcell0_.S</SQL_TEXT>
</ROW>
- <ROW>
<C0>13</C0>
<SID>97</SID>
<SERIAL_>46479</SERIAL_>
<SPID>22218</SPID>
<STATUS>INACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT />
</ROW>
</ROW>这是导出来的活动连接执行的语句,这只是一部分,由于帖子大小的问题,不能贴的太多请大家帮忙分析分析,会有什么原因导致产生这个的问题呢?
我利用查看数据库v$session和v$sqlarea查到大部分连接都在查询这个表
但是好像都没响应到数据,导致连接一直处于活动状态,最后连接不够用,使客户端在也获得不到连接
<?xml version="1.0" encoding="utf-8" ?>
- <ROWDATA>
- <ROW>
<C0>1</C0>
<SID>28</SID>
<SERIAL_>61466</SERIAL_>
<SPID>22533</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select lspcell0_.ID as ID6_, lspcell0_.NETWORK_TYPE as NETWORK2_6_, lspcell0_.BSC as BSC6_, lspcell0_.SITE as SITE6_, lspcell0_.ALTITUDE as ALTITUDE6_, lspcell0_.LATITUDE as LATITUDE6_, lspcell0_.LONGITUDE as LONGITUDE6_, lspcell0_.CGI as CGI6_, lspcell0_.CELL as CELL6_, lspcell0_.ACCMIN as ACCMIN6_, lspcell0_.ANTENNA_GAIN as ANTENNA11_6_, lspcell0_.ANTENNA_TILT as ANTENNA12_6_, lspcell0_.ANTENNA_TYPE as ANTENNA13_6_, lspcell0_.BCC as BCC6_, lspcell0_.BCCHNO as BCCHNO6_, lspcell0_.BSPWR as BSPWR6_, lspcell0_.BSPWRB as BSPWRB6_, lspcell0_.CELL_DIR as CELL18_6_, lspcell0_.C_SYS_TYPE as C19_6_, lspcell0_.CELL_TYPE as CELL20_6_, lspcell0_.CI as CI6_, lspcell0_.ENV_CHAR as ENV22_6_, lspcell0_.HEIGHT as HEIGHT6_, lspcell0_.LAC as LAC6_, lspcell0_.C_LATITUDE as C25_6_, lspcell0_.C_LONGITUDE as C26_6_, lspcell0_.MAX_ALTITUDE as MAX27_6_, lspcell0_.MAX_CELL_RADIUS as MAX28_6_, lspcell0_.MCC as MCC6_, lspcell0_.MIN_ALTITUDE as MIN30_6_, lspcell0_.MNC as MNC6_, lspcell0_.NCC as NCC6_, lspcell0_.S</SQL_TEXT>
</ROW>
- <ROW>
<C0>2</C0>
<SID>29</SID>
<SERIAL_>1246</SERIAL_>
<SPID>22176</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011040' and subscripti0_.MSID='8613809282018' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>3</C0>
<SID>35</SID>
<SERIAL_>43023</SERIAL_>
<SPID>22190</SPID>
<STATUS>INACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT />
</ROW>
- <ROW>
<C0>4</C0>
<SID>36</SID>
<SERIAL_>52769</SERIAL_>
<SPID>22517</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011040' and subscripti0_.MSID='8613418004240' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>5</C0>
<SID>37</SID>
<SERIAL_>65025</SERIAL_>
<SPID>22285</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011000' and subscripti0_.MSID='8613538753045' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>6</C0>
<SID>40</SID>
<SERIAL_>59940</SERIAL_>
<SPID>22248</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='075511000' and subscripti0_.MSID='8613530649212' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>7</C0>
<SID>50</SID>
<SERIAL_>64244</SERIAL_>
<SPID>22234</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='0760110' and subscripti0_.MSID='8613590922442' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>8</C0>
<SID>56</SID>
<SERIAL_>26224</SERIAL_>
<SPID>22192</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011000' and subscripti0_.MSID='8613824461545' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>9</C0>
<SID>88</SID>
<SERIAL_>28547</SERIAL_>
<SPID>22301</SPID>
<STATUS>INACTIVE</STATUS>
<PROG>PLSQLDev.exe</PROG>
<MACH>WW-TXWG\WW-B-XA-10</MACH>
<SQL_TEXT />
</ROW>
- <ROW>
<C0>10</C0>
<SID>92</SID>
<SERIAL_>7572</SERIAL_>
<SPID>22240</SPID>
<STATUS>INACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT />
</ROW>
- <ROW>
<C0>11</C0>
<SID>95</SID>
<SERIAL_>2757</SERIAL_>
<SPID>22289</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog02</MACH>
<SQL_TEXT>select subscripti0_.ID as ID21_, subscripti0_.CLIENT_ID as CLIENT2_21_, subscripti0_.SERVICE_ID as SERVICE3_21_, subscripti0_.MSID as MSID21_, subscripti0_.MSID_TYPE as MSID5_21_, subscripti0_.EXPIRE_DATETIME as EXPIRE6_21_, subscripti0_.CREATE_TIME as CREATE7_21_, subscripti0_.MODIFY_TIME as MODIFY8_21_, subscripti0_.SUBS_STATUS as SUBS9_21_, subscripti0_.SUBS_TYPE as SUBS10_21_ from SUBSCRIPTION_TEMP subscripti0_ where 1=1 and subscripti0_.SERVICE_ID='02011020' and subscripti0_.MSID='8613602224553' and subscripti0_.MSID_TYPE='msisdn' and subscripti0_.SUBS_TYPE='eme' and subscripti0_.SUBS_STATUS=0</SQL_TEXT>
</ROW>
- <ROW>
<C0>12</C0>
<SID>96</SID>
<SERIAL_>36793</SERIAL_>
<SPID>22228</SPID>
<STATUS>ACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT>select lspcell0_.ID as ID6_, lspcell0_.NETWORK_TYPE as NETWORK2_6_, lspcell0_.BSC as BSC6_, lspcell0_.SITE as SITE6_, lspcell0_.ALTITUDE as ALTITUDE6_, lspcell0_.LATITUDE as LATITUDE6_, lspcell0_.LONGITUDE as LONGITUDE6_, lspcell0_.CGI as CGI6_, lspcell0_.CELL as CELL6_, lspcell0_.ACCMIN as ACCMIN6_, lspcell0_.ANTENNA_GAIN as ANTENNA11_6_, lspcell0_.ANTENNA_TILT as ANTENNA12_6_, lspcell0_.ANTENNA_TYPE as ANTENNA13_6_, lspcell0_.BCC as BCC6_, lspcell0_.BCCHNO as BCCHNO6_, lspcell0_.BSPWR as BSPWR6_, lspcell0_.BSPWRB as BSPWRB6_, lspcell0_.CELL_DIR as CELL18_6_, lspcell0_.C_SYS_TYPE as C19_6_, lspcell0_.CELL_TYPE as CELL20_6_, lspcell0_.CI as CI6_, lspcell0_.ENV_CHAR as ENV22_6_, lspcell0_.HEIGHT as HEIGHT6_, lspcell0_.LAC as LAC6_, lspcell0_.C_LATITUDE as C25_6_, lspcell0_.C_LONGITUDE as C26_6_, lspcell0_.MAX_ALTITUDE as MAX27_6_, lspcell0_.MAX_CELL_RADIUS as MAX28_6_, lspcell0_.MCC as MCC6_, lspcell0_.MIN_ALTITUDE as MIN30_6_, lspcell0_.MNC as MNC6_, lspcell0_.NCC as NCC6_, lspcell0_.S</SQL_TEXT>
</ROW>
- <ROW>
<C0>13</C0>
<SID>97</SID>
<SERIAL_>46479</SERIAL_>
<SPID>22218</SPID>
<STATUS>INACTIVE</STATUS>
<PROG />
<MACH>gzsog01</MACH>
<SQL_TEXT />
</ROW>
</ROW>这是导出来的活动连接执行的语句,这只是一部分,由于帖子大小的问题,不能贴的太多请大家帮忙分析分析,会有什么原因导致产生这个的问题呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货