21 Aug 1) SAP delivers the “BR*Tools” to provide an interactive Oracle database administration tools 3) Different between BR*Tools and BRTOOLS. 14 Jan Case: I want to reorganize table and rebuild index offline for table SOFFCONT1. Table SOFFCONT1 contains SAP Business. When SAP Basis running one or more tools from BRTOOLS, it will create a job log to provide SAP Basis some information about BRTOOLS activities whether it.

Author: Samule Nanris
Country: Timor Leste
Language: English (Spanish)
Genre: Software
Published (Last): 11 June 2008
Pages: 405
PDF File Size: 20.24 Mb
ePub File Size: 8.33 Mb
ISBN: 292-6-86601-914-4
Downloads: 79241
Price: Free* [*Free Regsitration Required]
Uploader: Faujin

Unix system, with Oracle database. In certain cases, it may be advisable to adjust the standard function for example, to avoid unnecessarily large NEXT sizes or to exclude certain tables from a check.

BR*TOOLS and SAP DBA in Oracle

To find out more, including how to control cookies, see here: Tutorials Bassi is Oracle? What is the importance of the “jid” parameter? Database statistic need to be update in order to accelerate database query on your program or SAP standard program. In this case, you have to type the command manually.

basiw Type C to continue. It may be different if you are using old or new ones. Newer Post Older Post Home. To get more detailed information, click on Detail Log button. Deleting Multiple Spool Requests Simultaneously in As of Version 7. If MSEG table has may rows data and never been updated its statistics then your program would brtools sap basis running slowly especially when MSEG table rows had been grown rapidly.

BRTOOLS – SAP Documentation

September 14, Run this command using root user to update authorization needed for running brtools: 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. Set the required option sa new destination tablespace or set the parallel thread which will be used to perform reorganization.

Choose continue to start processing. SAP tcode DB02 is use to check database size, tablespaces size, current statistic, checking freespace statistic, analyze detailed tablespace, checking missing indexes, and space critical objects. They will mention and warn you if something wrong baais your backup configuration. June 11, 8: I done it for this purpose.

By default, logs that are older than 30 days are deleted. Method Allocation Displaying the Technical View: Please take note that bsis 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

For example in DB13, you will have an error when you schedule job like check database and update optimizer. SAP are design its database very complex and beatiful. Additional option available for table reorganization.

Abort Return Code 9: Where can I find more information? Wait until it finished.


Successful execution Return Code 1: Termination in the initialization phase Return Code 3: By continuing to use this website, you agree to their use. Enter table name in Table names table. To check tablespace current size, just click Current Size button.