Solution : https://service.sap.com/sap/support/notes/561961 (SAP Service marketplace login required)
Key words : 
data mart ora-600 oracle 9 reason, open hub scenarios independent, oracle-based bw systems, performance problems occur due, data mart access, export data source, open hub accesses -, open hub accesses, bypass db problems, abap report sap_rsadmin_maintain
Related Notes : 
       
| 1013912 | FAQ: Oracle BW performance | 
| 862809 | BW: Excessive temporary space usage/Long running Queries | 
| 760302 | Composite SAP note Oracle 9.2.0.3 and incorrect data | 
| 610445 | Merge fix for Oracle 9.2.0.3 | 
| 567747 | Composite note BW 3.x performance: Extraction & loading | 
| 567746 | Composite note BW 3.x performance: Query & Web applications | 
| 565086 | Composite SAP note: Wrong or no data in DataMart or Query | 
| 517950 | SAPBWNews BW 3.0B Support Package 07 |