RE: RE: Cary's Book - new topic

Or you can look into getting the "Hotsos Profiler" It would definitely be money well spent!

-----Original Message-----
Sent: Wednesday, October 08, 2003 8:50 AM To: Multiple recipients of list ORACLE-L

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" <Rajendra.Jamadagni_at_espn.com>
> Date: 2003/10/08 Wed AM 09:14:25 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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 <cary.millsap_at_hotsos.com> 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
>
> ********************************************************************Th
> is 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
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefick Ronald S Contr ESC/HRIDD
  INET: Ronald.Stefick_at_RANDOLPH.AF.MIL

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).