Reports are running slow [message #576642] |
Wed, 06 February 2013 21:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/161564.jpg) |
1982Hashmi
Messages: 69 Registered: March 2011 Location: Islamabad
|
Member |
|
|
Hi to everyone!
i) I've used interval based partitioning on a table
ii) Reports based on that table run very fast when I run through Reports Builder 10g.
iii) But same report when run through Application Server takes long time.
This Application Server is a testing environment, so there is not load of users.
iv) For reports format I am using 'PDF' format for CACHE type.
Can anyone tell me what could be the reason why my reports run slow on AS. Is there any compatibility issue as I'm using features of 11g Database (Interval based partitioning)?
Thanks.
[Updated on: Wed, 06 February 2013 21:55] Report message to a moderator
|
|
|
|