MIME-Version: 1.0
References: <CAO8FHeWg_PZQEn3jh46OGD9DNMdWLkxCp8FJiAyDrJ_Vsw9TWg@mail.gmail.com>
 <CABpiuuRHmFyNbL5vcean3tDG+Vz=uHOU=ppjWtiAHKeEf=xYgg@mail.gmail.com>
In-Reply-To: <CABpiuuRHmFyNbL5vcean3tDG+Vz=uHOU=ppjWtiAHKeEf=xYgg@mail.gmail.com>
From: Sayan Malakshinov <xt.and.r@gmail.com>
Date: Wed, 17 Nov 2021 04:37:11 +0300
Message-ID: <CAOVevU4Q4Wiix9AxLhCwReD93EEyizN_soWOrPU+dH7SjDWBng@mail.gmail.com>
Subject: Re: OPEN CURSOR EXECEEDED
To: quanwenzhao@gmail.com
Cc: chrishna0007@gmail.com, Oracle L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="0000000000005e229805d0f21597"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: xt.and.r@gmail.com
--0000000000005e229805d0f21597
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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@gmail.com> wrote:

> Hello Krishnaprasad =F0=9F=98=8A,
>
> 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/acq=
uire_cocc.sql*
> <https://github.com/guestart/Oracle-SQL-Scripts/blob/master/awr_trend/acq=
uire_cocc.sql>
> .
>
> Best Regards
> Quanwen Zhao
>
> Krishnaprasad Yadav <chrishna0007@gmail.com> =E4=BA=8E2021=E5=B9=B411=E6=
=9C=8816=E6=97=A5=E5=91=A8=E4=BA=8C =E4=B8=8B=E5=8D=882:22=E5=86=99=E9=81=
=93=EF=BC=9A
>
>> 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 f=
rom
>> 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
>>
>

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

--0000000000005e229805d0f21597
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Just one note:=C2=A0 &quot;open_cursors&quot; parameter an=
d=C2=A0ORA-1000 are about &quot;per session&quot; statistics, while &#39;Cu=
rrent Open Cursors Count&#39; metric=C2=A0shows total number of open cursor=
s for a whole database instance.</div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Wed, Nov 17, 2021 at 3:33 AM Quanwen Zha=
o &lt;<a href=3D"mailto:quanwenzhao@gmail.com">quanwenzhao@gmail.com</a>&gt=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div di=
r=3D"ltr">Hello Krishnaprasad=C2=A0=F0=9F=98=8A,<div><br></div><div>I once =
wrote a similar SQL script for your requirement last month, here&#39;s the =
link -=C2=A0<a href=3D"https://github.com/guestart/Oracle-SQL-Scripts/blob/=
master/awr_trend/acquire_cocc.sql" target=3D"_blank"><b>https://github.com/=
guestart/Oracle-SQL-Scripts/blob/master/awr_trend/acquire_cocc.sql</b></a>.=
</div><div><br></div><div>Best Regards</div><div>Quanwen Zhao</div></div><b=
r><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">Krishnap=
rasad Yadav &lt;<a href=3D"mailto:chrishna0007@gmail.com" target=3D"_blank"=
>chrishna0007@gmail.com</a>&gt; =E4=BA=8E2021=E5=B9=B411=E6=9C=8816=E6=97=
=A5=E5=91=A8=E4=BA=8C =E4=B8=8B=E5=8D=882:22=E5=86=99=E9=81=93=EF=BC=9A<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi=
 Experts ,=C2=A0<div><br></div><div><br></div><div>Currently , we are facin=
g the issue of ORA-1000 open cursor limit exceeded , we are looking for any=
=C2=A0 historical value of max open cursor from the database . For current =
utilization we are fetching=C2=A0open_cursor count v$sessstat and v$statnam=
e .=C2=A0</div><div><br></div><div>Request if any inputs we can get on this=
 can be help full .=C2=A0</div><div><br></div><div>Regards,</div><div>Krish=
na=C2=A0</div></div>
</blockquote></div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>Best=
 regards,<br>Sayan Malakshinov</div><span style=3D"font-size:13.6px">Oracle=
 performance tuning engineer</span><br style=3D"font-size:13.6px"><div>Orac=
le ACE Associate<br><a href=3D"http://orasql.org" target=3D"_blank">http://=
orasql.org</a></div></div></div></div></div>

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