SAP Note 706132 - Composite SAP Note: Problems with Oracle 9i

Composant : Oracle -

Solution : https://service.sap.com/sap/support/notes/706132 (Connexion à SAP Service Marketplace requise)

Mots Clés :
= 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

Notes associées :

906139Histogram creation takes longer with 9.2 than with 8.1.7
797629FAQ: Oracle histograms
755342Incorrect execution plans with bind variable peeking
727310Wrong Results with ODS or Non-Star_Transformation Queries
717496 Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE
711047Performance problem on DBMS_STATS in 9.2
695080Merge fix for Oracle 9.2.0.4
690702Histograms cause long runtimes on Oracle 9
690241The Shared SQL Area in the Shared Pool and large SQL Stmnts
684545Statistics generation: DBMS_STATS runs longer than ANALYZE
640910Problems when using OPatch
634263Selects with FOR ALL ENTRIES
632336Long runtimes when compiling statistics on Oracle 9.2.0.x
626172Performance problems with Outer Join queries in Oracle 9.2
592657ORA-12701/ORA-12705/ORA-12709
584187ora-600 [13009] in oracle 9.2
540021Add. information on migrating/updating to Oracle 9.2.0: UNIX
493143ORACLE upgrade to 9.2.0: Windows