Home » Developer & Programmer » Reports & Discoverer » ORACLE Reports not working after switch from RBO to CBO (9i DB) (Oracle 9i on windows 200 server)
icon4.gif  ORACLE Reports not working after switch from RBO to CBO (9i DB) [message #290487] Sat, 29 December 2007 02:23
dba_zk_08
Messages: 3
Registered: December 2007
Junior Member
Dear All,

We switched our instance to Cost Based Optimizer recently. Also, I have scheduled daily gathering of database statistics. Over all, for more than 3 weeks, we did not face any issues with our ERP application "ORION" and i have noticed significant performance improvements. Since last week, few of our Oracle Reports have been showing unexpected behavior. Usually, they run fine, but suddenly they show no data. If i run the underlying query, I get the data. In the same period, our SGA reached 90% full and i flushed it as one of the user was getting ora-04031 error, and continued with testing on those reports. This time i could see the data in the reports.

What i wanted to know was, has any one noticed CBO having an impact similar to my case, or could their be any other reasons for Oracle Report's such weird behavior?

Please assist.
Previous Topic: Load library unit
Next Topic: Oracle \report 10 G problem
Goto Forum:
  


Current Time: Fri Dec 09 08:06:08 CST 2016

Total time taken to generate the page: 0.08039 seconds