接到数据库报警:ORA-12516
查看数据库上相关连接:
INST_ID MACHINE USERNAME COUNT(*)
---------- ---------------------------------------------------------------- ------------------------------ ----------
2 xxxxxxxxx MREAD 900
1 aaa TMPUSER_CMUREF 616
1 xxxxxxxx- MREAD 235
aaa 是第八套数据库服务器主机名,怀疑是通过 dblink 连过来的,查看 TMPUSER_CMUREF 用户下的sql :
SELECT /*+ FULL(P) +*/ * FROM "PTL_RANK_VISIT_MONTH" P
SELECT "BOOKID","COUNT","COUNTORIGINAL" FROM "PTL_RANK_VISIT_MONTH" "PRVM&#