Finding size used by custom Z table?

[Former Member]

Hi,

We have a ECC 6.0 system running on Oracle 11.2.0.4.

One thing we need to do lately is to work out how much disk space is being utilised by a few custom Z* tables in the database. However we can't seem to find out exactly how much space is being used.

What we have tried is to use DB02, and then check under Segments -> Detailed Analysis.

However the result we get from the result is too small. Only 5MB.

The database table has a column that actually holds the file contents of attached documents, so it couldn't possibly be so small.

We've also tried the other option "Detailed Analysis (Aggregated)", and that returns a more sensible 6.9GB. However we don't know for sure what the "Aggregated" option does, and past discussions on SCN about how to find database disk space usage never mentioned the "Aggregated" option too.

Does anyone know which is the correct option?

Thank you!

[Former Member]

Siaw Woei Shyang wrote:

The database table has a column that actually holds the file contents of attached documents, so it couldn't possibly be so small.

We've also tried the other option "Detailed Analysis (Aggregated)", and that returns a more sensible 6.9GB. However we don't know for sure what the "Aggregated" option does, and past discussions on SCN about how to find database disk space usage never mentioned the "Aggregated" option too.

Does anyone know which is the correct option?

Thank you!

What is the type of this column? More likely that you are using some type of LOB. That is why option "Detailed Analysis (Aggregated)" shows you correct result. Some links to read:

Note 500340 - FAQ: LOBS

Segments Detailed Analysis - CCMS: Oracle - SAP Library

Segments Detailed Analysis (Aggregated) - CCMS: Oracle - SAP Library

[former_member224542]

Hi Siaw,

Have you tried querying the database via sqlplus? You can try something like:

SQL> select SEGMENT_NAME, SEGMENT_TYPE, BYTES/1024/1024 size_mb

  2  from dba_segments

  3  where SEGMENT_NAME like 'Z%'

  4  and SEGMENT_TYPE = 'TABLE';

Regards,

Glenn