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.
|Country:||Republic of Macedonia|
|Published (Last):||23 September 2008|
|PDF File Size:||17.53 Mb|
|ePub File Size:||20.6 Mb|
|Price:||Free* [*Free Regsitration Required]|
However, you might get errors if you brtoools the command. If you do not enter the class of szp information to be displayed, you see a menu displaying the different categories of information class: To find out more, including how to control cookies, see here: Choose Segement Management or run from the command prompt brspace —f tbreorg. Run this command using root user to update authorization needed for running brtools: The more you set the thread, the faster your process will be. There are the following reasons for this: You can also enter additional options in quick mode.
Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results. You can now enter all required options and execute the function immediately. You can perform the brtoos types of reorganization: One of the strategy is to reorg certain table which can impact on system performance.
With these functions you should also enter an action brtoole specify what kind of alter function you require. The object — for example, a tablespace name if you brtoolz to extend a tablespace — varies according to the function that you choose. 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.
The field for the object name is filled with your entry.
This is the command to change password of Oracle Database User: Unless you know the object name, we recommend you to use main menu mode.
By continuing to use this website, you agree to their use. If the list is not what you require, you can go back and make a new brtoo,s. Unix system, with Oracle database.
How to Use BR*Tools (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
This will make you unable vrtools run some commands from SAP. Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.
Enter table name in Table names table. 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.
Solution Run this command using root user to update authorization needed for running brtools: If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. Choose the category and then the class that you require.
Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. There are the following exceptions to quick mode: They jump directly to the final input menu to let you enter the remaining required parameters and execute the function immediately. BRW Error message from likeywlib: 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.
Here is the example using brspace:.
Show database object information. The following graphic illustrates in outline how quick mode works: Choose continue to start processing. 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. In SAP Netweaver 7. The exception to this is for the functions in segment management, where it makes no sense to display all tables or indexes, brhools the list would be too long.
Show database space information. Here is the example sxp brspace: For quick mode, you must specify at least the function and the object name. All other confirmation prompts and so on are skipped. You use quick mode from: Software Configuration o Standby Database o init. Show database instance information Show database space information Show database object information Choose the category and then the class that you require. 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.
For example in DB13, you will have an error when you schedule job like check database and update optimizer. You can force the tool brtoolx run in batch mode without any interactive component brfools entering the option —c force.