php oracle 释放资源,大量空闲session 不释放

最新推荐文章于 2021-04-15 19:18:27 发布
最新推荐文章于 2021-04-15 19:18:27 发布
阅读量110 收藏
点赞数
文章标签： php oracle 释放资源

SQL> select count(*),status from v$session group by status;

COUNT(*) STATUS

---------- --------

16 ACTIVE

465 INACTIVE

1 KILLED

SQL>

SQL>

SQL>

SQL> select event from v$session_wait;

EVENT

----------------------------------------------------------------

null event

null event

null event

pmon timer

rdbms ipc message

rdbms ipc message

rdbms ipc message

rdbms ipc message

rdbms ipc message

rdbms ipc message

rdbms ipc message

smon timer

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

EVENT

----------------------------------------------------------------

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

SQL*Net message from client

wakeup time manager

482 rows selected

SQL>

共享访问模式，如此是否造成server 进程也不释放从而导致整个系统反应迟缓 CPU过高？

Iefex
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle数据库进程不释放,核心数据库网络中断之后，清理不释放资源的session
weixin_30239869的博客
04-14 1062
昨天机房搞网络灾备切换演练，核心数据库在网络中断恢复之后，session数量突然增高，一般数据库的sessoin在475左右，突然接近600个会话，因为网络中断之后，会话没有及时释放资源，导致会话数量居高不下，下面是解决过程：(注：因为昨天在处理的的时候，来不及整理现场操作的资料，现在虚拟机上实验证明一下，思路是一样的)1.测试用户xiangyang,开启4个会话连接数据库(真实环境一般是用JDB...
ORACLE 如何查询被锁定表及如何解锁释放session
09-10
Oracle提供了`ALTER SYSTEM KILL SESSION`命令来强制结束一个session，解除其对资源的锁定。使用该命令时，需要提供session的sid和serial#，例如： ```sql ALTER system kill session '23, 1647'; ``` 在这个例子中...
php oracle 释放资源,Oracle 释放flash recovery area的四种方法
weixin_39565390的博客
04-07 62
早上收到一台Linux服务器磁盘告警邮件以及监控告警日志程序发来的邮件。检查过后，发现Linux服务器中一个分区没有空间了。主要原早上收到一台Linux服务器磁盘告警邮件以及监控告警日志程序发来的邮件。检查过后，发现Linux服务器中一个分区没有空间了。主要原因是由于昨晚程序员做升级时，产生了大量的归档日志，导致联机重做日志无法归档，出现下面错误：363 | Wed Mar 19 02:33:16...
oracle会话太多慢,系统突然变慢，session越来越多，查询无法释放
weixin_42315966的博客
04-15 438
系统突然变慢，用topas发现几十个oracle进程瓜分了所有CPU资源。跟踪session正在处理的SQL发现都是一些查询统计语句，平时也会有这么多查询的，但今天却出问题了。分析了几条SQL，有些计划比较理想，但有些明显没有进行过优化的。系统是AIX4.3+oracle9.2.0.4查询等待行出下面的SQL> select sid,event from v$session_wait;SID...
oracle session慢,系统突然变慢，session越来越多，查询无法释放
weixin_39794385的博客
04-11 266
系统突然变慢，用topas发现几十个oracle进程瓜分了所有CPU资源。跟踪session正在处理的SQL发现都是一些查询统计语句，平时也会有这么多查询的，但今天却出问题了。分析了几条SQL，有些计划比较理想，但有些明显没有进行过优化的。系统是AIX4.3+oracle9.2.0.4查询等待行出下面的SQL> select sid,event from v$session_wait;SID...
oracle连接数增加无法释放,Oracle连接数过多释放机制
weixin_42356284的博客
04-08 2426
在开发时，调试程序需要不断的连接数据库，这时到时Oracle服务器连接数过多会当掉，把连接数过多的客户机网线拔出后，在远程Oracle上依然还会保留此用户的连接数，久久不能释放，上网查了下可以以下面方法解决。通过profile可以对用户会话进行一定的限制，比如IDLE时间。将IDLE超过一定时间的会话断开，可以减少数据库端的会话数量，减少资源耗用。使用这些资源限制特性，需要设置resource_l...
oracle查看session状态
03-28
自己整理的关于oracle session的状态查看，对新手有一定的帮助，希望您喜欢。
对于oracle对session进行跟踪的分析
09-09
在Oracle数据库管理中，对session进行跟踪是一项关键的性能监控和问题排查技术。session跟踪允许DBA（数据库管理员）深入洞察数据库中各个会话的行为，包括SQL语句的执行情况，资源消耗，以及可能存在的性能瓶颈。...
Oracle释放临时表空间脚本
12-23
Oracle释放临时表空间脚本
Weblogic多应用部署在一个域下导致session冲突
weixin_33873846的博客
03-28 160
Weblogic多应用部署在一个域下导致session冲突问题解决办法 最近在Weblogic的一个域下面同时部署了多个应用，出现了session冲突的问题。其现象是这样的，访问A正常，但是从应用A跳转到应用B后，应用A的session立马就失效了。因为以前在tomcat上也遇到过类似的情况，当时立马就想到应该是session...
oracle设置会话释放,oracle 中dblink的session不能自动释放
weixin_26749843的博客
04-02 808
Oracle跨数据库连接dblink的session不能自动释放。环境: 远数据库A 目标数据库B目的:在B上建立dblink 连接到A,在B中创建视图,查询A的数据.问题: 由于B上的应用程序有很多用户在查询,造成dblink的session很多,而且一直无法释放.想到的解决办法:将B的视图改为接查询B自己的视图和表也是很多session不释放吗？还是只是dblink过来的session不释放...
weblogic weblogic.servlet.internal.session.MemorySessionData对象过多导致内存溢出
关注系统性能调优
05-20 4463
用MAT分析DUMP文件，可以发现weblogic.servlet.internal.session.MemorySessionData过多，  SELECT * FROM weblogic.servlet.internal.session.MemorySessionData 对象有120万之多，占用900M的内存。      300000 To look f
oracle用户进程不释放,oracle中止进程导致系统HANG住
weixin_35997133的博客
04-02 337
以前在11g上碰到过一次类似的情况，由于ALTER SYSTEM KILL SESSION导致资源被完全占用，在一段时间内数据库处于HANG住状态。这次又碰到类似的问题。简单描述一下问题产生的环境，用户在进行测试，在很短的时间内连续启动了多个应用服务器，导致大量的并发进程同时连接到数据库中，致使数据库服务器CPU利用率一下冲到100%。由于数据库的这种状态，用户决定中止一些进程来释放服务器上的资源...
weblogic集群session保持的问题
evilcry2012的专栏
06-04 1368
weblogic集群session保持的问题 收藏人：深呼吸 2007-06-06 | 阅：4205  转：3    |   来源   |  分享    
oracle中一个会话,一个Oracle会话严重阻塞的案例
weixin_34809884的博客
04-09 298
环境：os rhel 5.3dbms三节点Oracle 10g racver10.2.0.4现象：某些工作站死机或网络异常后，特定的收费人员在ZLHIS中收费时，点击确定后，程序无响应．将会话kill后，重新登录ZLHIS,再次收费现象依旧．无论普通病人，还是医保病人都是同样现象．1-2小时后，ZLHIS自动恢复正常．分析与解决过程：1.分析会话的状态：通过查询找出会话的等待事件：SQL&...
oracle查询不释放连接,使用ODP连接ORACLE时,连接不释放
weixin_42134537的博客
04-03 575
使用ODP连接ORACLE时,连接不释放数据库客户端连不上了(打印的信息忘记了),在网上找说的是process量超过了系统设置的数量,赶紧连上去服务器,用系统认证来进入ORACLE,show parameter process;得出的结果是150的,怎么会超过呢,这么大, 然后查看现在已连接上去的process的个数;select count(*) from v$process;发现有145个. ...
oracle僵死会话锁住buffer，导致数据库hang住
coujiongyong0208的博客
01-07 216
1、问题描述 今天早上，现数据库有点异常，通过hanganalyze分析，使用hanganalyze请参阅《数据库hang住，分析处理》，发现2172这个会话产生了enqueue阻塞，，导到程序运行非...
Oracle数据库的锁
看上去很美
11-25 1509
概念基础 数据库是一个多用户使用的共享资源。当多个用户并发地存取数据时，在数据库中就会产生多个事务同时存取同一数据的情况。若对并发操作不加控制就可能会读取和存储不正确的数据，破坏数据库的一致性。加锁是实现数据库并发控制的一个非常重要的技术。当事务在对某个数据对象进行操作前，先向系统发出请求，对其加锁。加锁后事务就对该数据对象有了一定的控制，在该事务释放锁之前，其他的事务不能对此数据对象
Oracle shared pool 不释放
最新发布
05-27
Oracle shared pool 是一个内存区域，用于存储共享的 SQL 和 PL/SQL 代码，以及共享的数据字典信息。如果 shared pool 不释放，可能会导致内存不足，从而影响数据库的性能。 有几种可能的原因导致 shared pool 不...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值