Hi Paul

thanks your reply.

I created the database from scratch and then imported all the data using oracle import.

All the hit ratio are very good

Library Cache Data Dictionary Cache Buffer Cache Hit Ratio
99.92 99.57 80.64
99.91 99.56 80.21

A simple querty (select code,sum(1) from customers ....)

taking 3 time more time on the new server.

Is there any parameter required for ZFS for improve performance.