Oracle Database running slow on ZFS Solaris
We recently moved our oracle database (ver 18.104.22.168, 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.
Could someone, please advise where else to look at.