How to get history growth of all tables in db02

[benoit-schmid]

Hello,

With the old db02 (db02old), it is possible to list all growth of tables:

db02old -> Space Statistics -> select * -> Ok

With the new db02 or the dbacockpit, it is possible to view the top growth:

Space -> Segments -> Overview -> Top Growth

But it shows only a few lines compared to the db02old.

How can I request all tables growth in the new db02?

Thanks in advance for your answers.

[former_member197466]

Hi, Benoit.

To ensure that the DB02 is working fine, please check sap note 1002840 No data or obsolete data in DB Space Statistic monitor. Make sure all the points are configured.

Thanks,

Ivy

[benoit-schmid]

Hello,

I have checked everything in this Note.

It is set correctly.

Anyway I am not having obsolete data as specified in Note 1002840.

I am having up to date data.

But, I would like to increase the size of the top growth list.

How can I do this?

Thanks in advance for your answers.

[Former Member]

Not sure why you want to increase the list of top size table as you get almost list of 90 tables/index under top size. You can execute your custom query to get the table size from DB02 - segment - detailed analysis and give the table/index size you want restrict.

Also look at note - 1438410 SAP Oralce script

[benoit-schmid]

Hell Sunil,

In my case, I am not interested in size but by the growth rate.

If I would like to get more lines, it means, that I interested by them.

This is why I ask how can I perform in db02 what was possible to do in the old db02.

Thanks in advance for your answer.

[benoit-schmid]

Hello,

I am not very impressed by the sql script provided in Note 1438410.

If I run Space_GrowthOfSegmentInHistory.txt, it returns

no rows selected.

Regards,

[Former Member]

You are looking for Database growth? It only maintain last 12 months of data (stats) even in DB02OLD or DB02. The new DB02 screen you have scroll right as it has two screens in one.

[benoit-schmid]

Hello,

The problem is that the new db02 shows much less line than the old db02.

The new db02 only show the top 100 growth.

I did not ask about the retention period.

I would like to have the whole list.

Thanks in advance for your answer.