PSAPSR3 tablespace size increase but which table takes this increase data

[Former Member]

Hi expert,

In Our PRD server suddnelly PSAPSAR3 tablespace size increase.around 15GB  we can see in DB02  history of tablespace but not showing the table information which contains this data.

i want to know  table name which take this data.

OS--HPUX

DB--Oracle 10g

ECC 6.0

Thanks in advance.

Regards,

Vivek

[Former Member · Accepted solution]

What about your table growth information in DB02? Take a look at top tables which are growing rapidly.

Regards,

Nick Loy

[Former Member · Accepted solution]

thanks hot DB02---segment--overview--top size 7 top growth

[former_member197466 · Accepted solution]

Hi Vivek,

If the top growth objects are BASIS table which are listed in SAP note 706478. You can perform the

data archiving on these objects follows the steps mentioned in sap note  706478.

To reclaim the freespace you need to perform the table reorganization as well.

Thanks,

Ivy

[Former Member]

Hi Vivek,

May the following points helps you -

• ckeck in DB02OLd, click on Detailed Analysis and use the tablespace in criteria.
• Otherwise go to sqlplus -  check the details in dba_tables where put tablespace_name=' XYZ';

Regards,

Vinay Shrimali