Mark Stewart wrote:
>
> We're thinking about getting Oracle to our 3000, but we would like to
> hear what others have done and how it works and the cost of buying!
> Hope to hear from someone
> -Mark
Mark,
Steve asked a question you may have missed. Perhaps he knows the cost?
Steve Donnelly wrote:
>
> Greetings HP3000 listers,
>
> Our company is evaluating the MPE version of Oracle. Are there users on
> this list who are currently running Oracle on MPE that could share their
> experiences and observations? I am primarily concerned with Oracle's
> performance and reliability when it is used with a fairly large database
> (20 GB database and growing).
Oracle has been developing and pushing client/server versions of their
databases. I would be sure you know how long Oracle plans on supporting
the database and whether they will force you to shift hardware architectures
in the future. I am not aware of any reliability problems, but Oracle sure
is a memory hog. With new versions of Oracle, allocate 5-8-MB per user.
Gary Adams
Strategic Solutions
703-525-7557
---------------------------------
Steve:
I have heard rumors that Oracle had planned to stop supporting new releases
of Oracle on the MPE/iX platform. If this is so, you may eventually run
into software compatibility and support issues. I would check with Oracle
to verify the current release that is available for the HP3000. I believe
that the current release on MPE/iX is 7.2.3 while you can get 7.3 on HP-UX
and NT.
Mark Redwood
--------------------------------
Mark is correct that the current version for Oracle on the 3k is 7.2.3 and
7.3 is available on UX and NT today. 7.3 is being ported to the 3k now,
and should be available soon. I'm sure your asking "what is soon?" and I
actually don't know. However, if you are interested I can find this out
from the CSY Oracle contact (Jennie, you may actually be monitoring the
list and can just add the information).
___
/ / Larry Boyd: Horizontal Growth Solution Manager
HEWLETT/hp/PACKARD Commercial Systems Division (CSY)
/__/ [log in to unmask] (408)447-4127
-----------------------------------
We have Oracle on our HP987/150, 10 gb database. We access the database
through SQLNET using Powerbuilder as the front end. Here are my
observations :
1. It takes a great deal more horsepower to handle Oracle than
Turboimage/SQL or Allbase.
2. You will need to max out your memory configuration (ours is 768) - it
will need it. Oracle is not fast at retreiving data from the database
(relative to Turboimage), you want as much in memory as possible.
3. We are using the fast and wide scsi drives - you will need the bandwidth
and speed.
4. Performance is very good with all these things in place and with good
SQL programmers.
We have found that just by adding an outer-join to an SQL process the run
time can go from 30 seconds to 45 minutes.
5. If you are not using Oracle in client server mode (your users sign on to
the HP then access Oracle) then you will not see the following problems.
The Oracle listener spawns system processes for each remote user (Oracle
7.1.6). Since they are system processes, their priority is linear, ie
they are never decremented when they exceed their quantum. This means
that, since they default to the CS queue, a large query or run-away process
can monopolize the system and cause you to have to shut down and reboot.
The listener process is expected to be changed to a batch process spawning
normal non-system processes in 7.3, so this problem should be fixed. We
retuned our queues to circumvent this problem for now.
6. Dead Connection Detection (DCD) does not work correctly as of yet. This
kills off orphaned processes when a user does a hard disconnect, such as
rebooting the pc. This typically throws the process into a cpu loop and
brings the system to its knees. This problem also exists on the Unix
platform, so you can't get away from this in client server mode.
7. Oracle support. He is very good. So far, though, I have found only one
proficient with the HP3000 in the US.
Joe Smith
----------------
Hope this refresher helps,
Gary Adams
Strategic Solutions
703-525-7557
|
