Ask the Expert

Network Appliance's claim

I understand that Network Appliance has claimed that Oracle Dbase works better on a filer than a raw partition or even UFS, is this true?

I have been under the impression that Dbases work better on direct attached drives or even in a SAN.


    Requires Free Membership to View

I would personally verify that claim. IP based communication overhead introduces latency into the communication process. This is why even backup over a SAN is MUCH faster than over IP. There is no traversing an IP stack for communication and the Fibre Channel protocol latency is negligible. I would pit my 100MB connection to my Fibre disks against anyone's 100Mb IP connection to a filer anyday. Block based storageI/O is much more efficient than frame based File I/O. This is especially true in Oracle data mining applications. Raw throughput is needed here, and the SCSI protocol is more suited to this than IP. This is why the iSCSI folks are creating TOE (TCP/IP stack offload engines) in HARDWARE, so the stack is less in the way.

I would have liked to see the CPU utilization on the performance test they did. My bet is it was MUCH higher than when tested against a Fibre storage solution.


This was first published in June 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: