Home » Developer & Programmer » JDeveloper, Java & XML » Oracle REFCURSOR issue. Front end app is slow
Oracle REFCURSOR issue. Front end app is slow [message #623281] Sun, 07 September 2014 23:45 Go to next message
sekhar123
Messages: 1
Registered: September 2014
Junior Member
I have a JAVA front end data window screen which is calling 4 oracle stored procedures to retrieve data and populated the data in a graph. Each stored procedures has 1 OUT refcursor variable which will retrieve records to that front end screen to display the records . The front end application is taking total time of 10 secs to display the final data output. But when i execute each stored procedure in TOAD it was taking just 1 second total run time for all the 4 stored procedures. What will be the issue ?. Why the front end tasking much time to display the refcursor records. Is it something issue in the front end screen of retrieving those ref cursor records and displaying the data or some network issue between front end and oracle database server.
Re: Oracle REFCURSOR issue. Front end app is slow [message #623285 is a reply to message #623281] Mon, 08 September 2014 00:20 Go to previous message
Michel Cadot
Messages: 67950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Set the fetch size.
http://docs.oracle.com/cd/E11882_01/java.112/e16548/resltset.htm#JJDBC28622

Previous Topic: Reading the xml value
Next Topic: Unique error while running appliction
Goto Forum:
  


Current Time: Sat Sep 25 20:13:28 CDT 2021