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):||27 July 2012|
|PDF File Size:||15.8 Mb|
|ePub File Size:||3.13 Mb|
|Price:||Free* [*Free Regsitration Required]|
With these functions you should also enter an action to specify what kind of alter function you require.
This is the important question before we plan to reorganize table in SAP system. To find out more, including how to control cookies, see here: Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.
One of the strategy is to reorg certain table which can impact on system performance. Show database space information.
Otherwise, the appropriate menus are shown for the function you select. Show database instance information Show database space information Show database object information Choose the category and brtoools the class that you require.
SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy
There are the following exceptions to quick mode: This will make you unable to run some commands from SAP. Exceptions to quick mode There are the following exceptions to quick mode: If the list is not what you require, you can go back and make a new selection.
Solution Run this command using brtiols user to update authorization needed for running brtools: There are the following reasons for this: Choose continue to start processing. Unix system, with Oracle database. 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.
You can also enter additional options in quick mode. You use quick mode from: Here is the example using brspace:. Software Configuration o Standby Database o init.
How to Use BR*Tools (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
The more you set the thread, the faster your process will be. This is the command to change password of Oracle Database User: You enter the command options required directly from the command line: Show database instance information.
Why do we need to reorganize table in SAP system? You can perform the following types of reorganization: If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. Enter table name in Table names table.
If you do not specify a brtoils, the tool is called with the default function when you start it from the command line: In this case, you have to type the command manually.
You can force the tool to run bgtools batch mode without any interactive component by entering the option —c force.
Brrools 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. Run this command using root user to update authorization needed for running brtools: The following graphic illustrates in outline how quick mode works: However, you might get errors if you change the command.
In SAP Netweaver 7. You can now enter all required options and execute the function immediately. Unless you know the object name, we recommend you to use main menu mode. Improvements to handling of database statistics.
Here kn the example using brspace: For example in DB13, you will have an error when you schedule job like check database and update optimizer. All other confirmation prompts and so on are skipped.