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.
http://download.oracle.com/docs/cd/B10500_01/server.920/a96533/a
I've also found this
http://developers.sun.com/solaris/docs/wp-oraclezfsconfig-0510_ds_ac2.pdf
On 9 December 2010 20:22, Jabbar 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 snapshots they mi
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 P
