SAP Note 403704 - BRCONNECT - Enhanced function for Oracle DBA

Component : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/403704 (SAP Service marketplace login required)

Summary :
BRCONNECT Version 6.XX replaces many SAPDBC commands due to the enhanced user interface and its compatibility with multi-component database systems since SAP Basis 4.6D. The conversion includes standard operations like database check, update optimizer statistics, and next extent processing, emphasizing migration from the deprecated SAPDBA tool. The shift mandates initialization parameters under init.sap, neglecting former init.dba settings. BRCONNECT is also backward compatible with SAP releases down to 4.0B, ensuring older systems smoothly transition to leverage improved functionalities. Documentation and transformation guidance are available on SAP Service Marketplace.

Key words :
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

Related Notes :

1020260Delivery of Oracle statistics (Oracle 10g, 11g)
972013Performance Blocked Documents Report: Database settings
900522Incorrect alerts/warnings in database check for Oracle 10g
806554FAQ: I/O-intensive database operations
657999Installing a Standalone Gateway in an MSCS Environment
651812FAQ: BR*TOOLS and SAPDBA
647697BRSPACE - New tool for Oracle database administration
592657ORA-12701/ORA-12705/ORA-12709
588668FAQ: Database statistics
583759R/3 error when you start jobs from DB13
575522Reduction of NEXT extent sizes with BRCONNECT
570764Missing description for BRCONNECT operations in DB14
557447ORA-4031 After upgrade to Oracle 8.1.x.x
543519Incorrect statistics alert in RZ03 after BRCONNECT change
536900Activating ODS: Error in creating SID - RSM1 187
535986MONITORING for BW fact tables on Oracle
489690CC INFO: Copying large production clients
483856Description of the alerts for Oracle database monitoring
483639New BRCONNECT parameter: cleanup_check_msg
458872ORA-00001 with sapdba or BR tools
445884New BRCONNECT 6.10 option and parameter values
435290Description of BRCONNECT 6.10 DB check conditions
428212Using BRCONNECT to update InfoCube statistics
425641Corrections in transactions of DB20 and DB21 (Oracle)
424243Update of the statistics of partitioned tables
424239New BRCONNECT parameter: stats_dbms_stats
419679New BRCONNECT options: " -t all_ind" and " -o process"
417258Migration/upgrade Oracle 8.1.7 for Reliant
408532Using the DBMS_STATS package for collecting statistics
408527Checking the statistics using DBA_TAB_MODIFICATIONS
403713BRCONNECT: Parallel updating of statistics
403706Corrections in BR*Tools Version 6.10
388866Multiple Components on One Database - Installation
379572Several mySAP.com components in one database
184513CBO: Parallel generation of optimizer statistics
134592Importing the SAPDBA role (sapdba_role.sql)
132861CBO: Statistics creation with SAPDBA or BRCONNECT
129252Oracle DB Statistics for BW Tables
122718CBO: Tables with special treatment
102590CBO: DBSTATC during upgrade or new installation