Re: OPEN CURSOR EXECEEDED

  • From: Quanwen Zhao <quanwenzhao@xxxxxxxxx>
  • To: chrishna0007@xxxxxxxxx
  • Date: Wed, 17 Nov 2021 08:33:06 +0800

Hello Krishnaprasad 😊,

I once wrote a similar SQL script for your requirement last month, here's
the link -
*https://github.com/guestart/Oracle-SQL-Scripts/blob/master/awr_trend/acquire_cocc.sql*
<https://github.com/guestart/Oracle-SQL-Scripts/blob/master/awr_trend/acquire_cocc.sql>
.

Best Regards
Quanwen Zhao

Krishnaprasad Yadav <chrishna0007@xxxxxxxxx> 于2021年11月16日周二 下午2:22写道:

Hi Experts ,


Currently , we are facing the issue of ORA-1000 open cursor limit exceeded
, we are looking for any  historical value of max open cursor from the
database . For current utilization we are fetching open_cursor count
v$sessstat and v$statname .

Request if any inputs we can get on this can be help full .

Regards,
Krishna

Other related posts: