Overview :

This document gives us information on identifying the largest table according to their size, record count , delta record size and other important parameters.

Process:


Large tables can be identified using the following step :


1. Go to T code: DB02 and click on “Large tables” section under System Information.

A1.png

Large tables in the system will be shown as below:

A2.png

2. Different Parameter to Sort the data on:


The result can also be sorted based on different parameters such as memory size in main ,memory size in Total and others as shown in the below.


A.  Based on Memory Size Column Table in Delta:

A3.png


B.  Based on Memory Size in Row Table (2nd Tab) in Allocated Partition Size:


A4.png

They can also be sorted based on the below highlighted selection.

A5.png


C. Disk Size(3rd Tab)

The third tab gives us information of the disk size of all the table.

A6.png

They also can be sorted based on  the highlighted parameters.

A7.png

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply