PSAPUNDO incorrect values between brtools and DB02

[nicola_blasi]

Hello

we have a SCM 5.00 with kernel 7.00 on oracle 10.2.0.4 .

In Db02 , also after a refresh , we have the tablespace at 99% busy.

If a check it in brtools it shows 0,5% busy.

I think that brtools shows the correct answer but i don't know why there is this difference.

SQL> show parameter undo

NAME TYPE VALUE

-

---

-

---

-

---

inmemory_undo boolean FALSE

undo_management string AUTO

undo_retention integer 36000

undo_tablespace string PSAPUNDO

I refeshed statistics in db02old and in db02 but the difference remains.

Any ideas?

Thanks

Nicola

[Former Member]

Hi,

have a look at note: 827019..

Mark

[nicola_blasi]

Hy Mark

thanks for your answer.

i forgot to tell you that i'm using brtools 7.20 patch 10

Bye

Nicola

[Former Member]

Have a look that the initSID.ora and spfileSID.ora are identical.

I can recall that DB02 depends on that aspect.

Kind regards,

[nicola_blasi]

Thanks Sven

This is not the problem i think.

This is an Oracle RAC with four instances.

They have configured it with four spfile linked to one . The same thing for initSID.ora

spfileP1S001.ora -> spfileP1S.ora

lrwxrwxrwx 1 orap1s dba 13 Dec 14 2007 spfileP1S002.ora -> spfileP1S.ora

lrwxrwxrwx 1 orap1s dba 13 Dec 14 2007 spfileP1S003.ora -> spfileP1S.ora

lrwxrwxrwx 1 orap1s dba 13 Mar 21 2009 spfileP1S004.ora -> spfileP1S.ora

Thanks

Nicola