This begins a series of blog posts on the subject of technical sessions that EMC presented at OOW2011. To begin with, we will examine the session that I co-presented with Kevin Jernigan entitled Clone Oracle Databases Online in Seconds with Oracle Clonedb and DirectNFS. The presentation for this session can be found here.
It may sound strange given EMC's reputation and history, but EMC has a strong partnership with Oracle in the area of NAS. We began working with Oracle on the Direct NFS client ("dNFS") way back in 2007, when dNFS was introduced as a major new feature in Oracle Database 11g Release 1. At that time, EMC, was a co-presenter (together with Oracle) at Oracle OpenWorld 2007 on this subject.
The goals of dNFS were simple, and well defined:
- Improve performance (in terms of latency and throughput) of NFS-mounted Oracle database I/O
- Reduce CPU cost of NFS-mounted Oracle database I/O
- Improve network port scalability and failover of NFS-mounted Oracle database I/O
- Simplify administration of NFS in terms of both network port scaling and mount point parameters
- Make administration of NFS uniform across all platforms
Notice the perfectly clean scaling of this performance chart. We then tested the performance of creating a snapshot to serve as the source for the clonedb database. This produced:
Note that there was no performance hit during clonedb creation at all. One additional test was performed. We measured the storage space occupied by the clonedb when it was created. A 10 TB database was used as the source. The total space occupied by the clonedb was only 7 MB.
See the link above for the full presentation of this technical session. Further blog posts in this series will contain summaries of other EMC technical sessions at OOW 2011.