Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle sometime sleeps?

Re: Oracle sometime sleeps?

From: frank.sara <frank.sara_at_infonie.fr>
Date: Thu, 1 Feb 2001 23:22:15 +0100
Message-ID: <981066797.224661@romulus.infonie.fr>

Maybe it's related to archiving. That is if you have a big archive log that gets writen every 10 minutes, it get extra load on the disk. Archiving on the same disk as your database is not a good idea.

  Good luck!
Oliver Schubert <OSchubert_at_timocom.de> a écrit dans le message : 3a7801bf$0$73973$45beb828_at_newscene.com...
> Hi sirs,
>
> i have a problem with my Oracle 8.0.1 Server on WinNT 4.0 SP6, 512 MB MEM,
> 80 GB HDD, 600 MHZ Athlon. Sometime (nearly every 10 Minutes) Oracle slow
> down so that some SQL's with normaly costs one or two seconds need 30 or
 40
> seconds to execute. The performance items are ok (i.e. 98% get &
> pin-hitratio...) and Oracle only uses 80 MB of memory. The tables are not
> very large (about 100 MB with 20.000 to 800.000 rows) but Oracle must
 serve
> about 5 to 10 million rows a hour to about 40 user, but the number of rows
> Oracle must return is from 100 to 100.000, maybe thats the problem?!
>
> Please help me,
>
> your OS
>
>
Received on Thu Feb 01 2001 - 16:22:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US