I am fairly new to SAP and am still learning my way around the transactions.
After we upgraded to 10G we noticed that the CJI3 report never completes -- it does not crash, it just does not complete, with the selection criteria given. The very same selection criteria is used in another instance with the same data and the report finishes in less than a minute. the difference between these two systems is that the long processing system is distributed -- two applications and a database each on separate Unix boxes.
I have applied the paramater changes identified in SAP Note 830576, run oradict_stats & system_stats and applied Optimizer mere patches 6488148 & 6455795.
Edited by: Juliann Smith on Sep 11, 2008 8:31 PM