Solution : https://service.sap.com/sap/support/notes/706132 (SAP Service marketplace login required)
Key words :
= 7-> subheap size = shared_pool_size / #subheaps = 896 mb / 7 = 128 mb, cbo merge notes referred, processing-intensive sql statements, seemingly optimal access path, expensive sql statements due, longer call oracle tools 8, longer call oracle tools, large oracle buffer caches, call oracle tools, expensive sql statements
Related Notes :
| 906139 | Histogram creation takes longer with 9.2 than with 8.1.7 |
| 797629 | FAQ: Oracle histograms |
| 755342 | Incorrect execution plans with bind variable peeking |
| 727310 | Wrong Results with ODS or Non-Star_Transformation Queries |
| 717496 | Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE |
| 711047 | Performance problem on DBMS_STATS in 9.2 |
| 695080 | Merge fix for Oracle 9.2.0.4 |
| 690702 | Histograms cause long runtimes on Oracle 9 |
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |
| 684545 | Statistics generation: DBMS_STATS runs longer than ANALYZE |
| 640910 | Problems when using OPatch |
| 634263 | Selects with FOR ALL ENTRIES |
| 632336 | Long runtimes when compiling statistics on Oracle 9.2.0.x |
| 626172 | Performance problems with Outer Join queries in Oracle 9.2 |
| 592657 | ORA-12701/ORA-12705/ORA-12709 |
| 584187 | ora-600 [13009] in oracle 9.2 |
| 540021 | Add. information on migrating/updating to Oracle 9.2.0: UNIX |
| 493143 | ORACLE upgrade to 9.2.0: Windows |