oracle报错12516,Oracle连接数太多报错-ORA-12516错误

接到数据库报警：ORA-12516

查看数据库上相关连接：

INST_ID MACHINE USERNAME COUNT(*)

---------- ---------------------------------------------------------------- ------------------------------ ----------

2 ZJHZ-PS-CMREAD-SV-SNS01-DB-BJ MREAD 900

1 irora28 TMPUSER_CMUREF 616

1 ZJHZ-CMREAD-CMUCMS01-VINT-SD MREAD 235

irora28 是第八套数据库服务器主机名，怀疑是通过 dblink 连过来的，查看 TMPUSER_CMUREF 用户下的sql ：

SELECT /*+ FULL(P) +*/ * FROM "PTL_RANK_VISIT_MONTH" P

SELECT "BOOKID","COUNT","COUNTORIGINAL" FROM "PTL_RANK_VISIT_MONTH" "PRVM" WHERE TO_NUMBER("BOOKID")=:1

SELECT "CPID" FROM "T_SINASYN_CP" "C" WHERE :1="CPID"

SELECT /*+ FULL(P) +*/ * FROM "CON_NODEANDCONTENT" P

SELECT /*+ FULL(P) +*/ * FROM "T_SINASYN_CP" P

在第八套数据库上查看 dblink ，发现有 一下dblink ：

2BKSLINK_CMSTMPUSER_CMUREF"(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = XXXX)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = server1)

)

)"2016/1/20 19:30:23

寻找数据库中使用了该dblink的 sql ，找到了一下sql

left join bks_seriesandbook sab on sab.bookid = bex.bookid

left join bks_copyright_info r on r.bookid = bex.bookid

left join ptl_rank_visit_month@link_cms prvm on prvm.bookid = bex.bookid

left join t_book_score_stat bss on bss.bookid = bex.bookid

询问业务该sql 跑的是什么业务，确认是否可以kill