Damian,
Are you using compression=on? There was a bug in the past (fixed
now) where if compression was turned on, it was being computed by a
single thread. The ZFS team fixed the "user data" part of it (i.e
user data is compressed in parallel now), but the meta data part
is still compressed by one
On Sun, Aug 19, 2007 at 09:32:02AM +0200, Louwtjie Burger wrote:
> http://blogs.sun.com/realneel/entry/zfs_and_databases
>
> http://www.sun.com/servers/coolthreads/tnb/parameters.jsp
>
> http://www.sun.com/servers/coolthreads/tnb/applications_oracle.jsp
>
> Be careful with long running single qu
http://blogs.sun.com/realneel/entry/zfs_and_databases
http://www.sun.com/servers/coolthreads/tnb/parameters.jsp
http://www.sun.com/servers/coolthreads/tnb/applications_oracle.jsp
Be careful with long running single queries... you want to throw lots
of users at it ... or parallelize as much as p
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.
A