Hi All,

We recently moved our oracle database (ver 9.2.0.8, Solaris 9, UFS ) to a new T5120 Sun Server.

Since moving to ZFS oracle queries are running very slow (almost 50% slow).

I have tried to change a oracle parameters but still no improvement.

I have created 8K files system for oracle database files and indexes as described on a forum.

The query is (a simple select ) taking very long time.

Timing:

real 2m20.192s
user 1m52.123s
sys 0m22.978s


Could someone, please advise where else to look at.