Rx 3660 with Oracle 10 g (273 Views)
Reply
Occasional Contributor
Rx 3660 with Oracle 10.
Posts: 4
Registered: ‎05-16-2007
Message 1 of 6 (273 Views)

Rx 3660 with Oracle 10 g

Someone have installed oracle 10g with windows 2003 for itanium on rx3660.
I have eva 4000 san storage but performance very slow of server and cpu often is at 60 %
Honored Contributor
rick jones
Posts: 3,814
Registered: ‎12-02-1996
Message 2 of 6 (273 Views)

Re: Rx 3660 with Oracle 10 g

Is it an rx3600 or an rx2660? There is no rx3660. I cannot claim to know much about Windows, but I would wonder how much of that CPU util is user versus OS etc etc.
there is no rest for the wicked yet the virtuous have no pillows
Occasional Contributor
Rx 3660 with Oracle 10.
Posts: 4
Registered: ‎05-16-2007
Message 3 of 6 (273 Views)

Re: Rx 3660 with Oracle 10 g

The server is rx3600 (AB596A)with 32 Gb of RAM, oracle is installed on eva 4000 with transfer rate of 100 Mb/s tested with i/o meter but the oracle query respond very slow, the cpu work at 60 % even if the query is very very simple e appears instable.
The o.s. installed is windows 2003 enterprise edition for itanium with service pack 2. The cpu of rx3600 is called "montecito" and they are itanium-2.
Oracle has installed patch for montecito cpu
but the system do not respond fast to query
Honored Contributor
rick jones
Posts: 3,814
Registered: ‎12-02-1996
Message 4 of 6 (273 Views)

Re: Rx 3660 with Oracle 10 g

With the caveat that I'm not a DB guy (I'm a networking guy) any idea how much I/O per query the DB is doing? Is it doing a lot of reads, suggesting (?) that the DB might want a larger SGA? Is the DB going to raw disc or is it going through the filesystem?
there is no rest for the wicked yet the virtuous have no pillows
Occasional Contributor
Rx 3660 with Oracle 10.
Posts: 4
Registered: ‎05-16-2007
Message 5 of 6 (273 Views)

Re: Rx 3660 with Oracle 10 g

The SGA is 10Gb and oracle use file system.
the problem is that the query executed on vraid5 and a vraid0 it comes at the same time executed, too much anomalous
With vraid5 the transfer rate of eva 4000 is 40 Mb/s while wirh vraid0 the transfer rate is 100 Mb/s but the query it comes at the same time executed
Occasional Visitor
TorE_5
Posts: 1
Registered: ‎05-18-2007
Message 6 of 6 (273 Views)

Re: Rx 3660 with Oracle 10 g

I would suggest, that you collect the Oracle statistics (statspack or AWR), and look at the top5 wait states, this should give you a good indication, of what the bottlenecks are.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.