Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle on Procom
Bill - No experience with Procom, but a little experience with a similar
unit. We use it on a test system. I would definitely try to get the faster
network connection if you can. My experience is that the device can work
fine, but you need to be cautious of doing tasks that require a lot of
network bandwidth. For example, building multiple Oracle indexes
simultaneously seemed to go incredibly slow. Now, I copy the table to real
disk when I can, and build one index at a time. Much better. Assuming this
is the bottleneck, then a faster connection will probably make you happier
with your purchase.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, December 17, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
Hello,
We are looking at buying a Procom NetForce box (a
Network Attached Storage solution) for
running a medium-sized (500GB) Oracle data warehouse
(currently, 8.1.6 on Solaris 2.7). I would appreciate
any comments regarding Procom NetForce from anyone with
experience, pro or con. I found several messages regarding
network appliances in the archives, but none about Procom.
I have some specific questions:
1) Do Procom's checkpoints integrate in any way with Oracle
backup and recovery, or are they useless if Oracle needs
to stay up 24x7?
2) How well does their java-based administration GUI work? Are
there any system adminstration tasks not included in this tool? 3) Are there any helpful Procom utilities for fast Oracle data transfer
among different Oracle instances sharing the same Procom box, or do
you still need to use an Oracle-based solution (replication,
transportable tablespaces, etc)?
4) Is a gigabit ethernet connection between the Oracle server and
Procomm box essential? Any performance measures? 5) Is it best to install Oracle_Home, redo logs, system and rollback
tablespaces, and control files on the local Oracle server, and use the Procom box for all other index and data tablespaces?
Any other advice or comments is appreciated.
Thanks to any responders.
Bill Becker - Marshfield Clinic - beckerb_at_mfldclin.edu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Becker
INET: beckerb_at_mfldclin.edu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 17 2001 - 14:04:28 CST