Wednesday, October 17, 2018

opidcl aborting process unknown ospid (xxxx) as a result of ORA-1000


By looking the error message we can easily find out the issue

01000, 00000, "maximum open cursors exceeded"

Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.

First you need to work with application team and find out why the cursors are not closing.

If required you can increase the OPEN_CURSORS value by running below command.
ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;

Note that to increase the value of OPEN_CURSORS no downtime required, but cursor storing require more memory.


Regards
Satishbabu Gunukula
htt://oracleracexpert.com

6 comments:

  1. Buy top High Authority niche related blog commenting services for your websites, just let us know what Website URL, the Keywords, and a Short description to increase your website SEO.

    if you want more just look here "Blog"

    ReplyDelete
  2. اكبر وافضل واقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية وتقدم ايضا شركه غسيل خزانات بجده افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما اطول فترة زمنية ممكنة

    ReplyDelete
  3. Bihar Class 11 Model Question Paper 2023 PDF will be Updated Soon on the Official Website. Bihar Question Paper 2023 Class 11 Arts, Science, Commerce Group Details are Given on this Page. BSEB Inter First Bihar 11th Question Paper 2023 Year Physics, Math, English, History, Biology, Political Science, Economics, Business Studies, Physics, Chemistry, Urdu, Maithili, Sanskrit, Persian etc,

    ReplyDelete