Errors executing Oracle recursive query

Azim Fahmi

THSNet,Inc.

I'm frequently getting ORA-00604 combined with ORA-01000 (max cursor opens). However, when I checked the code, all the result set and statement objects are closed in the final block (I am using JDBC). The query I am executing is an Oracle recursive query (start with and connect by). Can you tell me what could be wrong and under what circumstances the above error occurs?
It could be that the open_cursors parameter is set to a very low number in init .ora file. The default for this is very low (50). It should be set to 200 or higher.

It could be that even if you are closing the result set you are not closing the SQL statements in your JAVA code.

3. Please ensure that your Enable Connection Pooling if set to yes (for performance reason), is set to no.

Please have your DBA monitor the database and ask to see entries using V$OPEN_CURSORS and V$SYSSTAT data dictionary views.

This was last published in March 2004

Sybase vs. Oracle: Users speak out

Related Q&A from Azim Fahmi

Concatenating a null character affecting performance

Read, process and write a text file to the database

ORA-01654 even though maxextents defined as unlimited

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

11 real-time data streaming roadblocks and how to overcome them

Experts detail common challenges that IT teams encounter when deploying and managing real-time data streaming platforms and offer...

Snowflake product VP expounds on data warehouse for the cloud

In this Q&A, Christian Kleinerman, vice president of product development at cloud data warehouse vendor Snowflake, talks about ...

RavenDB Cloud automates database management

RavenDB's managed cloud database service, RavenDB Cloud, intends to automate security processes, reduce overhead and cater to ...

SearchBusinessAnalytics

Updated AtScale platform streamlines analysis of big data

By improving the machine learning and augmented intelligence capabilities of its platform, AtScale's newest release attempts to ...

ThoughtSpot strategic partnerships help add capabilities

Through its partnership strategy, ThoughtSpot is adding to its capabilities as a BI software vendor the same way others are ...

IBM battling to change perception of Cognos Analytics BI platform

While some see IBM's BI suite as being too complicated and expensive for citizen data scientists, the company is adding updates ...

SearchSAP

As SaaS ERP, S/4HANA Cloud not meant to replicate ECC

In a Q&A, Jan Gilg, SAP's new global head of S/4HANA, joined SVP Sven Denecken to explain the differences between the on-premises...

SAP Leonardo technologies seek to empower the digital enterprise

Learn the fundamentals of Leonardo, how it has evolved over the years and key steps to using its advanced technologies to build a...

SAP PartnerEdge initiative offers free S/4HANA Cloud resources

SAP now offers free access to S/4HANA and C/4HANA test and demonstration systems to qualified partners. The new partner program ...

SearchSQLServer

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos ...

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database ...

TheServerSide.com

Weigh cost, flexibility in your Java cloud IDE comparisons

What's in a cloud IDE for Java developers? Flexibility and integration for starters. Consider these four options in your ...

What are the differences between EAR, JAR and WAR files?

JAR, WAR and EAR files provide options in a Java application deployment. Let's compare these file types and determine which one ...

4 great Java-based CMS options

Open source Java CMS tools come in a wide variety of shapes and sizes. Explore these four platforms to see if they would be a ...

SearchDataCenter

3 ways to benefit from open source infrastructure

Using open source infrastructure can reduce operating costs and streamline upgrades, but it's important to weigh the pros and ...

IBM mainframes face competitive pressures inside and out

IBM's mainframe business continues to be under pressure from cloud-based competitors, and perhaps even its own Power server. ...

Linux features beyond server management

Due to its open source nature, Linux is constantly gaining new capabilities. Here's a look at some common use cases and features.

SearchContentManagement

Alfresco cloud migration service moves content off premises

With new cloud migration services, Alfresco promises to move content from IBM, SharePoint, Documentum and other legacy ECM ...

Using AI in content creation can streamline publishing

Companies using AI in content creation can generate short-form material automatically, which frees up humans to handle more ...

New Contentful CMS targets content delivery for retailers

Contentful's content infrastructure is a CMS that intends to bring more flexibility and benefits than a traditional or headless ...

SearchHRSoftware

Eliminating bias in AI is no easy feat, but fixes do exist

As more companies turn to AI to reduce workplace and recruiting bias, it is important to be aware that the data AI tools draw ...

Immigrant visa reform poised to complicate hiring plans

Legislators plan to act on a bill that will remove per-country caps for immigrant workers, making it more difficult for companies...

Continuous performance management comes with benefits, drawbacks

Many companies are ditching yearly performance reviews in favor of continuous performance management. The new method has its ...

Dig Deeper on Using Oracle PL-SQL

Related Q&A from Azim Fahmi

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.