oracle的连接数不断增加,无法自动释放的问题?
<?php
session_start();
include_once('config.inc.php');
$sqlstring="select name from t_user where id=1";
$rs = &$conn->Execute($sqlstring);
if ($rs)
{
$rs->Close();
}
$conn->close();
;?>
上面是一段简单的示例程序,运行前后我都用下面的sql查看会话数,结果多了一个会话数,没有释放掉,我再把网页关掉了,还是没有释放,在别的电脑上运行,又多一个会话数(运行环境是:php+apache+oracle817)我用是pconnect来连接oracle
问题是:1.如何才能做到释放,2.永久性链接的好处在哪儿
select A.SID,
B.SPID,
A.SERIAL#,
a.lockwait,
A.USERNAME,
A.OSUSER,
a.logon_time,
a.last_call_et / 3600 LAST_HOUR,
A.STATUS,
'orakill ' || sid || ' ' || spid HOST_COMMAND,
'alter system kill session ''' || A.sid || ',' || A.SERIAL# || '''' SQL_COMMAND
from v$session A, V$PROCESS B
where A.PADDR = B.ADDR AND SID > 6;