Our forum is the right place for exchanging infos, searching for help or helping others. Meanwhile there are many thousand posts, so please use our 'Search' function if you are looking for a special topic.

Because the forum is used more often for unauthorized advertising, we have decided to close it for new posts.

Who still wants to browse the old posts can do this with pleasure.

Start Up

Unclear oracle problem with getting response of query

RSS (Opens New Window)

james mason

Rank: Youngling

Posts: 1

Join Date: 8/29/18

Recent Posts

Unclear oracle problem with getting response of query

8/29/18 11:16 AM

The problem is very unclear,

I have an application server, that constructs queries and sends it to Oracle to get response.

The Oracle database is installed on a high perfomance server:
Linux 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

The application server was tested on different locations inside of the intranet, including that high perfomance server, where the database is located.

Several versions of the application server (from old to newest) were tested also.

The problem:

When the application server sends a query to the oracle apps dba, it has to wait for about 300 seconds to get response and construct logged output.

But when I'm connecting to the database with PL/SQL Developer and running that query using that IDE, I'm getting a response in less than one second.

Is there something familiar for you, guys?

We're just cracked our heads trying to determine where the problem could be located.

If you need more information - I'll update this post immediately.

0 (0 Votes)

Flag

Recent Bloggers Recent Bloggers

trust7 Posts: 39 Stars: 39 Date: 3/9/19
VAK Posts: 51 Stars: 124 Date: 2/25/18
trust 7 Posts: 2 Stars: 3 Date: 1/22/18
Ame Elliott Posts: 2 Stars: 2 Date: 10/21/17
Katja Ponert Posts: 2 Stars: 3 Date: 11/10/16
Rebecca Müller Posts: 1 Stars: 2 Date: 9/27/16
Andreas von der Heydt Posts: 4 Stars: 3 Date: 10/20/14

ZAV Pre-Approval / Vorabprüfung By trust7, On 3/9/19 2:33 PM

Einwanderungsgesetz By trust7, On 8/31/18 12:13 PM