dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Oracle Report 6i: No data Issue after migrating from RBO to CBO (9i DB) - Oracle Tools

This is a discussion on Oracle Report 6i: No data Issue after migrating from RBO to CBO (9i DB) - Oracle Tools ; 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 ...


Home > Database Forum > Oracle Database > Oracle Tools > Oracle Report 6i: No data Issue after migrating from RBO to CBO (9i DB)

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 12-29-2007, 04:14 AM
Database Newbie
  
Join Date: Dec 2007
Posts: 2
dba_zk_08 is on a distinguished road
Exclamation Oracle Report 6i: No data Issue after migrating from RBO to CBO (9i DB)
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
How the pages tables of each segment is located Database Administrator Arch 99 12-23-2007 05:40 AM
HPSBMA02133 SSRT061201 rev.6 - HP Oracle for OpenView (OfO) Critical Patch Update Database Administrator hp-hpux 0 10-25-2007 09:08 AM
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl' Database Administrator Database Discussions 98 04-29-2004 09:45 AM
SAP BW compared to Essbase/SQLServer/Oracle as a Enterprise Data Database Administrator Oracle Server 0 02-19-2004 07:42 AM
Oracle versioning discovery Database Administrator Oracle Server 12 10-30-2003 07:49 PM


All times are GMT -4. The time now is 06:54 AM.