Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

60 sec. Delay at CALL "SQLBEX"

Status
Not open for further replies.
Kearns

Kearns

Programmer
Nov 28, 2002
10
CA
I have a problem with a cobol program that experiences a periodic 60 second slowdown while executing the following statement - CALL "SQLBEX" USING SQLCTX SQLEXD SQLFPN. Does anyone know what this statement does and why it would take 60 seconds to execute? It doesn't happen all the time. Most of the time it is executed in under a second and other times it can be 5, 10, 30 up to 60 seconds.

We have had an Oracle DBA look at the database and he does not see any problems. I am stumped.
 
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
697
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
636
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
289
Livia8
Livia8
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
283
Livia8
Livia8
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
208
carp
carp

Part and Inventory Search

Sponsor

Back
Top