Re: Business Objects performance
From: ddf <oratune_at_msn.com>
Date: Wed, 8 Jul 2009 11:16:51 -0700 (PDT)
Message-ID: <07e9109b-57bd-478f-a590-7151d9aa62be_at_h8g2000yqm.googlegroups.com>
On Jul 8, 4:17 am, Helma <helma.vi..._at_hotmail.com> wrote:
> Greetings,
>
> I need to improve the performance of Business Objects reports.
> Whenever I look when the database is on it knees there is a B.O.
> report running which causes it.
>
> For trendanalysis and tuningsimpact, I need to know how long and how
> often each report runs every month. That information cannot be
> obtained in B.O. itself. Did anyone solve this problem before?
>
> tnx,
> Helma
Date: Wed, 8 Jul 2009 11:16:51 -0700 (PDT)
Message-ID: <07e9109b-57bd-478f-a590-7151d9aa62be_at_h8g2000yqm.googlegroups.com>
On Jul 8, 4:17 am, Helma <helma.vi..._at_hotmail.com> wrote:
> Greetings,
>
> I need to improve the performance of Business Objects reports.
> Whenever I look when the database is on it knees there is a B.O.
> report running which causes it.
>
> For trendanalysis and tuningsimpact, I need to know how long and how
> often each report runs every month. That information cannot be
> obtained in B.O. itself. Did anyone solve this problem before?
>
> tnx,
> Helma
Have you run a Statspack or AWR report? Have you traced the offending session or sessions with event 10046 at level 8 or level 12?
David Fitzjarrell Received on Wed Jul 08 2009 - 13:16:51 CDT