Re: Solaris9 V880 and relatively slow disks

From: Artur Karazniewicz (artur.karazniewicz[N0SPAM)
Date: 11/02/04 

Date: Tue, 02 Nov 2004 18:21:37 +0100

swapemround wrote:

>
> The reason is very likely that the PC is much faster than the V880.
>
> What spec processor is the PC running?

PC is single 2.8MHZ linux box with IDE and regular disks - nothing special.
But don't think there is problem in processing power - rather in IO
throughput. I tested Oracle and encoutered problem during database import
which is - of course - very heavy when it comes to IO. I have 50% IO wait
on V880 and 70-80% processor idle. This is very strange - since Fibre
Channel should be *much* more faster (?) vs. IDE. Additionaly I have all
data (indexes, data, rollabck segments etc.) on one disk o my PC. On
Solaris I used OFA and indexes, datafiles, redologs are on different disks.
As far as I can tell - there is problem with IO - since my oracle does
nothing but copy data from dump to database and creates simple indexes
(regular not computional). This all is very strange. I suspect that I did
some mistake when configuring Solaris.

Artur

Relevant Pages

  • SUMMARY: V440 small DATABASE SERVER
    ... apprehensive about how few disks you're using. ... PICK variant database, so your mileage with my "advice" may vary. ... the App is tuned to not do crazy IO (queries tuned), ... We had a small extranet server running a fairly classic "3-tier" client ...
    (SunManagers)
  • Re: If you were developing a database in Forth...
    ... For disks, the problem just shifts to the ... querying the drive's controller to get a sense of the health of the ... It doesn't look like a database issue to me. ... But I guess if you record the verification ...
    (comp.lang.forth)
  • Re: S85 not quite right !!
    ... maximum pinable=80.0% of real memory minperm=5.0% of real memory ... resources - have been due to the wrong vmtune settings. ... that the default settings are NOT good for a database.) ... The disks do not perform that much work ...
    (AIX-L)
  • Re: Server choice.
    ... You didn't say what database you're running. ... Your 'Dell only' ... Disks: SATA ... The pricing is really close. ...
    (freebsd-hackers)
  • Re: management software suggestions?
    ... if i'm incorrect please direct me to a better usenet group. ... etc) and images of his products and clients ... a thumbnail database of the disks. ... he/she can add quite a bit of info in the database. ...
    (rec.video.desktop)