Oracle Reports (MOSC)

MOSC Banner

Pack Slip Report runs slow usually only at the first time

edited Sep 16, 2009 9:38PM in Oracle Reports (MOSC) 3 commentsAnswered
 We have a customized Pack Slip report. The report can take 5 miniutes to finish, usually only when the first time you run it. If you run the report again on the same computer, it only takes 3 to 4 seconds. So it is hard for me to adjust and test the report performance because the slowness only happened once.

Is there anyone that knows how to tune a report? The slowness happens usually only at the first time, does it mean later on the report is cached in the memory?

thanks for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center