Do you mean one specific report? If so post the sql and some details of the
tables and indexes it is looking at. An explain plan would be good as well.
If on the other hand you mean reports generally what reporting environment
is setup.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Đuro Dretvić" <Djuro.Dretvic_at_Infodom.hr> wrote in message
news:9r9vti$obf$1_at_sunce.iskon.hr...
> Hi everybody!
>
> I have a database on RDBMS 8.1.7.3.3 on Windows 2000 + service pack 2
> Computer has one procesor (pentium 3 - 700 MHz) with 1GB RAM.
> It is a database for application development. (20 users)
>
> Details of a problem:
>
> Database normaly works fine, but when I start generating a report , CPU
> usage jump to 99 % and doesn't goes down.
> When I kill that process, CPU usage returns to normal state.
> How to resolve this problem ?
>
> Regards D.
>
>
>
Received on Fri Oct 26 2001 - 03:05:50 CDT
