PSAPUNDO in DB02 shows incorrect values when compared to BRtools

[former_member293883]

Hi,

In my SAP ECC system ( 7.00/Oracle10.2/AIX), in transaction db02old it shows the value of PSAPUNDO has 100% utilized. When we tried to check the same from BRTOOLS, it shows that the used percentage as 0.55%.

This difference is observed only for the PSAPUNDO tablespace.

Has any faced a similar issue ?

Regards

Parthasarathy S.

[former_member204746]

DB02 collects information usually twice a day. So, it is not up to date information.

[ashish_mishra2]

Hi,

PSAPUNDO tablespace is something, which would show the used space at one moment 100% and another moment 1%, its all depend upon the activities happening inside the SAP system hence no worries.

Brtools shows the most recent status of tablespaces where as DB02 would show the data collected during last refresh.

Please refresh data from DB02old and then check the status of tablespace.

Cheers !!!

Ashish

[former_member524429]

Hi,

Have you referred this [SAP Note 1035137 - Oracle Database 10g: Automatic Undo Retention|https://service.sap.com/sap/support/notes/1035137] ?

Regards,

Bhavik G. Shroff