Re: OS Paging/performance question

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 21 Sep 2004 11:20:53 -0700
Message-ID: <bf4638040921112025352018@mail.gmail.com>

> 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

Received on Tue Sep 21 2004 - 13:18:04 CDT