Home » Database Administration » Update Database Statistics using BRTOOLS and BRCONNECT

Update Database Statistics using BRTOOLS and BRCONNECT

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 692,146 hits


Categories

Advertisements

On this tutorial, you’ll see how to update your database statistic. Database statistic need to be update in order to accelerate database query on your program or SAP standard program. For example, you need to query data from MSEG table. If MSEG table has may rows data and never been updated its statistics then your program would be running slowly especially when MSEG table rows had been grown rapidly.

To update database statistic, you could use BRCONNECT or BRTOOLS. Actually, BRCONNECT is part of BRTOOLS. I’ll explain how to use both of them. I use my Windows box and use [sid]adm. If you use UNIX box, use ora[sid].

First, let’s try to use BRCONNECT to update MSEG table. Open your MSDOS prompt.

Type command : > brconnect -u / -c -f stats -t MSEG

Explanation :

  • – u means using user root (/)
  • – c means force without using password
  • – f means using function statistics. Another option is checks.
  • – t means which table is going to update its statistics. Another option is ALL for all tables.

Now, we are going to look at BRTOOLS to do this task. BRTOOLS are menu based program. Open your MS-DOS prompt. Type BRTOOLS.

Type 7 to choose Database Statistics. Press ENTER.

Type 1 to update database statistics. Press ENTER.

To update MSEG table choose 9 to enter MSEG table name and then press ENTER.

Type C to continue to next step, running update database statistic process.

You’ll see summary of what you are going to do. Type C to continue.

Last confirmation before running update database statistics. Type C to continue.

BRTOOLS update database statistics has been completed successfully. Type C to continue and back to update database statistic menu.

Type B to go back to BRTOOLS main menu.

Type 9 and then ENTER to exit from BRTOOLS menu.

That’s all for now. Now you know how to update your database statistic. Hope this tutorial work for you. See you on the next tutorial.

Advertisements

6 Comments

  1. Raffaell says:

    Thanks mas Ardhian, keren..

  2. Walter Huber says:

    This is good documentation,
    but only working at the host where the Database is running,

    Whats the commands to run this from the SAP application Server with an dedicated standalone ORACLE DB Server,
    where the connection should be using ssh?

    Thanks for you help
    Walter

  3. ardhian says:

    @walter : you can use BRGUI (GUI style of BRTOOLS)

    ardhian

  4. Walter Huber says:

    Hi ardhian,
    it’s known, that i can use BRGUI als in an centralized environmen,
    – But i have to schedule “Update Statistics” priodical,
    in my J2EE systems, like it is done in DB13 with ABAP.

    Thanks for your Assistance

  5. dhakeswar says:

    Thanks for ur document

    • W. Huber says:

      This only possible valid for ORACLE and not for all Databases
      (there are also MaxDB, MS-SQL, DB2/udb, Sybase which are in use with SAP)

Leave a Reply to W. Huber Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

My twitter post @devratt

June 2008
M T W T F S S
« Dec   Jul »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Popularity


PageRank

Bookmark and Share

Top Clicks

    %d bloggers like this: