Re: Trace Files

Niall Litchfield wrote:

> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F390EE3.ABBBE9B_at_exxesolutions.com...
> > Mike wrote:
> >
> > > Hi,
> > >
> > > I have a report developed using Ora Excel which connects to 25
> > > databases and populates the report.When ever we run the report it
> > > consumes a lot of CPU and all other processes become very slow.
> > > I want to enable trace for all the databases.The report is run from
> > > excel.Where do I enable the traceing?
> > >
> > > TIA
> > >
> > > Mike
> >
> > Tracing will only make things slower and will not do anything to speed
> > things up. I'd throw away Ora Excel as it does nothing that can't be
> > done faster and more efficiently with spool. But then again I'd throw
> > away Excel because it can't do anything that can't be done better in
> > Oracle in the first place.
>
> More than a little harsh, unless I've missed the charting facilities in
> Oracle to take just one example.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK

Point taken. But one should not chart in a program that is designed to corrupt raw data.

Connect Crystal, Brio, Cognos, anything to Oracle. But leave the data where its integrity and security can be guaranteed.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)