Displaying 1 result from an estimated 1 matches for "sqlldr".
Did you mean:
sqldf
2006 May 19
3
Oracle on ZFS vs. UFS
...on an old E3500 (4x400MHz, 2GB RAM) with
two A5200 attached (~15 still alive 9GB disks each).
The first results at home are not very promising for ZFS.
I measured:
. database creation
. catalog integration (catalog + catproc)
. tablespace creation
. loading data into the database from dbgen with sqlldr
I can provide all the scripts (and precompiled binaries for qgen and dbgen
(SPARC + x86) if anyone wants to verify my tests.
In most of these tests UFS was considerable faster than ZFS. I tested
. ZFS with default options
. ZFS with compression enabled
. ZFS without checksums
. UFS (newfs: -f 81...