Home » Developer & Programmer » Reports & Discoverer » Reports Consuming CPU (Report 10g)
Reports Consuming CPU [message #456728] Wed, 19 May 2010 06:21
Messages: 16
Registered: April 2010
Location: Delhi
Junior Member

We are migrating D2K 5.0 to iDS10gR2. The migrated source is hosted on oracle application server 10g( While running reports it is consuming substantial amount of CPU(12 to 15 %) on application server. Query of some of these reports are well tunned and costs around 18-25 only. These reports are more than 50 pages and some of these expands to 1500 pages also.

Does anyone has solution/workaround to minimize the CPU consumption.

The structure (i.e. architecture) is ..

  1. One report server with 6 JVM island to run all the report. there are 2500 reports within 20 different modules
  2. More than 500 users
  3. using Oracle application server 10gR2( for hosting forms and reports
  4. Hardware - Core2Duo CPU with 8 processor (HP Server)
  5. OS - Microsoft Windows 2003 R2
  6. I am using RDF to run report
  7. Because of security reason reports needs to be generated in PDF formats

Previous Topic: error in using dense_rank() in formula column (merged by CM)
Next Topic: Barcode
Goto Forum:

Current Time: Sun Aug 09 04:18:11 CDT 2020