Hi.,
I am using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi

We have a package in production which has suddenly started consuming greater than normal time to execute. On debugging this further, we found the following:
The package takes 5 mins to come out.
The queries inside the package, if run seperately, come out in milliseconds in total.

On looking through the sql trace when the package was run, it was found that an insert on a global Temp table is consuming around 5 mins (elapsed...

Hi ,

Do any one have solution to this problem ?

I am using a display tag for pagination in my JSP page. I have a checkbox field as one of the columns. I am using displayTagWrapp er class to display my checkboxes. I have a submit button in a page which will save checkbox status into the database. I also have pagination and sorting in the page.

The problem i have is, i will loose the status of the checkbox...