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 ：

2	BKS	LINK_CMS	TMPUSER_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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!