Re: DB server has a rest cyclically

On Fri, 5 Dec 2003 16:34:01 +0900, "Ko mi jung" <gorgeous_at_ccs.sogang.ac.kr> wrote:

>We are very curious about the reason that DB server doesn't service
>continuously.

I'm quite confident the DB server DOES function continously. The problem is however your application seems to be unscalable as you are hitting one single table continously. At the least this table will need to be extended over and over and over again, which is a problem if the particular table isn't in a LMT. A corollary problem is that you likely haven't set up sufficient freelists for that particular allowing multiple transactions hitting it at the same time. I would also assume you don't need this table at all, becausre in Oracle you don't need temp tables.
First of all you need to set up a *proper* analysis and determine what the server is waiting for by v$waitstat, v$system_events, v$session_events, and v$session_waits.
Then you'll need to drill down, probably to conclude the application has to be rewritten.

--
Sybrand Bakker, Senior Oracle DBA