OraFAQ Forum: JDeveloper, Java & XML » Oracle REFCURSOR issue. Front end app is slow

Home » Developer & Programmer » JDeveloper, Java & XML » Oracle REFCURSOR issue. Front end app is slow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle REFCURSOR issue. Front end app is slow [message #623281]

Sun, 07 September 2014 23:45

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.

Report message to a moderator