Home » Database Administration » Simple Table Reorganization for SAP R/3 using BRSPACE

Simple Table Reorganization for SAP R/3 using BRSPACE

RSS Link

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

Blog Stats

  • 692,146 hits


Categories

Advertisements

SAP R/3 are ERP software that relied on database performance to support its performance. High performance database directly effect on SAP R/3 system performance. One of activity that effect on its are table reorganization. Reorganization improves the structure of the database and can result in improved database performance. BRSPACE performs the reorganization using the new Oracle feature, online table redefinition. The following graphic shows some of the reasons for reorganization:

One of the reason to reorganization are that large disk and RAID system with large and secure memory buffers reduce I/O hotspot. You can check more about reorganization for SAP R/3 here.

I’ll use my Windows box and use [sid]adm user. For Unix box user, use ora[sid] user. Let’s do simple table reorganization here. Open your MS-DOS prompt.

Type > brspace -f tbreorg -t MSEG

Explanation :

  • -f means function to do table reorganization
  • -t means refer to table  name. On this tutorial, MSEG table.

Type ENTER.

Additional option available for table reorganization. Just accept default option. Type C to continue.

Table reorganization is running.

Table reorganization has been completed succesfully. Type C to continue.

Now you can try to reoganization simple and little table. This tutorial only show you simple and online reorganization. Be carefull when you are using it. Test it first on your Develop system or Test system.

Advertisements

3 Comments

  1. LINGA REDDY says:

    Hi

    It’s so helped for me to know the process of reorganization

    Thanks
    Linga reddy

  2. Geyson Rodriguez says:

    Hi, in the picture you didnt specified a newts, in wich tablespace it will do it?

Leave a 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: