OPEN CURSOR EXECEEDED

From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Tue, 16 Nov 2021 11:52:24 +0530
Message-ID: <CAO8FHeWg_PZQEn3jh46OGD9DNMdWLkxCp8FJiAyDrJ_Vsw9TWg_at_mail.gmail.com>

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

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

Received on Tue Nov 16 2021 - 07:22:24 CET

This message: [ Message body ]
Next message: Thomas Kellerer: "Installing 19c from scratch"
Previous message: Andy Sayer: "Re: Things to consider during upgrade/migration"
Next in thread: Quanwen Zhao: "Re: OPEN CURSOR EXECEEDED"
Reply: Quanwen Zhao: "Re: OPEN CURSOR EXECEEDED"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message