Hi All,
Is there a way to tune the zfs prefetch on a per pool basis? I have
a customer that is seeing slow performance on a pool the contains
multiple tablespaces from an Oracle database, looking at the LUNs
associated to that pool they are constantly at 80% -
Hello Tony,
If the hardware hasn't changed I'd look at the workload on the database
server. If the customer is taking regular statspack snapshots they might be
able to see whats causing the extra activity. They can use AWR or the
diagnostic pack, if they are licensed, to see the offending SQL or
I've also found this
http://developers.sun.com/solaris/docs/wp-oraclezfsconfig-0510_ds_ac2.pdf
On 9 December 2010 20:22, Jabbar aja...@gmail.com wrote:
Hello Tony,
If the hardware hasn't changed I'd look at the workload on the database
server. If the customer is taking regular statspack
Hi
I'd certainly look at the sql being run, examine the explain plan and in
particular SQL_TRACE, TIMED_STATISTICS, and TKPROF, these will really
highlight issues.
see following for autotrace which can generate explain plan etc.