Re: OPEN CURSOR EXECEEDED

Just one note: "open_cursors" parameter and ORA-1000 are about "per session" statistics, while 'Current Open Cursors Count' metric shows total number of open cursors for a whole database instance.

On Wed, Nov 17, 2021 at 3:33 AM Quanwen Zhao <quanwenzhao_at_gmail.com> wrote:

> 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_at_gmail.com> 于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
>>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l