• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cursors and PreparedStatements

 
kg manuel
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys, i used the built-in google search to check if any previous posts might be relevant and found none so i am posting this question.

Our DBA is having troubles with having too many cursors with a specific sql. i am not authorized to post the exact sql. but here is a general idea.

initially, the table has 25+ fields all inserted using a PreparedStatement. statistically, this sql runs atleast 50-100 times a day.

within the database system, Oracle 10g to be specific, a trigger is created to fill the primary key field. this trigger is runned before the actual insert is runned.

now, i am already expecting the trigger as a source of the cursor population. i would like to ask if the PreparedStatement adds up that much as well.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4031
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good Oracle DBAs are hard to find...

Also, are you sure all connections/statements are being regularly closed or is it one particular transaction that is hurting performance?
 
kg manuel
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks scott for your time.

yes there is one statement not being closed properly. that one is already fixed. i would like to confirm however if the number of '?' in the PreparedStatement has something to do with it.

thanks again in advance.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic