Re: OS Paging/performance question

> I've done virus-scanning, adware checks, etc.
> 
> Any other advice?
> 

Pick a job that is running too slowly, and run 10046 trace on it.

There are several tools available to analyze it, starting with tkprof.

tkprof may provide you with enough ( more or less accurate ) information
to pinpoint the problem, if the problem is slowly executing SQL.

There are other pieces of information in the trace file as well.

Try hotsos.com, ubtools.com and/or oraperf.com for detailed analysis
of the file(s).

HTH

Jared
--
http://www.freelists.org/webpage/oracle-l

Other related posts: