I am facing problem in troubleshooting the unacceptably slow response of a java code, while fetching data from Oracle database. When tried to retrieve the same amount of records ( through the same query which was used earlier), from a custom console code, the response was tolerably fast. I wonder if anybody around will view these lines and respond with a positive, creative and yielding solution.
These are the details of my Application configuration:
Original code is in java, with EJB concepts implemented.
Server is hosted by weblogic 8.0. webserver.
Database is oracle, residing locally.
Client is a browser, access to the application is through HTTP protocol.
Action is a harmless select query, to get data from a single table containing one lakh records.
When requested, the browser falls into a swoon, and after an unspecified or random time period, the weblogic server vomits an exception out alognwith a chain of stack, which essentially says that the Servelet could not forward the response, which was already forwarded.
Hope you are using JDBC Type IV driver( Oracle Thin driver ).
try to use Oracle SQL Hints like /*+ALL_ROWS */ , /*+FIRST_ROWS*/,
Thank you. I will experiment this proposal, and post the result in this column.
As you assumed, I am using oracle thin driver for the database access.
I am really not able to follow what you mean by Oracle Hints. Are they some directives to the SQL engine? You mean to modify the SQL sentence to get fast results? I am fetching all columns in the table. So can I use "select ALL_ROWS from SORTPACKAGELOGDATA"?
I don't really require indexing I guess, sicne there is no other tables involved.