| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: I have a clarification
THANKS Kevin,
Yeah, I read those papers but I wanted a real life "testimonial" like you gave to make sure there wasn't any WAFL waffling.
Steve
-----Original Message-----
Sent: Wednesday, July 11, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Steve;
We use netapp filers at our current location. I really like them myself.
>From a backup point of view, we only take our databases down for about 5
minutes each night and still get a full cold backup.
On the netapp you just stop the DB, make a new snapshot, and then restart the DB. At this point, you can backup the snapshot and logs. This is truely a full copy of the database. If anything happens, and it has in the past, you restore from the snapshot, apply the logs, and you are back.
I can not give you direct performance numbers. But, so far, our 37 instances are running find from an IO point of view. We do not see any IO performance hits out of the ordinary.
Their WAFL technology does appear to work well with the database.
Have you had a chance to read thru their TECHNICAL LIBRARY online ??
http://www.netapp.com/tech_library/index_db.html#O
This brings you to their papers on Oracle.
Kevin
-----Original Message-----
Sent: Wednesday, July 11, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Hi Gaja (AKA "oraperfman"),
Why search google when I can just ask you? :-)
We had some NetApp sales drones here last week and they made tremendous claims about their performance with Oracle. The sales engineer claims to have been an Oracle DBA for a few years and he made a compelling case but I haven't been able to get any performance feedback from current DBA's with NetApp filers in production. Do you have anything you can share as regards Oracle I/O performance on NetApp Filers which are a RAID4 implementation?
BTW, got your book... great job!! You make mention of NetApp and RAID4 in your book. You say RAID4 is like RAID3 (except it's block level parity) so I assume it performs like RAID3 which you state is better for DSS but not as good for OLTP. NetApp claims to have overcome RAID4 performance issues with their wafl architecture. Any feedback on this?
Waiting for your next book,
Steve Orr
-----Original Message-----
Sent: Wednesday, July 11, 2001 7:22 AM
To: Multiple recipients of list ORACLE-L
Peter & list,
NFS 2.0 and up is TCP-based and hence has the required reliability to support "acks and error checking" of network I/O calls. Having said that the only vendor that I am aware of where NFS-mounted filesystems is "certified by Oracle" for an Oracle database is Network Appliance. In the case of NetApp. because it is a NAS (Network Attached Storage) device and the filesystem is maintained and supported on the Filer rather than on the "host". In a very simplistic sense, the host has a pointer to the NAS device on which the filesystem is maintained. For more information on NAS or anything else I urge you to search on www.google.com.
And yes, you can hookup the NetApp. Filer to a Sun Solaris box for sure. Don't know about Linux, but you can check NetApp's website to verify that.
Cheers,
Gaja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: sorr_at_rightnow.com
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).
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 Wed Jul 11 2001 - 11:42:26 CDT
 |
 |