Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Fri Dec 05 2003 - 13:28:04 CST