Re: OPEN CURSOR EXECEEDED
Date: Wed, 17 Nov 2021 08:33:06 +0800
Message-ID: <CABpiuuRHmFyNbL5vcean3tDG+Vz=uHOU=ppjWtiAHKeEf=xYgg_at_mail.gmail.com>
Hello Krishnaprasad 😊,
I once wrote a similar SQL script for your requirement last month, here's
the link -
Best Regards
Krishnaprasad Yadav <chrishna0007_at_gmail.com> 于2021年11月16日周二 下午2:22写道:
> Hi Experts ,
*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>
.
Quanwen Zhao
>
>
> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 17 2021 - 01:33:06 CET