Oracle sometime sleeps?

From: Oliver Schubert <OSchubert_at_timocom.de>
Date: 31 Jan 2001 06:23:23 -0600
Message-ID: <3a7801bf$0$73973$45beb828@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 Wed Jan 31 2001 - 06:23:23 CST