Re: OS Paging/performance question
- From: Jared Still <jkstill@xxxxxxxxx>
- To: esimmonds@xxxxxxxxxxxxx
- Date: Tue, 21 Sep 2004 11:20:53 -0700
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
