Oracle Database running slow on ZFS Solaris
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.