Process hanging

[dklloyd]

Hope you can answer this...
Our application (written by a 3rd party) runs a stats build which deals with a huge number of records and as this is the 1st build it includes everything from day one.
The problem is that during the INSERT into a table the process appears to just stop. Its status is ACTIVE but the reads, gets & changes stay static (for days if we leave it). I suspect (either wrongly or rightly!) that there must be a resource or space issue, but I don't understad why the job doesn't fail. We don't use archive logging, just three redo logs that circulate (although too often for my liking).
Any ideas anyone?

Cheers

dklloyd

 

[carp]

Is it possible that the program has just entered an infinite loop?

 

[karluk]

Have you checked with the vendor of the application? What do they say? Are there any other customers with similar problems?

 

[dklloyd]

Thanks for both the replies...
I ran the program again over the weekend and monitored its resources. The most likely cause was insufficient rollback segments. I brought more on-line and increased the number and the program ran through okay. In all it used 710Mb of Rollback, which for a relatively small system was a bit too much!

Thanks again.