Solution : https://service.sap.com/sap/support/notes/403704 (Connexion à SAP Service Marketplace requise)
Résumé : Mots Clés : Notes associées :
La version 6.XX de BRCONNECT remplace plusieurs commandes SAPDBA en raison de l'amélioration de l'interface utilisateur, supportant des configurations de base de données multi-composants depuis SAP Basis 4.6D. Cela comprend les opérations standard telles que la vérification de la base de données, la mise à jour des statistiques de l'optimiseur et le traitement des prochains espaces d'extension, mettant en avant la migration de l'outil obsolète SAPDBA. Ce changement requiert des paramètres d'initialisation sous init
sql> @dbcheckora9or sql> @dbcheckora10_oltpor sql> @dbcheckora10_olapor sql> @dbcheckora11_oltpor sql> @dbcheckora11_olapnote 4, sqlplus sap<sid>/<pwd> sql> @dbstatc9or sql> @dbstatc10or sql> @dbstatc11note 1, $oracle_home/lib /oracle/client/81x_64/lib # oracle 64 bit ln -, $oracle_home/lib /oracle/client/81x_32/lib # oracle 32 bitif, $oracle_home/lib64 /oracle/client/81x_64/lib # oracle 64 bitotherwise, mkdir /oracle/client mkdir /oracle/client/81x_64, /community/oracle --> key topics --> performance --> update statistics, sqlplus sapr3/<pwd> sql> @db13brcwhen, sapdba command options brconnect function----------------------- ------------------sapdba -check brconnect -, oracle 11g olap systemsthe scripts
1020260 Delivery of Oracle statistics (Oracle 10g, 11g) 972013 Performance Blocked Documents Report: Database settings 900522 Incorrect alerts/warnings in database check for Oracle 10g 806554 FAQ: I/O-intensive database operations 657999 Installing a Standalone Gateway in an MSCS Environment 651812 FAQ: BR*TOOLS and SAPDBA 647697 BRSPACE - New tool for Oracle database administration 592657 ORA-12701/ORA-12705/ORA-12709 588668 FAQ: Database statistics 583759 R/3 error when you start jobs from DB13 575522 Reduction of NEXT extent sizes with BRCONNECT 570764 Missing description for BRCONNECT operations in DB14 557447 ORA-4031 After upgrade to Oracle 8.1.x.x 543519 Incorrect statistics alert in RZ03 after BRCONNECT change 536900 Activating ODS: Error in creating SID - RSM1 187 535986 MONITORING for BW fact tables on Oracle 489690 CC INFO: Copying large production clients 483856 Description of the alerts for Oracle database monitoring 483639 New BRCONNECT parameter: cleanup_check_msg 458872 ORA-00001 with sapdba or BR tools 445884 New BRCONNECT 6.10 option and parameter values 435290 Description of BRCONNECT 6.10 DB check conditions 428212 Using BRCONNECT to update InfoCube statistics 425641 Corrections in transactions of DB20 and DB21 (Oracle) 424243 Update of the statistics of partitioned tables 424239 New BRCONNECT parameter: stats_dbms_stats 419679 New BRCONNECT options: " -t all_ind" and " -o process" 417258 Migration/upgrade Oracle 8.1.7 for Reliant 408532 Using the DBMS_STATS package for collecting statistics 408527 Checking the statistics using DBA_TAB_MODIFICATIONS 403713 BRCONNECT: Parallel updating of statistics 403706 Corrections in BR*Tools Version 6.10 388866 Multiple Components on One Database - Installation 379572 Several mySAP.com components in one database 184513 CBO: Parallel generation of optimizer statistics 134592 Importing the SAPDBA role (sapdba_role.sql) 132861 CBO: Statistics creation with SAPDBA or BRCONNECT 129252 Oracle DB Statistics for BW Tables 122718 CBO: Tables with special treatment 102590 CBO: DBSTATC during upgrade or new installation