Finding source of database growth in SAP R/3

pts.
Tags:
Basis
Our DB grew by much more than usual last month and I'm curious to find the source. In DB02 it is possible to look at the historical growth of specific tables, or all tables in a tablespace (my DB is Oracle), but I haven't found a way of getting a list of how much each table (or each table in a tablespace) has grown in the last month. Have I missed something? If there isn't a standard way of getting such information, does anybody know where it is stored? I'm prepared to write an ABAP to get it if necessary. Thanks, Steve.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello Steve,

There is no SAP report to give you this information that I am aware of.

The MONI table holds those statistics in a highly compressed format. I recommend using the SE30 to evaluate your DB02 research. The ANALYZE step along with the EXPAIN should go a long way toward identification of the ABAP function modules that you will need to help prepare this report.

Regards,
Kirby Arnold
Kirby-Arnold@Kirby-Arnold.com

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bcmei1
    Hi, You should be able to go further into DB02 to see individual table growth. Goto "space statistics" under tables/indices section, enter tablespace name. You can then view history of all table growth by days, weeks, or months. You can then sort the size chg/month column to easily see the larger growing tables/indices. Is that not what you were looking for?
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following