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

来源：互联网发布：自动关注软件下载编辑：程序博客网时间：2024/04/30 03:48

接到数据库报警：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" PSELECT "BOOKID","COUNT","COUNTORIGINAL" FROM "PTL_RANK_VISIT_MONTH" "PRVM" WHERE TO_NUMBER("BOOKID")=:1SELECT "CPID" FROM "T_SINASYN_CP" "C" WHERE :1="CPID"SELECT /*+ FULL(P) +*/ * FROM "CON_NODEANDCONTENT" PSELECT /*+ 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

阅读全文

0 0