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):||5 June 2010|
|PDF File Size:||18.77 Mb|
|ePub File Size:||5.77 Mb|
|Price:||Free* [*Free Regsitration Required]|
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 dap. Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results.
xap Show database instance information Show database space information Show database object information Brgools the category and then the class that you require. 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. Show database object information. 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.
Run this command using root user to update authorization needed for running brtools: In this case, you have to type the command manually.
How to Use BR*Tools (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
If you do not specify a function, the tool is called with the default function when you start it from the command line: Improvements to handling of database statistics. If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: With these functions you should also enter an action to specify what kind of alter function you require.
For example in DB13, you will have an error when you schedule job like check database and update optimizer. Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization.
The field for the object name is filled with your entry. Choose continue to start processing.
You can enter manually enter the command. For quick mode, you must specify at least the function and the object name. 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 SAP Netweaver 7. For more information, see: There are the following exceptions to quick mode: BRW Error message from likeywlib: This is the command to change password of Oracle Database User: Unix system, with Oracle database.
Here is the example using brspace: Show database space information.
SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy
If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. Solution Run this command using root user to update authorization needed for running brtools: You use quick mode from: Choose the category and then the class that you require. There are the following reasons for this: Why do we need to brtoolx table in SAP system?
If the list is not what you require, you can go back and make a new selection. The more you set the thread, the faster your process will be.