go to metalink and check out trace analyzer. ITs a new tool for analyzing 10046 traces. Has ALOT more detail than tkprof. Major improvement. Its on metalink. > > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > Date: 2003/10/08 Wed AM 09:14:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: RE: Cary's Book - new topic > > Cary, > > We are doing exactly that on one of our databases. After hearing > _few_complaints that DB is slow (code is not), we enabled trace at level 12 > for power users. Now every AM my job is to analyze 20+ trace files that I > get and report back. > > Once we see a pattern, we will hand it over to Development team and then > work with them to resolve the issues. > > Now only if I could find a version of TKPROF that works with 2GB+ trace > files .. > > Raj > ---------------------------------------------------------------------------- > ---- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > --- Cary Millsap <[EMAIL PROTECTED]> wrote: > > These are the BEST projects to be on. You took a different path than I > would have at the second "Me" line. I would shoot for: > > > > Customer: "It's Slow" > > Me: What is? > > Customer: The application. Make it fast. > > Me: Show me. > > Customer: Okay, come see. > > > > Then your job becomes to get a 10046/12 trace on what you're watching. > > From there, it's all downhill. > > Cary Millsap > > ********************************************************************This e-mail > message is confidential, intended only for the named recipient(s) above and may > contain information that is privileged, attorney work product or exempt from > disclosure under applicable law. If you have received this message in error, or are > not the named recipient(s), please immediately notify corporate MIS at (860) > 766-2000 and delete this e-mail message from your computer, Thank > you.*********************************************************************2 > >Title: RE: RE: Cary's Book - new topic
Cary,
We are doing exactly that on one of our databases. After hearing _few_complaints that DB is slow (code is not), we enabled trace at level 12 for power users. Now every AM my job is to analyze 20+ trace files that I get and report back.
Once we see a pattern, we will hand it over to Development team and then work with them to resolve the issues.
Now only if I could find a version of TKPROF that works with 2GB+ trace files ..
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> These are the BEST projects to be on. You took a different path than I would have at the second "Me" line. I would shoot for:>
> Customer: "It's Slow"
> Me: What is?
> Customer: The application. Make it fast.
> Me: Show me.
> Customer: Okay, come see.
>
> Then your job becomes to get a 10046/12 trace on what you're watching.
> From there, it's all downhill.
> Cary Millsap
