search for: zfs_and_databases

Hi All, We are currently in the process of testing Solaris 10 with ZFS and Oracle and are running it on a T2000. When checking performance statistics on the T2000, we notice that only one thread of the CPU appears to be doing any of the processing. Leaving all other threads seemingly idle. Are there any tuning parameters that need to be set or changed when running Oracle on T2000 using

if you have N processes reading the same file sequentially (where file size is much greater than physical memory) from the same starting position, should I expect that all N processes finish in the same time as if it were a single process? In other words, if you have one process that reads blocks from a file, is it "free" (meaning no additional total I/O cost) to have another process

Greetings, all. Does anyone have a good whitepaper or three on how ZFS uses memory and swap? I did some Googling, but found nothing that was useful. The reason I ask is that we have a small issue with some of our DBA''s. We have a server with 16GB of memory, and they are looking at moving over databases to it from a smaller system. The catch is that they are moving to 10g. Oracle