Un able to View "top n growing/modified/largest Tables"

[Former Member]

Hi all,

We are using SAP ECC 5.0 with Oracle on SUSE linux.

Previously i will be getting a small POP-up immediately after clicking "space statistics" of DB02 T-code.

By which i can look on the Top 25 Growing, modified, largest TABLES.

and now the pop-up is not comming with TAB buttons to check the

Top 25 Growing, modified, largest tables.

The coming options in pop-up is with 2 field entry options.

The fields comming in pop-up of "Select history View" are

Tables/Indexes.

Tablespaces.

Button of "Space Statistics" in 3rd Section of DB02 screen. i.e... in Tables and Indexes.

DB02 screen will contain 3 sections:-

1*Database system

2*Table spaces

3*Tables and indexes

Second issue is that, i'm not able to see the Data base growth form the begining.

since the values were reset by one of my admin.

where will be the values will be saved (logged), so that i can get the Database Growth from go-live state.

i.e... right from the begining.

request you to give your valuable feed back.

thanks in advance for the valuable time that you'll be investing in this.

thanking you in anticipation,

by

Raghav

points assured for usefull answers

Edited by: raghav on Dec 20, 2007 2:06 PM

[former_member204746]

try tcode DB02OLD to see if it helps.

[Former Member]

Hi Eric,

there is no such T-code.

avaliable DBXXXX T-codes are as follows:-

DB01 RSDB0001 0000 Analyze exclusive lockwaits

DB02 RSDB0002 1000 Tables and Indexes Monitor

DB02N RSORA01E 1000 Database Performance Monitor

DB02_MSS RSMSS062 0100 Remote maintainance MSS (RFC,DBCON)

DB03 RSDB0003 0000 Parameter changes in database

DB05 RSDB0005 0000 Analysis of a table acc. to index

DB11 RSSDBCON 0010 Create Database Connection

DB12 RSDBA850 1000 DBA Backup Logs

DB12_MSS RSMSQ850 0200 Db12 Multiconnect transaction

DB13 RSDBAADM 1000 DBA Planning Calendar

DB13C RSDBAADM 1000 Central DBA Planning Calendar

DB14 RSDBASHX 1000 Display DBA Operation Logs

DB15 SAPLARCC 0200 Data Archiving: Database Tables

DB16 RSDBACHE 1000 Display DB Check Results

DB16ORA RSORADBM 0100 Display DB Check Results: Oracle

i checked all, but not able to find out.

request you to help me in this issue.

thanking you in anticipation,

by

raghav

[former_member204746]

DB02OLD is available with newest netweaver patches only.

anyways, check your standard jobs in SM36, one of them is probably missing.