Interactively from the BRGUI graphical interface or the BRTOOLS character interface. · Directly from the command line using the relevant BR*Tools options. SAP Database Administration Using BRTOOLS SAP provides a number of tools to administer the underlying Oracle Database. The combined group of tools is. 1) SAP delivers the “BR*Tools” to provide an interactive Oracle database administration tools 3) Different between BR*Tools and BRTOOLS.
|Published (Last):||15 July 2017|
|PDF File Size:||8.29 Mb|
|ePub File Size:||20.13 Mb|
|Price:||Free* [*Free Regsitration Required]|
Enter table name in Table names table. To find out more, including how to control cookies, see here: When you have finished executing a function and you choose back after starting BRSPACE in quick mode, the quick mode is deactivated and you can choose a new object to execute the function again.
The alternative to quick mode is main menu modein which you only use the menus in BRSPACE to enter the options required to perform a function. By continuing to use this website, you agree to their use.
BRtools and DB02 information:
For example in DB13, you will have an error when you schedule job like check database and update optimizer. There are the following exceptions to quick mode: Show database object information.
For quick mode, you must specify at least the function and the object name. Software Configuration o Standby Database o init.
You can enter manually enter the command. With these functions you should also enter an action to specify what kind of alter function you require. Exceptions to quick mode There are the following exceptions to quick mode: You use quick mode from: Reorganizing table can also be used to improve database structure, transform dictionary managed to locally managed tablespace, merge data in tablespace from many small files into larger files and perform segments defragmentation.
How to Use BR*Tools (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
Unless you know the object name, we recommend you to use main menu mode. Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low. In this case, you have to type the command manually.
Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself.
BRtools and DB02 information:
You can also enter additional options in quick mode. Solution Run this command using root user to update authorization needed for running brtools: Unix system, un Oracle database. For more information, see: You can force the tool to run in batch mode without any interactive component by entering the option —c force.
If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. The bdtools for the object name is filled with your entry.
Here is the example using brspace: BRW Error message from likeywlib: This is the important question before we plan to reorganize table in SAP system. The more you brrools the thread, the faster your process will be.
Show database space information. Choose Segement Management or run from the command prompt brspace —f tbreorg.
The following graphic illustrates in outline how quick mode works: This is the command to change brtpols of Oracle Database User: Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results.
Show database instance information.
There are the following reasons for this: However, you might get errors if you change the command. One of the strategy is to reorg certain table which can impact on system performance.