请问为什么Oracle监听后会有大量的等待连接?
下面是刚刚重启后运行netstat的结果,摘录了其中与1521端口有关的部分
TCP tky-026e3e945e8:1055 localhost:1521 ESTABLISHED
TCP tky-026e3e945e8:1057 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1060 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1061 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1062 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1063 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1064 localhost:1158 TIME_WAIT
TCP tky-026e3e945e8:1065 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1066 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1068 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1069 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1070 localhost:1521 TIME_WAIT
TCP tky-026e3e945e8:1071 localhost:1521
相关问答:
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
oracle not available
shared memory realm does not exist
请问高手这个问题如何解决?
http://www.inthirties.com/thread-109-2-1.html
指定下ORACLE_SID,ORACLE_HOME看看,不行就用1楼得方法了..
cm ......
在lomboz eclipse中的window->show view->others->中的怎样加入connectivity中的data source中连接oracle时只有8,9,10这三个版本,怎样才能连接oracle11这个版本呢??????????????
......
现在有二张表,表一和表二
使用 plsqldeveloper
表一大概有15个字段,约 140 万行记录,使用 count(1) 时执行了37秒,使用 count(*) 执行时间也在37秒
表二大概有7,8个字段,约 500 万行记录, ......