Lot of open Oracle statements

[Siva Ram]

Hi all,
I am accessing the Oracle procedure, dynamic sqls to fetch the data from the Oracle 8i database using JDBC for showing the data on the webpage.
From my Oracle Admin, I came to know that the following SQL is causing the problem. If any one has any idea for solving this proble it will be really helpful to me.
SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
Thanks & Regards,
Siva Ram

[Mark Spritzler]

Um, you didn't state what the problem is, just the query. What does the DBA says is the problem with the query. Is it taking a long time? Does it take up too much IO and slowing your production database down?
What does your DBA suggest, I don't think he would just say this is bad and not give you any suggestions.
Maybe you just keep the connection open and that is what he is complaining about. When you are down reading the data and don't need it anymore make sure you null out the ResultSets and Connections when they are no longer needed.
Mark