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.

Author: Zulular Dozahn
Country: Algeria
Language: English (Spanish)
Genre: Art
Published (Last): 3 April 2012
Pages: 492
PDF File Size: 12.79 Mb
ePub File Size: 16.63 Mb
ISBN: 607-8-95276-834-6
Downloads: 41986
Price: Free* [*Free Regsitration Required]
Uploader: Mezizuru

This will make you unable to run some commands from SAP.

The field for the object name is filled with your entry. This is the command to change password of Oracle Database User: Choose the category and then the class that you require. This is the szp question before we plan to reorganize table in SAP system.

For more information, see: The object — for example, a tablespace name if you want to extend a tablespace — varies according to the function that you choose.


All other confirmation prompts and so on are skipped. Solution Run this command using root user to update authorization needed for running brtools: This site uses cookies. The following graphic illustrates in outline how quick mode works: By continuing to use this website, you agree to their use.


The exception to this is for the functions in segment management, where it makes no sense to display all tables or indexes, because the list would be too long. You use quick mode from: In SAP Netweaver 7.

BRTOOLS (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Why do we need to reorganize table in SAP system? Improvements to handling of database statistics. There are the brtols exceptions to quick mode: BRW Error message from likeywlib: If you do not specify a function, the tool is called with the default function when you start it from the command line: You can perform the following types of reorganization: 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.

To find out more, including how to control cookies, see here: Show database instance information Show database brtools information Show database object information Choose the category and then the class that you require.

BRtools and DB02 information:

Software Configuration o Standby Database o init. You can also enter additional options in quick mode.

Here is the example using brspace: You can force the tool to run in batch mode without any interactive component by entering the option —c force. You enter the command options required directly from the command line: There are the following reasons for this: Show database instance information. One of the strategy is to reorg bdtools table which can impact on system performance. Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.


SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy

With these functions you should also enter an action to specify what kind of alter function you require. Unless you know the object name, we recommend you to use main menu mode.

Enter table name in Table names table. If you do not enter the class of the information to be displayed, you see a on displaying the different categories of information class: BRSPACE starts by displaying the function main menu for the function that you entered, which is Alter database parameter in this example.