Large Tables and Indexes

[Former Member]

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

PL/SQL Release 9.2.0.8.0 - Production

CORE 9.2.0.8.0 Production

TNS for 32-bit Windows: Version 9.2.0.8.0 - Production

NLSRTL Version 9.2.0.8.0 - Production

Hello everyone;

I would like to generate a list showing tables and indexes that are over 1 GB in size. What tcode would you use to do this in SAP?

Thank you for your time.

[Former Member · Accepted solution]

In DB02 (new dbacockpit) -> Space -> Segments -> Detailed analysis -> Size > 1000mb

or

SQL> select segment_name, bytes from dba_segments where bytes > 1000000000;

Regards

Michael

[Former Member · Accepted solution]

Michael;

Thank you so much for your help, have a great day.