Re: OPEN CURSOR EXECEEDED

Hi Sayan,

Thanks for the information,

We are facing issue of ora-01000 , we are trying to get infirmation about historical details , but i guess it wont be there as its session level stuff,

Does enabling error stack trace is giod option in production or it can cause overhead.

Additonally higher value of open_cursor can cause fragmentation in shared pool ?

Regards,
Krishna

On Wed, 17 Nov 2021, 07:07 Sayan Malakshinov, <xt.and.r_at_gmail.com> wrote:

> 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